📘 Purpose This page provides an overview of the product-related data views based on OCNS and CEFAS environmental regulatory sources. These views support reporting, environmental compliance, and substitution warning analysis across various product categories. 🔍 Use Cases 🗂️ DataViews Summary The following views are published within the cefas schema: DataView Name Category Description Notes / … Read more
📝 Description This view provides a structured metadata representation of Business Opportunities (BusOpp), transforming source data into a JSON-like attribute-value format. It supports consistent reporting and simplifies analytics by organising attributes under clear META_TYPE categories like OPPORTUNITY, STATUS, and SALES. 🎯 Purpose ✅ Use Cases 🧱 Structure Each row in the view corresponds to a … 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
Additions Customer Details & Project Details APC Alterations General Ledger Transaction Customer Details (CAD & USD) Business Opportunity Dates (Busopp Dates) Notes The following SQL scripts have been modified and differ from previous versions: There were additional alterations to cdm to support transaction error logging 1. ⚠️ DIFFERENT: create_table_comment.sql2. ⚠️ DIFFERENT: create_table_log.sqlSource ID altered to … Read more
Purpose The get.myarchive stored procedure is designed to retrieve archived data from a specified DataMart view, allowing for historical analysis and structured retrieval. The procedure integrates data retrieval logic, version control, and debugging capabilities to ensure flexible and efficient access to archived data. Key Features Workflow Use Case This procedure is ideal for historical data … Read more
Purpose The Infrastructure.OSHrecords DataMart is designed to provide a structured and centralised repository for occupational health and safety (OHS) records sourced from the myOSH system via API exports. This DataMart enables efficient reporting, compliance tracking, and analysis of safety-related incidents, risk assessments, and other regulatory documentation. By transforming the raw API data into a well-structured … Read more
Microsoft Fabric is designed to integrate multiple analytics workloads, including data engineering, data science, and business intelligence, within a unified platform. While our current Medallion structure already has a logical progression of data refinement (Bronze → Silver → Gold), there are key differences in architecture, tooling, and approach that we might consider while emulating a … Read more
Purpose The Customer Invoice Item data mart is designed to provide detailed insights into invoice-level transactional data for customers. It organises, validates, and enriches raw data from the source system into a structured and accessible format, enabling comprehensive analysis and reporting. Use Case Owner: Soon Tan Typical Use Case: Style: Fact, Each row represents a unique Invoice … Read more