Release 52

by

Additions

Employee.Absence

This view combines employee data (DIM_EMPLOYEE_OL) with absence details (QFACT_ABSENCE_DETAILS_OL$) to facilitate the creation of a dataset used for tracking and analysing employee absences in detail. It generates structured JSON data for efficient reporting, compliance, and analytical purposes.

Employee.AbsenceLimit

This view creates a structured dataset for tracking and analysing employee absence limits. It links employee details (DIM_EMPLOYEE_OL) with their corresponding absence limit information (QFACT_ABSENCE_LIMIT_OVERVI_OL$), presenting the data in JSON format for improved integration and usability.

Global.ForEx

The Global Foreign Exchange Rate view provides a structured dataset for analysing currency exchange rates relative to the British Pound (GBP) as the base currency. This view supports financial and operational use cases requiring reliable exchange rate data for reporting and analytics.

Alterations

Employee.Details

This version enriches the original employee.details by incorporating more operational details, such as job assignments, employment status, and supervisory information:

  1. Expanded Details: Includes assignment types, job families, and supervisor details to give more contextual depth.
  2. Integration with Email Systems: Adds employee and supervisor email addresses to support direct communication needs.
  3. Employment Status Insights: Flags for assignment and primary job association improve visibility into employee roles and their current status.
  4. Enhanced Organisational Context: Incorporates organisation levels and work locations for better reporting and analysis.

This view balances comprehensiveness with efficiency, ensuring a lightweight yet functional dataset suitable for operational and strategic reporting.

Currently only available in DEV as it requires QDIM_COMPANY_PERSON_ALL_CF_OL$

https://bmt-dwh-uks-app-my.azurewebsites.net/index.php?module=app/tables/mvw&dataMart=Employee&viewName=Details&rows=300&env=dev

Notes

1. 🔴 MISSING IN PRD CONTAINER: employee_absence.sql
2. 🔴 MISSING IN PRD CONTAINER: employee_absencelimit.sql
3. ⚠️ DIFFERENT: employee_details.sql
4. 🔴 MISSING IN PRD CONTAINER: global_forex.sql

Total number of different files: 1
Total number of missing files in DEV CONTAINER: 0
Total number of missing files in PRD CONTAINER: 3

Leave a Comment