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:

  • Control’s date and time

  • Control’s location (sector, gate)

  • Controlled product

  • Considered tariff

  • Sales channel

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:

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

  • Question and answer

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

  • Ticket purchase (order number, date)

  • Linked product

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


Domain - Mobile Ticket Status

Domain description

This domain contains the list of tickets and its mobile information retrieved from blockchain.

1 record = 1 ticket with information related to:

  • SecuTix Ticket ID
  • Ticket status: ONLINE_ACTIVATED, DOWNLOADED ,DELETED, PENDING_TRANSFER, FAILURE_TRANSFER, MANUAL_ACTIVATED, CONTROLLED, TRANSFERRED, OFFLINE_ACTIVATED, FAILURE, INJECTED, DELETION_PENDING
  • Current user, with all its details
  • Activation details: date/time/beacon or manual/Phone model/Duration (first activation)
  • Ticket assignee information (optional, only if entered and not owner, all fields)

Domain's columns description

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


Domain - Mobile Ticket Transactions

Domain description

This domain contains the list of mobile ticket transactions and its detail information.

1 record = 1 transaction with information related to:

  • SecuTix Ticket ID
  • Ticket status: ONLINE_ACTIVATED, DOWNLOADED ,DELETED, PENDING_TRANSFER, FAILURE_TRANSFER, MANUAL_ACTIVATED, CONTROLLED, TRANSFERRED, OFFLINE_ACTIVATED, FAILURE, INJECTED, DELETION_PENDING
  • Transaction date and time
  • Recipient, with all its details
  • Sender user email and phone number (empty for inject and delete)
  • Blockchain Transaction ID

Domain's columns description

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

© SecuTix 2023 - Login