The Data Dictionary describes the database structure for all the database files used by Sage HRMS. Use this information when building expressions within Sage HRMS or creating custom reports using SAP Crystal Reports.
The Data Dictionary is also useful for programmers writing supplemental applications that share Sage HRMS data. If you want to access this 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.
Database structures
Before you access a database file, it is helpful to have the file layout (the database structure) available.
The following field type codes are used:
|
Code |
Definition |
|---|---|
| C | Character |
| N | Numeric |
| T | Date/Time |
| L | Logical |
| M | Memo |
| I | Integer |
| G | General Note |
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.