Model: Salary Review Analysis - Specifications for 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)
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 |