On this page you will find the specifications regarding the Model: Salary Review Analysis and Dimension Table: SALARY REVIEW INFO.
| Attribute | Description (where applicable) |
| CURRENT_BASE_SALARY | The Current Basic Salary of the Employee. (This doesn't include the Variable Pay Amounts) |
| CURRENT_VARIABLE_PAY | Total of Variable Pay of the employee's current entitlement. |
| NEW_BASE_SALARY | The New Basic Salary of the Employee after the revision. (Only the base pay) |
| NEW_VARIABLE_PAY | The New Variable Pay of the Employee after the revision. (Only the variable pay) |
| NEW_SALARY | The new total salary of the employee after the revision. Includes a total of Base pay & variable pay |
| 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) |
| 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) |
| 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%. |
| 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%. |
| BENCHMARK_MID_SALARY | Based on external benchmarking the salary mid-point for a similar job. |
| BENCHMARK_MAX_SALARY | Based on external benchmarking the maximum salary for a similar job |
| BENCHMARK_MIN_SALARY | Based on external benchmarking the minimum salary for a similar job |
| SALARY_PLAN_PERIOD | Associated salary review period |
| 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 |
| Model Name |
The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.
Additional information can be found in the online documentation of Information Sources.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| SALARY REVIEW INFO | FACT_SALARY_REVIEW_INFO_BI | FACT_SALARY_REVIEW_INFO_PQ | On Line |