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 including dated values and apply the amount to single period.
  • QuantityXRate: Applies the amount across the configuration set including dated values and apply the amount to single period.
  • PercentOfPeriodic: Applies the amount across the configuration set including dated values.
  • PercentOfAnnualized: Applies the amount to a single period including dated values.
  • YTDRanges

The table is WFB_JobAction.

The Job Action business object is used in these dimensions and cubes:

  • Dimensions:
    • Workforce Budgeting Action (WBDACTION)
  • Cubes:
    • WFB Calculation (WBCCALCULATION)
    • WFB Calculation Order Configuration (WBCCONFIG_ACTION_ORDER)
    • WFB Scenario Configuration (WBCCONFIG_SCENARIO)

The Job Action business objects is related to these business objects:

  • Entity
  • Organization
  • Salary, Benefit, Cost Definition
  • Job

This table describes the Job Action business object:

Field Type Required Description
Entity [nvarchar] (200)

NOT NULL

Y Unique entity ID in the Entity business object that is activated in the configuration set.
BenefitCostCode nvarchar (200)

NOT NULL

Y Unique ID of the Benefit or Cost in the Salary, Benefit, Cost Definition business objects.

The related table is Benefit Cost, the field is BenefitCostCode.

JobID [nvarchar] (200)

NOT NULL

Y Unique job ID in the Job business object.

The related table is Job, the field is JobID.

EffectiveStart [datetime]

NULL

Y Effective start date for the benefit or cost action.

Required for job actions if the date type in the benefit definition is Calendar Date. The related table is BenefitCost, the field is DateType.

If the user specifies an effective start date for other benefit, the start date is not imported.

EffectiveEnd [datetime]

NULL

Y/N Effective end date for the benefit or cost action.

Do not specify EffectiveEnd for these calculation types:

  • PercentOfAnnualized
  • FlatAmount that applies for a single period. The related table is BenefitCost, the field is CalculationMethod = 0.
  • QuantityXRate that applies for a single period. The related table is BenefitCost, the field is CalculationMethod = 0.

The end date of the action must be greater than or equal the start date of the action.

Value1 [float] (53)

NULL

N Amount of the benefit or cost action.

If the calculation type is YTDRanges or the calculation type uses dated values, do not specify a value for Value1 as Value1 does not apply as the values are supplied from:

  • Benefit cost range business object for YTDRanges.
  • Benefit cost dated values business object for calculation types with dated values.

If the calculation type is not YTDRanges and the definition does not have dated values:

  • Value1 should be specified.
  • If Value1 is not specified, then defaults to Value1 from the benefit and cost definition. The related table is BenefitCost, the field is Value1.

If Value1 is specified, it must be greater than 0.

Value2 [float] (53)

NULL

N Amount of the benefit or cost action.

If the QuantityXRate calculation type does not have dated values, these rules apply:

  • Value2 is used for quantity.
  • Value2 should be specified.
  • If Value2 is not specified, then defaults to Value2 from the benefit and cost definition.

Not used by other calculation types.

If Value2 is specified, it must be greater than 0.