hematology child
hem_chldDefinition
ISO-11179 Definition
A subordinate hematology record, order, or encounter linked to a parent record in a hierarchical data relationship. Used in laboratory and clinical systems to associate individual blood test components with a parent panel order, or to link follow-up hematology encounters to an originating diagnostic episode.
Standard Abbreviation
hem_chld
Category
Production DDL — FACT_LAB_RESULT
CREATE OR REPLACE TABLE FACT_LAB_RESULT (
lab_rslt_key INTEGER NOT NULL -- surrogate key,
mbr_key INTEGER NOT NULL -- FK to DIM_MEMBER,
prvdr_key INTEGER NOT NULL -- FK to DIM_PROVIDER,
loinc_cd VARCHAR(10) -- LOINC code,
lab_test_nm VARCHAR(255) -- lab test name,
lab_rslt_val DECIMAL(18,4) -- result value,
lab_rslt_unit VARCHAR(20) -- result unit,
ref_range_low DECIMAL(18,4) -- reference range low,
ref_range_high DECIMAL(18,4) -- reference range high,
abnorm_ind CHAR(1) -- abnormal indicator,
crit_val_ind CHAR(1) -- critical value flag,
coll_dt DATE -- collection date,
rslt_dt DATE -- result date,
ord_prvdr_npi VARCHAR(10) -- ordering provider NPI,
load_dt TIMESTAMP_NTZ NOT NULL -- load timestamp
);
Standard Snowflake DDL for the canonical laboratory 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