Model: Production Performance - Specifications for Dimension Table: EMPLOYEE

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

Attributes

Attribute	Description (where applicable)
Company Code	Company code of employee.
Country Code	Country code of employee. Typically 2 char ISO abbr.
Employee	Built up as Compnay Code - Employee Code - Employee Name
Employee Code	Employee code value
Employee Name	Full name of employee.
Employee Person Id	Id of Employee.

Hierarchies

Hierarchy	Level
EmployeeHy
	Company Code
	Employee

USED BY MODEL(S)

Model Name

Incident Analysis

Production Performance

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	DIM_EMPLOYEE_TM	DIM_EMPLOYEE_BI	DIM_EMPLOYEE	On Line