Job actions
At the job level, benefit or cost actions can be assigned only if they have these calculation types:
- FlatAmount applies the amount across the configuration set and apply the amount to single period.
- QuantityXRate applies the amount across the configuration set and apply the amount to single period.
- PercentOfPeriodic applies the amount across the configuration set.
- PercentOfAnnualized applies the amount to a single period.
- YTDRanges applies to the amount across the configuration set.
The process uses these tables and stored procedures:
- The staging table is DAT_BENEFITCOST_JOB_ACTION_STAGE.
- The stored procedure to validate staged data is
depm_integration_wb_benefitcost_job_action_prepare_staging. - The stored procedure to process staged data is
depm_integration_wb_benefitcost_job_action. - The data is imported to:
- The DAT_BENEFITCOST_JOB_ACTION_TRANSFORMED table.
- The WBCCONFIG_ACTION_ORDER cube.
The output tables are:
- ATT_WBCCONFIG_ACTION_ORDER contains the configuration cube data.
- DIM_WBDACTION_ELEMENTS contains the action placeholder elements.
- DIM_WBDACTION_PARENTS contains the parent/child relationships for the WBDACTION dimension.
The entity ID must exist prior to importing data.
If you are importing job actions, you must also import benefit cost code data and job data.
This table describes DAT_BENEFITCOST_JOB_ACTION_STAGE:
| Field | Required | Description |
|---|---|---|
| BPDENTITY | Y | Unique entity ID from BPDENTITY. The related field is ID in the DIM_BPDENTITY_ELEMENTS table. |
| BenefitCostCode | Y | Unique BenefitCostCode identifier of the salary/benefit/cost definition
from Benefit Cost table. The related field is BenefitCostCode in the DAT_BENEFITCOST_STAGE table. |
| JobIdentifier | Y | Valid unique job identifier. The related field is Identifier in the DAT_ATCDATA_JOB_STAGE table. |
| EffectiveDate | Y/N | Effective start date for the benefit or cost action. The format is YYYY/MM/DD. Required for job actions if the date type in the benefit definition is Calendar Date. If an effective start date is specified for other benefit, the start date is not imported. |
| EndDate | N | Effective end date for the benefit or cost action. The format is YYYY/MM/DD. Do not specify EffectiveEnd for these calculation types:
The end date of the action must be greater than or equal the start date of the action. |
| Value1 | N | Amount of the benefit/cost action. |
| Value2 | N | Amount of the benefit or cost action that is used only by QuantityXRate
calculation method. Value2 is used for quantity. If Value2 is not specified, then defaults to Value2 from the benefit and cost definition. If Value2 is specified, it must be greater than 0. Not used by other calculation types. |