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.