How data is structured, governed, and consumed across the organisation 1. Purpose To provide a stable, governed data platform that: 2. Core Principle Data is not delivered as tables — it is delivered as structured, governed objects with defined behaviour 3. Platform Structure 3.1 Canonical Data Model (CDM) The platform is built on a consistent … Read more
Overview sustainability.item_values_co2factor provides a structured, item-value representation of greenhouse gas (GHG) conversion factors used for carbon reporting. The view standardises UK Government conversion factor data into a consistent CDM-aligned format, enabling emissions calculations to be performed in a repeatable and governed way across reporting and analytics. It forms a foundational dataset for sustainability, emissions tracking, … Read more
Overview Compliance.item_codes_osh provides a structured, business-ready item code view of OSH incident and safety form records. It consolidates form-level and location-related attributes from the source OSH records into a single consistent pattern so that incident, safety, and compliance information can be queried in the same way as other itemised CDM-style views. This view is designed … Read more
Overview The resource.item_values_activity view provides a structured, item-level representation of planned resource effort, linking employees to project activities through planned hours. It expresses resource planning as measurable activity, enabling clear visibility of how effort is distributed across projects, activities, and time-based snapshots. Purpose This view standardises planned resource effort into the CDM item_values pattern, allowing: … Read more
Overview The AccountsReceivable.item_values_receipts view provides a structured, line-level representation of how customer receipts are applied within Accounts Receivable. It exposes the financial impact of payments across ledger items, including settlement behaviour, adjustments, and associated financial movements. This view enables a transparent understanding of how incoming cash is allocated against customer balances, supporting reconciliation, audit, and … Read more
Overview The Person Meta Dates view provides a structured temporal layer for the Person domain, representing key date-based attributes associated with a canonical PERSON_UID. It captures assignment-related validity and lifecycle dates in a consistent CDM meta format, enabling controlled and interpretable time-based analysis of person-level context. This view complements: Purpose Key Features 1. Structured Date … Read more
Overview The Person Meta Codes view provides a governed and curated attribute layer for the Person domain, representing identity, linkage, restricted classification, and limited mirrored assignment context for each canonical PERSON_UID. This view extends person.core_details by introducing structured attributes using the CDM meta pattern, enabling controlled person-based reporting and cross-system identity linkage. It is designed … Read more
Overview util.identity_personid provides a resolved and reusable identity mapping between source-system person records and a canonical PERSON_UID. It supports the Person domain by combining: into a single trusted identity layer. This process reduces duplication, improves cross-system linking, and provides a stable foundation for: Purpose How It Works 1. Extract Source Email Identities Source: Processing: Outcome: … Read more
Overview The Person Core Details view defines the canonical person object for the IFS and external app-aligned Person domain within the Common Data Model (CDM). It provides a controlled identity layer for representing a human individual independently of any single employment record, using a stable PERSON_UID and a small set of governed link attributes. This … Read more
Overview The Employee Meta Dates view provides a structured temporal layer for employee objects within the Common Data Model (CDM). It captures key lifecycle dates associated with employees and presents them in a standardised attribute format, aligned to the CDM meta pattern. This view complements: Purpose Key Features 1. Structured Date Model Each date is … Read more