Data Mart Dimensions
The Workforce Rewards Data Mart contains the following dimensions:
Dimension Name |
Comment |
Dimension Table Name |
Application Engine Name |
---|---|---|---|
Age |
List of all age groups as defined by user. This dimension enables analysis of your workforce by grouping calculated ages by durations. |
WFR_AGE_DIM |
WFI_AGE_DIM |
Business Unit |
Logical units created within your organization for reporting purposes. You can have one or many business units. They do not have any predetermined restrictions or requirements. This flexible structure enables you to define a higher level of reporting for your employees and group them according to functional or administrative tasks or for your business purposes. You can define business units that reflect the specific functional needs of your internal human resources departments, or reflect the actual business structure of your enterprise. |
WFR_BU_DIM |
WFI_BU_DIM |
Compensation |
Provides logical groupings of compensation types such as base pay, short term variable compensation, deferred long term compensation, and so on. The hierarchy is the Compensation tree. |
WFR_COMP_DIM |
WFI_COMP_DIM |
Compensation Plan Rule |
Provides information about compensation plan rules. There is no hierarchy. |
WFR_CMPPLRU_DIM |
WFR_CPRU_DIM |
Cost Rule |
Provides information about retention cost rules. There is no hierarchy. |
WFR_COSTRU_DIM |
WFR_CORU_DIM |
Currency Code |
Provides a way to classify financial amounts, for example USD, FFR, and so on. |
WFR_CURCODE_DIM |
|
Decision |
Provides information about retention decision rules. There is no hierarchy. |
WFR_DECISON_DIM |
WFR_DECI_DIM |
Department Service |
List of department service groups as defined by user. This dimension enables analysis of your workforce by groupings of the calculated service duration your employees have been with the department. There is no hierarchy. |
WFR_DEPTSVC_DIM |
WFI_DESE_DIM |
Education Level |
Enables you to analyze your workforce by highest education levels such as Bachelor level degree, Master level degree, and so on. There is no hierarchy. |
WFR_EDULVL_DIM |
WFI_EDLV_DIM |
Geography |
Represents the hierarchical relationship of geographic areas and locations for reporting purposes. The hierarchy is the Geography tree. |
WFR_GEO_DIM |
WFI_GEO_DIM |
Group |
Provides information about workforce groups. There is no hierarchy. |
WFR_GROUP_DIM |
WFR_GRUP_DIM |
Job |
Job dimension represents how unique an employee is with their job. There is no hierarchy for the Job dimension. |
WFR_JOB_DIM WFR_JOBATTR_DIM |
WFI_JOB_DIM |
Job Code |
Represents the categorization of jobs into types; such as executive, technical, administrative services, and so on. The hierarchy is the Job Code Tree. |
WFR_JCD_DIM WFR_JCDATTR_DIM |
WFI_JOCD_DIM |
Job Service |
List of service duration groups in a job code as defined by the user. This dimension is used to enable grouping of workforce by amount of time in the job. Job Service duration group can be defined in days, months or years. |
WFR_JOBSVC_DIM |
WFI_JOSE_DIM |
Last Pay Change |
Represents predefined brackets of calculated time in service since the last pay change, for comparison purposes. There is no hierarchy. |
WFR_PAYCHG_DIM |
WFI_PACH_DIM |
Last Promotion |
Represents predefined brackets of calculated time in service since the last promotion, for comparison purposes. There is no hierarchy. |
WFR_PROMO_DIM |
WFI_PROM_DIM |
Measure Fit |
Provides information about measures. There is no hierarchy. |
WFA_MEAFIT_DIM |
WFR_MEFT_DIM |
Metric |
Provides information about metrics. There is no hierarchy. |
WFR_METRIC_DIM |
WFR_METR_DIM |
Organization |
Represents the relationship of departments from an organizational reporting perspective. The hierarchy is the Organization Tree. |
WFR_ORG_DIM WFR_MGR_DIM |
WFI_ORG_DIM |
Personal |
Identifies the attributes of a person. There is no hierarchy for the Personal dimension. |
WFR_PERSON_DIM WFR_PERSNAT_DIM |
WFI_PER_DIM |
Previous Job Code |
Represents the employee's previous Job Code. The hierarchy is the Job Code Tree. |
WFR_PRJCD_DIM WFR_PRJCDAT_DIM |
WFI_PRJC_DIM |
Previous Organization |
Represents the employee's previous Organization. The hierarchy is the Organization Tree. |
WFR_PRORG_DIM WFR_PRMGR_DIM |
WFI_PROR_DIM |
Previous Salary Grade |
Represents the employee's previous Salary Grade. There is no hierarchy. |
WFR_PRSLGRD_DIM |
WFI_PRSG_DIM |
Retain Action |
Provides information about retain actions. There is no hierarchy. |
WFR_RETACT_DIM |
WFR_RTAC_DIM |
Retention Rule |
Provides information about retention rules. There is no hierarchy. |
WFR_RETENRU_DIM |
WFR_RERU_DIM |
Review Rating |
Represents the employee's performance rating from their salary/performance review. There is no hierarchy. |
WFR_REVRTG_DIM |
WFI_RERA_DIM |
Risk Rule |
Provides information about retention risk rules. There is a hierarchy from Risk Rule to Retention Factor to Retention Factor Type. |
WFR_RSKRU_DIM |
WFR_RIRU_DIM |
Salary Grade |
Represents the employee's salary grade. There is no hierarchy. |
WFR_SALGRD_DIM |
WFI_SAGR_DIM |
Salary Grade Duration |
Represents predefined brackets of calculated time in service in the present salary grade, for comparison purposes. There is no hierarchy. |
WFR_SLGDDUR_DIM |
WFI_SAGD_DIM |
Service |
Represents predefined brackets of calculated time in service for comparison purposes. There is no hierarchy for Service Group. |
WFR_SERVICE_DIM |
WFI_SERV_DIM |
Scenario |
Provides information about scenarios. There is no hierarchy. |
WFR_SENARIO_DIM |
WFR_SCEN_DIM |
Target Rate |
Provides information about compensation target rates. There is no hierarchy. |
WFR_TGTRATE_DIM |
WFR_TARA_DIM |
Time (Period) |
Includes the accounting periods for which data is reported. The hierarchy is Year, Quarter, Month, Week and Day. |
WFR_YEAR_DIM WFR_QTR_DIM WFR_MONTH_DIM WFR_DAY_DIM |
WFI_TIME_DIM |
Track Decision |
Provides information about retention track decisions. There is no hierarchy. |
WFR_TRCRSN_DIM |
WFR_TCRN_DIM |
Value Rule |
Provides information about retention value rules. There is no hierarchy. |
WFR_VALRU_DIM |
WFR_VARU_DIM |
Each dimension, and its corresponding table, is built by an Application Engine (AE) library called by the various Workforce Rewards scenario-building Application Engine processes (Market-Based Pricing, Retention Assignment, Workforce Simulation, and Compensation Planning and Simulation).