Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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_REQUESTS_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: This link will be available with Whymper V1.

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: This link will be available with Whymper V1.

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 more information on the data of the domain: This link will be available with Whymper V1.

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: This link will be available with Whymper V1.