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

policy labelpol_lbl

The human-readable name or descriptive identifier assigned to an insurance policy record. Used across member communications, explanation of benefits documents, eligibility verification transactions, and internal reporting to clearly distinguish individual policy agreements within an insurer's book of business.

policy procedure datepol_proc_dt

Records the date on which a covered clinical procedure is performed or scheduled under a specific insurance policy. Used in claims adjudication, prior authorization processing, and coverage validation workflows to confirm the procedure date aligns with the active policy coverage period.

policy rangepol_rng

The minimum and maximum value boundaries governing a specific coverage rule or benefit within an insurance policy. Used in claims adjudication and PBM systems to enforce deductible thresholds, out-of-pocket limits, and dosage ranges applicable to covered services.

policy resultpol_rslt

The outcome or determination produced by applying a policy rule during claims adjudication, prior authorization, or eligibility verification. Captured in payer, EHR, and clearinghouse systems to record approval, denial, pend, or modification decisions for downstream processing and member communication.

policy surgery datepol_surg_dt

Records the date on which a surgical procedure is performed or scheduled under an insurance policy. Used during claims adjudication, pre-authorization review, and surgical case management to validate that the operative service date falls within the active coverage window of the policy.

practitioner admission dateprac_admn_dt

Records the date on which a licensed healthcare practitioner was formally admitted as an inpatient to a facility. Used in clinical and administrative workflows to calculate length of stay, coordinate care transitions, and support billing when the practitioner is themselves receiving inpatient treatment.

practitioner blood pressureprac_bp

Records the systolic and diastolic arterial blood pressure values measured for a licensed healthcare practitioner receiving clinical care. Captured as part of vital sign documentation when the practitioner is the patient, supporting clinical assessment, chronic disease monitoring, and longitudinal health management.

practitioner creatinineprac_cr

Records the serum or plasma creatinine laboratory result for a licensed healthcare practitioner receiving clinical care. Used to assess renal function, calculate estimated GFR, guide medication dosing decisions, and monitor kidney health within the practitioner's own longitudinal clinical record.

practitioner discharge dateprac_dsch_dt

Records the date on which a licensed healthcare practitioner was formally discharged from an inpatient facility following their own treatment. Used to calculate length of stay, finalize clinical documentation, support billing workflows, and coordinate post-discharge follow-up care for the practitioner as patient.

practitioner glucoseprac_gluc

Records the blood glucose concentration measured for a licensed healthcare practitioner receiving clinical care. Captured in laboratory or point-of-care testing contexts when the practitioner is the patient, supporting diabetes management, metabolic monitoring, and clinical decision-making within their own health record.

practitioner hemoglobinprac_hgb

Records the hemoglobin concentration from a complete blood count or hemoglobin-specific test for a licensed healthcare practitioner receiving care. Used to assess anemia status, oxygen-carrying capacity, and overall hematological health when the practitioner is themselves the patient in a clinical encounter.

practitioner labelprac_lbl

The human-readable display name or descriptive identifier assigned to a licensed healthcare practitioner record. Used across clinical systems, provider directories, credentialing platforms, and claims data to consistently identify and distinguish individual practitioners in administrative and clinical workflows.

practitioner oxygen saturationprac_o2sat

Records the peripheral oxygen saturation (SpO2) measurement documented for the treating practitioner during a clinical encounter or procedure. Used in clinical data systems to capture vital sign baselines for healthcare workers in occupational health or pre-procedure assessments.

practitioner procedure dateprac_proc_dt

The calendar date on which a licensed practitioner performed a specific clinical procedure. Used in clinical and claims data systems to establish the timeline of care delivery, support billing accuracy, and link practitioner activity to encounter records and service authorizations.

practitioner pulseprac_pulse

Records the heart rate measurement in beats per minute documented for the treating practitioner, typically captured in occupational health or pre-procedure screening contexts. Used in clinical data systems to track practitioner vital signs and support fitness-for-duty assessments.

practitioner respirationprac_resp

Records the respiratory rate measurement in breaths per minute documented for the treating practitioner, typically in occupational health or pre-procedure screening contexts. Used in clinical data systems to track practitioner vital signs and support workplace health monitoring programs.

practitioner surgery dateprac_surg_dt

The calendar date on which a licensed practitioner performed a surgical procedure. Used in clinical and claims data systems to establish operative timelines, support surgical billing and coding accuracy, and link the performing practitioner to specific operative events within encounter records.

precertification admission dateprecert_admn_dt

The anticipated or approved inpatient admission date associated with a pre-service authorization request. Captured in utilization management and EHR systems to validate that actual admission aligns with payer-approved dates, preventing claim denials and ensuring concurrent review triggers fire correctly.

precertification discharge dateprecert_dsch_dt

The anticipated or approved inpatient discharge date recorded within a pre-service authorization. Used in utilization management platforms and claims systems to validate length-of-stay against payer-approved parameters, triggering extension requests when actual discharge extends beyond the precertified end date.

precertification emergency indicatorprecert_emerg_ind

A flag designating whether a precertification request was initiated under emergency circumstances, bypassing standard prior authorization timelines. Used in utilization management systems to route urgent requests appropriately, ensure regulatory compliance, and track retrospective authorization for emergent care episodes.

PreviousPage 506 of 806Next