Medicare Part D

Part D

member

Updated 5/16/2026

Definition

The Medicare outpatient prescription drug benefit administered through CMS-contracted PDP and MA-PD plans. Pharmacy claims are processed through PBM systems using NCPDP transaction standards. Plan data including formulary tiers, coverage gap thresholds, and low-income subsidy flags are stored in benefit configuration and member enrollment tables.

Standard Abbreviation

Part D

Database Usage

-- Example column naming
CREATE TABLE claims (
  clm_id VARCHAR(50),
  part d VARCHAR(100),  -- Medicare Part D (max 100 chars)
  ...
);

-- Example in SELECT
SELECT
  clm_id,
  part d as medicare_part_d
FROM claims;

Common uses in healthcare data

Member eligibility verification and enrollment tracking
Medicare Advantage and Medicaid managed care reporting
COBRA, CHIP, and dual-eligible member management
Enrollment reconciliation and CMS submissions
Member 360 data model and longitudinal analysis

Example database column name

ISO-11179 snake_case standard

-- Recommended column name
part_d

-- Example DDL
CREATE TABLE healthcare_data (
  record_id   VARCHAR(50)   NOT NULL,
  part_d       VARCHAR(100),  -- Medicare Part D (max 100 chars)
  created_dt  TIMESTAMP     NOT NULL DEFAULT NOW()
);

Column names follow the ISO-11179 naming convention: lowercase, underscore-separated, using the standard abbreviation as a prefix where applicable.

Looking for more healthcare terms?

Browse our complete library of 100,000+ standardized healthcare data terms

Browse All Terms