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 childadmn_chld

A subordinate or linked record associated with a parent hospital inpatient admission, representing a dependent encounter, diagnosis, or service line in hierarchical data models. Used in EHR and claims data warehouses to manage parent-child relationships in encounter grouping logic.

admission cityadmn_city

The city associated with the patient's address recorded at the time of a hospital inpatient admission. Used in demographic data collection, population health analytics, and geographic utilization reporting to identify service area patterns and support social determinants of health analysis.

admission classadmn_cls

A classification tier designating the type or level of a hospital inpatient admission, such as inpatient, observation, or skilled nursing. Used in EHR ADT systems, UB-04 institutional claims, and utilization management platforms to drive billing rules and benefit determination logic.

admission codeadmn_cd

A standardized coded value assigned to categorize the type or source of a hospital inpatient admission, such as NUBC admission type or source codes. Used in UB-04 institutional claims (FL-14 and FL-15), EHR systems, and claims adjudication engines for processing and reporting.

admission coinsurance amountadmn_coins_amt

The portion of inpatient hospital charges the patient is responsible for paying after the deductible is met, calculated as a percentage of the allowed amount per the member's health plan benefits. Used in claims adjudication, member cost-sharing calculations, and explanation of benefits generation.

admission commentadmn_cmt

A free-text notation field captured at the time of hospital inpatient admission, documenting supplementary clinical or administrative information not captured in structured fields. Used in EHR systems, ADT event logs, and care management platforms for contextual documentation and audit trails.

admission completed dateadmn_cmpl_dt

The date on which all required administrative, clinical, or billing processes associated with a hospital inpatient admission were fully finalized. Used in workflow management and revenue cycle reporting to measure processing cycle times and ensure admissions are closed prior to claim submission.

admission confidential indicatoradmn_conf_ind

A flag designating that a hospital inpatient admission record contains sensitive information requiring restricted access, such as behavioral health, substance use disorder, or reproductive health encounters. Governs data sharing permissions in compliance with 42 CFR Part 2, HIPAA, and facility privacy policies.

admission contactadmn_cntct

The designated communication reference point for a hospital inpatient admission, including emergency contacts, referring providers, or case managers. Stored in EHR registration modules and ADT systems, used for care coordination, notification workflows, and discharge planning processes.

admission copay amountadmn_cpay_amt

The fixed out-of-pocket dollar amount a member is required to pay at the time of or following a hospital inpatient admission per their health plan benefit design. Used in claims adjudication and member cost-sharing calculations to determine the patient liability portion before insurance payment is applied.

admission costadmn_cst

The total expense incurred by the hospital or health system for delivering inpatient care during an admission, encompassing direct costs such as supplies and labor and indirect overhead allocations. Used in cost accounting, payer contract analysis, and profitability reporting within hospital financial systems.

admission countadmn_cnt

The total number of hospital inpatient admissions recorded for a patient, member, or population within a defined period. Used in EHR analytics, claims data warehouses, and population health platforms to measure utilization rates, readmission risk scoring, and care management prioritization.

admission countryadmn_ctry

The country associated with the patient's address recorded at the time of a hospital inpatient admission. Used in demographic data capture and international patient reporting to support billing, eligibility verification, and population health analytics for patients receiving care outside their country of residence.

admission created byadmn_crtd_by

The system username or staff identifier of the individual who initially created the inpatient admission record in the hospital information or registration system. Used in audit trail tracking, data governance, and workflow accountability to establish record ownership and support compliance investigations.

admission created dateadmn_crtd_dt

The system-generated timestamp indicating when a hospital inpatient admission record was first created in the source system. Used in EHR, ADT feeds, and data warehouse audit frameworks to support record lineage tracking, ETL processing windows, and data reconciliation workflows.

admission created timeadmn_crtd_tm

The exact timestamp when an inpatient admission record was first entered into the hospital information or registration system. Used in audit logging, workflow performance measurement, and data quality monitoring to track registration timeliness and establish the system-of-record creation point for the admission.

admission creatinineadmn_cr

The serum creatinine laboratory value obtained at or near the time of a patient's inpatient hospital admission. Used as a baseline indicator of renal function to guide clinical decision-making, medication dosing, contrast administration safety assessments, and early identification of acute kidney injury risk.

admission dateadmn_dt

The calendar date a patient was formally admitted to a hospital or inpatient facility, recorded in institutional claims (UB-04) and EHR systems. Used in revenue cycle, utilization management, and length-of-stay calculations. Maps to CMS field FL-12 in institutional billing.

admission datetimeadmn_dttm

The combined date and time value capturing the exact moment a patient was admitted to a hospital inpatient setting, recorded in EHR ADT systems and HL7 event feeds. Used for precise length-of-stay calculations, clinical event sequencing, and real-time bed management workflows.

admission dea numberadmn_dea_nbr

The Drug Enforcement Administration registration number associated with the prescribing clinician or facility linked to a hospital inpatient admission. Used to identify and validate licensed prescribers of controlled substances during the admission for regulatory compliance, pharmacy dispensing, and audit purposes.

PreviousPage 28 of 806Next