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

stay effective datestay_eff_dt

The date on which coverage, authorization, or a benefit period becomes active for a patient's inpatient stay, establishing the start of applicable insurance or utilization management eligibility. Used in claims adjudication to validate that inpatient services fall within an authorized or covered period.

stay group numberstay_grp_nbr

The health insurance group plan identifier associated with a patient's inpatient stay, linking the hospitalization to the employer or sponsor group plan responsible for coverage. Used in inpatient claims processing and eligibility verification to determine applicable benefits and coordination of benefits rules.

stay medical record numberstay_mrn

The unique medical record number assigned to a patient in the context of an inpatient stay, linking clinical documentation, orders, and diagnoses to the specific hospitalization episode. Used in health information management and inpatient claims processing to ensure accurate patient identity matching.

stay scheduled datestay_sched_dt

The planned admission or procedure date for a patient's inpatient stay, recorded at the time of pre-registration or surgical scheduling. Used in hospital operations and utilization management to coordinate bed assignments, pre-authorization submission, and resource planning prior to the actual admission.

stay scheduled timestay_sched_tm

The planned time of day for a patient's inpatient admission or procedure within a scheduled stay, used in hospital operations to coordinate clinical staffing, operating room scheduling, and bed management workflows in advance of the patient's actual arrival or procedure start.

stay street addressstay_st_addr

The physical street address associated with an inpatient hospital stay, typically capturing the facility location where care was delivered. Used in claims processing and utilization reporting to identify and validate the site of inpatient service for billing and auditing purposes.

stay unitstay_unt

The unit of measure applied to an inpatient stay, such as days or hours, used to quantify the duration of the inpatient episode. Critical for inpatient claims adjudication, length-of-stay analysis, and DRG-based reimbursement calculations in hospital billing systems.

step therapy requirement flagstep_thrpy_req_flg

A flag indicating that a specific drug or service requires the member to try and fail one or more preferred alternatives before the payer will cover the requested treatment. Step therapy requirements are used in utilization management to drive cost-effective prescribing patterns and are subject to state and federal override requirements when clinically indicated.

strength addressstr_addr

The physical location associated with a specific drug strength record in a pharmacy or formulary system. Used to link drug concentration data to a dispensing facility or compounding location for inventory management, drug master file maintenance, and pharmacy claims processing.

strength approval statusstr_appr_sts

Indicates the regulatory or formulary approval state of a specific drug strength, such as approved, pending, or discontinued. Used in pharmacy benefit management and formulary administration to determine whether a drug concentration is eligible for dispensing or reimbursement.

strength charge amountstr_chrg_amt

The monetary charge associated with a specific drug strength at the time of dispensing or billing. Captured in pharmacy claims and drug master records to support pricing validation, cost analysis, and reimbursement calculations based on drug concentration and quantity dispensed.

strength effective datestr_eff_dt

The date on which a specific drug strength became active within a formulary, drug master file, or pharmacy benefit system. Used to manage formulary lifecycle changes, pricing updates, and eligibility for reimbursement based on the concentration and formulation of a medication.

strength group numberstr_grp_nbr

A grouping identifier assigned to a specific drug strength within a pharmacy or formulary system. Used to associate related drug concentrations under a common therapeutic category, formulary tier, or drug family for benefit management, reporting, and formulary decision support.

strength medical record numberstr_mrn

The patient medical record number linked to a specific drug strength record, associating a prescribed or dispensed medication concentration to an individual patient. Used in pharmacy and clinical data systems to maintain an accurate medication history and support medication reconciliation.

strength scheduled datestr_sched_dt

The date on which administration or dispensing of a specific drug strength is planned or scheduled. Used in medication management systems and pharmacy workflows to coordinate medication preparation, administration timing, and adherence monitoring for a prescribed drug concentration.

strength scheduled timestr_sched_tm

The planned time of day for the administration or dispensing of a specific drug strength. Used in inpatient medication administration records and pharmacy systems to schedule and track dosing events, ensuring accurate timing for drug concentration delivery and clinical compliance.

strength street addressstr_st_addr

The street-level address associated with a drug strength record, identifying the specific facility or location where a medication of a given concentration is stocked, compounded, or dispensed. Used in pharmacy data management for site-level drug tracking and regulatory compliance reporting.

strength unitstr_unt

The unit of measure that quantifies a drug's concentration, such as mg, mcg, or mg/mL. Used in pharmacy systems, drug master files, and medication administration records to standardize drug strength representation, support clinical dosing decisions, and ensure accurate pharmacy claims adjudication.

study addressstdy_addr

The physical location associated with a diagnostic imaging study, identifying the facility or department where the examination was performed. Used in radiology information systems and imaging claims to link study records to a specific site for scheduling, billing, and radiology workflow management.

study approval statusstdy_appr_sts

Indicates the authorization or review state of a diagnostic imaging study, such as ordered, approved, completed, or pending radiologist interpretation. Used in radiology information systems and prior authorization workflows to track imaging study progression from order to final report.

PreviousPage 255 of 325Next