Version: 1.0
| Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
|---|---|---|---|---|---|
| ACTIVITY | VARCHAR2 | 240 | Y | Activity | Activity name of event |
| 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 |
| ORGANIZATION | VARCHAR2 | 240 | Y | Organization | Organization name |
| PARENT_CONTINGENT | VARCHAR2 | 240 | Y | Parent contingent | Contingent name |
| PLANNED_C_CHILDREN | NUMBER | 22 | Y | Planned quota destined to complimentary tickets (sum of children contingents) | |
| PLANNED_C_PARENT | NUMBER | 22 | Y | Planned quota destined to complimentary tickets (parent contingent) | |
| PLANNED_P_CHILDREN | NUMBER | 22 | Y | Planned quota destined to paid tickets (sum of children contingents) | |
| PLANNED_P_PARENT | NUMBER | 22 | Y | Planned quota destined to paid tickets (parent contingent) | |
| PLANNED_QUOTA_TYPE_PARENT | VARCHAR2 | 6 | Y | Type of planned quota (parent contingent): 'L': logical contingent 'S': Sales contingent |
|
| PLANNED_T_CHILDREN | NUMBER | 22 | Y | Total planned quota (sum of children contingents) | |
| PLANNED_T_PARENT | NUMBER | 22 | Y | Total planned quota (parent contingent) | |
| 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_CHILDREN | NUMBER | 22 | Y | Initial quota assigned on the seatmap to the children of the parent contingent | |
| QUOTA_MAPPED_PARENT | VARCHAR2 | 40 | Y | Initial quota assigned on the seatmap to the parent contingent | |
| QUOTA_TO_BE_MAPPED_PARENT | NUMBER | 22 | Y | PLANNED_T_PARENT + PLANNED_T_CHILDREN minus QUOTA_MAPPED_PARENT minus QUOTA_MAPPED_CHILDREN | |
| SEASON | VARCHAR2 | 240 | Y | Season | Season name |
| SEAT_CATEGORY | VARCHAR2 | 240 | Y | Seat category | Seat category name |
| T_ACTIVITY_ID | NUMBER | 22 | Y | Activity technical identifier | |
| 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_PRODUCT_ID | NUMBER | 22 | Y | Product technical identifier | |
| T_P_CONTINGENT_ID | NUMBER | 22 | N | Technical identifier of contingent | |
| T_SEASON_ID | NUMBER | 22 | Y | Season technical identifier | |
| T_SEAT_CAT_ID | NUMBER | 22 | Y | Seat category technical identifier |