Tips for Designing Custom Pages and Fields

You can insert two types of fields:

Custom fields. These enable you to track information specific to your needs. Sage HRMS stores the information in one of the custom databases.

For single-record pages, fields are stored in HRTKPERS.
For multi-record pages, fields are stored in the page's unique database, TKMULXXX.

Sage HRMS fields. These enable you to reference information such as an employee's address or telephone number.

Most of the fields from the Employee Personnel (HRPERSNL) database can be updated from single-record custom pages.
Each custom page consists of two columns, each of which can include up to ten fields:
A single-record, single tab page can include a maximum of 20 fields.
A single-record, multi-tab page can include up to 16 fields per page for a maximum of 80 fields.
A multi-record, multi-tab page can include up to 18 fields per page for a maximum of 90 fields.
Custom fields can always be edited on a custom page. However, Sage HRMS fields may be display-only:

Fields from the Employee Personnel (HRPERSNL) database, can generally be updated from your custom pages.

Custom Fields

If you need to edit the properties of a field, use the following table as a guideline:

If you are editing a:	You can change:
Custom field	Field Title Field Level Security Required Field
Calculated field	Field Title Field Level Security Required Field Expression
Sage HRMS field on a single-record page	Field Title Required Field
Sage HRMS field on a multi-record page	Field Title

If you need to change any other properties of a custom field (such as Field Type and Field Length), you must delete the field and then add a new custom field with the correct properties.