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

write off rangewo_rng

The minimum and maximum monetary limits defining the permissible scope of a write-off transaction in revenue cycle management. Used to enforce financial controls, ensuring that write-off amounts fall within approved thresholds before authorization is granted by billing supervisors.

write off resultwo_rslt

The outcome recorded after a write-off transaction is processed against an uncollectible balance, indicating whether the adjustment was successfully applied, denied, or pended in the revenue cycle system. Used for reconciliation and financial close reporting in healthcare billing.

write off routewo_rte

The designated workflow path or approval channel through which a write-off request for an uncollectible balance is directed in revenue cycle management. Defines whether the adjustment routes through supervisor review, automated rules engine, or payer dispute resolution before posting.

write off surgery datewo_surg_dt

The date of a surgical procedure associated with a claim balance that has been identified as uncollectible and subject to write-off in the revenue cycle system. Used to link the financial adjustment back to the originating clinical encounter for audit trail and denial analysis purposes.

xray active indicatorxr_actv_ind

A boolean flag in radiology or EHR systems indicating whether an X-ray order, image record, or imaging protocol is currently active and available for clinical use. Used to filter valid records from historical or deprecated entries during diagnostic imaging workflows and reporting.

xray active statusxr_actv_sts

A coded value representing the current operational state of an X-ray record, order, or imaging study within radiology information systems. Status values may include active, completed, cancelled, or suspended, supporting radiology workflow management and imaging order tracking.

xray admission datexr_admn_dt

The date a patient was admitted to a facility in association with an X-ray imaging encounter or inpatient radiology order. Used in radiology information systems to link imaging studies to the corresponding inpatient stay for clinical documentation and claims billing purposes.

xray agexr_age

The patient's age at the time an X-ray imaging study was performed, recorded in radiology information systems to support clinical interpretation, dosage calculations, and population-level imaging utilization analytics across age-stratified patient cohorts.

xray allowed amountxr_alwd_amt

The maximum reimbursable dollar amount a payer has contractually agreed to pay for an X-ray imaging service, as determined by fee schedules or negotiated rates. Used in claims adjudication and radiology revenue cycle reporting to calculate contractual adjustments and patient cost-sharing obligations.

xray amountxr_amt

The total monetary value associated with an X-ray imaging service, representing either the charged, allowed, paid, or patient-responsibility amount depending on context within the revenue cycle. Used in radiology billing systems for claims submission, payment posting, and financial reconciliation.

xray approved byxr_appr_by

The name or identifier of the clinician, radiologist, or authorized user who approved an X-ray order, imaging protocol, or study result within the radiology information system. Supports clinical accountability, order verification workflows, and regulatory compliance documentation for diagnostic imaging.

xray arrival timexr_arrv_tm

The time a patient arrived in the radiology department or imaging suite for an X-ray procedure. Captured in radiology information systems to measure wait times, support operational throughput analysis, and track compliance with imaging turnaround time benchmarks.

xray arrived datexr_arrv_dt

The calendar date a patient arrived at the radiology department or imaging facility for an X-ray study. Used in radiology scheduling and workflow systems to reconcile appointment records, track no-shows, and report imaging department utilization and access metrics.

xray assessmentxr_asmt

The radiologist's or ordering clinician's clinical evaluation narrative associated with an X-ray imaging study, summarizing findings, impressions, and diagnostic conclusions. Stored in radiology information or EHR systems as part of the formal diagnostic report linked to the imaging encounter.

xray balancexr_bal

The remaining unpaid dollar amount owed on an X-ray imaging service after insurance payments and adjustments have been applied. Tracked in radiology billing and revenue cycle systems to manage patient statements, collections activity, and outstanding accounts receivable for diagnostic imaging services.

xray billed amountxr_bill_amt

The total charges submitted to a payer or patient for an X-ray imaging service, reflecting the facility's standard fee schedule before contractual adjustments or payments are applied. Used in radiology claims processing, revenue cycle reporting, and payer contract performance analysis.

xray birth datexr_birth_dt

The patient's date of birth associated with an x-ray imaging record. Used in radiology information systems to verify patient identity, calculate age-appropriate radiation dosing protocols, and match imaging studies to the correct patient demographic record.

xray blood pressurexr_bp

The patient's arterial blood pressure measurement recorded at the time of an x-ray imaging encounter. Captured in radiology workflows to document pre-procedure vitals, assess patient stability, and support clinical decision-making for contrast administration or procedural safety screening.

xray cancelled datexr_cncl_dt

The date on which a scheduled x-ray imaging order or appointment was cancelled. Used in radiology information systems to track order lifecycle, measure cancellation rates, analyze operational efficiency, and support downstream billing adjustments for unfulfilled imaging requests.

xray categoryxr_cat

The classification grouping assigned to an x-ray imaging study, such as chest, skeletal, or abdominal. Used in radiology information systems to organize imaging orders by anatomical region or clinical purpose, supporting workflow routing, reporting, and utilization analysis across imaging departments.

PreviousPage 799 of 806Next