Data Mart Facts

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