Domain - Planned quotas

Domain description

This domain describes the use and availability of planned quotas (contingent type "sub-target group") and corresponds to the view D_AVL_PLANNED_QUOTAS_V1_0 in which:

1 record = information on:

either on a given contingent of type "sub-target group", a given performance (or match) and a given seat category
or on a given contingent of type "sub-target group", a given logical configuration and a given seat category

Each record provides information on:

Record type (description of a performance or a logical configuration)
Considered performance or logical configuration
Considered contingent
Considered seat category
Initial quota
Used quota
Quota available
Quota assigned in the seatmap
Proportion of the sold quota already seated or to be seated

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) or (T_CONTINGENT_ID, T_LOGCONFIG_ID, T_SEAT_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: D_AVL_PLANNED_QUOTAS_V1_0.pdf

Domain - Planned quotas of parents contingent