Workforce Budgeting tables

This table describes the Designer tables:

Table Description
ATT_ATCDATA_EMPLOYEE Employee dynamic attributes cube data.
ATT_ATCDATA_JOB Job dynamic attributes cube data.
ATT_ATCDATA_POSITION Position dynamic attributes cube data.
ATT_WBCCONFIG_ACTION_ORDER Action order configuration cube data.
ATT_WBCCONFIG_ALLOCATION Funding allocation configuration cube data.
ATT_WBCCONFIG_BENEFITCOST Benefit cost configuration cube data.
ATT_WBCCONFIG_BENEFITCOST_ASSIGNMENT Benefit cost assignment configuration cube data.
ATT_WBCCONFIG_PROGRESSION Progression rules configuration cube data.
ATT_WBCCONFIG_STEPANDGRADE Step-and-grade configuration cube data.
DAT_ALLOCATION_STAGE Staged data for the funding allocation information.
DAT_ALLOCATION_TRANSFORMED Validated staged data for funding allocation information.
DAT_ASSIGNMENT_STAGE Staged data for employee assignment.
DAT_ASSIGNMENT_TRANSFORMED Validated staged data for employee assignment.
DAT_ATCDATA_EMPLOYEE_STAGE Staged data for employee information.
DAT_ATCDATA_EMPLOYEE_TRANSFORMED Validated staged data for employee information.
DAT_ATCDATA_JOB_STAGE Staged data for job information.
DAT_ATCDATA_JOB_TRANSFORMED Validated staged data for job information.
DAT_ATCDATA_POSITION_STAGE Staged data for position information.
DAT_ATCDATA_POSITION_TRANSFORMED Validated staged data for position information.
DAT_BENEFITCOST_ASSIGNMENT_ACTION_STAGE Staged data for benefit costs related to assignments.
DAT_BENEFITCOST_ASSIGNMENT_ACTION_TRANSFORMED Validated staged data for benefit costs related to assignments.
DAT_BENEFITCOST_BASEDON_STAGE Staged data for based on benefit costs.
DAT_BENEFITCOST_BASEDON_TRANSFORMED Validated staged data for based on benefit costs.
DAT_BENEFITCOST_JOB_ACTION_STAGE Staged data for benefit costs related to jobs.
DAT_BENEFITCOST_JOB_ACTION_TRANSFORMED Validated staged data for benefit costs related to jobs.
DAT_BENEFITCOST_POSITION_ACTION_STAGE Staged data for benefit costs related to positions.
DAT_BENEFITCOST_POSITION_ACTION_TRANSFORMED Validated staged data for benefit costs related to positions.
DAT_BENEFITCOST_STAGE Staged data for benefit cost meta-data information.
DAT_BENEFITCOST_TRANSFORMED Validated staged data for benefit cost meta-data information.
DAT_BENEFITCOSTDATA_CAPS_STAGE Staged data for benefit cost caps.

DAT_BENEFITCOSTDATA_CAPS_TRANSFORMED

Validated staged data for benefit cost caps.
DAT_BENEFITCOSTDATA_RANGE_STAGE Staged data for benefit cost ranges.
DAT_BENEFITCOSTDATA_RANGE_TRANSFORMED Validated staged data for benefit cost ranges.
DAT_PROGRESSION_STAGE Staged data for progression rules information.
DAT_PROGRESSION_TRANSFORMED Validated staged data for progression rules information.
DAT_WBDSG_GRADE_STAGE Staged data for grade information.
DAT_PROGRESSIONDATA_STAGE Staged data for progression data information.
DAT_PROGRESSIONDATA_TRANSFORMED Validated staged data for progression data information.
DAT_WBDSG_GRADE_TRANSFORMED Validated staged data for grade information.
DAT_WBDSG_STEP_STAGE Staged data for step information.
DAT_WBDSG_STEP_TRANSFORMED Validated staged data for step information.
DAT_WBDSG_TABLE_STAGE Staged data for salary table information.

DAT_WBDSG_TABLE_TRANSFORMED

