Domain - Product follow up

Domain description

This domain contains product availability and corresponds to the view D_AVL_PROD_FOLLWUP_V1_0 in which:

1 record = quota and availability of a ticketing product for a given contingent with information related to:

A record is identified in a unique way by means of all the following attributes : T_CONTINGENT_ID, T_ITEM_ID, T_TIMESLOT_ID, T_VISITGROUP_ID. The attributes T_TIMESLOT_ID, T_VISITGROUP_ID can be null.

In case of a performance or a match, T_ITEM_ID can be replaced by the couple (T_PERFORMANCE_ID, T_SEAT_CAT_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_AVL_PROD_FOLLWUP

Domain - Room availability

Domain description

This domain contains the seats availability in a given room and corresponds to the view D_AVL_ROOM_AVL_V1_0 in which:

1 record = For a given performance or match, the number of seats of a given category located in a given area and block, assigned to a given contingent with the information related to:

• The given performance or match
• Location: area, block, sector, level, access
• Contingent
• Quota
• Availability
• Number of seats sold, booked, invalidated, blocked

A record is identified in a unique way by means of all the following attributes : T_CONTINGENT_ID, T_PERFORMANCE_ID, T_SEAT_CAT_ID, T_PHYAREA_ID, T_PHYBLOCK_ID. The attribute T_PHYBLOCK_ID can be null.

This domain is available since Matterhorn V3.

Domain's columns description

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