Fields
This section details the required and optional fields that can be included in an import file.
Required fields are dependent on the position definition.
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 shown for import.
| Field name | Data type | Required | Description |
|---|---|---|---|
| POSITION_NAME | String | Yes | A valid position name. |
| VER_ID | Name | Numeric | String | Yes | A valid version name. |
| MEM_ID | Name | Numeric | String | Yes | A valid primary dimension name. |
| EMPLOYEE_ID | Numeric | No | If specified, a valid employee ID. |
| POSITION_TYPE | Numeric | Yes | 1 for authorized position; 0 for assigned position |
| HEADCOUNT | Numeric | Yes | |
| ACTIVE | String | Yes | Y for yes, N for no |
| BASE_RATE | Numeric | Yes* | |
| STEP_GRADE_NAME | String | Yes* | A step and grade schedule name. |
| GRADE_NAME | String | Yes* | |
| STEP | Numeric | Yes* | |
| SPREAD_METHOD | String | No | |
| NUMERIC1 - NUMERIC2 | Numeric | As specified on the Attribute Definitions page. | |
| STRING1 - STRING5 | String | As specified on the Attribute Definitions page. | |
| ALLOCATION_ID | String | No | An ID associated with loaded allocation definitions. |
| EFFECTIVE_START | Date | Yes | |
| EFFECTIVE_END | Date | No | |
| DATE1 | Date | As specified on the Attribute Definitions page. | |
| NOTE_TEXT | String | No |
Note: The import file must contain base rate or step and grade information.
If supplying step and grade information, data for all three fields must be
supplied.