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 |