Domain - Guide planning

Domain description

This domain contains the guides availability and corresponds to the view D_VISIT_GUIDE_AVL_V1_0 in which:

1 record = 1 availability or unavailability period of a guide. Following information is available:

  • Guide
  • Availability or unavailability 
  • Date, hour, day of the week of the period

A record is identified in a unique way by means of the attributes: GUIDE_ID (or CONTACT_ID), RESOURCEPERIOD_ID.

This domain is available since Matterhorn V3.

Domain's columns description

The following link contains more information on the data of the domain: D_VISIT_GUIDE_AVL

Domain - Visit planning

Domain description

This domain contains visit planning and corresponds to the view D_VISIT_PLANNING_DATA_V1_1 in which:

1 record = 1 visit on a given timeslot led by a given guide for a given group. Following information is available:

  • Guide
  • Information on the visit (product, timeslot)
  • Theme and language
  • Infomration on the group (name, nature, group criteria, number of people planned and actual)
  • Information on the purchase
  • Remark: group criteria are defined by SecuTix for each institution (e.g. qualification and handicap type)

A record is identified in a unique way by means of the attributes: T_PRODUCT_ID, T_TIMESLOT_ID, T_GUIDE_ID, VISITGROUP_ID.

This domain is available since Matterhorn V3.

Domain's columns description

The following link contains more information on the data of the domain: D_VISIT_PLANNING_DATA