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

discharge creatininedsch_cr

The serum creatinine laboratory value recorded at or near the time of inpatient hospital discharge, used as an indicator of renal function. Referenced in quality measures for conditions such as acute kidney injury, heart failure, and chronic kidney disease to assess patient status at the point of care transition.

discharge datedischarge_dt

The date on which a patient was discharged from an inpatient facility or ended an episode of care. Used in institutional claims processing, length of stay calculations, and DRG assignment. Required field on UB-04 claim forms for inpatient and outpatient facility billing.

discharge datetimedsch_dttm

The combined date and timestamp recording the exact moment of patient release from a facility, stored in EHR and hospital information systems to calculate precise length of stay in hours, support bed management workflows, and enable time-sensitive analytics in clinical operations platforms.

discharge dea numberdsch_dea_nbr

The Drug Enforcement Administration registration number associated with the prescribing clinician responsible for controlled substance orders at the time of inpatient discharge. Used in medication reconciliation, discharge prescription validation, and regulatory compliance tracking within pharmacy and clinical documentation systems.

discharge death datedsch_death_dt

The recorded date of patient death coinciding with or resulting in a hospital discharge event, captured in EHR systems and institutional claims using UB-04 discharge status code 20, used for mortality reporting, quality metrics, and population health analytics across clinical and payer data systems.

discharge deductible amountdsch_ded_amt

The portion of inpatient hospital discharge costs applied toward the patient's annual insurance deductible before the health plan begins paying its share. Used in member cost-sharing calculations, explanation of benefits statements, and financial counseling workflows within hospital billing and health plan claims systems.

discharge deleted datedsch_del_dt

The calendar date on which an inpatient discharge record was marked as deleted or voided in the clinical or administrative system. Used in data governance, audit trail management, and record reconciliation processes to track when erroneous or duplicate discharge entries were removed from active reporting datasets.

discharge deleted indicatordsch_del_ind

A flag identifying that an inpatient discharge record has been logically deleted or voided in the system without physical removal from the database. Used in data quality management and reporting filters to exclude invalidated discharge records from active utilization analysis, billing, and clinical quality reporting.

discharge descriptiondsch_desc

A textual explanation describing the nature, reason, or outcome of an inpatient discharge event, stored in EHR and hospital information systems to provide clinical context, support documentation compliance, and supplement structured discharge codes in revenue cycle and analytics reporting environments.

discharge detaildsch_dtl

Granular clinical or administrative information associated with an inpatient discharge record, including service details, billing line items, or clinical findings stored in EHR and claims systems to support itemized billing, audit reviews, and detailed encounter-level analysis in healthcare data warehouses.

discharge discharge datedsch_dsch_dt

The explicit hospital release date recorded within a discharge encounter record, often appearing in EHR or claims data models where discharge is the encounter type prefix, used to validate billing period end dates, calculate length of stay, and reconcile institutional claim submissions.

discharge due datedsch_due_dt

The expected or scheduled date by which the patient's inpatient hospital discharge is anticipated to occur, as determined during care planning. Used in utilization management, bed capacity planning, and care coordination to track adherence to anticipated discharge timelines and reduce avoidable inpatient days.

discharge durationdsch_dur

The total elapsed time from hospital admission to the completion of the inpatient discharge process, representing the patient's length of stay. Used in utilization management, DRG-based reimbursement analysis, quality benchmarking, and case management reporting to evaluate inpatient care efficiency and resource consumption.

discharge effective datedsch_eff_dt

The date on which a discharge record or associated benefit, coverage change, or clinical status becomes active in EHR, member enrollment, or claims systems, used to align discharge event timelines with payer eligibility windows, authorization periods, and revenue cycle adjudication workflows.

discharge emaildsch_eml

An email address captured at patient discharge in hospital or care management systems, used to deliver discharge summaries, follow-up instructions, or care transition notifications. Supports post-acute outreach workflows and care coordination platforms integrated with EHR discharge modules.

discharge emergency indicatordsch_emerg_ind

Flag identifying whether a hospital inpatient or observation discharge originated from an emergency department visit. Used in utilization reporting, case mix analysis, and payer claim adjudication to distinguish emergent admissions from scheduled or elective inpatient stays.

discharge end datedsch_end_dt

The date marking the conclusion of a discharge-related process or episode in hospital EHR or claims systems. Used to calculate length of post-discharge periods, track readmission windows, and close encounter records in downstream analytics and quality reporting pipelines.

discharge end timedsch_end_tm

Timestamp recording the exact clock time when a hospital discharge process was completed and the patient physically departed the facility. Used in bed management, length-of-stay calculations, and operational throughput analytics to measure discharge efficiency and capacity planning.

discharge enrollment statusdsch_enrl_sts

The health plan or program enrollment status of a patient at the time of hospital discharge, such as active, terminated, or pending. Used in care management workflows and post-discharge follow-up to determine coverage continuity and eligibility for transitional care services.

discharge entered bydsch_ent_by

The user identifier or credentials of the clinical or administrative staff member who recorded the discharge event in the hospital information system. Used in audit trails, compliance reviews, and workflow accountability tracking for inpatient discharge documentation.

PreviousPage 177 of 806Next