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

requirement instructionreq_instr

Contains specific instructions or conditions attached to an approved prior authorization or clinical requirement, such as site-of-service restrictions, quantity limits, or step therapy mandates. Guides providers and members on how authorized services must be rendered or accessed.

requirement labelreq_lbl

The standardized display name or descriptive label assigned to a prior authorization requirement type within utilization management systems. Used to present requirement details consistently across member portals, provider-facing platforms, and internal care management dashboards.

requirement notereq_nt

Free-text annotation field capturing supplemental information added by utilization management staff, clinical reviewers, or systems during the evaluation or processing of a prior authorization or clinical requirement. Used to document decisions, exceptions, or communications not captured in structured fields.

requirement procedure datereq_proc_dt

Records the date on which an authorized clinical procedure is scheduled or performed in relation to a prior authorization requirement. Used during claims adjudication to verify that services were rendered within the approved authorization period and match the authorized procedure.

requirement rangereq_rng

Defines the acceptable minimum and maximum boundaries for a clinical parameter or service quantity within a prior authorization or clinical requirement. Used in utilization management to enforce approved dosage limits, visit counts, or measurable clinical thresholds tied to the authorization.

requirement resultreq_rslt

Captures the outcome or finding associated with a clinical requirement, such as lab values, diagnostic findings, or functional assessment scores submitted to support a prior authorization decision. Used by utilization reviewers to apply evidence-based criteria during medical necessity determinations.

requirement routereq_rte

Specifies the clinically required route of administration for a medication or treatment included in a prior authorization requirement, such as oral, intravenous, or subcutaneous. Used to enforce site-of-service rules and step therapy protocols during pharmacy or medical benefit review.

requirement strengthreq_str

Records the required drug concentration or dosage strength specified within a medication prior authorization requirement. Used during pharmacy benefit adjudication to validate that the dispensed medication matches the approved strength and enforce quantity limit or step therapy policies.

requirement surgery datereq_surg_dt

Captures the scheduled or actual date of a surgical procedure associated with a prior authorization requirement. Used in utilization management to confirm that surgical services were performed within the authorized window and to coordinate pre-operative and post-operative care management activities.

result active indicatorrslt_actv_ind

Binary flag identifying whether a diagnostic or laboratory test result record is currently active and valid for clinical use. Inactive results may have been superseded by amended values, duplicated, or retracted, and this indicator governs which result version is surfaced in clinical decision support and reporting.

result active statusrslt_actv_sts

Indicates the current lifecycle state of a diagnostic or laboratory test result, such as active, amended, corrected, or cancelled. Used in clinical data systems to manage result validity, control which values are visible to clinicians, and ensure accurate reporting across population health and quality programs.

result addressrslt_addr

The physical or mailing address associated with a clinical test or procedure result record in EHR, lab, and claims systems. Data engineers use this field to route result notifications, validate provider or patient location data, and support address standardization and geocoding in downstream analytics pipelines.

result adjustment amountrslt_adj_amt

Records the financial adjustment value applied to a reimbursement or payment associated with a diagnostic or laboratory result-driven service. Used in claims processing to capture contractual adjustments, recoupments, or correction amounts tied to result-based billing transactions.

result admission daterslt_admn_dt

The inpatient admission date linked to a specific clinical test or procedure result in EHR and lab systems. Data engineers use this field to associate diagnostic findings with hospital encounter records, validate result ordering timelines, and support episode-of-care attribution in clinical analytics pipelines.

result agerslt_age

Captures the patient's age at the time a diagnostic or laboratory test result was recorded. Used in clinical analytics, population health stratification, and quality measure reporting to apply age-specific reference ranges, risk scores, and screening benchmarks to result interpretation.

result allowed amountrslt_alwd_amt

The maximum dollar amount a payer will reimburse for a diagnostic test or clinical result transaction. Derived from contracted fee schedules or payer policies, this value represents the ceiling for reimbursement after adjudication and is used in financial reconciliation of laboratory and clinical result claims.

result amountrslt_amt

The monetary or numeric value representing the cost, charge, or payment associated with a clinical test or procedure result in claims and EHR systems. Data engineers use this field to reconcile lab and diagnostic billing records, calculate reimbursement amounts, and support cost analytics in value-based care platforms.

result approval statusrslt_appr_sts

The current authorization state of a clinical test result, indicating whether the result has been reviewed, approved, pending, or rejected by an authorized clinician. Used in laboratory and clinical workflows to enforce result verification protocols before results are released to ordering providers or patient records.

result approved byrslt_appr_by

The unique identifier or name of the clinician, laboratorian, or authorized user who formally reviewed and approved a clinical test result for release. Supports audit trails and chain-of-custody documentation in laboratory information systems and clinical data repositories, ensuring result integrity and accountability.

result arrival timerslt_arrv_tm

The timestamp recording when a clinical specimen, diagnostic result, or associated result data was received at the processing facility or laboratory. Used in laboratory information systems to calculate turnaround times, monitor workflow efficiency, and support time-sensitive clinical decision-making processes.

PreviousPage 574 of 806Next