Data Architecture Overview
Four-layer architecture for healthcare data integration
1. Raw Layer
One table per system, version, location, snapshot, and concept (e.g., Patients). Direct ingestion from source systems.
2. Stage Layer
One table per system, concept, snapshot. Uses mappings and custom transformation rules to standardize data.
3. Reference Layer
One unified table per concept. Built using mapping/code to create a common data model across all systems.
4. Visualization Layer
One table per business concept. Generated via code based on Reference Layer for reporting and analytics.