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

Provider

NPI, credentialing, taxonomy and provider networks

1,236 provider terms

physician surgery datephys_surg_dt

Date on which a licensed physician performed or is scheduled to perform a surgical procedure on a patient. Used in claims processing, operative documentation, and outcomes tracking to establish the timeline of surgical intervention and support billing accuracy.

physician system identifierphys_sys_id

Unique identifier assigned by an internal system to a licensed physician record, enabling consistent tracking across applications, claims, and clinical data sources. Used to link physician data across enrollment, credentialing, and claims platforms within a health system.

physician targetphys_tgt

A reference identifier or benchmark value representing the intended recipient, goal, or destination associated with a physician in referral workflows, care management, or performance programs in EHR and population health systems. Used by data engineers in attribution and referral pattern analysis.

physician taxonomy codephys_tax_cd

NUCC Health Care Provider Taxonomy code assigned to a licensed physician that identifies their specialty, subspecialty, and type of practice. Used in claims adjudication, provider enrollment, and network management to classify physician scope of practice.

physician temperaturephys_temp

Body temperature measurement recorded by or attributed to a licensed physician during a patient clinical encounter. Captured as a vital sign in clinical documentation systems to support diagnosis, monitor patient condition, and meet Evaluation and Management documentation standards.

physician termination datephys_term_dt

The date on which a physician's affiliation, contract, or network participation was formally ended. Used in provider roster management to determine eligibility periods, claims adjudication validity, and credentialing history within health plan and hospital systems.

physician timephys_tm

The time-of-day value associated with a physician activity such as order entry, procedure performance, or documentation in EHR and hospital information systems. Data engineers use this field for workflow latency analysis, shift-based utilization reporting, and event sequencing within encounters.

physician timestampphys_ts

The combined date and time value recording when a physician-related event occurred, such as a signature, order, or claim submission, in EHR, claims, and audit log systems. Data engineers use this field for event sequencing, regulatory audit trails, and processing latency calculations.

physician titlephys_ttl

The formal professional designation or honorific assigned to a physician, such as MD, DO, or MBBS. Used in provider directories, credentialing records, and clinical documentation to accurately identify the physician's degree and professional standing within healthcare systems.

physician totalphys_tot

The aggregate sum of charges, units, payments, or services associated with a physician across claims, encounters, or reporting periods in healthcare financial and analytics systems. Data engineers use this field for cost trend analysis, provider profiling, and value-based payment reconciliation.

physician total countphys_tot_cnt

The aggregate number of physicians associated with a given network, group practice, specialty, or geographic region. Used in workforce analytics, network adequacy reporting, and health plan contracting to assess physician availability and distribution across service areas.

physician typephys_typ

A classification code identifying the specialty, role, or licensure category of a physician, such as primary care, surgeon, or hospitalist, in EHR, claims, and provider directory systems. Data engineers use this field for network adequacy reporting, specialty-based routing, and utilization segmentation.

physician unitphys_unt

The standardized measurement unit associated with a physician service, such as RVUs, minutes, or procedure units, in claims and fee schedule systems. Data engineers use this field to normalize service volumes, validate billing quantities, and support relative value unit-based reimbursement calculations.

physician updated datephys_upd_dt

The most recent date on which a physician's record was modified in the provider database. Used in credentialing, provider roster maintenance, and audit tracking to ensure data currency and identify stale or outdated physician information in health plan and clinical systems.

physician urgencyphys_urg

A classification indicating the time-sensitivity or priority level assigned to a physician-related referral, authorization request, or clinical task. Used in utilization management and care coordination workflows to triage and route physician-initiated requests within appropriate response timeframes.

physician valuephys_val

A discrete numeric or coded data point captured for a physician in clinical, financial, or operational healthcare systems, such as a quality metric score or contracted rate. Data engineers use this field in provider analytics pipelines, benchmark comparisons, and performance dashboards.

physician versionphys_ver

A sequential number identifying the specific iteration of a physician's record in the provider database. Used in provider data management to track changes over time, support audit trails, and ensure that downstream claims and credentialing systems reference the most current record version.

physician zipphys_zip

The five or nine-digit U.S. postal code associated with a physician's primary practice or billing address. Used in provider directory maintenance, network adequacy analysis, claims routing, and geographic access reporting within health plan and credentialing systems.

plan npi numberpln_npi

The National Provider Identifier assigned to a health benefit plan entity when acting in a provider capacity under HIPAA transactions. Used in claims processing and electronic data interchange to identify the plan as a trading partner in standard 837 and 835 transaction sets.

policy npi numberpol_npi

The National Provider Identifier associated with the entity administering or underwriting an insurance policy in HIPAA-standard transactions. Used in claims adjudication and eligibility verification to identify the responsible coverage entity across electronic healthcare transactions and enrollment systems.

PreviousPage 39 of 62Next