culture start time
cult_start_tmDefinition
ISO-11179 Definition
Records the exact time a microbiology culture was initiated in the laboratory, marking when specimens were placed in growth media or incubation conditions. Critical for tracking incubation duration, turnaround time compliance, and interpreting organism growth results accurately.
Standard Abbreviation
cult_start_tm
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