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

bill rangebill_rng

The minimum and maximum allowable charge amounts associated with a billing statement for a healthcare service. Used in claims adjudication to validate that submitted charges fall within acceptable bounds before processing payment or applying contractual adjustments.

bill resultbill_rslt

The final outcome of a billing statement after processing, such as paid, denied, adjusted, or pending. Captured in claims management systems to track the disposition of submitted charges and support accounts receivable reconciliation and revenue cycle reporting.

bill routebill_rte

The transmission pathway used to submit a billing statement to a payer, such as electronic clearinghouse, direct payer portal, or paper submission. Determines how claims data flows from the billing system to the payer for adjudication and reimbursement.

bill strengthbill_str

The concentration or dosage strength of a drug item appearing on a pharmacy or medical billing statement. Used in pharmacy billing and itemized hospital charge capture to accurately identify the specific drug formulation billed and support clinical and financial audit validation.

bill surgery datebill_surg_dt

The calendar date on which a surgical procedure was performed, as recorded on the associated billing statement. Used in claims processing to validate procedure timing, apply correct reimbursement rates, and ensure compliance with payer authorization and medical necessity requirements.

capacity active indicatorcap_actv_ind

A binary flag indicating whether a defined capacity limit, such as a bed count, staffing threshold, or service slot maximum, is currently in effect. Used in facility management and utilization tracking systems to filter active versus inactive capacity configurations for operational reporting.

capacity active statuscap_actv_sts

The current operational state of a defined healthcare capacity limit, such as active, suspended, or retired. Used in bed management, staffing, and service utilization systems to determine which capacity records should be applied in real-time census tracking and resource allocation workflows.

capacity admission datecap_admn_dt

The date on which a patient was admitted relative to a specific facility or unit capacity record. Used in inpatient census and bed management systems to associate patient intake events with capacity tracking periods and measure occupancy against defined maximum volume thresholds.

capacity discharge datecap_dsch_dt

The date on which a patient was discharged from a facility or unit in relation to a capacity tracking record. Used in bed management and utilization systems to close capacity allocation periods, calculate length of stay, and update real-time occupancy against defined maximum volume limits.

capacity durationcap_dur

The total length of time a capacity limit, such as a bed block, service slot reservation, or staffing ceiling, remains in effect. Used in facility scheduling and resource management systems to define the active window of a capacity constraint for census planning and utilization analysis.

capacity emergency indicatorcap_emerg_ind

A flag denoting whether a capacity record is associated with an emergency or urgent care designation, such as surge capacity activation or emergency bed allocation. Used in facility management systems to distinguish standard capacity from emergency-triggered capacity expansions during high-census or disaster events.

capacity history present illnesscap_hpi

The clinical narrative describing the history of present illness recorded in the context of a capacity management encounter. Used in inpatient and emergency department systems to document patient condition at the time of admission and link clinical context to bed assignment and capacity utilization records.

capacity instructioncap_instr

Operational or clinical instructions associated with a specific capacity limit or resource allocation record, such as bed assignment protocols or unit-specific intake guidelines. Used in facility management systems to guide staff actions when a capacity threshold is reached or a new allocation is activated.

capacity labelcap_lbl

A human-readable display name or identifier assigned to a capacity record, such as a unit name, bed type designation, or service line label. Used in bed management dashboards and facility reporting tools to distinguish and present capacity configurations clearly across operational and administrative views.

capacity notecap_nt

A free-text annotation attached to a capacity record documenting exceptions, special conditions, or operational context related to a facility or unit volume limit. Used in bed management and utilization tracking systems to capture qualitative information that supplements structured capacity data fields.

capacity procedure datecap_proc_dt

The date on which a clinical procedure was performed in association with a capacity management record. Used in surgical scheduling and inpatient utilization systems to link procedure events to bed or resource capacity allocations and measure the impact of procedural volume on overall facility capacity.

capacity rangecap_rng

The minimum and maximum volume thresholds defined for a specific facility, unit, or service capacity record, such as bed count floors and ceilings. Used in bed management and operational planning systems to establish acceptable occupancy bounds and trigger alerts or escalations when utilization falls outside defined limits.

capacity resultcap_rslt

The measured outcome of a capacity period, such as actual occupancy achieved, utilization rate, or whether maximum volume was reached. Used in facility management and healthcare operations analytics to evaluate how effectively capacity was used relative to defined thresholds during a specific time interval.

capacity routecap_rte

The designated pathway or workflow through which patients or resources are directed when a capacity limit is engaged, such as diversion routing, overflow unit assignment, or transfer protocols. Used in bed management and emergency operations systems to manage patient flow when primary capacity thresholds are reached.

capacity surgery datecap_surg_dt

The scheduled or performed date of a surgical procedure as recorded within a capacity planning or operating room management record. Used in surgical scheduling and facility utilization systems to align operative case volume with available capacity, track OR throughput, and manage resource allocation across surgical services.

PreviousPage 77 of 806Next