Model: Employee Analysis - Specifications for Dimension Table: EMPLOYMENT

On this page you will find the specifications regarding the Model: Employee Analysis and Dimension Table: EMPLOYMENT.

This model dimension represents the human resouces dimension employee duration and is based on the IFS Cloud dimension DIM_EMPLOYMENT.

Attributes

Attribute Description (where applicable)
CompanyAssociated Company ID which the Employee is employed
Employee NoUnique ID to identify the employee
Employment TypeThe type of the employee's employment within the company.
Reason for LeavingThe reason why the employment or employment period was ended.
Employment AgreementThe identity of the agreement linked to the employee during the period.
Company - Employee NoUnique ID to identify the employee

USED BY MODEL(S)

Model Name
Employee Analysis

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