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,390 operations terms

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.

address active statusaddr_actv_sts

A status value indicating the current operational state of an address record within a healthcare data system, such as active, inactive, or pending verification. Used in member enrollment, provider directories, and claims processing to control which address records are eligible for use in transactions.

address addressaddr_addr

The full text of a physical or mailing address stored within an address record entity, capturing the complete location string for a member, patient, or contact. Used in enrollment, claims, and care management systems to support correspondence, eligibility verification, and service delivery coordination.

address ageaddr_age

The calculated duration, typically in days or months, that an address record has been on file within a healthcare data system. Used in member enrollment and data quality workflows to identify stale or potentially outdated address entries that may require reverification or member outreach.

PreviousPage 7 of 320Next