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.10 Patch 1 Reporting Data Dictionary.
Click here to view the 12.10 Patch 3 Reporting Data Dictionary.
Click here to view the 12.15p2 Reporting Data Dictionary.
Click here to view the 12.19 Reporting Data Dictionary.