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 periodadmn_prd

The defined time span encompassing the start and end dates of a hospital inpatient stay in EHR, claims, and utilization management systems. Used by data engineers to construct inpatient episode windows, validate claim date ranges against authorization periods, and support length-of-stay and readmission interval calculations.

admission phoneadmn_ph

The telephone number captured during hospital inpatient registration and stored in EHR and patient administration systems, associated with the patient or responsible party for the admission. Used by data engineers to support identity resolution, care coordination outreach matching, and contact data quality validation in inpatient demographic pipelines.

admission planadmn_pln

The documented clinical treatment strategy or care plan established at the time of hospital inpatient admission, outlining intended interventions, goals, and anticipated course of care. Used by clinical teams to guide inpatient management and communicate care objectives across disciplines.

admission policy numberadmn_pol_nbr

The insurance policy identifier associated with the patient's coverage at the time of hospital inpatient admission. Used during eligibility verification, prior authorization, and claims submission to accurately identify the applicable health plan and coordinate benefits with payers.

admission preferred nameadmn_pref_nm

The patient's preferred display name recorded at the time of hospital inpatient admission. Captures chosen name or alias distinct from legal name, supporting patient identity preferences in clinical documentation, wristbands, and communication throughout the inpatient stay.

admission priceadmn_prc

The billed or estimated cost associated with a hospital inpatient admission event. Used in revenue cycle management to capture charges at the admission level, supporting financial reporting, cost analysis, and reconciliation against insurance reimbursements and payer contracts.

admission primary indicatoradmn_prim_ind

A flag identifying whether a hospital inpatient admission record is the primary or principal encounter among multiple concurrent or related admissions. Used in clinical data systems to distinguish the main admission driving care decisions, billing, and discharge planning workflows.

admission priorityadmn_prty

Ranking that determines urgency of hospital inpatient admission, typically coded as emergent, urgent, or elective in UB-04 claims (field 14). Used in EHR and inpatient claims processing to drive bed assignment, resource allocation, and case management workflows.

admission procedure dateadmn_proc_dt

The calendar date on which a clinical procedure was performed during a hospital inpatient admission. Used in medical records and claims processing to sequence care events, validate billing timelines, support quality reporting, and reconcile procedure codes against encounter dates.

admission pulseadmn_pulse

The patient's heart rate, measured in beats per minute, recorded at the time of hospital inpatient admission. Captured as a baseline vital sign in clinical documentation to assess cardiovascular status, triage acuity, and establish reference values for monitoring during the inpatient stay.

admission quantityadmn_qty

Numeric count of inpatient admissions within a defined population, time period, or facility in hospital claims and EHR systems. Used by analytics platforms and utilization management tools to measure inpatient volume, benchmark performance, and calculate per-member admission rates.

admission raceadmn_race

The patient's self-reported racial identity recorded at the time of hospital inpatient admission. Collected to support health equity reporting, population health analytics, regulatory compliance under CMS and NCQA standards, and identification of disparities in inpatient care access and outcomes.

admission rangeadmn_rng

The minimum and maximum boundary values applied to inpatient admission metrics such as length of stay, acuity scores, or admit dates in EHR and claims data systems. Used in population health analytics and reporting tools to filter, segment, and validate inpatient admission datasets.

admission rateadmn_rt

The frequency of inpatient hospital admissions per unit of population or member months, calculated in claims and EHR analytics platforms. Used by payers and health plans to measure utilization, compare against benchmarks, and assess care management program effectiveness across member populations.

admission ratingadmn_rtg

A scored assessment value assigned to a hospital inpatient admission, such as severity rating, acuity score, or quality rating. Used in clinical decision support, case management prioritization, utilization management, and benchmarking inpatient outcomes against peer institutions and national standards.

admission ratioadmn_ratio

A calculated proportional value associated with a hospital inpatient admission, such as nurse-to-patient ratio or observed-to-expected outcome ratio. Used in operational reporting, staffing analysis, quality measurement, and comparative effectiveness studies across inpatient care settings.

admission reasonadmn_rsn

Coded or free-text explanation documenting the clinical justification for a hospital inpatient admission, often derived from ICD-10 principal diagnosis codes in UB-04 claims or EHR encounter records. Used by utilization review, case management, and quality reporting systems to validate medical necessity.

admission received dateadmn_rcvd_dt

The date on which a hospital inpatient admission request, referral, or notification was received by the facility. Used in utilization management and care coordination workflows to measure pre-admission processing time, authorization timeliness, and compliance with payer notification requirements.

admission referenceadmn_ref

A unique identifier or external pointer linking an inpatient hospital admission record to related documents such as prior authorization numbers, referral IDs, or source encounter records in EHR and claims systems. Used to maintain data lineage and support cross-system reconciliation of inpatient episodes.

admission resolution dateadmn_resol_dt

The date on which the primary condition or issue driving a hospital inpatient admission was resolved or concluded. Used in clinical data analysis to calculate condition duration, measure treatment effectiveness, support discharge planning workflows, and report episode-of-care timelines.

PreviousPage 32 of 806Next