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