Model: Salary Review Analysis - Specifications for Dimension Table: SALARY REVIEW PERIOD
Attributes
| Attribute |
Description (where applicable) |
| REMARK | Additional comments on the salary review period |
| REVIEW_PERIOD | This is the name of the salary review period. Usually, it is the calendar year, or a unique name provide by the HR. I.e 2020 or 2020 Confirmations |
| REVIEW_PERIOD_ID | Unique ID to identify the review period |
| TOLERANCE | The tolerance level is set to indicate the percentage, a manager can exceed when registering an increment amount. It is compared against the increment proposal set by HR. |
| VALID_FROM | Start date of the salary review period |
| VALID_TO | End date of the 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 PERIOD | | | | |