Data Mart Facts
The Workforce Rewards Data Mart contains six fact output tables.
Data Mart Fact Name |
Description |
Input Tables |
Output Tables |
---|---|---|---|
WA_MC_SCEN_FACT |
The Market Compensation fact table is generated by an Application Engine program (WA_MC_SCEN), that is called by the Market-Based Pricing Application Engine process (WA_MBP), or run by itself. The purpose of WA_MC_SCEN is to populate the WA_MC_SCEN_FACT table in the Data Mart for use in decision reporting. |
WA_MKT_SCEN_TBL, WA_MKT_RATE_TBL , JOB_F00, WA_COMP_HST_F00, JOBCODE_D00, LOCATION_D00, SAL_GRADE_D00 |
WA_MC_SCEN_FACT, WA_MC_EMPL_FACT |
WA_EMPL_FACT |
The Employee fact table is generated by an Application Engine Library (WA_EMPL_FACT), that can be called by any program, but cannot be run by itself. The purpose of WA_EMPL_FACT is to populate the WA_EMPL_FACT table in the Data Mart. Each time this engine is called, it adds employee details to the WA_EMPL_FACT table, for any employees that the calling engine has. This optional table can then be used later in the reporting process to provide all the employee dimensions and attributes. |
WA_JOB_S00, JOBCODE_D00, LOCATION_D00, SAL_GRADE_D00, PERSONAL_D00, JOB_INTRDY_F00, EMPL_REVW_F00 |
WA_EMPL_FACT |
WA_RM_FACT |
The Retention fact table is generated by an Application Engine program (WA_RM_FACT) that is called by the Retention Assignment Application Engine process (WA_RM_ASSIGN). The purpose of WA_RM_FACT is to populate the two tables in the Data Mart for use in decision reporting. |
Uses TEMP tables of the following: WA_RM_SUM_F00, WA_RM_DET_C_F00, WA_RM_DET_R_F00, WA_RM_DET_V_F00, WA_RM_TRACK_F00, WA_RM_RETN_F00, WA_RM_RDCE_F00, WA_JOB_S00, LOCATION_D00 |
WA_RM_ASMT_FACT, WA_RM_DECN_FACT |
Each fact, and its corresponding table, is built by an Application Engine (AE) library that is called by the various Workforce Rewards scenario-building Application Engine processes (Market-Based Pricing, Retention Assignment).