On this page you will find the specifications regarding the Model: Employee Analysis and Dimension Table: EMPLOYEE CATEGORY.
This model dimension represents employee categories (in HR) based on the IFS Cloud dimension DIM_EMPLOYEE_CATEGORY. All models that refer to this dimension will have the attributes and hierarchies as described below.
Attribute | Description (where applicable) |
Company ID | Company Code |
Employee Category Code | Employee Category Code |
Employee Category Name | Employee Category Name |
Remark | Remark |
Contractor | Contractor Y/N, represented by 1/0 |
Employee Category | Employee Category built as Company + '-' + Code + '-' + Name |
Employee Category Code Name | Built as Company + '-' + Code + '-' + Name |
Hierarchy | Level |
EmployeeCategoryHy | |
Company ID | |
Employee Category Code |
Model Name |
Employee Analysis |
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 |
EMPLOYEE CATEGORY | DIM_EMPLOYEE_CATEGORY_BI | DIM_EMPLOYEE_CATEGORY | On Line |