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 languagedsch_lang

The preferred or primary language of the patient at the time of hospital discharge, used to ensure appropriate translation services and discharge instruction delivery. Supports CMS language access requirements, health literacy standards, and care transition quality for non-English-speaking patients.

discharge last namedsch_last_nm

The family or surname of the patient as recorded on the hospital discharge record. Used for patient identification, discharge summary generation, and cross-system matching between inpatient discharge records, health plan member enrollment files, and medical claims data.

discharge legal namedsch_legal_nm

The official legal name of the patient as recorded at the time of hospital discharge. Used to ensure identity accuracy in discharge documentation, continuity of care records, post-acute referrals, and regulatory reporting where legal identification is required.

discharge leveldsch_lvl

A coded value representing the intensity or category of care at the time of patient discharge in EHR and claims systems, such as home, skilled nursing, or acute rehabilitation. Used in episode grouping, post-acute claims processing, and quality measure calculations to classify discharge disposition tiers.

discharge license numberdsch_lic_nbr

The professional license number of the clinician or facility responsible for authorizing the hospital discharge. Used to attribute discharge decisions to credentialed providers and supports compliance auditing, claims adjudication, and clinical accountability tracking.

discharge marital statusdsch_mar_sts

The patient's marital status as recorded at the time of hospital discharge. Used in post-discharge care planning, insurance coordination of benefits determinations, social determinants of health assessments, and demographic reporting for inpatient encounters.

discharge master identifierdsch_mstr_id

The enterprise master patient index identifier assigned to the patient at the time of hospital discharge. Used to link discharge records across disparate clinical systems, support longitudinal patient tracking, and enable accurate matching in data integration workflows.

discharge maximumdsch_max

The upper threshold value associated with a measurable clinical or administrative parameter at the time of hospital discharge. Used to define acceptable ranges for vital signs, lab values, or financial limits applied during discharge eligibility or care transition assessments.

discharge medical record numberdsch_mrn

The unique medical record number assigned to the patient within the facility's health information system at the time of discharge. Serves as the primary identifier linking inpatient encounters, clinical documentation, and discharge summaries within the hospital's records.

discharge middle namedsch_mid_nm

The patient's middle name or initial as captured in the hospital's registration system at the time of discharge. Used to improve patient identity matching accuracy, reduce duplicate records, and support full legal name verification in discharge documentation and claims processing.

discharge minimumdsch_min

The lower threshold value associated with a measurable clinical or administrative parameter at the time of hospital discharge. Used to define acceptable floor values for vital signs, lab results, or financial thresholds applied during discharge readiness evaluations or care transitions.

discharge mobiledsch_mob

The patient's mobile phone number recorded at the time of hospital discharge. Used to facilitate post-discharge follow-up communications, care transition outreach, appointment reminders, and patient engagement programs that support readmission prevention efforts.

discharge modified bydsch_mod_by

The identifier of the user who last updated the discharge record within the clinical or administrative system. Used for audit trail purposes, data stewardship accountability, and tracking changes to discharge documentation in compliance with healthcare data governance requirements.

discharge modified datedsch_mod_dt

The timestamp recording the most recent update to a discharge record in EHR, ADT, or claims systems. Used in data pipeline auditing, incremental ETL loads, and change data capture processes to identify modified discharge records requiring reprocessing in downstream healthcare analytics environments.

discharge modified timedsch_mod_tm

The timestamp indicating when the discharge record was most recently updated in the clinical or administrative system. Used to maintain an accurate audit trail, support version control of discharge documentation, and ensure data integrity in downstream reporting and integration workflows.

discharge namedsch_nm

A descriptive label associated with a discharge record, disposition type, or discharge facility in EHR and claims systems. Used in reporting interfaces, care transition dashboards, and data dictionaries to provide human-readable identification of discharge events and destinations for analysts and clinical operations teams.

discharge notedsch_nt

A clinical annotation or free-text entry recorded by a provider at patient discharge in EHR systems, capturing clinical summary, patient condition, and follow-up requirements. Used in clinical NLP pipelines, care management platforms, and quality audits to extract structured insights from unstructured discharge documentation.

discharge numberdsch_nbr

A numeric reference value assigned to a discharge event within hospital EHR, ADT, or claims billing systems. Used to uniquely reference discharge transactions in revenue cycle workflows, claims submissions, and inpatient encounter reconciliation processes across payer and provider data integration pipelines.

discharge onset datedsch_onset_dt

The date on which the patient's presenting symptoms or condition first began, as recorded at the time of hospital discharge. Used in clinical documentation, coding accuracy for diagnosis-related groups, and longitudinal analysis of disease progression relative to admission and discharge timelines.

discharge oxygen saturationdsch_o2sat

The patient's peripheral blood oxygen saturation level measured at the time of hospital discharge. Used as a key clinical indicator for discharge readiness, respiratory condition monitoring, and documentation of patient stability in inpatient encounter records and care transition summaries.

PreviousPage 179 of 806Next