Summary The [cdm].[post_insert] stored procedure is responsible for inserting a new metadata row into a specified table using a structured JSON payload. It dynamically builds the insert logic using the column metadata from cont.table_templates, including default values and computed checksum logic. This procedure is a core component of the CDM metadata engine, providing consistency, reusability, … Read more
Summary The [cdm].[patch_upsert] procedure acts as a controller for metadata inserts and updates. It dynamically evaluates JSON payloads, identifies whether an existing active row already exists, and determines whether to call an insert (post_insert) or update (put_update) operation. This ensures consistent versioned metadata with minimal redundancy. It supports JSON-driven payloads with field mapping based on … Read more
Summary The [cdm].[create_table] stored procedure dynamically builds SQL tables using metadata templates from cont.table_templates. It is used to create consistent core, meta or item tables within a specified schema, complete with partitioning, indexes, and insertion triggers for data integrity and metadata logging. This approach ensures repeatability, consistency, and automated setup of foundational table structures across … Read more
Commits: 24Files Changed: 33 🔄 Alterations 1. global_organisation_ifs.sql3. 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: Update: Continued development of CDM views for the new generation.Main change: Standardisation on the field … Read more
🔗 How to Configure VNet Peering for Azure Data Factory and Oracle Integration This guide walks you through securely connecting Azure Data Factory (ADF) to an Oracle Virtual Machine hosted in a different Virtual Network. By setting up VNet Peering and configuring a Managed Virtual Network Integration Runtime (IR), you can enable private, secure data … Read more
Additions Common Data Model New Common Data Model (CDM) views have been introduced, conforming to the latest standard: Employee Domain Customer & Supplier Domains Project Domain These views establish a consistent and scalable approach to data modelling across core business domains, streamlining downstream reporting and integration. CDM Functions Key functions have been revised to support … Read more
Additions 202409 ⚠️ Created:global_company_202409.sql ⚠️ Created:global_organisation_202409.sql⚠️ Created:customer_details_202409.sql Datamart views have been created to ensure a seamless transition for clients migrating from 202404 to 202409, providing a structured and usable view for ongoing data integration. These views have been explicitly versioned with the 202409 signature to: Common Data Standard ⚠️ Created:project_core.sql ⚠️ Created:project_codes.sql ⚠️ Created:employee_item_codes_expense.sql ⚠️ … Read more
🧾 Overview This view provides attribute-level values related to employee absence and leave entitlements, enabling structured DataMart-level analysis across both transactional absence events and annual entitlement summaries. 📚 Description The Employee Item Codes Absence view translates raw absence and entitlement data into attribute-coded rows that support dimensional modelling. Each row identifies: 🏗️ Source Tables 📦 … Read more
Purpose This view is part of the Common Data Standard, following an item and codes style table structure, ensuring consistency in data modelling across financial and operational datasets.The Employee Item Codes Expense view provides structured details on the various codes associated with employee expense items. It captures key attributes such as expense type, cost centre, … Read more
Purpose This view is part of the Common Data Standard, following an item and values style table structure, ensuring consistency in data modelling across financial and operational datasets.The Employee Item Value Expense view provides detailed information about individual expense items attributed to employees. It captures various expense attributes, including expense type, gross pay amount, and … Read more