Model: Salary Review Analysis - Specifications for Dimension Table: COMPENSATION TYPE

On this page you will find the specifications regarding the Model: Salary Review Analysis and 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)

Model Name

Data source Information

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
COMPENSATION TYPE DIM_COMPENSATION_TYPE_BI DIM_COMPENSATION_TYPE_PQ On Line