On this page you will find the specifications regarding the Model: Employee Analysis and Dimension Table: EMPLOYEE ANALYSIS.
This model fact represents Employee Analysis information and is based on the IFS Applcations fact FACT_EMPLOYEE_ANALYSIS.
Note: Please refer to documentation of each model to find out about attributes used in referenced models
Attribute | Description (where applicable) |
Company-Employee-Calendar-Period | |
Current Employment | Indicates the current employment |
Employee Age | Age of the employee |
Employee Assignment Id | Nature of the employee's position assignment Eg- Permanent |
Employee Citizenship | The country where the employee is registered as a citizen. |
Employee Gender | Gender of the employee |
Employee Name | Name of the employee |
Employee No | Unique ID to identify the employee |
Employee Person ID | ID of the person linked to the employee |
Employee Primary Job | Primary job of the employee |
Employee Primary Position | Primary Position of the employee |
Employee Status | Indicates whether the employee is in active service |
Information Base | Due to what reason information was picked. Eg- Period Headcount, Start Employment, End Employment |
Model Name |
Employee Analysis |
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 ANALYSIS | FACT_EMPLOYEE_ANALYSIS_TM | FACT_EMPLOYEE_ANALYSIS_BI | FACT_EMPLOYEE_ANALYSIS | On Line |