Model: Employee Analysis - Specifications for Dimension Table: ORGANIZATION CODE

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

This model dimension represents the human resouces dimension organization code and is based on the IFS Cloud dimensions DIM_COMPANY and DIM_ORGANIZATION_CODE. The two dimensions are connected through the company column in each dimension.

Attributes

Attribute Description (where applicable)
Organization CodeThe unique identifier of an organization unit.
Organization NameThe description of the organization unit.
Organization LevelThe organization level. This field contains information for classifying the organization unit in a specific hierarchical level. Examples of levels: Division, Department, Section, or Team.
Valid ToThe date until which the organization code will be valid.
Company - Organization NameThe Company in which the Organization is defined
Company - Structure - Organization - Valid ToThe Company/Structure in which the Organization is defined
Organization Code NameThe description of the organization unit.

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
ORGANIZATION CODEDIM_ORGANIZATION_CODE_BIDIM_ORGANIZATION_CODEOn Line