Validate field names in the XML definition
When saving a Payroll Export Task, the field names in both <field> and <dummy_field> elements are validated against system-defined properties. Field names that start with reserved prefixes, such as job_, dept_, and tcode_, must match valid data properties. Otherwise, the task cannot be saved and an error is displayed.
The system also validates <field> elements that do not use reserved prefixes to ensure that they exist as columns in the payroll export database views. This validation does not apply to <dummy_field> elements or fields with reserved prefixes.
To avoid validation errors, use custom field names that do not begin with reserved prefixes and update all related references when renaming.
Reserved prefix table
This table shows the reserved prefixes and the corresponding data types used to validate field names:
| Reserved prefix | Validate against | Valid fields example |
|---|---|---|
| dept_ | DepartmentData | dept_name, dept_id |
| shft_ | ShiftData | shft_name, shft_id |
| paygrp_ | PayGroupData | paygrp_name, paygrp_id |
| calcgrp_ | CalcGroupData | calcgrp_name, calcgrp_id |
| job_ | JobData | job_name, job_id |
| dock_ | DocketData | dock_name, dock_id |
| proj_ | ProjectData | proj_name, proj_id |
| tcode_ | TimeCodeData | tcode_name, tcode_id |
| htype_ | HourTypeData | htype_name, htype_id |
| wbt_ | WorkbrainTeamData | wbt_name, wbt_id |
| rsncd_ | ReasonCodeData | rsncd_name, rsncd_id |
| acctu_ | AcctUnitData | acctu_desc, acctu_label |
| acctp_ | AcctProjectData | acctp_desc, acctp_label |
| accta_ | AcctAccountData | accta_desc, accta_label |
| dimension1_ | AcctDimensionData | dimension1_desc, dimension1_label |
| dimension2_ | AcctDimensionData | dimension2_desc, dimension2_label |
| dimension3_ | AcctDimensionData | dimension3_desc, dimension3_label |
| dimension4_ | AcctDimensionData | dimension4_desc, dimension4_label |
| dimension5_ | AcctDimensionData | dimension5_desc, dimension5_label |
| dimension6_ | AcctDimensionData | dimension6_desc, dimensio6_label |
| dimension7_ | AcctDimensionData | dimension7_desc, dimension7_label |
| dimension8_ | AcctDimensionData | dimension8_desc, dimension8_label |
| dimension9_ | AcctDimensionData | dimension9_desc, dimension9_label |
| dimension10_ | AcctDimensionData | dimension10_desc, dimension10_label |