Published — v. 15
/
Theme: Attendance

Theme: Attendance

Domain - Attendance

Domain description

This domain contains attendance statistics and corresponds to the view D_ANALYTICS_ATTEND_V1_0 in which:

1 record = 1 movement with information related to:

  • The related product

  • The related ticket (if any)
  • The date-time at which the ticket (if any) has been checked the first time

  • The related tariff

  • The geographical area (accuracy level: postal code) of the ticket holder

  • Sales channel

A record is identified in a unique way by means of the following attributes: T_MOVEMENT_ID

This domain is available since Matterhorn V3 and has been refactored during Whymper V1.

Domain's columns description

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

Important remarks

  • This domain has been significantly refactored during Whymper V1 in order to improve the performances of the update process. Previously, it was containing pre-aggregated data. More precisely, before Whymper V1, a record was describing the usage of a given ticketing product by persons located within a given area and entitled to the same tariff within a time frame of 15 minutes. Each record was therefore matching several movements. The data contained in this domain aren't aggregated anymore.
  • This design change at domain level has an impact on the BI developers but has no consequences on the users of the reporting tool. Indeed, the reporting tool performs the aggregations that was previously performed by the domain itself.

Related content

BI and reporting domains
BI and reporting domains
More like this
Thème: Fréquentations
Thème: Fréquentations
Read with this
Theme: Availability
Theme: Availability
More like this
Theme: Tickets
Theme: Tickets
More like this
Theme: Visits
Theme: Visits
More like this
Theme: Planned quotas
Theme: Planned quotas
More like this

© SecuTix 2023 - Login