Domain - List of ticket requests

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.

Domain - List of lottery users

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:

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:

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.