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 |