Fields
This section details the required and optional fields that are included in an import file.
Different action definitions require a different combination of fields and that interdependency is not indicated in the user interface.
For these fields, you can select default values that will apply to the entire load.
- Spread_Calculation
- Calendar_based
- Distribute
- Admin_Only
- Edit_Value
| Field name | Data type | Required | |
|---|---|---|---|
| ACTION_DEFINITION_ID | Numeric | No | |
| ACTION_TYPE | Integer | Yes | Must be one of the defined action types listed above. |
| ACTION_NAME | String | Yes | The unique action name. |
| ACTION_DESC | String | No | |
| SPREAD_CALCULATION | String | No | Y to apply across the budget cycle. N to apply the annual amount to a single period. |
| INCLUDE_IN_VIEW | String | No | The action group name in which to include the action. |
| BASE_ON_VIEW | Numeric | No | The action group name on which to base the action. |
| BASE_ON_ACTION | Numeric | No | The action name on which to base the action. |
| DATE_TYPE | Numeric | No | The attribute ID for available date fields. |
| CALENDAR_BASED | String | No | Y for calendar year calculation cycle; N for fiscal year calculation cycle. |
| CALC_BY_EMPLOYEE | String | No | By default, this is set to N. |
| CALCULATION_CAP | Numeric | No | |
| SHIFT_DIFFERENTIAL | String | No | Y for yes. This is only valid for action type 4 when calculating shift differential. |
| ADMIN_ONLY | String | No | Y for yes; N for no |
| EDIT_VALUE | String | No | Y for yes; N for no |
| DEFAULT_QUANTITY | Numeric | No | |
| LOW_VALUE | Numeric | No | |
| HIGH_VALUE | Numeric | No | |
| ACTION_AMOUNT | Numeric | No | |
| DISTRIBUTE | String | No | Y for yes; N for no |