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 the 11.37 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.