Purpose:
The purpose of this DataMart view is to provide a clear snapshot of an employee’s current and historical employment status within a company. It captures essential details such as employment dates, employment type, and agreement, with a focus on determining whether an employee is currently active or not. This view is useful for HR reporting, compliance checks, and organisational planning, particularly when identifying current employees or assessing employment trends over time.
Synopsis:
This view retrieves employee employment data from the
ifs.DIM_EMPLOYMENT_OL source, focusing on fields that define an employee’s employment type, agreement, and key dates (employment start and leaving). It includes:
- Company ID and Employee Number: Unique identifiers to track the employee within a company.
- Date of Employment: The start date of the employee’s current or past employment.
- Is_Current: A calculated field that determines if the employee is currently employed, based on the employment and leaving dates.
- Employment Type: A categorisation of the type of employment (e.g., full-time, part-time).
- Agreement: The employment agreement type and description.
- Leaving Information: Captures the date and reason for leaving, if applicable.
Optional fields like job title, department, and grade could be added to enrich the view, providing more detailed role-based information. This structure supports monitoring and analysis of employment statuses across the company.
Use Case
Owner: x
Typical Use Case: x
Style: Fact
Source
Key Parameters
Company
Details
Sample Exec
EXEC get.myView @dataMart = 'Employee', @viewName = 'Employment', @token = '<myToken>', @version = '<202404>'
Response
SEQ
Dates
Measures
Codes
SQL
BMT-DWH-DEV/Employee_Employment.sql
