Fields

This section details the required and optional fields that are included in an import file.

Field name* Data type Required Description
VER_ID | Name Numeric | String Yes A valid version name.
POSITION_NAME String Yes Must be unique in combination with version name.
POSITION_DESC String No
PAY_TYPE String Yes S for salary; H for hourly
SPREAD_ID | NAME Numeric | String Yes A valid spread method name.
ANNUAL_HOURS Numeric No
PAY_PERIODS Numeric No
ACTIVE String No Y for yes, N for no
BASE_RATE Numeric No The hourly rate if Pay_Type is hourly. The salary rate if Pay_Type is S.
STEP_GRADE_NAME String No A valid Step and Grade schedule name.
GRADE_NAME String No A valid grade for the schedule.
STEP String No
NUMERIC1 - NUMERIC2 Numeric No
STRING1 - STRING5 String No If values have been loaded for the attribute, then the import value must match.
DATE1 Date No
NOTE_TEXT String No
Note: For this load type, the field name is replaced by the corresponding attribute name from the Attribute Definition page. Only the activated attribute fields are displayed for import.