Workforce Budgeting dimensions

This section describes the Workforce Budgeting dimensions.

WBDPERIOD

This dimension is used to represent the Workforce Budgeting periods. It is created automatically when BPDTIME is created, after the administrator has configured the Infor EPM financial calendar. The dimension contains top level elements for N.A., TOTAL_FISCAL, TOTAL_FISCAL_YTD, TOTAL_CALENDAR, and TOTAL_CALENDAR_YTD. All of the base elements in this dimension correspond to base elements in BPDTIME. The use of this dimension allows (in the future) for budgeting of Workforce Budgeting data at a different periodicity than the financial calendar. For example, weeks instead of months.

WBDJOB

This dimension includes a list of the elements associated with the defined jobs. It is provided with two elements: TOTAL_JOB and N.A.

Additional elements are created when jobs are created in Workforce Budgeting.

WBDPOSITION

This dimension includes a list of the elements associated with the defined positions. It is provided with two elements: TOTAL_POSITION and N.A.

Additional elements are created when positions are created in Workforce Budgeting.

WBDEMPLOYEE

This dimension includes a list of the elements associated with the defined employees. It is provided with two elements: TOTAL_EMPLOYEE and N.A.

Additional elements are created when employees are created in Workforce Budgeting.

WBDSG_TABLE

This dimension includes a list of the elements associated with salary tables. This is a placeholder dimension. The initial elements include: TOTAL_SG_TABLE, N.A., SG_TABLE_0001, SG_TABLE_0002, SG_TABLE_0003, SG_TABLE_0004, SG_TABLE_0005, SG_TABLE_0006, SG_TABLE_0007, SG_TABLE_0008, SG_TABLE_0009, SG_TABLE_0010.

Additional elements are created as needed when more salary tables are created.

WBDSG_GRADE

This dimension includes a list of the elements associated with salary table grades. This is a placeholder dimension. The initial elements include: TOTAL_SG_GRADE, N.A., SG_GRADE_0001, SG_GRADE_0002, SG_GRADE_0003, SG_GRADE_0004, SG_GRADE_0005, SG_GRADE_0006, SG_GRADE_0007, SG_GRADE_0008, SG_GRADE_0009, SG_GRADE_0010.

Additional elements are created as needed when more salary table grades are created.

WBDSG_STEP

This dimension includes a list of the elements associated with salary table steps. This is a placeholder dimension. The initial elements include: TOTAL_SG_STEP, N.A., SG_STEP_0001, SG_STEP_0002, SG_STEP_0003, SG_STEP_0004, SG_STEP_0005, SG_STEP_0006, SG_STEP_0007, SG_STEP_0008, SG_STEP_0009, SG_STEP_0010.

Additional elements are created as needed when more salary table steps are created.

WBDPROGRESSION

This dimension includes a list of the elements associated with progression rules. This is a placeholder dimension. The initial elements include: TOTAL_PROGRESSION, N.A., PROGRESSION_0001, PROGRESSION_0002, PROGRESSION_0003, PROGRESSION_0004, PROGRESSION_0005, PROGRESSION_0006, PROGRESSION_0007, PROGRESSION_0008, PROGRESSION_0009, PROGRESSION_0010.

Additional elements are created as needed when more progression rules are created.

WBDCALCULATION_TYPE

This dimension includes a list of the elements associated with calculation types used by the calculation engine. This is a placeholder dimension. The initial elements include: TOTAL_CALCULATION_TYPE, N.A., CALCULATION_TYPE_0001, CALCULATION_TYPE_0002, CALCULATION_TYPE_0003, CALCULATION_TYPE_0004, CALCULATION_TYPE_0005, CALCULATION_TYPE_0006, CALCULATION_TYPE_0007, CALCULATION_TYPE_0008, CALCULATION_TYPE_0009, CALCULATION_TYPE_0010.

WBD_BENEFITCOST

This dimension includes a list of elements associated with the benefits/costs. It is a placeholder dimension. The dimension has several sections used to categorize the type of benefits/costs:

  • TOTAL_BENEFITCOST: This is the top level parent.
    • N.A.
    • TOTAL_BENEFITS: Parent of all benefit types.
      • TOTAL_SALARY_BENEFITS: Parent of all Salary related benefits.
        • BENEFIT_SALARY_BASE: Always represents the base salary.
        • BENEFIT_SALARY_####:- Placeholder elements for additional benefits.
      • TOTAL_OTHER_BENEFITS: Parent of all non-salary benefits.
        • BENEFIT_####: Placeholder elements for other benefits.
      • TOTAL_COSTS: Parent of all cost types.
        • COST_####: Placeholder elements for the costs.

Additional placeholder elements are created as needed.

WBD_BASEDON_BENEFITCOST

This dimension includes a list of the elements associated with the benefits/costs. It is an exact duplicate of the WBD_BENEFITCOST dimension. It is required to provide the associated between benefits/costs and those they are based on (percent types). When additional placeholder elements are created in WBD_BENEFITCOST they are also created in this dimension.

WBDLONGEVITY

This dimension includes a list of the elements associated with longevity rules. This is a placeholder dimension. The initial elements include: TOTAL_LONGEVITY, N.A., LONGEVITY_0001, LONGEVITY_0002, LONGEVITY_0003, LONGEVITY_0004, LONGEVITY_0005, LONGEVITY_0006, LONGEVITY_0007, LONGEVITY_0008, LONGEVITY_0009, LONGEVITY_0010.

Additional elements are created as needed when more longevity rules are created.

WBDBC_RANGE

This dimension includes a list of the elements associated with benefit/cost value ranges. This is a placeholder dimension. The initial elements include: TOTAL_BC_RANGE, N.A., BC_RANGE_0001, BC_RANGE_0002, BC_RANGE_0003, BC_RANGE_0004, BC_RANGE_0005, BC_RANGE_0006, BC_RANGE_0007, BC_RANGE_0008, BC_RANGE_0009, BC_RANGE_0010.

Additional elements are created as needed when more ranges are created.

WBDACTION

This dimension includes a list of the elements associated with benefit/cost instances for a particular job/position/employee. The dimension has a several sections, used to categorize the type of action:

  • TOTAL_ACTION: Top level element.
    • N.A.
    • TOTAL_DETAIL_ACTIONS: Parent of elements associated with actions assigned directly to an employee.
      • ACTION_DETAIL_####: Placeholder elements for the actions.
    • TOTAL_GLOBAL_JOB_ACTIONS: Parent of elements associated with actions assigned to a job.
      • ACTION_GLOBAL_JOB_####: Placeholder elements for the job actions.
    • TOTAL_GLOBAL_POSITION_ACTIONS: Parent of elements associated with actions assigned to a position.
      • ACTION_GLOBAL_POSITION_####: Placeholder elements for the position actions.

Additional elements are created as needed.

WBDDAY

This dimension includes a list of elements 1 through 31 representing the days of a month. It includes a TOTAL_DAY parent and N.A. element.

WBDPHASING

This dimension includes a list of elements associated with phasing methods. This is a placeholder dimension. The initial elements include: TOTAL_PHASING, N.A., PHASING_001, PHASING_002, PHASING_003, PHASING_004, PHASING_005, PHASING_006, PHASING_007, PHASING_008, PHASING_009, PHASING_010.

Additional elements are created as needed when more phasing methods are created.