sources of data to supplement pde dataresdac.umn.edu/sites/resdac.umn.edu/files/the plan... ·...
TRANSCRIPT
![Page 1: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/1.jpg)
Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE
Kyoungrae Jung, Ph.D.
Assistant Professor
Penn State University
![Page 2: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/2.jpg)
Plan Characteristics File
Contains information about plan type,
benefit design, premium, cost-sharing and
service area of Part D plans
2
![Page 3: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/3.jpg)
Why Use Plan Characteristics File
You can examine:
˗ Characteristics of enrollees by plan type
˗ Medication utilization/cost by plan type or within
selected plan types
˗ Premium elasticities from Part D Plan choice models
You need to control for plan characteristics as
covariates in your regression models
3
![Page 4: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/4.jpg)
Plan Characteristics File
Consists of four sub-files:
- Plan Benefit Base file
- Premium file
- Cost Sharing Tier file
- Service area file
Unit of record differs by sub-file
4
![Page 5: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/5.jpg)
Plan Characteristics File
Contract ID/Plan ID are encrypted
Can be linked to BSF or PDE data (using
encrypted Contract/Plan IDs)
Created from an end-of-year snapshot
Cannot be linked to plan-landscape files
available on CMS website
5
![Page 6: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/6.jpg)
Plan Benefit Base File
Contains plan type and drug benefit information
One record per contract/plan
˗ A contract identification number (Contract ID)
» Unique to each contract with CMS
» Encrypted
» 1st letter (not encrypted) indicates organization type
˗ A plan benefit package number (Plan ID)
» Indicates a specific benefit package within a contract
» Encrypted
6
![Page 7: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/7.jpg)
Contract ID and Organization Type
1st letter (not encrypted) of contract ID indicates organization type
˗ H: Local managed care organization
˗ R: Regional PPO (Preferred Provider Organization)
˗ S: Stand-alone PDP (prescription drug plan)
˗ E: Employer Direct Contract plans
˗ H: Others
Demonstrations
National PACE (Program of All-inclusive Care for the Elderly)
Cost plan
7
![Page 8: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/8.jpg)
Part D Contracts and Plans Summary (2008)
8
1st digit
Contract ID
General structure of
plan (organization)
Number of
contracts
Number of
plans
H Local managed care
plans (MA-PD) 578 3,152
R Regional PPO (MA-PD) 14 124
S Stand-alone PDP 93 2,060
E Employer Direct Contract
Plans 10 10
H Others
- Demonstrations
- National PACE
- Cost
84 219
![Page 9: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/9.jpg)
Organization/Plan Type (Benefit Base File)
Organization type: Local Medicare Advantage,
Regional PPO, PDP, Employer Direct Contract,
National PACE, Cost etc.
Plan type: Health Maintenance Organization
(HMO), Private Fee-for-Service , PPO, PDP etc.
Demo type: Non-Demo, ESRD Demo, etc
Employer group waiver plan (EGWP )
Special Need Plan(SNP) Type
9
![Page 10: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/10.jpg)
EGWP Indicator
EGWP indicates an employer-sponsored Part D
plan
EGWPs do not have benefit/tier information
Some EGWPs have PDE data
Not all EGWPs are employer-direct contract
plans
10
![Page 11: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/11.jpg)
Organization Type and EGWP (2008)
Number of Plans
EGWP
Organization Type
Yes
No
Employer Direct Contract 10 0
Stand-alone PDP 183 1,877
MA-PD (Local MA, PFFS,
Regional PPO) 603 2,673
11
![Page 12: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/12.jpg)
EGWP (Employer Group Waiver Plan)
EGWP captures all employer direct contract plans
(contract IDs begin with “E”)
Most EGWPs are MA-PDs or PDPs (contract IDs
start with “H” or “S”)
Use this indicator to exclude all employer-sponsored
Part D plans
12
![Page 13: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/13.jpg)
PDP/MA-PD Contracts and Plans (2008)
Excludes PACE, Demonstration, 1876 cost,
Employer, SNP, and Part B only plans.
Need to use both contract and plan-specific
information
Contract Type Contracts Plans
PDP 87 1,877
MA-PD 474 1,926
13
![Page 14: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/14.jpg)
Drug Benefit Type (Benefit Base File)
Defined standard
Actuarially equivalent
˗ Defined deductible & modified cost-sharing
˗ No gap coverage
Basic alternative
˗ Reduced deductible and/or modified cost-sharing
˗ No gap coverage
Enhanced alternative
˗ Reduced deductible
˗ Gap coverage
14
![Page 15: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/15.jpg)
Type of Drug Benefit (2008)
15
222 (11.83%)
243 (12.95%)
463 (24.67%)
949 (50.56%)
PDP
Defined standard Actuarily equivalent
Basic alternative Enhanced
80 (4.15%) 16 (0.83%)
116 (6.02%)
1,714 (89.99%)
MA-PD
Defined standard Actuarily equivalent
Basic alternative Enhanced
Excludes employer-sponsored plans, Part B only, SNP, National PACE, cost plans.
![Page 16: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/16.jpg)
Deductible Type (Benefit Base File)
Defined standard
Reduced (plan-defined)
Zero
16
![Page 17: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/17.jpg)
Type of Deductible (2008)
590 (31.43%)
187 (9.96%)
1,100 (58.6%)
PDP
Defined standard Reduced Zero
169 (8.77%)
111 (5.76%)
1,646 (85.46%)
MA-PD
Defined standard Reduced Zero
Excludes employer-sponsored plans, Part B only, SNP, National PACE, cost plans. 17
![Page 18: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/18.jpg)
Gap Coverage
Gap coverage type
˗ Some Generics
˗ Some Generics and Some Brands
˗ All Generics
˗ All Generics and Some Brands
˗ All Generics and All Preferred Brands
˗ All Generics and All Brands
˗ All Drugs on Your Formulary
˗ No Gap Coverage
18
![Page 19: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/19.jpg)
Gap Coverage (2008)
Gap
coverage PDP MA-PD
N % N %
Yes 547 29.14 985 51.14
No 1,330 70.86 941 48.86
Total 1,877 100 1,926 100
19
![Page 20: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/20.jpg)
Tier Information (Benefit Base File)
Type of drug covered in each tier during pre-ICL and
gap periods
Copayment amount and coinsurance for 1 month in
each tier during pre-ICL and gap periods
20
![Page 21: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/21.jpg)
Type of Drug in Each Tier (Benefit Base File)
Variables:
˗ pre_ICL_drug_type_tier01 – 07
˗ Six-digit number (combination of 0s and 1s) and each digit in
each position means:
» 1 in 1: Non-preferred Brand
» 1 in 2: Generic
» 1 in 3: Preferred Generic
» 1 in 4: Non-preferred Generic
» 1 in 5: Brand
» 1 in 6: Preferred Brand
˗ Examples (the most frequent values) » 010000 (pre_ICL_drug_type_tier01)
» 000001 (pre_ICL_drug_type_tier02)
» 100000 (pre_ICL_drug_type_tier03)
21
![Page 22: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/22.jpg)
Cost Sharing in Each Tier (Benefit Base File)
Variables:
˗ pre_ICL_inp_1m_COPAY_tier01 – 07
Mean Values (2008):
˗ pre_ICL_inp_1m_COPAY_tier01: $4.27
˗ pre_ICL_inp_1m_COPYA_tier02: $30.72
˗ pre_ICL_inp_1m_COPYA_tier03: $63.98
With information on drug type, we can obtain each
plan’s copayment for generic and branded drugs
˗ Application: The relationship between copayment
amounts and the use of medications
22
![Page 23: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/23.jpg)
Example of using plan information
23
Filling Rx with a branded drug
OR 95% CI P-value
Copayment for
preferred branded drugs ($) 0.981 [0.978, 0.985] 0.000
Plan type
Private FFS (ref)
HMO 0.863 [0.768, 0.970] 0.014
PPO 1.242 [1.072, 1.438] 0.004
-Among MA-PD enrollees who used a statin in 2008 -Controls for demographic factors, health-risk measures, and market-area variables
![Page 24: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/24.jpg)
Premium File
Contains premium information
One record per contract/plan/segment
˗ Segment: a geographic area covered by a particular
benefit package
Segment ID:
– Applies only to local MA-PDs
– Premium information may vary by segment
˗ Less than 2 % of MA-PD records had more than one
segment ID (2008)
24
![Page 25: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/25.jpg)
Part D Premium Fields (Premium File)
Basic premium: net of rebate
Supplemental premium: net of rebate
Total premium: net of rebate
25
![Page 26: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/26.jpg)
How Part D Premium is Determined
Part D Premium = base premium + (plan bid –
national average bid)
˗ Base premium: a portion of national average
bid ($31.08 in 2012)
˗ Beneficiary pays or receives the difference
between his/her plan’s bid and benchmark
˗ Example:
» National average bid: $100 (Plan A: $110; Plan B: $90)
» Base Premium: $30
» Part D premium for each plan?
26
![Page 27: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/27.jpg)
Figure 19
Example of Part D Premium Bidding
$100 $90
Plan A Bid = $110 Plan B Bid = $90
Enrollee
Pays
National
Average Bid
= $100
$10
$10
Enrollee
Receives
![Page 28: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/28.jpg)
Part D Premium Information
Basic premium
˗ Net of rebate
˗ Can be zero or negative
˗ Some MA-PDs have negative basic premiums in 2008
˗ MA-PDs are allowed to cross-subsidize between Parts C and D
Supplemental premium: net of rebate
˗ Premium for supplementary benefits
Total premium: net of rebate
˗ Basic premium + supplemental premium
28 28
![Page 29: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/29.jpg)
Average Part D Total Premium (2008)
29
PDP MA-PD
N Average
premiums
(monthly)
N Average
premiums
(monthly)
Benefit type
Basic
928
30.0
212
17.9
Enhanced 949 49.5 1,760 20.5
Deductible
Yes
777
30.1
280
17.8
No 1,100 46.7 1,692 20.7
Gap coverage
Yes
547
62.6
1,009
21.8
No 1,330 30.5 963 14.4
![Page 30: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/30.jpg)
Tier File
One record per contract/plan/tier
Type of drug covered, cost-sharing type, and cost-
sharing amount by
˗ benefit phase (pre-ICL, gap, post OOPT)
˗ days supplied (1 month, 3 months, other days)
˗ type of pharmacy (in-network, mail-order; preferred,
non-preferred)
Information is available only for relevant benefit
types of each plan
30
![Page 31: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/31.jpg)
Service Area File
Region, state, and county where each plan benefit
package is offered
one record per contract/plan/service area
Service area
˗ Local MA-PDs: county (listed by state & county)
˗ Regional MA-PDs: region (listed by MAPD region &
state)
˗ PDPs: state (listed by PDP region and state)
31
![Page 32: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/32.jpg)
Using Plan Characteristics File
As stand-alone source, you can examine
˗ How many Part D plans are available to beneficiaries
˗ What percentage of Part D plans offer coverage for the
gap
˗ Whether premiums differ by plan type or benefit
package; How much they are different?
˗ Geographical differences in plan availability or
premiums
32
![Page 33: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/33.jpg)
Using Plan Characteristics File
Link to BSF data to examine:
˗ Demographics of enrollees in each plan type
˗ Part D plan choice models to estimate premium
elasticities, etc.
Identifiers to use for merge:
˗ Contract ID/Plan ID (plan/tier files)
˗ Contract ID/Plan ID/Segment ID (premium/service
area files)
33
![Page 34: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/34.jpg)
Using Plan Characteristics File
Link to PDE data to examine:
˗ Medication utilization/cost by plan type
˗ Percent of beneficiaries who reach ICL by plan type
˗ PDE-data based risk scores by plan type
May need to aggregate PDE data to patient level
Identifiers to use for merge:
˗ Contract ID/Plan ID (plan/premium/service area files)
˗ Contract ID/Plan ID/Tier ID (tier file)
34
![Page 35: Sources of Data to Supplement PDE Dataresdac.umn.edu/sites/resdac.umn.edu/files/The Plan... · Sources of Data to Supplement PDE Data PLAN CHARACTERISTICS FILE Kyoungrae Jung, Ph.D](https://reader036.vdocuments.us/reader036/viewer/2022062607/5fb3abe0bb60b561b452cff9/html5/thumbnails/35.jpg)
PART D EVENT DATA ENHANCED DENOMINATOR
PDE_ID BENE_ID
BENE_ID PTD_CNTRCT_ID_01-PTD_CNTRCT_ID_12
SRVC_DT PTD_PBP_ID_01-PTD_PBP_ID_12
PLAN_CNTRCT_REC_ID PTD_SGMT_ID_01-PTD_SGMT_ID_12
PLAN_PBP_REC_NUM
TIER_ID
PLAN BENEFIT FILE
CONTRACT_ID
PLAN_ID
FORMULARY_ID
PREMIUM FILE
CONTRACT_ID
PLAN_ID
SEGMENT_ID
TIER-LEVEL BENEFIT FILE
CONTRACT_ID
PLAN_ID
TIER_ID
SERVICE AREA FILE
CONTRACT_ID
PLAN_ID
SEGMENT_ID
*See Part D User Manual for more specific guidance on fi le l inkage.
For Defined Standard and Enhanced Plans using the M edicare-defined
cost sharing structure, there is just one record (TIER_ID=1) in the Tier-
Level Benefit File, but TIER_ID on the PDE may be greater than 1 for
these plans. Researchers wanting to link these PDEs to the Tier-Level
file will need to link on just the plan identifiers and not the TIER_ID.
RELATIONSHIP DIAGRAM FOR PDE, DENOMINATOR, AND PLAN CHARACTERISTICS FILES*
The Plan Benefit File can be joined to
the other plan characteristic files in a
one-to-many relationship.
PLAN CHARACTERISTICS FILES
For some plans premium information varies across
segments. Users will need to develop their own
methodology for rolling up at the plan level.
Use SRVC_DT to map to the correct monthly indicator.
35