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 license numberadmn_lic_nbr

The professional license identifier of the clinician or admitting physician associated with the inpatient admission record. Used to verify credentials, attribute clinical responsibility, and support regulatory reporting requirements tied to licensed healthcare practitioners.

admission marital statusadmn_mar_sts

The patient's legally recognized marital status recorded at the time of hospital inpatient admission. Used in demographic profiling, insurance coordination of benefits determinations, social history documentation, and population health analytics within clinical data systems.

admission master identifieradmn_mstr_id

The enterprise master patient index identifier assigned to a hospital inpatient admission, enabling consistent cross-system patient identification. Links admission records across disparate clinical, billing, and analytics platforms to support longitudinal care tracking and data integrity.

admission maximumadmn_max

The upper threshold or limit value associated with a clinical or administrative measurement captured at inpatient admission, such as maximum allowable length of stay, benefit limit, or dosage ceiling. Used in utilization management, clinical decision support, and benefits adjudication workflows.

admission medical record numberadmn_mrn

The facility-assigned medical record number uniquely identifying the patient within the hospital's health information system at the time of inpatient admission. Serves as the primary local identifier for linking clinical documentation, orders, results, and billing records for the encounter.

admission middle nameadmn_mid_nm

The patient's middle name or initial as recorded at hospital inpatient admission. Used to enhance identity matching accuracy during patient lookup, record deduplication, and demographic verification in registration, clinical documentation, and claims processing workflows.

admission minimumadmn_min

The lower threshold or limit value associated with a clinical or administrative measurement captured at inpatient admission, such as minimum required length of stay, base benefit amount, or dosage floor. Used in utilization management, clinical decision support, and benefits adjudication workflows.

admission mobileadmn_mob

The patient's mobile or cellular phone number collected at hospital inpatient admission. Used for post-discharge follow-up communications, appointment reminders, care coordination outreach, and emergency contact purposes within patient engagement and care management programs.

admission modified byadmn_mod_by

The system username or user identifier of the individual who last updated the hospital inpatient admission record. Captured as part of the audit trail to support data governance, compliance review, and accountability tracking within healthcare information systems.

admission modified dateadmn_mod_dt

The timestamp recording the most recent update made to a hospital inpatient admission record in EHR, claims, or case management systems. Used by data engineers to implement incremental data loads, detect record changes in CDC pipelines, and audit inpatient data integrity across source-to-target workflows.

admission modified timeadmn_mod_tm

The date and timestamp recording when the hospital inpatient admission record was most recently updated in the system. Captured as part of the audit trail to support data lineage tracking, compliance reviews, and change history documentation within healthcare information systems.

admission nameadmn_nm

The label or descriptive text associated with a hospital inpatient admission type or category in EHR and hospital information systems, such as elective, emergency, or urgent. Used by data engineers to decode admission type codes, populate display fields in inpatient reporting layers, and support clinical analytics classification.

admission noteadmn_nt

A clinical or administrative annotation recorded at the time of or following a hospital inpatient admission in EHR systems, capturing physician observations, care plan summaries, or operational comments. Used by data engineers to extract unstructured text for NLP pipelines and link narrative content to structured inpatient encounter records.

admission numberadmn_nbr

A numeric reference value assigned to a hospital inpatient admission by a facility or health system in EHR and claims systems, often used interchangeably with account number or visit number. Used by data engineers as a linking key across UB-04 claims, ADT event feeds, and clinical encounter records in inpatient data models.

admission onset dateadmn_onset_dt

The date on which the patient's presenting symptoms or condition first began, as documented at hospital inpatient admission. Used in clinical documentation, diagnosis coding, length of illness calculations, and reporting to payers or public health agencies for disease surveillance.

admission oxygen saturationadmn_o2sat

The patient's peripheral blood oxygen saturation level, expressed as a percentage, measured at or near the time of hospital inpatient admission. A critical vital sign used to assess respiratory status, guide clinical decision-making, and establish baseline acuity for inpatient care planning.

admission paid amountadmn_pd_amt

The total dollar amount paid toward the hospital inpatient admission claim or encounter, reflecting actual reimbursement from insurers, patients, or other payers. Used in revenue cycle management, financial reconciliation, and claims adjudication reporting within healthcare billing systems.

admission paid dateadmn_pd_dt

The date on which payment was received or posted for the hospital inpatient admission claim or encounter. Used in revenue cycle management to track reimbursement timelines, monitor payer performance, and reconcile accounts receivable within healthcare billing and financial systems.

admission parentadmn_prnt

A reference to the superior or originating record in a hierarchical data structure associated with a hospital inpatient admission in EHR and case management systems. Used by data engineers to model parent-child admission relationships, link transfer episodes, and navigate hierarchical inpatient encounter data schemas.

admission percentageadmn_pct

A calculated ratio expressing a proportional measure related to a hospital inpatient admission event in claims and utilization management systems, such as cost-sharing percentage or authorization utilization rate. Used by data engineers in member liability calculations, inpatient cost allocation models, and population health benchmarking pipelines.

PreviousPage 31 of 806Next