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

Pharmacy

NDC codes, dispensing, PBM, RxNorm and formulary management

1,921 pharmacy terms

pharmacist modified byphrm_mod_by

Identifies the user who last updated a pharmacist record in the pharmacy management system. Captures the username or system ID of the individual who made changes, supporting audit trails and accountability in medication dispensing and clinical workflow documentation.

pharmacist modified datephrm_mod_dt

Timestamp recording the most recent update to a pharmacist's record in EHR, PBM, or pharmacy management systems. Data engineers use this field to drive incremental ETL loads, detect record changes, and maintain synchronization across provider directories and credentialing platforms.

pharmacist modified timephrm_mod_tm

Records the exact timestamp when a pharmacist record was last updated in the pharmacy management system. Used in audit logging to track when changes occurred to pharmacist credentials, assignments, or clinical documentation, supporting data integrity and compliance requirements.

pharmacist namephrm_nm

Full or formatted name of a licensed pharmacist stored in EHR, PBM, provider directory, or pharmacy management systems. Used by data engineers for record linkage, display label generation, and fuzzy matching when deduplicating pharmacist entities across credentialing and claims data sources.

pharmacist notephrm_nt

Free-text annotation field in EHR, PBM, or pharmacy management systems capturing clinical observations, dispensing exceptions, or patient counseling details documented by a pharmacist. Data engineers use this field for NLP processing, audit documentation, and clinical quality measure derivation.

pharmacist numberphrm_nbr

Numeric reference value assigned to a licensed pharmacist in PBM, claims, or pharmacy management systems, such as a state license number or internal employee ID. Data engineers use this field for cross-system record matching, regulatory reporting, and pharmacist-level claims attribution analysis.

pharmacist onset datephrm_onset_dt

Captures the date a pharmacist first documented or identified a patient condition, drug interaction, or medication-related problem during a clinical review. Used in pharmacy intervention tracking to establish the timeline of identified medication therapy issues requiring intervention or follow-up.

pharmacist oxygen saturationphrm_o2sat

Records the peripheral oxygen saturation percentage documented by a pharmacist during a medication therapy management (MTM) encounter or clinical consultation. Used to assess patient respiratory status when evaluating appropriateness of respiratory medications or monitoring treatment response.

pharmacist paid amountphrm_pd_amt

Represents the reimbursement amount paid to a pharmacist or pharmacy for dispensing services, medication therapy management consultations, or clinical interventions. Used in pharmacy billing and claims adjudication to track actual payment values against submitted claim amounts.

pharmacist paid datephrm_pd_dt

Records the date on which reimbursement was issued to a pharmacist or pharmacy for dispensed medications or clinical services rendered. Used in pharmacy claims processing and accounts receivable reconciliation to confirm payment completion and track reimbursement cycle times.

pharmacist parentphrm_prnt

Hierarchical relationship linking a pharmacist record to its superior organizational or provider entity in EHR and PBM systems. Used by data engineers to resolve provider hierarchy chains, enabling rollup reporting across pharmacy networks and multi-location dispensing organizations.

pharmacist percentagephrm_pct

Numeric ratio associated with a licensed pharmacist in PBM, claims, or EHR systems, representing metrics such as dispensing fee split, network participation rate, or medication adherence score. Critical for data engineers calculating performance benchmarks and reimbursement allocations across pharmacy provider records.

pharmacist periodphrm_prd

Defined time span associated with a licensed pharmacist's activity, credentialing window, or contract term in EHR, PBM, and provider roster systems. Data engineers use this field to apply effective-date logic, manage slowly changing dimensions, and filter active pharmacist records within temporal reporting boundaries.

pharmacist phonephrm_ph

Telephone contact number for a licensed pharmacist stored in provider master files, EHR systems, and pharmacy benefit management platforms. Data engineers use this field for provider directory validation, deduplication of pharmacist records, and ensuring accurate contact data in member-facing and claims routing workflows.

pharmacist planphrm_pln

Contains the pharmacist-authored treatment plan narrative developed during a medication therapy management (MTM) session or clinical consultation. Documents recommended medication adjustments, adherence strategies, or therapeutic interventions to optimize patient drug therapy outcomes.

pharmacist policy numberphrm_pol_nbr

Stores the insurance policy identifier associated with a pharmacist's professional liability or malpractice coverage. Used in credentialing and provider enrollment to verify active insurance coverage and ensure compliance with pharmacy practice and payer contracting requirements.

pharmacist preferred namephrm_pref_nm

Records the preferred display name of a licensed pharmacist as used in clinical communications, prescription labels, and patient-facing documentation. Supports accurate identification in pharmacy systems where a pharmacist's legal name differs from their commonly used professional name.

pharmacist pricephrm_prc

Represents the charge amount set by a pharmacist or pharmacy for dispensed medications or clinical pharmacy services rendered. Used in pharmacy billing systems to establish the billed rate prior to insurance adjudication, copay application, or contractual discount calculations.

pharmacist primary indicatorphrm_prim_ind

A flag designating whether a pharmacist is the primary dispensing or clinical pharmacist of record for a patient, prescription, or pharmacy location. Used in pharmacy management systems to route clinical responsibilities, prescription verification duties, and patient care accountabilities appropriately.

pharmacist priorityphrm_prty

Importance or precedence ranking assigned to a pharmacist record in PBM routing, prior authorization workflows, or EHR care team configurations. Data engineers rely on this field to determine processing order when multiple pharmacist records exist for a member or claim, ensuring correct provider assignment logic.

PreviousPage 66 of 97Next