Release 41

by

Additions

Employee.Employment

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.

Alterations

Alterations are to Beta versions, (there are no 202410 versions pending change)

Customer Invoice/Orderline Value

Inclusion of Company, previously omitted

Project Details_Plus

Minor change to return [Baseline_Comment] previously omitted

Project Cost

  1. REMOVE Project Dates in preference to Project.Dates
  2. UPDATE [CURRENCY_CODE] as COALESCE(dim_proj.PROJECT_CURRENCY_CODE, dim_company.CURRENCY_CODE)
  3. Add Row [MODIFIED DATE] as COALESCE(DATE_MODIFIED,DATE_CREATED)

Notes

Here’s a summary of the identified differences:

  1. customer_orderlinevalue.sql – Different between DEV and PRD.
  2. customer_invoicevalue.sql – Different between DEV and PRD.
  3. customer_invoicestatus.sql – Different between DEV and PRD.
  4. project_details_plus.sql – Different between DEV and PRD.
  5. project_cost.sql – Different between DEV and PRD.
  6. employee_employment.sql – Present in DEV but missing in PRD.

Leave a Comment