Back to search

data quality framework

dq_frmwk
technology·Updated Jul 6, 2026

Definition

ISO-11179 Definition

A structured set of dimensions, rules, metrics, and processes used to measure and improve the quality of healthcare data across attributes such as completeness, accuracy, consistency, timeliness, validity, and uniqueness. In healthcare data platforms, data quality frameworks are implemented through dbt tests, Great Expectations profiles, or custom SQL validation rules applied at each layer of a medallion architecture to prevent data quality issues from propagating to downstream analytics and clinical decision support.

Standard Abbreviation

dq_frmwk

Category

technology

Production DDL — DIM_SYSTEM

DIM_SYSTEM.sql
CREATE OR REPLACE TABLE DIM_SYSTEM (
    sys_key         INTEGER       NOT NULL  -- surrogate key,
    sys_id          VARCHAR(50)   NOT NULL  -- system identifier,
    sys_nm          VARCHAR(200)  NOT NULL  -- system name,
    sys_type_cd     VARCHAR(50)             -- system type code,
    sys_vrsn        VARCHAR(50)             -- system version,
    vndr_nm         VARCHAR(200)            -- vendor name,
    intfc_type_cd   VARCHAR(50)             -- interface type code,
    intfc_proto_cd  VARCHAR(20)             -- interface protocol,
    env_cd          VARCHAR(20)             -- environment code,
    host_nm         VARCHAR(200)            -- hostname,
    ip_addr         VARCHAR(45)             -- IP address,
    sts_cd          VARCHAR(20)             -- status code,
    eff_dt          DATE          NOT NULL  -- effective date,
    exp_dt          DATE                    -- expiration date,
    rec_creat_dt    TIMESTAMP     NOT NULL  -- record created date
);

Standard Snowflake DDL for the canonical technology table. Convert to BigQuery or Databricks →

Why This Term Matters

Healthcare data terminology is foundational for any data engineer working in this industry. Precise understanding of standard terms enables accurate schema design, reduces downstream data quality issues, and ensures pipelines meet the regulatory and interoperability requirements imposed by HIPAA, HL7 FHIR, and CMS reporting frameworks. Without this foundation, even technically well-built pipelines produce data that fails validation when it reaches payers or regulators.

Related Content

Looking for more healthcare terms?

Browse our complete library of 100,000+ standardized healthcare data terms

Browse All Terms