The Data Dictionary documents the database structure for all the database files used by Sage HRMS. You might find this information useful when building expressions within Sage HRMS or creating custom reports using SAP Crystal Reports.
It is also useful for programmers writing supplemental applications that share Sage HRMS data. If you want to access your data externally to the Sage HRMS software, you should have a thorough knowledge of database concepts and the database software you intend to use.
Note: Time Off databases work with the databases included with Sage HRMS.
Before you access a database file, you can have the file layout (the database structure) available.
The field type codes are as follows:
The Descriptions that accompany the fields in the data dictionaries are shown in SAP Crystal Reports when you select fields to include in your custom reports. To obtain the most recent version of the database structure, run the Data Dictionary reports.