door to doctor time minutes
door_to_doc_minDefinition
ISO-11179 Definition
The elapsed time in minutes between a patient arrival in the emergency department and first contact with a physician or advanced practice provider, a standard emergency department performance metric tracked against regulatory and accreditation benchmarks. Door-to-doctor time is a key driver of patient satisfaction scores and ED operational efficiency.
Standard Abbreviation
door_to_doc_min
Category
Production DDL — FACT_OPERATIONAL_EVENT
CREATE OR REPLACE TABLE FACT_OPERATIONAL_EVENT (
oprtnl_evnt_key INTEGER NOT NULL -- surrogate key,
evnt_id VARCHAR(50) NOT NULL -- source event identifier,
evnt_type_cd VARCHAR(50) NOT NULL -- event type code,
evnt_dt DATE NOT NULL -- event date,
evnt_ts TIMESTAMP -- event timestamp,
fac_id VARCHAR(20) -- facility identifier,
dept_cd VARCHAR(20) -- department code,
unit_cd VARCHAR(20) -- unit code,
mbr_id VARCHAR(20) -- member identifier,
prvdr_npi VARCHAR(10) -- provider NPI,
evnt_sts_cd VARCHAR(20) -- event status code,
evnt_sts_dt DATE -- status date,
capacity_cnt INTEGER -- capacity count,
utilztn_pct DECIMAL(5,2) -- utilization percentage,
rec_creat_dt TIMESTAMP NOT NULL -- record created date,
rec_updt_dt TIMESTAMP NOT NULL -- record updated date
);
Standard Snowflake DDL for the canonical operations 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