Skip to content

Insights Data Dictionary

Version 1.5 | November 2025

Introduction

This Data Dictionary offers a detailed overview of the elements available within Avionté DataLink, covering data from both Front Office and Back Office applications.

Avionté DataLink contains two types of data: Insights Data Warehouse data and Source Table data.

The Insights Data Warehouse is structured using a star schema, a data modeling technique that organizes data into central Fact tables surrounded by Dimension tables. In this schema, a central Fact table, which contains quantitative data for analysis, is linked to multiple Dimension tables that store descriptive attributes related to the data.

Source Tables contain unprocessed data from source systems such as BOLD (Front Office) and CLASSIC (Back Office).

This document details the Fact and Dimension tables of the Insights Data Warehouse, as well as the Source System tables. It provides column names within these tables, descriptions of each column, their data types, and default values where applicable. For Fact tables, additional diagrams are included to illustrate the relationships between tables and provide a visual representation of the data model. The document includes two appendices: Appendix A provides detailed descriptions of data types to assist in understanding and interpreting the data accurately; Appendix B contains screenshots from the application to visually reference where specific data elements appear in the source system.

Note on keys and IDs

The Insights Data Warehouse is transitioning from using Keys to using IDs. Keys are retained for backward compatibility but will eventually be deprecated. In most cases, the Key and ID columns have the same value. The exception is ActivityType, where ACTIVITYTYPEID is not the foreign key to the DIMACTIVITYTYPE table and ACTIVITYTYPEKEY should be used for joins instead.

Note on naming standards

Some changes have been made to standardize names to make it easier to write queries.

  • All underscores have been removed from column names.
  • The FCTACTIVITY table has been renamed to ACTIVITY_FACT to follow the naming standard already followed by the other Fact tables.

Fact tables

Dimension tables

Source tables

Appendices