Version: 1.0
| Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
|---|---|---|---|---|---|
| ACTIVITY | VARCHAR2 | 240 | Y | Activity | Activity name of event |
| AVAILABLE_C | NUMBER | 22 | Y | Planned quota complimentary minus reservations minus sales for FREE tariffs. Null in case of logical contingents | |
| AVAILABLE_FORECAST_C | NUMBER | 22 | Y | Planned quota complimentary minus reservations minus sales minues all options for FREE tariffs. Null in case of logical contingents | |
| AVAILABLE_FORECAST_P | NUMBER | 22 | Y | Planned quota purchase minus reservations minus sales minus all options for non FREE tariffs. Null in case of logical contingents | |
| AVAILABLE_FORECAST_T | NUMBER | 22 | Y | Planned quota minus reservations minus sales minus all options. Null in case of logical contingents | |
| AVAILABLE_P | NUMBER | 22 | Y | Planned quota purchase minus reservations minus sales for non FREE tariffs. Null in case of logical contingents | |
| AVAILABLE_T | NUMBER | 22 | Y | Planned quota minus reservations minus sales. Null in case of logical contingents | |
| CONTINGENT | VARCHAR2 | 240 | Y | Contingent | Contingent name |
| INSTIT_CODE | VARCHAR2 | 15 | N | Institution code | |
| LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
| LOGICAL_CONFIGURATION | VARCHAR2 | 240 | Y | Logical configuration | Internal name of logical configuration |
| OPTION_PRE_REQUESTED_C | NUMBER | 22 | Y | Number of pre-requested options for tariffs of type FREE. Null in case of logical contingents | |
| OPTION_PRE_REQUESTED_P | NUMBER | 22 | Y | Number of pre-requested options for tariffs of type not FREE. Null in case of logical contingents | |
| OPTION_PRE_REQUESTED_T | NUMBER | 22 | Y | Number of pre-requested options. Null in case of logical contingents | |
| OPTION_REQUESTED_C | NUMBER | 22 | Y | Number of options requested for tariffs of type FREE. Null in case of logical contingents | |
| OPTION_REQUESTED_P | NUMBER | 22 | Y | Number of options requested for tariffs of type not FREE. Null in case of logical contingents | |
| OPTION_REQUESTED_T | NUMBER | 22 | Y | Number of options requested. Null in case of logical contingents | |
| OPTION_VALIDATED_C | NUMBER | 22 | Y | Number of options requested for tariffs of type FREE. Null in case of logical contingents | |
| OPTION_VALIDATED_P | NUMBER | 22 | Y | Number of options requested for tariffs of type not FREE. Null in case of logical contingents | |
| OPTION_VALIDATED_T | NUMBER | 22 | Y | Number of options validated. Null in case of logical contingents | |
| ORGANIZATION | VARCHAR2 | 240 | Y | Organization | Organization name |
| PARENT_CONTINGENT | VARCHAR2 | 240 | Y | Parent contingent | Contingent name |
| PLANNED_C | NUMBER | 22 | Y | Planned quota destined to complimentary tickets | |
| PLANNED_P | NUMBER | 22 | Y | Planned quota destined to paid tickets | |
| PLANNED_QUOTA_TYPE | VARCHAR2 | 6 | Y | Type of planned quota: 'L': logical contingent 'S': Sales contingent |
|
| PLANNED_T | NUMBER | 22 | Y | Total planned quota | |
| PRODUCT | VARCHAR2 | 240 | Y | Product | Product name |
| PRODUCT_DATE_TIME | TIMESTAMP(3) | 11 | Y | Product date time | Performance or timeslot date and time (dd.mm.yyyy hh:mm:ss) |
| QUOTA_MAPPED | VARCHAR2 | 40 | Y | Initial quota assigned to the contingent on the seatmap | |
| QUOTA_TO_BE_MAPPED | NUMBER | 22 | Y | PLANNED_T minus QUOTA_MAPPED | |
| RESERVED_C | NUMBER | 22 | Y | Number of reservations for tariffs of type FREE. Null in case of logical contingents | |
| RESERVED_P | NUMBER | 22 | Y | Number of reservations for tariffs of type not FREE. Null in case of logical contingents | |
| RESERVED_SEATED | NUMBER | 22 | Y | Number of reserved tickets that have already been seated. Null in case of logical contingents | |
| RESERVED_T | NUMBER | 22 | Y | Number of reservations. Null in case of logical contingents | |
| RESERVED_TO_BE_SEATED | NUMBER | 22 | Y | Number of reserved tickets that remain to be seated. Null in case of logical contingents. | |
| SEASON | VARCHAR2 | 240 | Y | Season | Season name |
| SEAT_CATEGORY | VARCHAR2 | 240 | Y | Seat category | Seat category name |
| SOLD_C | NUMBER | 22 | Y | Number of sale for tariffs of type FREE. Null in case of logical contingents | |
| SOLD_P | NUMBER | 22 | Y | Number of sales for tariffs of type not FREE. Null in case of logical contingents | |
| SOLD_SEATED | NUMBER | 22 | Y | Number of sold tickets that have already been seated. Null in case of logical contingents | |
| SOLD_T | NUMBER | 22 | Y | Number of sales. Null in case of logical contingents | |
| SOLD_TO_BE_SEATED | NUMBER | 22 | Y | Number of sold tickets that remain to be seated. Null in case of logical contingents. | |
| T_ACTIVITY_ID | NUMBER | 22 | Y | Activity technical identifier | |
| T_CONTINGENT_ID | NUMBER | 22 | N | Technical identifier of contingent | |
| T_LOGCONFIG_ID | NUMBER | 22 | Y | Technical identifier of performance logical configuration | |
| T_ORGANIZ_ID | NUMBER | 22 | Y | Technical identifier of organization | |
| T_PERFORMANCE_ID | NUMBER | 22 | Y | Technical identifier of performance | |
| T_PLANNED_QUOTAS_ID | NUMBER | 22 | N | Planned quotas technical identifier | |
| T_PRODUCT_ID | NUMBER | 22 | Y | Product technical identifier | |
| T_P_CONTINGENT_ID | NUMBER | 22 | Y | Technical identifier of contingent | |
| T_SEASON_ID | NUMBER | 22 | Y | Season technical identifier | |
| T_SEAT_CAT_ID | NUMBER | 22 | N | Seat category technical identifier |