On this page you will find the specifications regarding the Model: Salary Review Analysis and Dimension Table: EMPLOYEE.
Represents a model specific dimension based on the IFS Cloud fact FACT_EMPLOYEE_ANALYSIS. The dimension is based on a fact and there is no corresponding dimension in core.
| Attribute | Description (where applicable) |
| Employee Code | Unique key to identify the employee within the company |
| 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 Name | Name of 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 |
| Employee Person Id | Unique key to identify the Person who is linked to the employee |
| 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. |
| Model Name |
| Production Performance |
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 |
| EMPLOYEE | DIM_EMPLOYEE_PERSON_BI | DIM_EMPLOYEE_PERSON | On Line |