Back to search

record linkage

rec_linkage
technology·Updated Jul 6, 2026

Definition

ISO-11179 Definition

The process of identifying and connecting records across different datasets that refer to the same real-world entity, such as the same patient across different healthcare systems or the same provider across different data sources. Record linkage is fundamental to healthcare data integration, enabling longitudinal patient records, provider attribution, and population health analytics that require combining data from multiple administrative and clinical sources.

Standard Abbreviation

rec_linkage

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