Version: 1.1
| Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
|---|---|---|---|---|---|
| ACCOMPANYING_CNT | NUMBER | 22 | Y | Expected number of accompanying persons | |
| ACTIVITY | VARCHAR2 | 240 | Y | Activity | Activity name of event |
| CONTACT_ID | VARCHAR2 | 4000 | Y | Contact Id | Contact technical identifier |
| DIFF_ACTUAL_FORESEEN | NUMBER | 22 | Y | Difference Actual – foreseen | Difference between expected and actual number of participants |
| DONE_DURATION | NUMBER | 22 | Y | Done duration | Total visit duration already done by the guide |
| DONE_VISIT | NUMBER | 22 | Y | Done timeslot | Total number of visits already done by the guide |
| ESTIMATED_ARRIVAL_HOUR | TIMESTAMP(6) | 11 | Y | Estimated arrival hour | Estimated arrival hour |
| FILE_CONTACT | VARCHAR2 | 4000 | Y | File contact | Name of file contact in format: "lastname,firstname(contact number)" ( only valid for visit groups ) |
| FILE_CONTACT_EMAIL | VARCHAR2 | 4000 | Y | File contact email | Email address of contact |
| FILE_CONTACT_TELEPHONE | VARCHAR2 | 4000 | Y | File contact telephone | Phone number incl. Prefix |
| FILE_NUMBER | VARCHAR2 | 4000 | Y | File number | File number |
| FORESEEN_TOTAL_CNT | NUMBER | 22 | Y | Foreseen total number | Expected total number of visitors |
| GROUP_CRITERION_1 | VARCHAR2 | 4000 | Y | Value of 1st criterion of visit group | |
| GROUP_CRITERION_2 | VARCHAR2 | 4000 | Y | Value of 2nd criterion of visit group | |
| GROUP_CRITERION_3 | VARCHAR2 | 4000 | Y | Value of 3rd criterion of visit group | |
| GROUP_NAME | VARCHAR2 | 400 | Y | Group name | Group name |
| GROUP_NATURE | VARCHAR2 | 4000 | Y | Group nature | Nature of group. Possible values are: - Adult - Secondary school - Primary school - Pre-school |
| GUIDE | VARCHAR2 | 4000 | Y | Guide | Last name, firstname of guide |
| GUIDE_PLANNING_MARGIN_AFTER | NUMBER | 22 | Y | Margin after visit | Margin after visit |
| GUIDE_PLANNING_MARGIN_BEFORE | NUMBER | 22 | Y | Margin before visit | Margin before visit |
| INSTIT_CODE | VARCHAR2 | 15 | Y | Institution code | |
| IS_ALLOCATED_GUIDE | VARCHAR2 | 1 | Y | Flag indicating if a guide has been attributed to a visit | |
| IS_GUIDED | VARCHAR2 | 1 | Y | Flag indicated if the visit is guided | |
| LANGUAGES | VARCHAR2 | 4000 | Y | Name of visit language | |
| LANGUAGE_CODE | VARCHAR2 | 32 | Y | Code of visit language | |
| LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
| OPERATION_TYPE | VARCHAR2 | 25 | Y | Operation type | Operation type. Possible values are: - booking - booking cancellation - sale - refund - option - option cancellation |
| ORGANIZATION | VARCHAR2 | 240 | Y | Organization | Organization name |
| PARTICIPANTS_CNT | NUMBER | 22 | Y | Number of participants (excluding number of accompanying people) | |
| PRODUCT | VARCHAR2 | 240 | Y | Product | Product name |
| PRODUCT_DATE | VARCHAR2 | 10 | Y | Product date | Performance or timeslot date (dd.mm.yyyy) |
| PRODUCT_DATE_MONTH | VARCHAR2 | 7 | Y | Performance or timeslot month (mm.yyyy) | |
| PRODUCT_DATE_TIME | VARCHAR2 | 16 | Y | Product date time | Performance or timeslot date and time (dd.mm.yyyy hh:mm:ss) |
| PRODUCT_DATE_YEAR | VARCHAR2 | 4 | Y | Performance or timeslot year (yyyy) | |
| PRODUCT_TYPE | VARCHAR2 | 240 | Y | Product type | Name of product type |
| RATE_TYPE | VARCHAR2 | 240 | Y | Rate type | Name of rate type |
| REMARK | VARCHAR2 | 4000 | Y | Remark | Remark for the group |
| SEASON | VARCHAR2 | 240 | Y | Season | Season name |
| SITE | VARCHAR2 | 240 | Y | Site | Name of site where event takes place |
| SPACE | VARCHAR2 | 240 | Y | Space | Name of space where event takes place |
| THEME | VARCHAR2 | 240 | Y | Theme | Theme of the visit |
| TOTAL_CNT | NUMBER | 22 | Y | Total number of actual visitors | |
| TOTAL_CNT_GUIDE | NUMBER | 22 | Y | Total people per guide | Total number of visitors per guide |
| TOTAL_SOLD_AMOUNT | NUMBER | 22 | Y | Total sales amount including tax | |
| TO_DELETE | NUMBER | 22 | Y | This field will be removed soon | |
| T_ACTIVITY_ID | NUMBER | 22 | Y | Activity technical identifier | |
| T_GUIDE_ID | VARCHAR2 | 4000 | Y | Technical identifier of contact | |
| T_ORGANIZATION_ID | NUMBER | 22 | Y | Technical identifier of organization | |
| T_PERFORMANCE_ID | NUMBER | 22 | Y | Technical identifier of performance | |
| T_PRODUCT_DATE_TIME | TIMESTAMP(9) | 11 | Y | Date and hour of start of timeslot | |
| T_PRODUCT_DURATION | NUMBER | 22 | Y | Duration of timeslot | |
| T_PRODUCT_FAMILY_ID | NUMBER | 22 | Y | Technical identifier of product family | |
| T_PRODUCT_ID | NUMBER | 22 | Y | 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_SITE_ID | NUMBER | 22 | Y | Technical identifier of site | |
| T_SPACE_ID | NUMBER | 22 | Y | Technical identifier of space | |
| T_THEME_ID | NUMBER | 22 | Y | Ideue of 2nd criterion of product visits | |
| T_TIMESLOT_ID | NUMBER | 22 | Y | Technical identifier of timeslot | |
| T_VISITGROUP_STATE | VARCHAR2 | 25 | Y | State of visit group. Possible values are: - RESERVED - SOLD - CANCELLED - Undefined (for old visits (performances)) |
|
| T_VISIT_STATE | VARCHAR2 | 25 | Y | Visit state - CLOSED - RUNNING - SUSPENDED - VALIDATED - PREPARING |
|
| VISITGROUP_ID | NUMBER | 22 | Y | Technical identifier of visit group | |
| VISIT_PRICING_TYPE | VARCHAR2 | 4000 | Y | Pricing type of visit pass. Possible values are: - PER_PERSON - GROUP_FLAT_RATE - Undefined (for old visits (performances)) |
|
| VISIT_STATE | VARCHAR2 | 4000 | Y | Visit state | Visit state - CLOSED - RUNNING - SUSPENDED - VALIDATED - PREPARING |
| VISIT_TICKET_TYPE | VARCHAR2 | 4000 | Y | Ticket type of visit pass. Possible values are: - INDIVIDUAL_TICKET - GROUP_TICKET - Undefined (for old visits (performances)) |
|
| VISIT_TYPE | VARCHAR2 | 4000 | Y | Type of visit pass. Possible values are: - INDIVIDUAL_VISIT - GROUP_VISIT - Undefined (for old visits (performances)) |