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

admission death dateadmn_death_dt

The recorded date of patient death occurring during a hospital inpatient admission, captured in EHR systems, ADT discharge events, and institutional claims. Used in mortality reporting, CMS quality measures, discharge disposition coding, and population health outcomes analysis.

admission deductible amountadmn_ded_amt

The dollar amount applied toward a member's annual deductible as a result of a hospital inpatient admission, per their health plan benefit structure. Used in claims adjudication to calculate the member's out-of-pocket responsibility before coinsurance or copay provisions activate under the applicable insurance policy.

admission deleted dateadmn_del_dt

The date on which a hospital inpatient admission record was marked as deleted or voided within the health information or registration system. Used in data governance, audit trail maintenance, and revenue cycle exception reporting to track record lifecycle events and support compliance review of removed encounters.

admission deleted indicatoradmn_del_ind

Flag identifying whether a hospital inpatient admission record has been removed or voided in the healthcare system. Used in claims processing and clinical data warehouses to exclude cancelled or erroneous admission records from active reporting and billing workflows.

admission descriptionadmn_desc

A textual explanation associated with a hospital inpatient admission record, providing context for the admission type, clinical scenario, or administrative classification. Used in EHR documentation systems, claims data dictionaries, and reporting platforms to support human-readable data interpretation and audit workflows.

admission detailadmn_dtl

Granular clinical and administrative attributes captured for a hospital inpatient encounter in EHR and claims systems, including admit type, source, attending physician, and facility data. Used by data engineers to populate inpatient fact tables and support utilization analytics.

admission discharge dateadmn_dsch_dt

The calendar date on which a hospital inpatient was formally released from an acute care facility, recorded in EHR, claims, and case management systems. Critical for calculating length of stay, triggering post-discharge workflows, and validating inpatient claim billing periods.

admission due dateadmn_due_dt

The deadline date by which a payment, authorization, or required action must be completed for a hospital inpatient admission. Used in revenue cycle management to track billing obligations, payer authorization expiration, or compliance deadlines associated with an inpatient stay.

admission durationadmn_dur

The total length of time spanning a patient's hospital inpatient stay, typically calculated as the difference between admission and discharge dates. Used in utilization management, case mix reporting, and reimbursement calculations such as DRG-based payment under Medicare and commercial payers.

admission effective dateadmn_eff_dt

The date on which a hospital inpatient admission officially begins, marking the start of the covered inpatient stay in EHR, claims, and utilization management systems. Used to align authorization periods, DRG billing windows, and inpatient episode grouping logic.

admission emailadmn_eml

The electronic mail address associated with a hospital inpatient admission record, captured during patient registration in EHR and hospital information systems. Used by data engineers to support patient communication workflows, identity matching, and care coordination outreach pipelines.

admission emergency indicatoradmn_emerg_ind

Flag identifying whether a hospital inpatient admission originated as an emergency, distinguishing unplanned urgent admissions from scheduled elective stays. Used in claims adjudication, utilization review, and quality reporting to apply appropriate reimbursement rules and track emergency utilization patterns.

admission end dateadmn_end_dt

The date marking the conclusion of a hospital inpatient admission episode, used in EHR, claims, and utilization management systems to define the boundary of the inpatient stay. Supports length-of-stay calculations, episode grouping, and post-acute care transition tracking.

admission end timeadmn_end_tm

The specific time of day at which a hospital inpatient admission episode concluded, typically representing the discharge time. Used in clinical operations and billing systems to calculate precise length of stay, coordinate bed management, and support accurate same-day discharge reporting.

admission enrollment statusadmn_enrl_sts

The health plan or insurance enrollment state of a patient at the time of hospital inpatient admission, indicating whether the patient was an active member with coverage. Used in eligibility verification, claims adjudication, and authorization workflows to confirm coverage at the point of inpatient service.

admission entered byadmn_ent_by

The identifier of the user or staff member who recorded the hospital inpatient admission into the healthcare information system. Used in audit trails, data quality oversight, and compliance reporting to track data entry accountability and support corrections to inpatient admission records.

admission ethnicityadmn_ethn

The self-reported or recorded ethnic background of a patient at the time of hospital inpatient admission. Used in population health analytics, health equity reporting, and regulatory submissions such as UB-04 billing and CMS quality programs to identify disparities in inpatient care utilization and outcomes.

admission expiration dateadmn_exp_dt

The date after which a hospital inpatient admission authorization or record is no longer considered valid in utilization management and claims systems. Used by data engineers to enforce authorization expiration rules, flag stale records, and manage payer approval windows for inpatient stays.

admission external identifieradmn_ext_id

A reference identifier assigned by an external system, such as a health plan, clearinghouse, or state registry, used to link a hospital inpatient admission record across multiple healthcare platforms. Supports interoperability, claims reconciliation, and cross-system tracking of inpatient encounters.

admission faxadmn_fax

The facsimile number associated with a hospital inpatient admission record, typically used to transmit clinical documents such as authorization requests, referral forms, or discharge summaries to payers, referring physicians, or post-acute facilities during the inpatient care coordination process.

PreviousPage 29 of 806Next