Version: 1.0
| Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
|---|---|---|---|---|---|
| ACTIVITY | VARCHAR2 | 240 | Y | Activity | Activity name of event |
| AC_DATE | DATE | 7 | Y | Control date | Access control date |
| AC_DATETIME | DATE | 7 | Y | Control datetime | Access control date time (rounded to the minute) |
| AC_DATE_DAY | VARCHAR2 | 1 | Y | Control day | Access control date: day number in the week |
| AC_DATE_MM_YY | VARCHAR2 | 7 | Y | Control month | Access control date: month in MM.YYYY format |
| AC_DATE_WEEK | VARCHAR2 | 2 | Y | Control week | Access control date: week number |
| AC_DEVICE_CODE | VARCHAR2 | 100 | Y | Control Device code | Access control device code |
| AC_DTE | DATE | 7 | Y | Date-time of access control (unformated) | |
| AC_FAILURE_REASON | VARCHAR2 | 80 | Y | Failure reason | Access control failure reason |
| AC_GATE_CODE | VARCHAR2 | 100 | Y | Gate code | Access control gate code |
| AC_RD_DATETIME | DATE | 7 | Y | Rounded Control datetime | Access control date time (rounded to the previous quarter) |
| AC_RD_TIME | VARCHAR2 | 5 | Y | Access control time (rounded to the previous quarter) | |
| AC_RD_TIMEHR | VARCHAR2 | 16 | Y | Control hour | |
| AC_RESULT | VARCHAR2 | 25 | Y | Result | Access control result (OK/KO) |
| AC_SECTOR_CODE | VARCHAR2 | 100 | Y | Control Sector code | Access control sector code |
| AC_SYNC_DATETIME | VARCHAR2 | 16 | Y | Date time of synchronisation with access control system | |
| AC_TIME | VARCHAR2 | 8 | Y | Access control time | |
| AREA | VARCHAR2 | 240 | Y | Area | Area name |
| AREA_CODE | VARCHAR2 | 32 | Y | Area code | Area code |
| AUDIENCE_CAT | VARCHAR2 | 4000 | Y | Audience category name. Possible values are: - Invited in error - Complimentary guest - Member community - Member contact - Member group - Occasional community - Occasional contact - Promotional guest - Season-ticket community - Season-ticket contact - Royalty cost guest |
|
| AUDIENCE_SUB_CAT | VARCHAR2 | 240 | Y | Tariff name | |
| BLOCK | VARCHAR2 | 240 | Y | Block | Block name |
| BLOCK_CODE | VARCHAR2 | 32 | Y | Block code | Block code |
| COUNTING_PRODUCT | CHAR | 1 | Y | Boolean (T/F) indicating if it′s the particular ticket check is for a counting product | |
| INSTIT_CODE | VARCHAR2 | 15 | Y | Institution code | |
| LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
| NUMBER_OF_PARTICIPANTS | NUMBER | 22 | Y | Number of people matching the current ticket (1 for individual tickets, > 1 for group tickets) | |
| ORGANIZATION | VARCHAR2 | 240 | Y | Organization | Organization name |
| PRODUCT | VARCHAR2 | 240 | Y | Product | Product name |
| 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 |
| SALES_CHANNEL | VARCHAR2 | 240 | Y | Sales channel | Sales channel name |
| SAL_ENT_COUNTRY_CODE | CHAR | 2 | Y | Sales entity country code | Country code of the selling entity |
| SAL_ENT_ID | NUMBER | 22 | Y | Identifier of the sales entity | |
| SAL_ENT_NAME | VARCHAR2 | 240 | Y | Sales entity name | Name of the sales entity |
| SAL_ENT_STRUCT_ADDRESS | VARCHAR2 | 400 | Y | Mailing address of the contact structure | |
| SAL_ENT_STRUCT_COUNTRY_CODE | CHAR | 2 | Y | Contact structure country code | |
| SAL_ENT_STRUCT_ID | NUMBER | 22 | Y | Identifier of the contact structure | |
| SAL_ENT_STRUCT_NAME | VARCHAR2 | 400 | Y | Sales entity structure | Contact structure name |
| SAL_ENT_STRUCT_ZIP_CODE | VARCHAR2 | 20 | Y | Contact structure zip code | |
| SEASON | VARCHAR2 | 240 | Y | Season | Season name |
| SECTOR | VARCHAR2 | 240 | Y | Sector | Name of sector in which an area is located |
| SITE | VARCHAR2 | 240 | Y | Site | Name of site where event takes place |
| 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. |
| T_ACTIVITY_ID | NUMBER | 22 | Y | Activity technical identifier | |
| T_AUDIENCE_CAT_ID | NUMBER | 22 | Y | Audience category technical identifier | |
| T_AUDIENCE_SUB_CAT_ID | NUMBER | 22 | Y | Technical identifier of tariff | |
| T_MOVEMENT_ID | NUMBER | 22 | N | Technical identifier of movement | |
| T_OPERATION_ID | NUMBER | 22 | Y | Technical identifier of operation | |
| T_ORGANIZ_ID | NUMBER | 22 | Y | Technical identifier of organization | |
| T_PHYAREA_ID | NUMBER | 22 | Y | Technical identifier of physical area | |
| T_PHYBLOCK_ID | NUMBER | 22 | Y | Technical identifier of physical block | |
| T_PRODUCT_FAMILY_ID | NUMBER | 22 | Y | Technical identifier of product family | |
| T_PRODUCT_ID | NUMBER | 22 | Y | Product technical identifier | |
| T_SALES_CHANNEL_ID | NUMBER | 22 | Y | Technical identifier of sales channel | |
| T_SEASON_ID | NUMBER | 22 | Y | Season 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_TICKCHK_ID | NUMBER | 22 | Y | Technical identifier of ticket check | |
| T_TICKET_ID | NUMBER | 22 | Y | Technical identifier of ticket | |
| T_TOPIC_ID | NUMBER | 22 | Y | Technical identifier of goods topic |