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 first namephrm_first_nm

The given name of a licensed pharmacist as recorded in pharmacy management or credentialing systems. Used to identify and display the pharmacist in prescription records, dispensing logs, claims processing, and regulatory compliance reporting.

pharmacist flagphrm_flg

Binary or enumerated indicator field in EHR, PBM, or claims systems marking a specific status or attribute of a pharmacist record, such as active licensure, network participation, or dispensing authority. Used by data engineers for row-level filtering and cohort segmentation in pharmacy analytics.

pharmacist frequencyphrm_freq

The dispensing or consultation frequency associated with a pharmacist's activity in pharmacy claims or management systems. Tracks how often a pharmacist dispenses prescriptions or performs medication therapy management within a defined reporting period.

pharmacist full namephrm_full_nm

The complete name of a licensed pharmacist, combining first, middle, and last name components. Used in pharmacy claims, dispensing records, credentialing systems, and regulatory submissions where a single concatenated name field is required for identification.

pharmacist genderphrm_gndr

The gender identity or biological sex classification of a licensed pharmacist as recorded in credentialing or workforce management systems. Used in demographic reporting, diversity analytics, and pharmacist directory maintenance across pharmacy networks.

pharmacist glucosephrm_gluc

The blood glucose measurement recorded for a pharmacist participating in employee health or wellness programs. Captured in occupational health systems to support pharmacist health monitoring, chronic disease management initiatives, and workplace wellness reporting.

pharmacist group numberphrm_grp_nbr

The insurance group identifier associated with a pharmacist's health benefit plan enrollment. Used in pharmacy benefit administration and credentialing systems to link the pharmacist to their specific employer-sponsored insurance group for claims and coverage verification.

pharmacist hemoglobinphrm_hgb

The hemoglobin level recorded for a pharmacist within an employee health or occupational wellness program. Stored in workforce health management systems to support pharmacist health screening, anemia monitoring, and workplace wellness program tracking.

pharmacist history present illnessphrm_hpi

A narrative description of a pharmacist's current medical condition or health concern documented during an occupational health encounter. Captured in employee health records to provide clinical context for workplace accommodations, fitness-for-duty evaluations, or health program participation.

pharmacist identifierphrm_id

Unique alphanumeric key assigned to a licensed pharmacist in PBM, EHR, claims, or pharmacy management systems, such as NPI, DEA number, or internal system ID. Data engineers use this field as a primary or foreign key for joining pharmacist records across disparate healthcare data sources.

pharmacist indexphrm_idx

Numeric positional or surrogate key assigned to a pharmacist record in pharmacy management, PBM, or EHR systems. Used by data engineers for efficient table indexing, record ordering, and linking pharmacist entities across normalized relational schemas and data warehouse dimensional models.

pharmacist indicatorphrm_ind

Boolean or coded field in claims, EHR, or PBM systems signaling whether a provider record represents a licensed pharmacist. Used by data engineers to filter provider datasets, classify dispensing events by clinician type, and enforce business rules in pharmacy analytics pipelines.

pharmacist instructionphrm_instr

Structured or free-text guidance field in EHR or pharmacy management systems capturing dispensing directions, counseling notes, or clinical protocols associated with a pharmacist. Data engineers use this field for natural language processing pipelines and medication management workflow analysis.

pharmacist keyphrm_key

A system-generated surrogate key uniquely identifying a pharmacist record in pharmacy management or data warehouse environments. Used as the primary join key across relational tables in claims processing, dispensing history, and pharmacy network credentialing databases.

pharmacist languagephrm_lang

The primary spoken or written language of a licensed pharmacist, recorded in credentialing and pharmacy network directories. Used to match pharmacists with patients requiring language-specific counseling and to support multilingual pharmacy staffing and care coordination.

pharmacist last namephrm_last_nm

The family surname of a licensed pharmacist as recorded in credentialing, pharmacy claims, or dispensing systems. Used alongside first name for pharmacist identification in prescription records, regulatory filings, pharmacy network directories, and claims adjudication.

pharmacist legal namephrm_legal_nm

The officially registered name of a licensed pharmacist as it appears on state licensure, DEA registration, or other regulatory documents. Used in credentialing verification, prescription signature validation, controlled substance monitoring, and pharmacy board compliance reporting.

pharmacist levelphrm_lvl

Coded or numeric field in PBM, EHR, or credentialing systems representing a pharmacist's hierarchical classification, such as staff, clinical specialist, or director. Used by data engineers for role-based access control, provider segmentation, and workforce analytics across pharmacy data platforms.

pharmacist license numberphrm_lic_nbr

The unique state-issued license number assigned to a pharmacist by the relevant pharmacy board. Used to verify active licensure status, validate prescriptions and dispensing authority, support credentialing processes, and meet regulatory reporting requirements in pharmacy claims systems.

pharmacist marital statusphrm_mar_sts

The marital or domestic relationship status of a licensed pharmacist as recorded in HR or benefits enrollment systems. Used to determine dependent eligibility for benefits administration, tax withholding classification, and workforce demographic reporting within healthcare organizations.

PreviousPage 67 of 100Next