Version: 1.0
Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
---|---|---|---|---|---|
ACTIVITY | VARCHAR2 | 240 | Y | Activity | Activity name of event |
ASSIGNED_QTY | NUMBER | 22 | Y | Number of bookings and sales (cancellations are subtracted) | |
BOOKING_T_QTY | NUMBER | 22 | Y | Booking T | Total number of bookings (cancellations are subtracted) |
BOOKING_T_STARTS | NUMBER | 22 | Y | Booking T starts | Number of booked starts (cancellations are subtracted) |
CONTINGENT | VARCHAR2 | 4000 | Y | Contingent | Contingent name |
INSTIT_CODE | VARCHAR2 | 15 | N | Institution code | |
ITEM | VARCHAR2 | 4000 | Y | Item | Item name |
LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
LOGICAL_SEAT_CATEGORY | VARCHAR2 | 240 | Y | Logical seat category | Name of logical seat category |
OPTION_PRE_REQ_QTY | NUMBER | 22 | Y | Number of pre requested options | |
OPTION_REJECT_QTY | NUMBER | 22 | Y | Number of rejected options | |
OPTION_REQ_QTY | NUMBER | 22 | Y | Number of requested options | |
OPTION_T_QTY | NUMBER | 22 | Y | Requested T | Total number of options |
OPTION_VALID_QTY | NUMBER | 22 | Y | Number of validated/confirmed options | |
ORGANIZATION | VARCHAR2 | 240 | Y | Organization | Organization name |
PRODUCT | VARCHAR2 | 240 | Y | Product | Product name |
PRODUCT_DATE | VARCHAR2 | 8 | Y | Product date | Performance or timeslot date (dd.mm.yyyy) |
PRODUCT_DATE_TIME | TIMESTAMP(3) | 11 | Y | Product date time | Performance or timeslot date and time (dd.mm.yyyy hh:mm:ss) |
PRODUCT_FAMILY | VARCHAR2 | 4000 | Y | Prod. Family | Product family name. Possible values are: - Membership - Season ticket - Voucher - Goods - Hospitality bundle - Competition - Event - Package - Dated pass - Timeslot pass - Non-dated pass - Visit pass - Service - Hospitality - Open product - Visit |
PRODUCT_TYPE | VARCHAR2 | 240 | Y | Product type | Name of product type |
QUOTA | VARCHAR2 | 40 | Y | Quota | Initial number of available seats (neither booked, nor sold, nor invalidated, nor frozen) matching the current table row |
RATE_TYPE | VARCHAR2 | 240 | Y | Rate type | Name of rate type |
RESERVED_SEATED | NUMBER | 22 | Y | Number of reserved tickets that have already been seated. Null in case of logical contingents | |
RESERVED_TG_SEATED | NUMBER | 22 | Y | Number of reserved tickets that have already been seated on target. | |
SEASON | VARCHAR2 | 240 | Y | Season | Season name |
SEAT_CAT | VARCHAR2 | 32 | Y | Seat category name | |
SITE | VARCHAR2 | 240 | Y | Site | Name of site where event takes place |
SOLD_C_QTY | NUMBER | 22 | Y | Sold C | Number of sales of free tickets (cancellations are subtracted) |
SOLD_P_QTY | NUMBER | 22 | Y | Sold P | Number of sold paid tickets (cancellations are subtracted) |
SOLD_SEATED | NUMBER | 22 | Y | Number of sold tickets that have already been seated. Null in case of logical contingents | |
SOLD_TG_SEATED | NUMBER | 22 | Y | Number of sold tickets that have already been seated on target. | |
SOLD_T_QTY | NUMBER | 22 | Y | Sold T | Total number of sales (cancellations are subtracted) |
SOLD_T_STARTS | NUMBER | 22 | Y | Sold T starts | Total number of sold starts (cancellations are subtracted) |
SPACE | VARCHAR2 | 240 | Y | Space | Name of space where event takes place |
SUB_TOPIC | VARCHAR2 | 240 | Y | Sub topic | Subtopic (level 1) of lowest rank assigned to the product. |
TOPIC | VARCHAR2 | 240 | Y | Topic | Parent of the subtopic related to the product. |
TO_DELETE | NUMBER | 22 | Y | This field will be removed soon | |
T_ACTIVITY_ID | NUMBER | 22 | Y | Activity technical identifier | |
T_CONTINGENT_ID | NUMBER | 22 | Y | Technical identifier of contingent | |
T_ITEM_ID | NUMBER | 22 | N | Technical identifier of item | |
T_LOG_SEAT_CAT_ID | NUMBER | 22 | Y | Technical identifier of logical seat category | |
T_ORGANIZ_ID | NUMBER | 22 | Y | Technical identifier of organization | |
T_PERFORMANCE_ID | NUMBER | 22 | Y | Technical identifier of performance | |
T_PRODUCT_FAMILY_ID | NUMBER | 22 | N | Technical identifier of product family | |
T_PRODUCT_ID | NUMBER | 22 | N | Product technical identifier | |
T_PRODUCT_TYPE_ID | NUMBER | 22 | Y | Technical identifier of product type | |
T_RATE_TYPE_ID | NUMBER | 22 | Y | Technical identifier of rate type | |
T_SEASON_ID | NUMBER | 22 | Y | Season technical identifier | |
T_SEAT_CAT_ID | NUMBER | 22 | Y | Seat category technical identifier | |
T_SITE_ID | NUMBER | 22 | Y | Technical identifier of site | |
T_SPACE_ID | NUMBER | 22 | Y | Technical identifier of space | |
T_SUB_TOPIC_ID | NUMBER | 22 | Y | Identifier of subtopic | |
T_TIMESLOT_ID | NUMBER | 22 | Y | Technical identifier of timeslot | |
T_TOPIC_ID | NUMBER | 22 | Y | Technical identifier of goods topic | |
VISIT_STARTS_QUOTA | VARCHAR2 | 40 | Y | Initial quota of starts available for a visit |