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 completed datephrm_cmpl_dt

Calendar date on which a pharmacist finalized a prescription fill, clinical consultation, medication therapy management session, or credentialing process. Recorded in pharmacy operations and care management systems to track workflow completion and support performance reporting.

pharmacist confidential indicatorphrm_conf_ind

Binary flag designating that a pharmacist's record or associated patient encounter contains sensitive information requiring restricted access under applicable privacy regulations. Used in pharmacy management systems to enforce data access controls and ensure compliance with HIPAA confidentiality requirements.

pharmacist contactphrm_cntct

Communication data element in pharmacy provider master files and PBM network directories capturing phone, fax, or email details for a licensed pharmacist. Used by data engineers to support provider outreach workflows, prior authorization routing, network directory publishing, and claims inquiry resolution across pharmacy systems.

pharmacist copay amountphrm_cpay_amt

The fixed dollar amount a member pays out-of-pocket for pharmacist services at the point of dispensing. Captured in pharmacy claims and benefit adjudication records to calculate member cost-sharing obligations and reconcile pharmacy benefit payments against plan design.

pharmacist costphrm_cst

The total expense incurred for pharmacist services, including dispensing fees and associated professional charges. Used in pharmacy claims processing and financial reporting to track pharmacy benefit expenditures, reimbursement rates, and cost trend analysis across payer and PBM systems.

pharmacist countphrm_cnt

Numeric aggregation field in pharmacy workforce analytics, PBM network reporting, and provider master systems representing the total number of licensed pharmacists within a defined scope such as a chain, region, or network tier. Used by data engineers in staffing models, network adequacy calculations, and regulatory compliance reports.

pharmacist countryphrm_ctry

The country in which a licensed pharmacist is credentialed or practices. Used in pharmacy provider directories and credentialing systems to support multi-national pharmacy networks, international licensure verification, and geographic reporting for pharmacy benefit administration.

pharmacist created byphrm_crtd_by

The username or system identifier of the user who created the pharmacist record in the pharmacy management or credentialing system. Used for audit trail purposes to maintain data integrity and accountability in pharmacy provider enrollment and directory maintenance workflows.

pharmacist created datephrm_crtd_dt

Timestamp recording when a licensed pharmacist's record was first entered into EHR, PBM, or pharmacy management systems. Critical for data lineage tracking, audit trails, and reconciling pharmacist credentialing records across provider directories and dispensing platforms.

pharmacist created timephrm_crtd_tm

The precise timestamp indicating when a pharmacist's record was initially created in the pharmacy management or credentialing system. Used for audit logging, data lineage tracking, and compliance purposes to establish when pharmacist enrollment or directory entries were first established.

pharmacist creatininephrm_cr

The serum creatinine lab value associated with a pharmacist's clinical review of a patient's kidney function. Used in pharmacy clinical decision support systems to guide pharmacist dosing recommendations and renal adjustment alerts for renally-cleared medications during medication therapy management.

pharmacist datephrm_dt

Generic calendar date field associated with a licensed pharmacist in pharmacy management, PBM, or claims systems. Context-dependent usage may reference dispensing activity, licensure events, or clinical review dates; data engineers must validate field purpose per source system schema.

pharmacist datetimephrm_dttm

Combined date and time value capturing a pharmacist-related event in PBM, EHR, or dispensing systems. Used to precisely timestamp prescription verification, drug utilization reviews, or clinical interventions, enabling accurate sequencing of medication workflow events in downstream analytics.

pharmacist dea numberphrm_dea_nbr

The unique Drug Enforcement Administration registration number assigned to a licensed pharmacist authorizing them to dispense controlled substances. Required in pharmacy dispensing records and credentialing systems to validate prescribing authority and ensure regulatory compliance with federal controlled substance laws.

pharmacist death datephrm_death_dt

Date of death recorded for a licensed pharmacist in provider registry, credentialing, or EHR systems. Used by data engineers to terminate active records, suppress future claim processing, and maintain accurate provider master data across PBM and health plan platforms.

pharmacist deductible amountphrm_ded_amt

The dollar amount applied toward a member's annual pharmacy deductible for pharmacist services. Captured during pharmacy claims adjudication to accurately track member accumulator balances and determine when deductible thresholds are met under the applicable pharmacy benefit design.

pharmacist deleted datephrm_del_dt

The date on which a pharmacist's record was logically removed or inactivated in the pharmacy management or credentialing system. Used to maintain historical data integrity and support audit trails for pharmacy provider directory changes, terminations, and credentialing lifecycle tracking.

pharmacist deleted indicatorphrm_del_ind

A boolean flag indicating whether a pharmacist's record has been logically deleted or inactivated in the pharmacy management system. Used to filter active versus inactive pharmacist records in provider directories, credentialing databases, and pharmacy network reporting without permanently removing historical data.

pharmacist descriptionphrm_desc

Free-text or structured narrative field in pharmacy management and EHR systems describing a pharmacist's role, specialty, or scope of practice. Used by data engineers for provider classification, directory enrichment, and mapping pharmacist types across PBM and credentialing data sources.

pharmacist detailphrm_dtl

Granular attribute data associated with a licensed pharmacist in PBM, EHR, or pharmacy management systems, including specialty certifications, practice settings, and dispensing authorities. Essential for data engineers building provider-level analytics and credentialing validation pipelines.

PreviousPage 63 of 97Next