Model: Salary Review Analysis - Specifications for Dimension Table: COMPENSATION TYPE
Attributes
| Attribute |
Description (where applicable) |
| Base Salary |
Indicates whether this Compensation Type is the Base Salary Compensation Type. Base Salary is the initial
salary paid to an employee, not including any benefits, bonuses, or raises. |
| Calc From Base Salary |
Indicates whether this Compensation Type will be calculated as a percentage of the Base Salary. |
| Company ID |
Associated Company ID which the compensation type is defined |
| Compensation Type |
Type of compensation paid to employee; Example: Base Salary. |
| Compensation Type ID |
Unique key to identify the Compensation Type. |
| Description |
Description of Compensation Type. |
| Include in Budget |
Indicates whether this Compensation Type is in the Salary Increment Budget calculation. |
| Percentage |
Default percentage used to calculate this Compensation Type, if Compensation Type is defined as
Calculated from Base Salary. |
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 |
| COMPENSATION TYPE |
DIM_COMPENSATION_TYPE_TM |
DIM_COMPENSATION_TYPE_BI |
DIM_COMPENSATION_TYPE |
On Line |