Model: Salary Review Analysis - Specifications for Dimension Table: SALARY REVIEW INFO
Attributes
| Attribute |
Description (where applicable) |
| BENCHMARK_MAX_SALARY | Based on external benchmarking the maximum salary for a similar job |
| BENCHMARK_MID_SALARY | Based on external benchmarking the salary mid-point for a similar job. |
| BENCHMARK_MIN_SALARY | Based on external benchmarking the minimum salary for a similar job |
| CURRENT_BASE_SALARY | The Current Basic Salary of the Employee. (This doesn't include the Variable Pay Amounts) |
| CURRENT_COMPA_RATIO | Indicates the % of an employee’s current salary compared to the salary mid-point of the employee's Job Grade. (Internal benchmark) if the Compa ratio is 100% employee is paid exactly the mid-point of the min and max salary the employee can get paid. (Base pay + Variable Pay is considered) |
| CURRENT_RANGE_PENETRATION | Range penetration indicates how competitive the current salary is compared to the min and max salary of an employee’s job grade (Internal benchmark). If min salary is 100, Max is 200 and the current salary is 125. Range penetration is simply 25%. |
| CURRENT_VARIABLE_PAY | Total of Variable Pay of the employee's current entitlement. |
| CalculatedNewCompaRatio | Indicates the % of an employee’s new salary (after the revision) compared to the salary mid-point of the employee's Job Grade. (Internal benchmark) if the Compa ratio is 100% employee is paid exactly the mid-point of the min and max salary the employee can get paid. (Base pay + Variable Pay is considered) |
| CompaRatioColumnOrder | Order the CompaRatioGroups field in Ascending order |
| CompaRatioGroups | Group Compa Ratio figures |
| NEW_BASE_SALARY | The New Basic Salary of the Employee after the revision. (Only the base pay) |
| NEW_COMPA_RATIO | Indicates the % of an employee’s new salary (after the revision) compared to the salary mid-point of the employee's Job Grade. (Internal benchmark) if the Compa ratio is 100% employee is paid exactly the mid-point of the min and max salary the employee can get paid. (Base pay + Variable Pay is considered) |
| NEW_RANGE_PENETRATION | Range penetration indicates how competitive the new salary is compared to the min and max salary of an employee’s job grade (Internal benchmark). If min salary is 100, Max is 200 and the new salary is 140. Range penetration is simply 40%. |
| NEW_SALARY | The new total salary of the employee after the revision. Includes a total of Base pay & variable pay |
| NEW_VARIABLE_PAY | The New Variable Pay of the Employee after the revision. (Only the variable pay) |
| SALARY_PLAN_PERIOD | Associated salary review period |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| SALARY REVIEW INFO | FACT_SALARY_REVIEW_INFO_TM | FACT_SALARY_REVIEW_INFO_BI | FACT_SALARY_REVIEW_INFO | Data Mart |