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.
The following link contains more information on the data of the domain: D_LOTTERY_TICKET_REQUEST.
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.
The following link contains more information on the data of the domain: D_LOTTERY_USERS.
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.
The following link contains more information on the data of the domain: D_LOTTERY_TARIFF_DETAILS.
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.
The following link contains more information on the data of the domain: D_LOTTERY_GUESTS.
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
The following link contains more information on the data of the domain: D_LOTTERY_OPERATION_REQUEST