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

refill discharge daterfll_dsch_dt

The inpatient discharge date recorded at the time of a prescription refill authorization in pharmacy and EHR systems. Used by data engineers to reconcile PBM refill events with hospital encounter records and validate continuity-of-care medication dispensing timelines.

refill emergency indicatorrfll_emerg_ind

A flag identifying that a prescription refill request was processed as an emergency, such as for early refill overrides or urgent supply situations. Used in pharmacy management systems to track policy exceptions, support claims adjudication, and monitor controlled substance dispensing compliance.

refill history present illnessrfll_hpi

A clinical narrative documenting the patient's current condition or symptom status at the time a prescription refill is requested. Provides clinical justification for continued medication therapy, supporting pharmacist review, prior authorization renewals, and medication management documentation in pharmacy workflows.

refill labelrfll_lbl

A descriptive identifier or display name associated with a prescription refill transaction within pharmacy management and medication dispensing systems. Used to distinguish refill events from original fills, support patient-facing medication labels, and enable accurate tracking of refill history across dispensing records.

refill procedure daterfll_proc_dt

The date on which a clinical procedure relevant to a prescription refill authorization was performed, such as a required follow-up visit or lab test. Used in pharmacy and utilization management systems to verify compliance with prescribing guidelines before dispensing ongoing medication therapy.

refill rangerfll_rng

The permissible numeric span defining minimum and maximum allowable refill quantities or intervals for a prescription renewal in PBM and pharmacy systems. Data engineers use this field to validate refill eligibility rules, detect outliers, and enforce formulary compliance thresholds.

refill resultrfll_rslt

The discrete outcome code or status value returned after processing a prescription refill request in PBM, pharmacy, or EHR systems. Values may include approved, denied, pending, or partial fill. Data engineers use this field to track refill adjudication outcomes and measure medication adherence rates.

refill surgery daterfll_surg_dt

The date of a surgical procedure associated with a prescription refill request, typically relevant for post-operative medications such as analgesics or antibiotics. Used to validate clinical appropriateness of continued dispensing, support prior authorization documentation, and audit post-surgical medication utilization.

regulation admission datereg_admn_dt

The inpatient admission date recorded in the context of a specific regulatory compliance requirement, such as state-mandated reporting for behavioral health or long-term care admissions. Used to ensure regulatory submissions accurately reflect admission timing and meet statutory reporting deadlines for applicable patient populations.

regulation discharge datereg_dsch_dt

The date a patient was discharged from an inpatient facility as recorded for regulatory compliance purposes. Used in claims and clinical data systems to satisfy mandatory reporting requirements, audit trails, and government-mandated quality or utilization benchmarks.

regulation labelreg_lbl

The human-readable display name assigned to a specific regulatory requirement or compliance rule within healthcare data systems. Used to identify and categorize applicable federal, state, or accreditation mandates governing clinical documentation, billing, or operational workflows.

regulation procedure datereg_proc_dt

The date on which a clinical procedure was performed, captured specifically to fulfill regulatory reporting obligations. Used in compliance tracking systems to validate timeliness of care delivery against government-mandated quality measures, prior authorization rules, or mandatory reporting standards.

regulation surgery datereg_surg_dt

The date on which a surgical procedure was performed, recorded to meet regulatory reporting and compliance requirements. Used in clinical and claims data systems to support mandatory surgical outcome reporting, accreditation reviews, and government quality program submissions.

reimbursement admission datereimb_admn_dt

The date a patient was admitted to an inpatient facility as recorded for insurance payment processing. Used in claims adjudication systems to determine applicable reimbursement rates, length-of-stay calculations, DRG assignments, and payer contract compliance for inpatient billing.

reimbursement discharge datereimb_dsch_dt

The date a patient was discharged from an inpatient facility as recorded for insurance payment calculation. Used in claims processing to finalize DRG-based reimbursement, length-of-stay billing periods, and payer contract terms governing inpatient episode payment.

reimbursement labelreimb_lbl

The human-readable display name assigned to a specific insurance payment type, method, or category within healthcare financial systems. Used to identify reimbursement models such as fee-for-service, capitation, or bundled payments across claims and revenue cycle workflows.

reimbursement procedure datereimb_proc_dt

The date on which a clinical procedure was performed, recorded for insurance payment processing and claims adjudication. Used in revenue cycle systems to determine timely filing compliance, apply correct fee schedule rates, and validate procedure billing against payer reimbursement rules.

reimbursement surgery datereimb_surg_dt

The date on which a surgical procedure was performed, captured for insurance payment determination and claims adjudication. Used in revenue cycle systems to apply surgical fee schedules, validate global surgery billing periods, and ensure accurate reimbursement under applicable payer contracts.

remittance admission dateremit_admn_dt

The inpatient admission date as reflected on an Electronic Remittance Advice (ERA) or Explanation of Benefits (EOB) document. Used in payment reconciliation to match payer remittance data against original claims, verify reimbursed service periods, and identify payment discrepancies.

remittance discharge dateremit_dsch_dt

The inpatient discharge date as reflected on an Electronic Remittance Advice (ERA) or Explanation of Benefits (EOB) document. Used in payment reconciliation workflows to match remittance data to original inpatient claims and verify that the correct length-of-stay period was reimbursed.

PreviousPage 572 of 806Next