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 is updated for each new product release.
The document is structured into a series of sections under the following hierarchical structure:
...
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 Boolean or enumerator value i.e. Status; 1 = Active, 2= Inactive.
Click here to 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 Dictionaryapplicable to your environment, please see FT360 Releases and click on the relevant release. Within the release pages, navigate to the Reporting Modules Enhancements section to find the related Data Dictionary. The Database Schema changes for each release are also available within this section.