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 |