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 feeadmn_fee

The charge assessed at the time of a hospital inpatient admission, representing facility fees, administrative processing costs, or initial service charges. Used in revenue cycle management and patient financial services to establish billing obligations and track collected amounts against expected reimbursement.

admission first nameadmn_first_nm

The patient's given first name as recorded at the time of hospital inpatient admission registration. Used in patient identity matching, medical record linking, and claims submission to ensure accurate association of inpatient records with the correct individual across healthcare and billing systems.

admission flagadmn_flg

A binary indicator field in EHR and claims data systems that denotes whether a specific encounter or claim record qualifies as a hospital inpatient admission. Used by data engineers in inpatient identification logic, episode grouping algorithms, and acute care utilization reporting pipelines.

admission frequencyadmn_freq

The rate or number of times a patient experiences hospital inpatient admissions within a defined measurement period. Used in utilization management, care management programs, and population health analytics to identify high-utilizer patients and evaluate the effectiveness of readmission reduction interventions.

admission full nameadmn_full_nm

The complete legal name of the patient as captured during hospital inpatient admission registration, including first, middle, and last name components. Used in patient identity verification, medical record management, and claims processing to ensure accurate matching across clinical and administrative systems.

admission genderadmn_gndr

The sex or gender identity of a patient as recorded at the time of hospital inpatient admission. Used in clinical documentation, UB-04 claim submission, and quality measure reporting to support appropriate care protocols, demographic analytics, and health equity assessments for inpatient populations.

admission glucoseadmn_gluc

The blood glucose level measured at the time of a patient's hospital inpatient admission, serving as a baseline clinical indicator. Used in clinical decision support, diabetes management protocols, and outcomes research to assess metabolic status on arrival and guide inpatient treatment planning.

admission group numberadmn_grp_nbr

The insurance plan group identifier associated with a patient's health coverage at the time of hospital inpatient admission. Used in eligibility verification, claims submission, and remittance reconciliation to route inpatient claims to the correct payer contract and apply appropriate group-level benefit rules.

admission hemoglobinadmn_hgb

The hemoglobin concentration measured from a blood sample collected at the time of hospital inpatient admission, establishing a baseline hematologic value. Used in clinical assessment, anemia management protocols, surgical risk stratification, and outcomes tracking throughout the inpatient stay.

admission history present illnessadmn_hpi

The structured clinical narrative documenting the onset, progression, and characteristics of the patient's current medical condition at the time of hospital inpatient admission. Used in clinical documentation, physician coding, and medical necessity review to support accurate diagnosis coding and inpatient authorization decisions.

admission identifieradmn_id

A unique alphanumeric key assigned to a hospital inpatient admission event within EHR, claims, and hospital information systems. Used by data engineers as a primary or foreign key to link clinical encounters, UB-04 claims, authorization records, and discharge disposition data across inpatient data models.

admission indexadmn_idx

A positional numeric value assigned to a hospital inpatient admission record within a sequence or array structure in EHR and claims data systems. Used by data engineers to order multiple admission events for a member, support array-based data models, and facilitate temporal sorting of inpatient episodes.

admission indicatoradmn_ind

A Boolean or coded field in claims and EHR systems that signals the presence of a qualifying inpatient hospital admission within an encounter or claim record. Used by data engineers to filter inpatient populations, trigger DRG grouping logic, and distinguish acute admissions from observation or outpatient stays.

admission instructionadmn_instr

Structured or free-text guidance associated with a hospital inpatient admission record in EHR and care management systems, detailing clinical protocols, payer requirements, or facility-specific directives. Used by data engineers to parse and route clinical decision support content within inpatient workflow and utilization management pipelines.

admission keyadmn_key

The unique surrogate or natural key value that serves as the primary identifier for a hospital inpatient admission record within a healthcare data warehouse or transactional system. Used in data integration, relational joins, and downstream reporting to uniquely resolve and link inpatient admission records across tables and systems.

admission labeladmn_lbl

The display text or tag assigned to a hospital inpatient admission record, used to categorize or identify the encounter type within clinical and administrative systems. Supports worklist management, bed tracking, and care coordination across inpatient units.

admission languageadmn_lang

The preferred spoken or written language of the patient at the time of hospital inpatient admission. Used to coordinate interpreter services, deliver appropriate patient education materials, and ensure compliance with language access requirements under federal healthcare regulations.

admission last nameadmn_last_nm

The patient's family surname as recorded at the time of hospital inpatient admission. Used for patient identification, record matching, and demographic verification across registration, billing, and clinical systems to ensure accurate association of records to the correct individual.

admission legal nameadmn_legal_nm

The patient's full official name as it appears on government-issued identification, captured at hospital inpatient admission. Used for insurance verification, consent documentation, claims submission, and identity matching to prevent duplicate or mislinked medical records.

admission leveladmn_lvl

A coded or hierarchical classification indicating the intensity or tier of care associated with a hospital inpatient admission in EHR and utilization management systems, such as ICU, step-down, or general medical. Used by data engineers to stratify inpatient records for acuity scoring, cost modeling, and resource utilization analysis.

PreviousPage 30 of 806Next