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 |
|
|
|
|