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 pulsephrm_pulse

Records the patient heart rate in beats per minute as documented by a pharmacist during a medication therapy management (MTM) encounter or point-of-care assessment. Used to evaluate cardiovascular medication appropriateness and monitor patient response to cardiac or antihypertensive drug therapy.

pharmacist quantityphrm_qty

Numeric count or volume measure associated with a licensed pharmacist in pharmacy claims, PBM, or EHR dispensing records, such as the number of prescriptions processed or days supply dispensed. Used by data engineers to aggregate dispensing volumes, flag outliers, and support utilization management analytics.

pharmacist racephrm_race

Captures the self-reported racial identity of a licensed pharmacist as collected during credentialing or workforce demographic surveys. Used in healthcare workforce analytics, diversity reporting, and regulatory compliance to monitor equitable representation across pharmacy staffing and professional practice settings.

pharmacist rangephrm_rng

Minimum and maximum value boundaries associated with a pharmacist's performance metrics, dosage thresholds, or reimbursement limits in PBM and EHR systems. Data engineers apply this field to validate claim values, enforce business rules, and identify out-of-range dispensing or billing anomalies in pharmacy data pipelines.

pharmacist ratephrm_rt

Unit price or reimbursement rate associated with a licensed pharmacist's services in claims, PBM, and provider contract systems. Data engineers use this field to calculate dispensing fee payments, reconcile pharmacy claims adjudication outputs, and support financial modeling for pharmacy network cost analysis.

pharmacist ratingphrm_rtg

Stores a performance or quality assessment score assigned to a pharmacist based on clinical outcomes, patient satisfaction surveys, dispensing accuracy audits, or peer review evaluations. Used in pharmacy quality management programs to identify improvement opportunities and recognize high-performing practitioners.

pharmacist ratiophrm_ratio

Represents the calculated proportion of pharmacists to patients, prescriptions, or pharmacy technicians within a given practice setting or time period. Used in pharmacy staffing analysis, regulatory compliance reporting, and workload management to ensure safe dispensing volumes and adequate clinical oversight.

pharmacist reasonphrm_rsn

Explanatory code or free-text value documenting why a pharmacist action was taken in EHR, PBM, or pharmacy claims systems, such as a drug substitution rationale or prior authorization denial explanation. Data engineers use this field for audit trails, compliance reporting, and root cause analysis of pharmacy workflow exceptions.

pharmacist received datephrm_rcvd_dt

Captures the date a pharmacist received a prescription, referral, prior authorization request, or clinical documentation for processing. Used in pharmacy workflow tracking to measure turnaround times, identify processing bottlenecks, and ensure timely medication dispensing and patient care coordination.

pharmacist referencephrm_ref

External identifier or pointer linking a pharmacist record to a related entity in EHR, PBM, or claims systems, such as an NPI, DEA number, or state license registry ID. Data engineers use this field for cross-system provider matching, referential integrity checks, and pharmacist credentialing data integration workflows.

pharmacist resolution datephrm_resol_dt

Records the date a pharmacist resolved a drug therapy problem, medication-related issue, or clinical intervention initiated during a patient encounter. Used in medication therapy management tracking to measure intervention effectiveness and document the closure of identified medication safety or adherence concerns.

pharmacist respirationphrm_resp

Records the patient respiratory rate in breaths per minute as documented by a pharmacist during a medication therapy management (MTM) visit or clinical assessment. Used to evaluate appropriateness of respiratory or cardiovascular medications and monitor patient response during pharmacy-led chronic disease management consultations.

pharmacist resultphrm_rslt

Outcome value recorded for a pharmacist-driven clinical or operational activity in EHR and PBM systems, such as a medication therapy management intervention result or drug utilization review finding. Data engineers use this field to measure pharmacist program effectiveness and support quality measure reporting pipelines.

pharmacist review systemsphrm_ros

Documents the systematic review of patient body systems conducted by a pharmacist during a comprehensive medication review (CMR) or medication therapy management encounter. Captures symptom findings across organ systems to identify drug-related problems, contraindications, or unrecognized adverse medication effects.

pharmacist revisionphrm_rev

Tracks the version or iteration number of a pharmacist-authored clinical document, medication therapy management plan, or pharmacy protocol that has been updated. Used in pharmacy documentation systems to maintain version control and ensure clinical staff reference the most current medication therapy recommendations.

pharmacist riskphrm_rsk

Risk level assigned to a pharmacist's clinical intervention or medication review, indicating the potential for patient harm from drug interactions, contraindications, or dosing errors identified during the pharmacist's medication management activities.

pharmacist routephrm_rte

The medication administration route specified or verified by a pharmacist during dispensing or clinical review, such as oral, intravenous, or topical, ensuring the prescribed delivery method aligns with clinical guidelines and patient safety protocols.

pharmacist scheduled datephrm_sched_dt

The calendar date on which a pharmacist is scheduled to perform a clinical activity such as a medication therapy management session, patient consultation, or pharmacy services review within a care coordination or outreach program.

pharmacist scheduled timephrm_sched_tm

The specific time of day at which a pharmacist is scheduled to conduct a clinical activity, such as a medication review or patient consultation, used to coordinate pharmacy workflows and ensure timely delivery of pharmaceutical care services.

pharmacist scorephrm_scr

Calculated numeric rating assigned to a licensed pharmacist in PBM, EHR, or quality management systems, reflecting performance dimensions such as adherence counseling effectiveness, star rating contribution, or network quality metrics. Data engineers use this field for provider profiling, incentive payment calculations, and network adequacy assessments.

PreviousPage 67 of 97Next