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,993 pharmacy terms

pharmacist active indicatorphrm_actv_ind

Binary flag indicating whether a licensed pharmacist is currently active within the pharmacy network or credentialing system. Used in pharmacy benefit management to control eligibility for claim processing, dispensing privileges, and network participation status validation.

pharmacist active statusphrm_actv_sts

Categorical status code representing the current operational standing of a licensed pharmacist within the pharmacy network or credentialing registry. Supports pharmacy benefit administration by identifying pharmacists eligible to dispense medications and process prescription claims.

pharmacist addressphrm_addr

Physical location data element stored in pharmacy provider master files, PBM network directories, and state licensure databases containing street, city, state, and ZIP for a licensed pharmacist. Used by data engineers for provider matching, network validation, and regulatory reporting across claims and credentialing systems.

pharmacist adjustment amountphrm_adj_amt

Monetary value representing a post-adjudication modification applied to a pharmacist's reimbursement on a pharmacy claim. Captures corrections due to pricing disputes, DIR fees, clawbacks, or contractual reconciliations within pharmacy benefit management and claims processing workflows.

pharmacist agephrm_age

Numeric value representing the current age in years of a licensed pharmacist, calculated from date of birth. Used in pharmacist credentialing, workforce analytics, and demographic reporting within pharmacy network management and provider data systems.

pharmacist allowed amountphrm_alwd_amt

Maximum reimbursable dollar amount a pharmacy benefit plan will pay a pharmacist for a dispensed medication or clinical service, as defined by the plan's contracted fee schedule. Used in pharmacy claims adjudication to determine net reimbursement after cost-sharing is applied.

pharmacist amountphrm_amt

Monetary value field in PBM claims, pharmacy reimbursement, and provider payment systems representing fees, dispensing costs, or compensation associated with a licensed pharmacist. Critical for reconciliation logic, remittance processing, and cost analytics in pharmacy financial data pipelines.

pharmacist approval statusphrm_appr_sts

Coded value indicating the credentialing or network enrollment approval state of a licensed pharmacist, such as pending, approved, or denied. Used in pharmacy network management to control dispensing authorization and claims processing eligibility within the benefit plan.

pharmacist approved byphrm_appr_by

Identifier of the individual or system that granted credentialing, network enrollment, or administrative approval for a licensed pharmacist. Captured in pharmacy network management systems to maintain an audit trail of authorization decisions and credentialing workflow accountability.

pharmacist arrival timephrm_arrv_tm

Timestamp recording the time a pharmacist arrived at a pharmacy site, clinical setting, or scheduled shift. Used in pharmacy operations and workforce management systems to monitor staffing compliance, shift adherence, and service availability for prescription dispensing workflows.

pharmacist arrived datephrm_arrv_dt

Calendar date on which a pharmacist arrived at a pharmacy location, clinical site, or assignment. Used in pharmacy workforce management and scheduling systems to track attendance, verify coverage for dispensing operations, and support staffing compliance reporting.

pharmacist assessmentphrm_asmt

Structured or free-text clinical evaluation documented by a pharmacist during a medication therapy management session or patient consultation. Captures findings related to drug therapy problems, adherence barriers, and clinical recommendations within pharmacy care management programs.

pharmacist balancephrm_bal

Outstanding financial amount field in pharmacy billing, PBM accounts receivable, and provider payment systems reflecting unpaid or pending reimbursement owed to or from a licensed pharmacist. Used by data engineers in financial reconciliation, aging report generation, and payment cycle monitoring workflows.

pharmacist billed amountphrm_bill_amt

Total dollar amount submitted by a pharmacist or dispensing pharmacy on a prescription claim before adjudication and contractual adjustments are applied. Represents the gross charge used as the starting value in pharmacy benefit management claim processing and reimbursement calculations.

pharmacist birth datephrm_birth_dt

Date of birth field stored in pharmacy provider master records, state licensure registries, and PBM credentialing systems used to uniquely identify a licensed pharmacist and validate identity during provider matching. Data engineers use this field for deduplication logic and cross-system provider record linkage.

pharmacist blood pressurephrm_bp

Systolic and diastolic blood pressure measurement recorded by a pharmacist during a clinical consultation or medication therapy management encounter. Captured in pharmacy care management platforms to support chronic disease monitoring and pharmacist-led clinical intervention documentation.

pharmacist cancelled datephrm_cncl_dt

Calendar date on which a pharmacist's network contract, credentialing enrollment, scheduled shift, or service agreement was formally cancelled. Recorded in pharmacy network management systems to track termination timelines and ensure claims processing access is appropriately revoked.

pharmacist categoryphrm_cat

Classification field in pharmacy provider master files and PBM network systems designating the pharmacist type such as retail, clinical, compounding, or specialty. Used by data engineers to segment provider populations, apply category-specific reimbursement rules, and support formulary and network management reporting.

pharmacist charge amountphrm_chrg_amt

Dollar amount charged by a pharmacist or dispensing pharmacy for a medication or clinical service prior to insurance adjudication. Used in pharmacy claims processing to establish the gross billed value against which contracted rates, discounts, and plan allowances are applied.

pharmacist chief complaintphrm_cc

Primary symptom, medication concern, or clinical issue reported by a patient at the initiation of a pharmacist-led consultation or medication therapy management session. Documented in pharmacy care management records to guide clinical assessment and intervention planning.

PreviousPage 64 of 100Next