Domain - Access control

Domain description

This domain contains the access control history and corresponds to the ciew D_ACONTROL_TICKETCHECK_V1_0 in which:

1 record = 1 control performed on a ticket with information related to:

A record is identified in a unique way by means of the attribute T_TICKCHK_ID.

This domain is available since Piz Bernina V1.

Domain's columns description

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

Domain - List of tickets

Domain description

This domain contains the list of tickets and corresponds to the view D_SHIPMENTTICKET_TICKETS_V1_0 in which:

1 record = 1 ticket with information related to:

• Ticket holder (name, address, structure in case of relay) 

• Ticket information (price, barcode, state,…)

• Ticket purchase (order number, date, purchase contact)

• Seat location (in case of performance or match)

• Ticket delivery address

A record is identified in a unique way by means of the following attribute: T_TICKET_ID.

This domain is available since Matterhorn V3.

Domain's columns description

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

Domain - Questionnaires

Domain description

This domain contains answers to questionnaires and corresponds to the view D_SHIPMENTTICKET_QSTNR_V1_0 in which:

1 record = 1 answer to the questionnaire’s question linked to a ticket (the questionnaire is optional) with information related to:

A record is identified in a unique way by means of all the following attributes : T_TICKET_ID, QUESTION.

This domain is available since Matterhorn V3.

Domain's columns description

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