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:

Table 1.
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

See VIEW_PAYEXP_CURRENT fields.