Release 62

by

Commits: 24
Files Changed: 33

🔄 Alterations

1. global_organisation_ifs.sql
3. global_organisation_202409.sql

Update: Retention of previous IFS logic for PRU codes and Programme assignment.
Note: 202409 now draws from the MIS80 source and includes PRU codes and Programmes across all regions.

4–5, 6–12, 30–33:
Includes:

  • employee_codes.sql
  • employee_dates.sql
  • employee_item_codes_absence.sql
  • employee_item_codes_expense.sql
  • employee_item_dates_absence.sql
  • employee_item_values_absence.sql
  • employee_item_values_expense.sql
  • project_codes.sql
  • project_dates.sql
  • customer_core.sql
  • employee_core.sql
  • project_core.sql
  • supplier_core.sql

Update: Continued development of CDM views for the new generation.
Main change: Standardisation on the field name CODE_VALUE, enabling seamless use of table.combine() or UNION.
Benefit: Supports the simple 3-step pivot approach across similar structured tables.

24–25:

  • employee_headcount_202409.sql
  • employee_hours_202409.sql

Update: Efficiency improvements using CTE methods for identifying Codes, Dates, and Values in preparation for CDM alignment.
Impact: No visible change in view format.

➕ Additions

2. project_details_plus_APC.sql

New: Adds a regional Project Details Plus view for APAC (APC).
Usage: Completes the regional coverage; can be filtered by version = 'APC' and stacked with other regions using table.combine() or UNION.

23. Dates_DIM_DATE 202409.sql

New: Optimised DIM_DATE view using CTEs for UK Holidays and Accounting Periods.
Impact: Improved performance with identical output format.

26. resource_details_202409.sql

New: Adds the 202904 version, allowing for the deprecation of 202404.

📦 Archived Views

No Longer Maintained

16–22:

  • employee_absence.sql
  • employee_absencelimit.sql
  • employee_details.sql
  • employee_details_plus.sql
  • employee_employment.sql
  • employee_leaveentitlement.sql
  • employee_status.sql

Note: These (non versioned development) views have been archived from further development. Use equivalent CDM-aligned views where applicable.

Notes

  • Found 24 commits
  • Found 33 unique file changes in the given period.

🔍 Found 33 unique file changes in the given period:
1. ⚠️ DIFFERENT: global_organisation_ifs.sql
2. ⚠️ DIFFERENT: project_details_plus_APC.sql
3. ⚠️ DIFFERENT: global_organisation_202409.sql
4. ⚠️ DIFFERENT: employee_codes.sql
5. ⚠️ DIFFERENT: employee_dates.sql
6. ⚠️ DIFFERENT: employee_item_codes_absence.sql
7. ⚠️ DIFFERENT: employee_item_codes_expense.sql
8. ⚠️ DIFFERENT: employee_item_dates_absence.sql
9. ⚠️ DIFFERENT: employee_item_values_absence.sql
10. ⚠️ DIFFERENT: employee_item_values_expense.sql
11. ⚠️ DIFFERENT: project_codes.sql
12. ⚠️ DIFFERENT: project_dates.sql
13. ⚠️ DIFFERENT: DateTable SRV.sql
14. ⚠️ DIFFERENT: DateTable SYN.sql
15. ⚠️ DIFFERENT: Dates_DIM_DATE.sql
16. ⚠️ DIFFERENT: employee_absence.sql
17. ⚠️ DIFFERENT: employee_absencelimit.sql
18. ⚠️ DIFFERENT: employee_details.sql
19. ⚠️ DIFFERENT: employee_details_plus.sql
20. ⚠️ DIFFERENT: employee_employment.sql
21. ⚠️ DIFFERENT: employee_leaveentitlement.sql
22. ⚠️ DIFFERENT: employee_status.sql
23. ⚠️ DIFFERENT: Dates_DIM_DATE 202409.sql
24. ⚠️ DIFFERENT: employee_headcount_202409.sql
25. ⚠️ DIFFERENT: employee_hours_202409.sql
26. ⚠️ DIFFERENT: resource_details_202409.sql
27. ⚠️ DIFFERENT: upsert_meta.sql
28. ⚠️ DIFFERENT: upsert_meta_insert.sql
29. ⚠️ DIFFERENT: upsert_meta_update.sql
30. ⚠️ DIFFERENT: customer_core.sql
31. ⚠️ DIFFERENT: employee_core.sql
32. ⚠️ DIFFERENT: project_core.sql
33. ⚠️ DIFFERENT: supplier_core.sql

Leave a Comment