Model: Project - Specifications for Dimension Table: EMPLOYEE CATEGORY

On this page you will find the specifications regarding the Model: Project and Dimension Table: EMPLOYEE CATEGORY.

Attributes

Attribute	Description (where applicable)
Company ID	Company Code
Contractor	Contractor  Y/N, represented by 1/0
Employee Category	Employee Category built as Company + '-' + Code + '-' + Name
Employee Category Code	Employee Category Code
Employee Category Code Name	Built as Company + '-' + Code + '-' + Name
Employee Category Name	Employee Category Name
Remark	Remark

Hierarchies

Hierarchy	Level
EmployeeCategoryHy
	Company ID
	Employee Category Code

USED BY MODEL(S)

Model Name

Employee Analysis

Incident Analysis

Project

Salary Review Analysis

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
EMPLOYEE CATEGORY	DIM_EMPLOYEE_CATEGORY_TM	DIM_EMPLOYEE_CATEGORY_BI	DIM_EMPLOYEE_CATEGORY	On Line