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,301 provider terms

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.

practitioner account numberprac_acct_nbr

A unique internal or external reference number assigned to a licensed healthcare practitioner for billing, credentialing, or contracting purposes. Used in provider data management systems to link practitioner records across claims, enrollment, and payment reconciliation workflows.

practitioner active indicatorprac_actv_ind

A binary flag denoting whether a licensed healthcare practitioner is currently active and eligible to render or bill for services. Used in provider roster management and claims adjudication to validate practitioner participation status at the time of service or submission.

practitioner active statusprac_actv_sts

A categorical field describing the current participation or employment status of a licensed healthcare practitioner, such as active, inactive, suspended, or terminated. Used in credentialing systems, provider directories, and claims validation to determine service eligibility and network standing.

practitioner addressprac_addr

The physical or mailing address associated with a licensed healthcare practitioner's primary practice location. Used in provider directories, credentialing records, claims routing, and network adequacy reporting to establish practice location and support member access-to-care analysis.

practitioner adjustment amountprac_adj_amt

The dollar value of a financial modification applied to a practitioner's claim payment, including contractual adjustments, recoupments, or corrections. Used in claims payment reconciliation and remittance processing to reflect the difference between billed charges and the final reimbursement amount.

practitioner ageprac_age

The calculated age in years of a licensed healthcare practitioner, typically derived from date of birth. Used in workforce analytics, credentialing databases, and succession planning to assess practitioner demographics and project future provider availability within a health system or network.

practitioner allowed amountprac_alwd_amt

The maximum dollar amount a health plan will reimburse for a service rendered by a licensed practitioner, based on the contracted fee schedule or plan pricing methodology. Used in claims adjudication to calculate member cost-sharing and determine the practitioner's net payment.

practitioner amountprac_amt

The total monetary value associated with a practitioner's claim, payment transaction, or financial record within a healthcare system. Used in claims processing, provider payment reconciliation, and financial reporting to capture the gross dollar amount attributed to practitioner-level service activity.

practitioner approval statusprac_appr_sts

A field indicating the current credentialing or privileging approval state of a licensed healthcare practitioner, such as pending, approved, denied, or conditionally approved. Used in credentialing workflows and network enrollment systems to control a practitioner's eligibility to participate in a health plan or facility.

practitioner approved byprac_appr_by

The identifier or name of the individual or committee that granted credentialing, privileging, or network enrollment approval for a licensed healthcare practitioner. Used in credentialing audit trails and compliance documentation to establish accountability for provider approval decisions within health plan or facility systems.

practitioner arrival timeprac_arrv_tm

The recorded timestamp indicating when a licensed healthcare practitioner arrived at a clinical setting, such as a hospital, clinic, or patient location. Used in scheduling systems, workflow management, and operational reporting to measure practitioner punctuality, patient wait times, and care coordination efficiency.

practitioner arrived dateprac_arrv_dt

The date and time a licensed practitioner arrived at a clinical encounter location, such as a hospital unit, clinic, or patient room. Used in scheduling, staffing, and care coordination systems to track provider punctuality and response times across care settings.

practitioner assessmentprac_asmt

The structured or free-text clinical evaluation documented by a licensed practitioner during a patient encounter. Captures the provider's diagnostic impressions, findings, and clinical reasoning, forming a critical component of the SOAP note within EHR encounter documentation.

practitioner balanceprac_bal

The outstanding financial amount remaining on a practitioner-associated account or claim after payments, adjustments, and credits have been applied. Used in medical billing and revenue cycle management to track unresolved practitioner billing balances.

PreviousPage 41 of 66Next