mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator
  • Data Model Canvas

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data teams.

Back to Glossary

Domain

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

episode arrival timeepsd_arrv_tm

Records the clock time a patient physically arrived at a care facility for an episode-initiating encounter, such as an emergency department visit. Used to calculate door-to-treatment intervals, measure facility throughput efficiency, and support quality metrics like door-to-balloon time in acute care settings.

episode arrived dateepsd_arrv_dt

The calendar date a patient arrived at a care facility marking the beginning of an episode-initiating encounter. Used alongside arrival time in emergency and acute care settings to establish episode start, calculate wait times, measure access to care, and support quality reporting and regulatory submissions.

episode assessmentepsd_asmt

Contains the clinical evaluation narrative or structured findings documented by a provider at the time of an episode encounter, including differential diagnoses and condition severity. Used in clinical documentation systems to summarize the provider's interpretation of patient status and inform treatment plan decisions within the episode.

episode birth dateepsd_birth_dt

The patient's date of birth recorded in association with a clinical care episode, used to verify patient identity, calculate age at episode onset, and support demographic analysis. Critical for linking episode records to the correct member in health plan, EHR, and care management systems.

episode blood pressureepsd_bp

The systolic and diastolic arterial pressure measurement recorded during a clinical care episode encounter, expressed in mmHg. Used as a key vital sign for monitoring cardiovascular risk, tracking chronic condition management such as hypertension, and establishing clinical baselines within episode-based care records.

episode cancelled dateepsd_cncl_dt

Records the date a clinical care episode was formally cancelled prior to completion, such as when a scheduled procedure or treatment course was discontinued. Used in care management and utilization review systems to track episode abandonment rates, reschedule workflows, and analyze patterns in care interruption.

episode categoryepsd_cat

Classifies a clinical episode into a defined grouping such as acute, chronic, preventive, or behavioral health. Used in EHR and care management systems to organize patient care periods by condition type, supporting population health analytics and care coordination workflows.

episode chief complaintepsd_cc

Records the primary symptom or reason for care as reported by the patient at the start of a clinical episode. Captured in EHR intake and triage workflows, this field drives clinical decision support, diagnosis coding, and longitudinal condition tracking across care encounters.

episode childepsd_chld

Identifies a subordinate episode linked to a parent episode in a hierarchical care relationship. Used in EHR and care management systems to represent nested clinical events, such as a follow-up visit or complication episode that originates from a primary condition episode.

episode cityepsd_city

Records the municipality name associated with the location where a clinical episode occurred or where the patient resided during the care period. Used in EHR and public health systems to support geographic analysis, care access reporting, and social determinants of health tracking.

episode classepsd_cls

Designates the classification tier assigned to a clinical episode, such as inpatient, outpatient, emergency, or observation. Used in EHR and revenue cycle systems to determine care setting context, reimbursement pathways, and appropriate clinical documentation and coding requirements.

episode codeepsd_cd

Contains the standardized code value that identifies and classifies a clinical episode within EHR and care management systems. This code enables consistent episode tracking across encounters, supports clinical grouping logic, and links care periods to diagnosis or procedure classification standards.

episode commentepsd_cmt

Stores free-text narrative notes entered by clinicians or care coordinators to provide additional context about a clinical episode. Used in EHR and care management systems to capture observations, clarifications, or care instructions that supplement structured episode data fields.

episode completed dateepsd_cmpl_dt

Records the calendar date on which a clinical episode was formally closed or resolved. Used in EHR and care management systems to calculate episode duration, measure care cycle times, support quality reporting, and trigger downstream workflows such as discharge follow-up or billing finalization.

episode confidential indicatorepsd_conf_ind

Flag that designates a clinical episode as sensitive or confidential, restricting access in accordance with privacy regulations such as 42 CFR Part 2 for substance use or state mental health statutes. Controls visibility of episode data within EHR and health information exchange systems.

episode countepsd_cnt

Represents the total number of clinical episodes recorded for a patient or condition within a defined period. Used in EHR, care management, and population health systems to measure disease burden, care utilization patterns, and recurrence rates for chronic or episodic conditions.

episode countryepsd_ctry

Records the country associated with the location of a clinical episode or the patient's residence during the care period. Used in EHR and public health systems to support international patient tracking, cross-border care coordination, and geographic reporting in global health contexts.

episode created byepsd_crtd_by

Identifies the username or system ID of the user who initially created the clinical episode record. Used in EHR audit trails and data governance workflows to establish accountability, support record traceability, and meet regulatory requirements for documentation integrity and user activity logging.

episode created dateepsd_crtd_dt

Records the calendar date on which the clinical episode record was first entered into the EHR or care management system. Used in audit trails, data quality monitoring, and operational reporting to establish record provenance and distinguish episode creation from clinical event onset dates.

episode created timeepsd_crtd_tm

Records the exact time at which a clinical episode record was first created in the EHR or care management system. Combined with the creation date, this timestamp supports audit logging, workflow sequencing, and data governance requirements for precise record provenance tracking.

PreviousPage 245 of 806Next