Domain - List of ticket requests

Domain description

This domain contains detailed information on tickets requested via a lottery and corresponds to the view D_LOTTERY_TICKET_REQUEST_V1_0 in which :

1 record = 1 ticket request for a given match with information related to:

• Lottery used to perform the request

• ID of the selected match

• ID of user (= future contact) having performed the request

• Information on the seat category

• Information on persons who will assist to the match

• Information on the payment (which will be processed only if the request was drawn lots)

• Information on the request status

A record is identified in a unique way by means of the following attributes: : T_TICKET_REQUEST_ID

This domain is available since Whymper V1.

Domain's columns description

The following link contains more information on the data of the domain: D_LOTTERY_TICKET_REQUEST.

Domain - List of lottery users

Domain description

This domain contains detailed information on users of the lottery and corresponds to the view D_LOTTERY_USERS_V1_0 in which:

1 record = 1 user of a lottery with information related to:

• ID of the user

• Means of communication with user

• Contact number corresponding to this user. This number will be assigned when the user will be imported in the ticketing system as a contact

• Lottery from where the user has been created

A record is identified in a unique way by means of all the following attributes: T_USER_ID or EXTERNAL_CONTACT_NUMBER

This domain is available since Whymper V1.

Domain's columns description

The following link contains more information on the data of the domain: D_LOTTERY_USERS.

Domain - List of requested tariffs

Domain description

This domain contains details on tariffs mentioned in the ticket requests and corresponds to the view D_LOTTERY_TARIFF_DETAILS_V1_0 in which:

1 record = 1 request for a given tariff inside a given ticket request with information related to:

• Tariff and number of requested tickets 

• Concerned ticket request (ID) 

A record is identified in a unique way by means of all the following attributes: T_TICKET_REQUEST_ID, T_AUDIENCE_CAT_ID, T_AUDIENCE_SUB_CAT_ID

This domain is available since Whymper V1.

Domain's columns description

The following link contains moD_LOTTERY_TARIFF_DETAILS.

Domaine - List of guests

Domain description

This domain contains the list of guests planned for the requested tickets and corresponds to the view D_LOTTERY_GUESTS_V1_0 in which:

1 record = 1 guest of a given ticket being part of a given ticket request with information related to:

• Ticket request (ID)

• Guest information

A record is identified in a unique way by means of all the following attributes: T_GUEST_ID or (T_TICKET_REQUEST_ID, TICKET_REQUEST_RANK)

This domain is available since Whymper V1.

Domain's columns description

The following link contains more information on the data of the domain: D_LOTTERY_GUESTS.

Domaine - List of Lottery Operation request

Domain description

The new report has been renamed from "D_LOTTERY_OPERATION_REQUEST_V1_0" to "D_LOTTERY_OPERATION_REQUEST_V1_1" for the new version.

This domain contains detailed information on lottery application on the view D_LOTTERY_OPERATION_REQUEST_V1_1 in which:

1 record = 1 movement for a given lottery application with information related to:

• Application Id, Request Id, Operation Id, Movement Id

• Application state, Request state

• ID of S360 File, S360 Order

• ID package, performance, seatcat, tariff, contingent

• Quantity and unit amount

• Id of sales channel, point of sales

• The contact who applied and their EPC alias

• Rank & Rank priority

A record is identified in a unique way by means of the following attributes: : BALLOT_MOVEMENT_ID

Domain's columns description

The following link contains more information on the data of the domain: D_LOTTERY_OPERATION_REQUEST