1️⃣Overview The Data Dictionary serves as the backbone for structured data definitions across financials, operations, projects, compliance, and workforce domains. It ensures standardised terminology, clear metadata definitions, and structured governance for all key data entities. Key Functions: ✅ Standardised Definitions – Ensures clarity and uniformity across datasets.✅ Metadata-Driven Organisation – Supports schema validation and query … Read more
Summary This minor release of some 36 changes to ensure that all view definitions now include an Alias for the table in the FROM clause. These updates are cosmetic in nature and do not impact the performance of the DataViews. Key Updates Impact Next Steps For any queries or issues, please reach out to the … 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
Proposal for a white paper on Common Data Model (Datamarts) Proposed Structure for the White Paper 1. Executive Summary 2. Introduction 3. Objectives 4. Proposed Standardised Format 5. Naming Conventions 6. Standardised Structure for Views 7. Metadata Format 8. Implementation Roadmap 9. Benefits 10. Conclusion Naming Suggestions for Views Here are some options for naming … Read more
Additions customer_orderline_202501 This release introduces a new version of customer.orderline, evolving from the current beta version. The latest update incorporates a fully JSON-managed field structure, enhancing flexibility, data integrity, and future scalability. Key Changes & Enhancements Impact on Data Consumers Alterations project_details_plus_CAD This update continues the ongoing improvements to mapping accuracy and data consistency within … Read more
In its most basic definition, sensitive data is a specific set of “special categories”: Article 9 of the GDPR prohibits special category data from being processed unless you can rely on an exemption.
Core Views and their Standard Structures Each DataMart will be built on six primary views: 1. Details (or Core) View Purpose: Schema: Column Name Data Type Description company VARCHAR Primary entity identifier object_id VARCHAR Unique object identifier (project_id) seq_json JSON Structured metadata reference for linking name VARCHAR Name of the project/entity description TEXT Brief descriptive … Read more