Model: Salary Review Analysis - Specifications for Dimension Table: EMPLOYEE

On this page you will find the specifications regarding the Model: Salary Review Analysis and Dimension Table: EMPLOYEE.

Attributes

Attribute	Description (where applicable)
Age	Age of the employee
Assignment Type	Nature of the employee's position assignment Eg- Permanent
Company Code	Associated Company ID which the Employee is employed
Country Code	Country in which the employee is based in
Employee Code	Unique key to identify the employee within the company
Employee Name	Name of the employee
Employee Person Id	Unique key to identify the Person who is linked to the employee
Employee Status	Indicates whether the employee is in active service
First Name	First Name of the employee
Gender	Gender of the employee
Initials	Initials of the employee
Last Name	Last name of the employee
Middle Name	Middle name of the employee
Organization Id	Organization ID in which the employee is assigned to
Position Id	Position ID in which the employee is assigned to
Prefix	The prefix, e.g., Mr., Mrs., Ms.
Title	The persons title. The use of the title field may vary based on the mapping.

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_PERSON_TM	DIM_EMPLOYEE_PERSON_BI	DIM_EMPLOYEE_PERSON	On Line