Fields
This section details the required and optional fields that are included in an import file.
Required fields are dependent on the Action Definition.
You cannot specify both FTE and Hours for a base salary action, premium percent action types or premium amount action types.
Field name | Data type | Required | Description |
---|---|---|---|
POSITION_ID | Name | String | Yes | A valid position name. |
VER_ID | Name | Numeric | String | Yes | A valid version name. |
EMPLOYEE_ID | No String String | If specified, a valid employee ID. | |
MEM_ID | Name | Numeric | String | Yes | A valid primary dimension name. |
ACTION_NAME | String | Yes | A valid action name. |
ACTION_ORDER | Numeric | Yes | |
AMOUNT | Numeric | No | |
HOURS | Numeric | No | |
QUANTITY | Numeric | No | |
Numeric | No | ||
STEP_GRADE_NAME | nullString | No | A valid step and grade schedule name, if applicable. |
GRADE_NAME | String | No | |
STEP | Numeric | No | |
STEP_INCREMENT | Numeric | No | |
SPREAD_NAME | String | No | |
TRANSFER_MEM_ID | Name | Numeric | String | No | A valid target primary dimension name. |
TRANSFER_POSITION_ID | Numeric | No | |
TRANSFER_STATUS | Numeric | No | |
ALLOCATION_ID | Numeric | No | An ID associated with loaded allocation definitions. |
ACTION_DATE | Date | Yes | Date action is applied and started. |
END_DATE | Date | No | |
ACTION_GENERATOR_DATE | Date | No | |
NOTE_TEXT | String | No |