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

result urgencyrslt_urg

A coded indicator reflecting the clinical priority or time-sensitivity assigned to a diagnostic or laboratory result, such as routine, urgent, or stat. Used in laboratory and clinical order management systems to drive result routing, notification workflows, and turnaround time tracking based on the patient's clinical need.

result valuerslt_val

Stores the actual measured or observed data point returned by a diagnostic test or procedure in LIS, EHR, and clinical data warehouse systems. rslt_val is the core field data engineers use for clinical analytics, reference range comparison, abnormal flagging, and population health reporting pipelines.

result versionrslt_ver

A numeric or alphanumeric value identifying the iteration of a clinical or diagnostic result record, used to distinguish original results from subsequent amendments or corrections. Used in laboratory and clinical data systems to maintain a complete audit history and ensure downstream consumers reference the most current result.

result ziprslt_zip

The postal ZIP code associated with the location linked to a clinical or diagnostic result record, such as the specimen collection site or reporting facility. Used in laboratory and clinical data systems to support geographic analysis, result routing, and location-based reporting across regional or national health networks.

review admission datervw_admn_dt

Records the inpatient or observation admission date associated with a clinical utilization or quality review assessment in EHR, case management, and claims systems. rvw_admn_dt is used by data engineers to align review records with encounter data for UM, peer review, and retrospective clinical audit workflows.

review discharge datervw_dsch_dt

Captures the inpatient discharge date linked to a utilization management or clinical quality review assessment in EHR, case management, and claims systems. rvw_dsch_dt enables data engineers to calculate length-of-stay metrics, link review outcomes to claims, and support retrospective audit and UM reporting pipelines.

review emergency indicatorrvw_emerg_ind

A flag indicating whether a clinical review or utilization management assessment has been designated as an emergency case requiring expedited evaluation. Used in care management and utilization review systems to trigger priority workflows, ensure regulatory compliance with emergency authorization timelines, and prioritize clinical decision-making resources.

review history present illnessrvw_hpi

A structured narrative documenting the chronological progression and current status of a patient's chief complaint at the time of a clinical review or assessment. Used in utilization management and clinical documentation systems to provide reviewers with the contextual illness history necessary to support medical necessity determinations.

review labelrvw_lbl

A short descriptive text string used to identify or categorize a clinical review or utilization management assessment within a healthcare data system. Used in care management platforms to display human-readable review identifiers that distinguish case types, review categories, or workflow stages in reporting and user interfaces.

review procedure datervw_proc_dt

The date on which a clinical procedure under review was performed or is scheduled to be performed, recorded as part of a utilization management or quality review assessment. Used in prior authorization and retrospective review systems to validate procedure timing against clinical criteria and payer authorization requirements.

review rangervw_rng

Defines the minimum and maximum value boundaries applied during a clinical or utilization management evaluation assessment in EHR and quality management systems. rvw_rng is used by data engineers to validate result thresholds, flag out-of-range findings, and configure acceptable limits in clinical review and audit pipelines.

review resultrvw_rslt

Stores the final outcome or determination produced by a clinical, utilization management, or quality review assessment in EHR, case management, and payer systems. rvw_rslt is used by data engineers to track approval, denial, or modification decisions and feed downstream authorization and quality reporting workflows.

review surgery datervw_surg_dt

The date on which a surgical procedure subject to clinical review was performed or is planned, captured within a utilization management or quality assessment record. Used in prior authorization and surgical review systems to evaluate procedural timing, coordinate pre-surgical approvals, and support post-operative outcome tracking.

rheumatology active indicatorrheum_actv_ind

A flag identifying whether a rheumatology-related record, program, or clinical designation is currently active within a healthcare data system. Used in specialty care and chronic disease management platforms to filter active autoimmune and musculoskeletal condition records for reporting, patient outreach, and longitudinal care coordination workflows.

rheumatology active statusrheum_actv_sts

Indicates whether a patient's rheumatology case, treatment plan, or care episode is currently active or inactive. Used in clinical data systems to filter ongoing autoimmune and musculoskeletal disease management cases, such as rheumatoid arthritis or lupus, from resolved or closed encounters.

rheumatology admission daterheum_admn_dt

The calendar date on which a patient was formally admitted to a rheumatology inpatient unit or specialty service for treatment of autoimmune or musculoskeletal conditions such as rheumatoid arthritis, lupus, or vasculitis. Used in hospital clinical systems to calculate length of stay and coordinate specialist care.

rheumatology agerheum_age

The patient's age in years at the time of a rheumatology encounter, diagnosis, or treatment event. Used in clinical analytics to stratify autoimmune and musculoskeletal disease populations, assess age-related disease onset patterns, and support risk-adjusted reporting for conditions like rheumatoid arthritis or osteoarthritis.

rheumatology allowed amountrheum_alwd_amt

The maximum dollar amount a payer will reimburse for rheumatology specialty services, including infusion therapies, joint injections, or biologic administration, as defined by the contracted fee schedule. Used in claims processing to determine payment after applying deductibles, copays, and coordination of benefits.

rheumatology amountrheum_amt

A general monetary value associated with a rheumatology financial transaction, which may represent charges, payments, or adjustments related to specialty services such as biologic drug administration, joint procedures, or autoimmune disease management visits recorded in claims or billing systems.

rheumatology approval statusrheum_appr_sts

Indicates the current authorization or prior approval state for a rheumatology service, procedure, or specialty medication such as a biologic or DMARD therapy. Used in utilization management workflows to confirm whether payer authorization has been requested, approved, denied, or is pending review.

PreviousPage 582 of 806Next