FastTrack360 Version 12 Online Help

Reporting Data Dictionary (11.37 / UK Release 12.10).

Owned by Fiona Sims
Last updated: 06 February 2022
1 min read

Description


To provide users with an insight into the Data Structure for data consumption via the FastTrack360 Reporting module, a Reporting Data Dictionary has been included with this release.


The document is structured into a series of sections under the following hierarchical structure:

  • Product Area (e.g. Rates & Rules)

  • Functional Area (e.g. Agreements)

There will be one or more tables listed beneath each Functional Area and each of these tables corresponds to a database table in the FastTrack360 database. Each of these tables lists;

  • The table purposes

  • All database fields and their purpose

  • Primary and Foreign Key Relationship to other tables

  • References to field values where they are a boolean or enumerator value i.e. Status; 1 = Active, 2= Inactive.

Click here to view the 11.37 Reporting Data Dictionary.

Benefits

The Reporting Data Dictionary will assist users of the Report Designer tool where custom reports are developed using custom SQL queries.

Configuration

No configuration is required.

 

 

Classification-Public