Data Dictionary reports

The Data Dictionary is a collection of names and descriptions for the Sage HRMS system database tables, where all of your company and employee information is stored. Use the Data Dictionary reports to obtain the most recent version of the database structure in the software. After you have the database tables and structure identified, you can use this information to build custom reports.

To run Data Dictionary reports:

1. Select Reports > System > Data Dictionary Reports.

2. In the Data Dictionary Reports window, select one of the following options:

   • Files List to print a list of database files.
   • Fields List to print a list of all the fields within each database file.
   • Index Keys to print a list of the index keys.
3. Select the products you want to appear on the report by selecting the appropriate check boxes.
4. Click Preview to preview the report. Then, click the Close button to close the preview window.
5. Click Print to print the report.
6. Click the Close button to close the Data Dictionary Reports window.

Using functions in reports

Functions can be used to manipulate data in Sage HRMS reports. All field names beginning with an underscore are functions. You can use them rather than the standard field names when creating custom reports by simply selecting a field name beginning with an underscore.

For example, if you insert the field name _SEX, your report will display the field description of Male, Female, or Unknown for an employee’s gender. If you insert the field name P_SEX, your report will display the code M, F, or U instead. Some of the functions (field names beginning with an underscore) do more than display a description rather than its code. The function _NAME1 displays the employee’s name as: Last, First Middle.