Validated staged data for salary table information.
DIM_WBD_BASEDON_BENEFITCOST_ATTRIBUTES Attributes table for the based-on benefit cost dimension.
DIM_WBD_BASEDON_BENEFITCOST_ELEMENTS Elements table for the based on benefit cost dimension.
DIM_WBD_BASEDON_BENEFITCOST_HIERARCHIES Hierarchies for the based-on benefit cost dimension.
DIM_WBD_BASEDON_BENEFITCOST_PARENTS Parent/child relationships for the based-on benefit cost dimension.
DIM_WBD_BENEFITCOST_ATTRIBUTES Attributes table for the benefit cost dimension.
DIM_WBD_BENEFITCOST_ELEMENTS Elements table for the benefit cost dimension.
DIM_WBD_BENEFITCOST_HIERARCHIES Hierarchies for the benefit cost dimension.
DIM_WBD_BENEFITCOST_PARENTS Parent/child relationships for the benefit cost dimension.
DIM_WBDACTION_ATTRIBUTES Attributes table for the action dimension.
DIM_WBDACTION_ELEMENTS Elements table for the action dimension.
DIM_WBDACTION_HIERARCHIES Hierarchies for the action dimension.
DIM_WBDACTION_PARENTS Parent/child relationships for the action dimension.
DIM_WBDBC_RANGE_ATTRIBUTES Attributes table for the benefit cost range dimension.
DIM_WBDBC_RANGE_ELEMENTS Elements table for the benefit cost range dimension.
DIM_WBDBC_RANGE_HIERARCHIES Hierarchies for the benefit cost range dimension.
DIM_WBDBC_RANGE_PARENTS Parent/child relationships for the benefit cost range dimension.
DIM_WBDEMPLOYEE_ATTRIBUTES Attributes table for the employee dimension.
DIM_WBDEMPLOYEE_ELEMENTS Elements table for the employee dimension.
DIM_WBDEMPLOYEE_HIERARCHIES Hierarchies for the employee dimension.
DIM_WBDEMPLOYEE_PARENTS Parent/child relationships for the employee dimension.
DIM_WBDJOB_ATTRIBUTES Attributes table for the job dimension.
DIM_WBDJOB_ELEMENTS Elements table for the job dimension.
DIM_WBDJOB_HIERARCHIES Hierarchies for the job dimension.
DIM_WBDJOB_PARENTS Parent/child relationships for the job dimension.
DIM_WBDPHASING_ATTRIBUTES Attributes table for the phasing methods dimension.
DIM_WBDPHASING_ELEMENTS Elements table for the phasing methods dimension.
DIM_WBDPHASING_HIERARCHIES Hierarchies for the phasing methods dimension.
DIM_WBDPHASING_PARENTS Parent/child relationships for the phasing methods dimension.
DIM_WBDPOSITION_ATTRIBUTES Attributes table for the position dimension.
DIM_WBDPOSITION_ELEMENTS Elements table for the position dimension.
DIM_WBDPOSITION_HIERARCHIES Hierarchies for the position dimension.
DIM_WBDPOSITION_PARENTS Parent/child relationships for the position dimension.
DIM_WBDPROGRESSION_ATTRIBUTES Attributes table for the progression rules dimension.
DIM_WBDPROGRESSION_ELEMENTS Elements table for the progression rules dimension.
DIM_WBDPROGRESSION_HIERARCHIES Hierarchies for the progression rules dimension.
DIM_WBDPROGRESSION_PARENTS Parent/child relationships for the progression rules dimension.
DIM_WBDSG_GRADE_ATTRIBUTES Attributes table for the grade dimension.
DIM_WBDSG_GRADE_ELEMENTS Elements table for the grade dimension.
DIM_WBDSG_GRADE_HIERARCHIES Hierarchies for the grade dimension.
DIM_WBDSG_GRADE_PARENTS Parent/child relationships for the grade dimension.
DIM_WBDSG_STEP_ATTRIBUTES Attributes table for the step dimension.
DIM_WBDSG_STEP_ELEMENTS Elements table for the step dimension.
DIM_WBDSG_STEP_HIERARCHIES Hierarchies for the step dimension.
DIM_WBDSG_STEP_PARENTS Parent/child relationships for the step dimension.
DIM_WBDSG_TABLE_ATTRIBUTES Attributes table for the salary table dimension.
DIM_WBDSG_TABLE_ELEMENTS Elements table for the salary table dimension.
DIM_WBDSG_TABLE_HIERARCHIES Hierarchies for the salary table dimension.
DIM_WBDSG_TABLE_PARENTS Parent/child relationships for the salary table dimension.