Model: Salary Review Analysis - Specifications for Dimension Table: SALARY REVIEW INFO EMP RLS
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 | ID of the employee |
| Employee Name | Name of the employee |
| Employee Person Id | ID of the person 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 |
| ID | Unique ID to identify 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 |
| SALARY REVIEW INFO EMP RLS | DIM_EMPLOYEE_PERSON_TM | DIM_EMPLOYEE_PERSON_BI | DIM_EMPLOYEE_PERSON | On Line |