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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

United States Core Data for InteroperabilityUSCDI

A standardized health data framework defined by ONC that specifies the minimum set of data classes and elements required for nationwide interoperability. Used in EHR and HIE systems, USCDI guides data engineers in designing FHIR-compliant APIs, patient data exchange pipelines, and CMS interoperability rule compliance architectures.

Units of Serviceunit_cnt

The total count of discrete services, items, or procedures provided during a claim encounter, such as the number of X-rays taken or therapy sessions completed. Stored in the quantity field of professional and institutional claims (unit_cnt), this value is used by data engineers to calculate reimbursement, detect billing anomalies, and validate claim line accuracy.

Usual and CustomaryU&C

The prevailing market rate for a healthcare service in a specific geographic area, used by insurers and PBMs to cap reimbursement on out-of-network claims and retail pharmacy transactions. U&C pricing data is referenced in claims adjudication systems to apply payment limits, audit provider charges, and support cost benchmarking analytics.

Vial Identification CodeVIC

A unique identifier assigned to a specific pharmaceutical vial, used in pharmacy dispensing, specialty drug tracking, and serialization systems. VIC supports chain-of-custody validation, drug diversion detection, and lot-level traceability in pharmacy data pipelines, and is critical for specialty PBM and hub services data engineering workflows.

Warningwarn

Clinical decision support alert indicating a potential risk, contraindication, or threshold breach associated with a medication, diagnosis, or care pathway. Generated by EHR rules engines, PBM drug utilization review systems, and prior authorization platforms to prompt clinician review before proceeding with an order or transaction.

Weight Managementwt_mgmt

Structured clinical program or care plan addressing obesity, overweight, or metabolic health goals through diet, exercise, pharmacotherapy, or surgical intervention. Documented in EHR care plans and problem lists using ICD-10 Z-codes, and tracked in claims data for HEDIS weight assessment and counseling quality measures.

Wholesalerwhlslr

An intermediary entity in the pharmaceutical supply chain that purchases drugs from manufacturers and distributes them to pharmacies. In pharmacy and PBM systems, wholesaler identifiers (e.g., NABP, DEA) appear in drug procurement, inventory, and claims data to track drug sourcing, reimbursement calculations, and supply chain compliance.

Will-Callwill_call

A pharmacy workflow status indicating a prescription has been filled and is staged for patient pickup. In pharmacy dispensing and EHR systems, will-call queue data tracks hold duration, abandonment rates, and inventory tie-up. Data engineers use this status to monitor fulfillment cycle times and return-to-stock thresholds.

Year OldYO

A patient age descriptor used in clinical documentation, EHR systems, and member enrollment records to denote a member's age in completed years at a reference date. In claims and eligibility data, age-in-years drives risk stratification, pediatric billing rules, Medicare eligibility checks, and HEDIS age-band population segmentation logic.

acuity addressacu_addr

The physical location associated with a patient acuity classification record, such as the care unit or facility where a specific severity level assessment was conducted. Used in clinical data systems to link acuity evaluations to a treatment site for staffing and resource planning.

acuity approval statusacu_appr_sts

Indicates whether a patient acuity classification has been reviewed and authorized by a clinical supervisor or charge nurse. Tracks the workflow state of acuity assessments in inpatient settings, ensuring severity scores are validated before influencing staffing ratios or care assignments.

acuity charge amountacu_chrg_amt

The monetary charge associated with a specific patient acuity level, reflecting the cost of care resources required for that severity classification. Used in hospital billing and cost accounting systems to align nursing labor and clinical resource expenditures with patient complexity tiers.

acuity effective dateacu_eff_dt

The calendar date on which a patient acuity classification becomes active and applicable for care planning, staffing, or billing purposes. Used in clinical data systems to establish the valid timeframe of a severity assessment within an episode of care or inpatient stay.

acuity group numberacu_grp_nbr

A numeric identifier that associates a patient acuity record with a defined clinical or administrative grouping, such as a care unit cohort or staffing tier. Used in hospital management systems to aggregate acuity scores across patient populations for workload balancing and reporting.

acuity medical record numberacu_mrn

The unique patient medical record number linked to an acuity classification entry, enabling the severity assessment to be attributed to a specific individual's longitudinal health record. Used to join acuity data with clinical encounters, diagnoses, and care plans in hospital data systems.

acuity scheduled dateacu_sched_dt

The calendar date on which a patient acuity assessment is planned to occur, used in clinical scheduling systems to coordinate severity evaluations with nursing workflows. Supports proactive staffing decisions by anticipating when acuity scores will be recorded or updated.

acuity scheduled timeacu_sched_tm

The specific time of day at which a patient acuity assessment is planned, used alongside the scheduled date to coordinate clinical staff availability. Supports nursing workflow management in inpatient settings by aligning severity evaluations with shift schedules and care rounds.

acuity street addressacu_st_addr

The street-level physical address of the facility or care unit where a patient acuity assessment is recorded or administered. Used in clinical data systems to precisely identify the location associated with a severity classification for operational reporting and resource allocation purposes.

acuity unitacu_unt

The hospital unit or clinical department where a patient acuity classification is assigned, such as an ICU, step-down, or medical-surgical unit. Used in staffing and care management systems to tie severity scores to specific care environments for nurse-to-patient ratio planning.

address active indicatoraddr_actv_ind

A flag indicating whether a recorded address is currently valid and in use for a member, patient, or provider contact record. Used in enrollment and claims systems to determine which address should be used for correspondence, claims adjudication, eligibility verification, and care coordination outreach.

PreviousPage 7 of 325Next