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

effective procedure dateeff_proc_dt

The date on which a clinical procedure or medical service is performed and recognized as falling within a member's active coverage period. Used in claims adjudication to confirm that the service date aligns with benefit eligibility, ensuring accurate reimbursement and prior authorization validation.

effective rangeeff_rng

The defined start and end boundary of a member's coverage validity window, representing the span during which benefits are active and claims are eligible for adjudication. Used in enrollment and eligibility systems to validate service dates against coverage periods for accurate benefit application.

effective resulteff_rslt

The outcome or determination produced by evaluating a clinical service, authorization request, or claim against an active coverage effective period. Used in utilization management and claims adjudication systems to record whether a service was deemed covered, denied, or modified based on eligibility validation.

effective surgery dateeff_surg_dt

The date on which a surgical procedure is performed and validated against a member's active insurance coverage period. Used in claims adjudication and prior authorization systems to confirm that operative services fall within the benefit effective window, supporting accurate reimbursement and surgical cost-sharing calculations.

eligibility admission dateelig_admn_dt

The date a member was admitted to a hospital or inpatient facility for a specific episode that triggered or affected their insurance coverage eligibility status. Used in member enrollment systems to validate benefit coverage periods and coordinate inpatient claims processing.

eligibility discharge dateelig_dsch_dt

The date a member was formally discharged from an inpatient facility for an episode linked to their insurance coverage eligibility status. Used in member enrollment and claims systems to define benefit coverage boundaries and reconcile inpatient stay durations against active coverage periods.

eligibility labelelig_lbl

A human-readable display text or descriptive tag assigned to a member's coverage qualification status, such as Active, Terminated, or Pending. Used in member enrollment systems and payer portals to present eligibility status in a standardized, user-friendly format for administrative and reporting workflows.

eligibility procedure dateelig_proc_dt

The date a specific medical procedure was performed that is associated with a member's insurance coverage eligibility determination. Used in member enrollment and claims adjudication systems to verify that procedures occurred within active coverage windows and to support prior authorization or benefit coordination reviews.

eligibility surgery dateelig_surg_dt

The date a surgical procedure was performed that is linked to a member's insurance coverage eligibility status or benefit qualification. Used in member enrollment and claims systems to validate surgical events against active coverage periods and to support coordination of benefits and pre-authorization determinations.

emergency active indicatoremerg_actv_ind

A binary flag indicating whether an emergency department encounter or urgent care episode is currently open and active within the clinical or administrative system. Used in emergency department information systems to track real-time patient status and support workflow management for active versus resolved ED visits.

emergency active statusemerg_actv_sts

A coded or descriptive value representing the current activity state of an emergency department encounter, such as In Progress, Pending Discharge, or Closed. Used in ED information systems to monitor patient flow, resource allocation, and care coordination across active urgent care episodes in real time.

emergency addressemerg_addr

Physical location data element captured in EHR, member enrollment, and claims systems identifying the geographic site associated with an emergency care episode. Used in facility billing, dispatch coordination, and population health data pipelines to associate emergency service events with provider or patient location records.

emergency adjustment amountemerg_adj_amt

The dollar value of a financial modification applied to an emergency department claim or service charge, such as a contractual writeoff, payer discount, or billing correction. Used in claims adjudication systems to reconcile the difference between billed charges and the final reimbursable amount for ED services.

emergency admission dateemerg_admn_dt

Date field in hospital information systems and claims data recording the calendar date a patient was formally admitted through the emergency department. Used in inpatient 837I claim transactions, DRG grouping logic, and length-of-stay calculations within revenue cycle and clinical analytics data pipelines.

emergency ageemerg_age

The patient's age in years at the time of an emergency department visit or urgent care encounter. Used in ED clinical and administrative systems for triage stratification, age-specific treatment protocols, pediatric versus adult care routing, and population health reporting on emergency utilization patterns.

emergency allowed amountemerg_alwd_amt

The maximum dollar amount a payer will reimburse for a specific emergency department service based on the contracted fee schedule or benefit plan terms. Used in claims adjudication to establish payment limits for ED encounters and calculate member cost-sharing obligations such as copays and coinsurance.

emergency amountemerg_amt

Monetary data element in claims and billing systems representing the total charged or allowed dollar value associated with an emergency care episode. Used in cost analytics, member cost-sharing calculations, and payer adjudication workflows to quantify financial liability for emergency department or urgent care services.

emergency approval statusemerg_appr_sts

The authorization or approval state assigned to an emergency department service request or claim, such as Approved, Pending Review, or Denied. Used in utilization management and claims systems to track whether ED services have received payer authorization and to manage reimbursement eligibility for urgent care episodes.

emergency approved byemerg_appr_by

The name or identifier of the clinician, administrator, or system user who authorized or approved an emergency department service, order, or claim. Used in ED workflow and audit systems to maintain accountability, support compliance reviews, and document the authorization chain for urgent care service decisions.

emergency arrival timeemerg_arrv_tm

The exact time a patient arrived at the emergency department, recorded as part of the ED encounter registration. Used in emergency department systems to measure door-to-triage and door-to-treatment intervals, track ED throughput performance, and support quality reporting metrics such as CMS emergency care time measures.

PreviousPage 221 of 806Next