To provide report designers with an insight into the Data Structure for data consumption via the FastTrack360 Reporting module, a Reporting Data Dictionary exists and will be updated for each 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 are 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 12.20P1 Reporting Data Dictionary.
Click here to view the 12.20 Reporting Data Dictionary.
Click here to view the 12.19 Reporting Data Dictionary.
Click here to view the 12.15p2 Reporting Data Dictionary.
Click here to view the 12.10 Patch 3 Reporting Data Dictionary.
Click here to view the 12.10 Patch 1 Reporting Data Dictionary.