Define a Custom Field

1. Select Setup > System > Design Custom Details..
2. Select the page and click More.
3. Click the location where you want to add the field. The Define a Custom Field dialog box opens.
4. Click Employee Custom Fields and then click Add. The Field Information dialog box opens.
5. In the Field Title box, enter up to 20 characters for the field title (label) as it is to appear on the page.
6. In the Database Field box, enter up to eight characters for a field name that will uniquely identify the field in the custom database. When you save the field, Custom Details automatically adds a "U" to the field name.
7. From the Data Type drop-down list, select a data type. Depending on the data type selected, you may need to define related properties for the custom field, as described in the data type table.

   • Character. Specify the Field Length. The maximum length is 254 characters.
   • Numeric. Specify the Field Length and number of Decimal Places.
   • Date. Automatically formatted.

   • Code Table. Select the appropriate custom Code Table from the Table Name drop-down list.

     Note: You must define any code tables you want to use before designing or using your custom pages. For more information, see Create a Custom Code Table.

   • Logical. Automatically formatted with Yes and No radio buttons.
   • Calculated. Build an expression using the Expression Builder. For more information, see To Add a Calculated Field.

8. For Required Field, select Yes or No. If you select Yes, the field cannot be left blank when a user is entering data on the page.
• This property is not available for Logical or Calculated fields.
• A required field is indicated by a red "R" on the design page; the "R" is not visible when a user is entering data on the page.
9. For Field Level Security, select from three Field Level Security options: Same as Address/Phone, Same as EEO, or Same as Salary. For example, if you select Same as Salary, users will have the same access to view or update this custom field that they have for salary fields.
• A field with Field Level Security is indicated by a blue "S" on the design page; the "S" is not visible when a user is entering data on the page.
• Field level security only affects whether a user can view or update the fields on a custom page. You must also set security for custom fields when generating custom reports.
10. Click OK to save the field properties and close the dialog box.
11. Continue to create new custom fields as needed.

Published: May 17, 2017
© 2017 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks