Data Documentation

MBSF Base A/B/C/D
Back to File Overview

For most files, a table of variables will display below, with links to the variable definitions. If no table displays, or if you need additional information for a specific variable, please see the CCW website. Data documentation is available for all files and codebooks for many.

If you are unable to locate the information you need, please contact ResDAC.

Document
codebook-mbsf-abcd.pdf544.8 KB
Document
record-layout-mbsf-abcd.xlsx22.14 KB

Base (A/B/C/D) segment

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 BENE_ENROLLMT_REF_YR Reference Year (Base)
3 ENRL_SRC Enrollment Source
4 SAMPLE_GROUP Medicare Sample Group Indicator
5 ENHANCED_FIVE_PERCENT_FLAG Enhanced Medicare 5% Sample Indicator
6 CRNT_BIC_CD Current Beneficiary Identification Code
7 STATE_CODE State code for beneficiary (SSA code)
8 COUNTY_CD County code for beneficiary (SSA code)
9 ZIP_CD Zip code for beneficiary
10 STATE_CNTY_FIPS_CD_01 State and county FIPS code - January
11 STATE_CNTY_FIPS_CD_02 State and county FIPS code - February
12 STATE_CNTY_FIPS_CD_03 State and county FIPS code - March
13 STATE_CNTY_FIPS_CD_04 State and county FIPS code - April
14 STATE_CNTY_FIPS_CD_05 State and county FIPS code - May
15 STATE_CNTY_FIPS_CD_06 State and county FIPS code - June
16 STATE_CNTY_FIPS_CD_07 State and county FIPS code - July
17 STATE_CNTY_FIPS_CD_08 State and county FIPS code - August
18 STATE_CNTY_FIPS_CD_09 State and county FIPS code - September
19 STATE_CNTY_FIPS_CD_10 State and county FIPS code - October
20 STATE_CNTY_FIPS_CD_11 State and county FIPS code - November
21 STATE_CNTY_FIPS_CD_12 State and county FIPS code - December
22 AGE_AT_END_REF_YR Age of beneficiary at end of year
23 BENE_BIRTH_DT Beneficiary Date of Birth
24 VALID_DEATH_DT_SW Valid Date of Death Switch
25 BENE_DEATH_DT Beneficiary Date of Death
26 SEX_IDENT_CD Sex
27 BENE_RACE_CD Beneficiary Race Code (Base)
28 RTI_RACE_CD Research Triangle Institute (RTI) Race Code
29 COVSTART Medicare Coverage Start Date
30 ENTLMT_RSN_ORIG Original Reason for Entitlement Code
31 ENTLMT_RSN_CURR Current Reason for Entitlement Code
32 ESRD_IND End-Stage Renal Disease (ESRD) Indicator
33 MDCR_STATUS_CODE_01 Medicare Status Code - January
34 MDCR_STATUS_CODE_02 Medicare Status Code - February
35 MDCR_STATUS_CODE_03 Medicare Status Code - March
36 MDCR_STATUS_CODE_04 Medicare Status Code - April
37 MDCR_STATUS_CODE_05 Medicare Status Code - May
38 MDCR_STATUS_CODE_06 Medicare Status Code - June
39 MDCR_STATUS_CODE_07 Medicare Status Code - July
40 MDCR_STATUS_CODE_08 Medicare Status Code - August
41 MDCR_STATUS_CODE_09 Medicare Status Code - September
42 MDCR_STATUS_CODE_10 Medicare Status Code - October
43 MDCR_STATUS_CODE_11 Medicare Status Code - November
44 MDCR_STATUS_CODE_12 Medicare Status Code - December
45 BENE_PTA_TRMNTN_CD Part A Termination Code
46 BENE_PTB_TRMNTN_CD Part B Termination Code
47 BENE_HI_CVRAGE_TOT_MONS Part A Months Count
48 BENE_SMI_CVRAGE_TOT_MONS Part B Months Count
49 BENE_STATE_BUYIN_TOT_MONS State Buy-In Coverage Count
50 BENE_HMO_CVRAGE_TOT_MONS HMO Coverage Count
51 PTD_PLAN_CVRG_MONS Months of Part D Coverage
52 RDS_CVRG_MONS Months of Retiree Drug Subsidy Coverage
53 DUAL_ELGBL_MONS Months of Dual Eligibility
54 MDCR_ENTLMT_BUYIN_IND_01 Medicare Entitlement/Buy-In Indicator - January
55 MDCR_ENTLMT_BUYIN_IND_02 Medicare Entitlement/Buy-In Indicator - February
56 MDCR_ENTLMT_BUYIN_IND_03 Medicare Entitlement/Buy-In Indicator - March
57 MDCR_ENTLMT_BUYIN_IND_04 Medicare Entitlement/Buy-In Indicator - April
58 MDCR_ENTLMT_BUYIN_IND_05 Medicare Entitlement/Buy-In Indicator - May
59 MDCR_ENTLMT_BUYIN_IND_06 Medicare Entitlement/Buy-In Indicator - June
60 MDCR_ENTLMT_BUYIN_IND_07 Medicare Entitlement/Buy-In Indicator - July
61 MDCR_ENTLMT_BUYIN_IND_08 Medicare Entitlement/Buy-In Indicator - August
62 MDCR_ENTLMT_BUYIN_IND_09 Medicare Entitlement/Buy-In Indicator - September
63 MDCR_ENTLMT_BUYIN_IND_10 Medicare Entitlement/Buy-In Indicator - October
64 MDCR_ENTLMT_BUYIN_IND_11 Medicare Entitlement/Buy-In Indicator - November
65 MDCR_ENTLMT_BUYIN_IND_12 Medicare Entitlement/Buy-In Indicator - December
66 HMO_IND_01 HMO Indicator - January
67 HMO_IND_02 HMO Indicator - February
68 HMO_IND_03 HMO Indicator - March
69 HMO_IND_04 HMO Indicator - April
70 HMO_IND_05 HMO Indicator - May
71 HMO_IND_06 HMO Indicator - June
72 HMO_IND_07 HMO Indicator - July
73 HMO_IND_08 HMO Indicator - August
74 HMO_IND_09 HMO Indicator - September
75 HMO_IND_10 HMO Indicator - October
76 HMO_IND_11 HMO Indicator - November
77 HMO_IND_12 HMO Indicator - December

Part C

NumberSAS NameVariable Name
1 PTC_CNTRCT_ID_01 Part C Contract Number - January
2 PTC_CNTRCT_ID_02 Part C Contract Number - February
3 PTC_CNTRCT_ID_03 Part C Contract Number - March
4 PTC_CNTRCT_ID_04 Part C Contract Number - April
5 PTC_CNTRCT_ID_05 Part C Contract Number - May
6 PTC_CNTRCT_ID_06 Part C Contract Number - June
7 PTC_CNTRCT_ID_07 Part C Contract Number - July
8 PTC_CNTRCT_ID_08 Part C Contract Number - August
9 PTC_CNTRCT_ID_09 Part C Contract Number - September
10 PTC_CNTRCT_ID_10 Part C Contract Number - October
11 PTC_CNTRCT_ID_11 Part C Contract Number - November
12 PTC_CNTRCT_ID_12 Part C Contract Number - December
13 PTC_PBP_ID_01 Part C PBP Number - January
14 PTC_PBP_ID_02 Part C PBP Number - February
15 PTC_PBP_ID_03 Part C PBP Number - March
16 PTC_PBP_ID_04 Part C PBP Number - April
17 PTC_PBP_ID_05 Part C PBP Number - May
18 PTC_PBP_ID_06 Part C PBP Number - June
19 PTC_PBP_ID_07 Part C PBP Number - July
20 PTC_PBP_ID_08 Part C PBP Number - August
21 PTC_PBP_ID_09 Part C PBP Number - September
22 PTC_PBP_ID_10 Part C PBP Number - October
23 PTC_PBP_ID_11 Part C PBP Number - November
24 PTC_PBP_ID_12 Part C PBP Number - December
25 PTC_PLAN_TYPE_CD_01 Part C Plan Type Code - January
26 PTC_PLAN_TYPE_CD_02 Part C Plan Type Code - February
27 PTC_PLAN_TYPE_CD_03 Part C Plan Type Code - March
28 PTC_PLAN_TYPE_CD_04 Part C Plan Type Code - April
29 PTC_PLAN_TYPE_CD_05 Part C Plan Type Code - May
30 PTC_PLAN_TYPE_CD_06 Part C Plan Type Code - June
31 PTC_PLAN_TYPE_CD_07 Part C Plan Type Code - July
32 PTC_PLAN_TYPE_CD_08 Part C Plan Type Code - August
33 PTC_PLAN_TYPE_CD_09 Part C Plan Type Code - September
34 PTC_PLAN_TYPE_CD_10 Part C Plan Type Code - October
35 PTC_PLAN_TYPE_CD_11 Part C Plan Type Code - November
36 PTC_PLAN_TYPE_CD_12 Part C Plan Type Code - December

Part D

NumberSAS NameVariable Name
1 PTD_CNTRCT_ID_01 Monthly Part D Contract Number - January
2 PTD_CNTRCT_ID_02 Monthly Part D Contract Number - February
3 PTD_CNTRCT_ID_03 Monthly Part D Contract Number - March
4 PTD_CNTRCT_ID_04 Monthly Part D Contract Number - April
5 PTD_CNTRCT_ID_05 Monthly Part D Contract Number - May
6 PTD_CNTRCT_ID_06 Monthly Part D Contract Number - June
7 PTD_CNTRCT_ID_07 Monthly Part D Contract Number - July
8 PTD_CNTRCT_ID_08 Monthly Part D Contract Number - August
9 PTD_CNTRCT_ID_09 Monthly Part D Contract Number - September
10 PTD_CNTRCT_ID_10 Monthly Part D Contract Number - October
11 PTD_CNTRCT_ID_11 Monthly Part D Contract Number - November
12 PTD_CNTRCT_ID_12 Monthly Part D Contract Number - December
13 PTD_PBP_ID_01 Monthly Part D Plan Benefit Package Number - January
14 PTD_PBP_ID_02 Monthly Part D Plan Benefit Package Number - February
15 PTD_PBP_ID_03 Monthly Part D Plan Benefit Package Number - March
16 PTD_PBP_ID_04 Monthly Part D Plan Benefit Package Number - April
17 PTD_PBP_ID_05 Monthly Part D Plan Benefit Package Number - May
18 PTD_PBP_ID_06 Monthly Part D Plan Benefit Package Number - June
19 PTD_PBP_ID_07 Monthly Part D Plan Benefit Package Number - July
20 PTD_PBP_ID_08 Monthly Part D Plan Benefit Package Number - August
21 PTD_PBP_ID_09 Monthly Part D Plan Benefit Package Number - September
22 PTD_PBP_ID_10 Monthly Part D Plan Benefit Package Number - October
23 PTD_PBP_ID_11 Monthly Part D Plan Benefit Package Number - November
24 PTD_PBP_ID_12 Monthly Part D Plan Benefit Package Number - December
25 PTD_SGMT_ID_01 Monthly Part D Market Segment Identifier - January
26 PTD_SGMT_ID_02 Monthly Part D Market Segment Identifier - February
27 PTD_SGMT_ID_03 Monthly Part D Market Segment Identifier - March
28 PTD_SGMT_ID_04 Monthly Part D Market Segment Identifier - April
29 PTD_SGMT_ID_05 Monthly Part D Market Segment Identifier - May
30 PTD_SGMT_ID_06 Monthly Part D Market Segment Identifier - June
31 PTD_SGMT_ID_07 Monthly Part D Market Segment Identifier - July
32 PTD_SGMT_ID_08 Monthly Part D Market Segment Identifier - August
33 PTD_SGMT_ID_09 Monthly Part D Market Segment Identifier - September
34 PTD_SGMT_ID_10 Monthly Part D Market Segment Identifier - October
35 PTD_SGMT_ID_11 Monthly Part D Market Segment Identifier - November
36 PTD_SGMT_ID_12 Monthly Part D Market Segment Identifier - December
37 RDS_IND_01 Part D Retiree Drug Subsidy Indicator - January
38 RDS_IND_02 Part D Retiree Drug Subsidy Indicator - February
39 RDS_IND_03 Part D Retiree Drug Subsidy Indicator - March
40 RDS_IND_04 Part D Retiree Drug Subsidy Indicator - April
41 RDS_IND_05 Part D Retiree Drug Subsidy Indicator - May
42 RDS_IND_06 Part D Retiree Drug Subsidy Indicator - June
43 RDS_IND_07 Part D Retiree Drug Subsidy Indicator - July
44 RDS_IND_08 Part D Retiree Drug Subsidy Indicator - August
45 RDS_IND_09 Part D Retiree Drug Subsidy Indicator - September
46 RDS_IND_10 Part D Retiree Drug Subsidy Indicator - October
47 RDS_IND_11 Part D Retiree Drug Subsidy Indicator - November
48 RDS_IND_12 Part D Retiree Drug Subsidy Indicator - December
49 DUAL_STUS_CD_01 Monthly Medicare-Medicaid dual eligibility code - January
50 DUAL_STUS_CD_02 Monthly Medicare-Medicaid dual eligibility code - February
51 DUAL_STUS_CD_03 Monthly Medicare-Medicaid dual eligibility code - March
52 DUAL_STUS_CD_04 Monthly Medicare-Medicaid dual eligibility code - April
53 DUAL_STUS_CD_05 Monthly Medicare-Medicaid dual eligibility code - May
54 DUAL_STUS_CD_06 Monthly Medicare-Medicaid dual eligibility code - June
55 DUAL_STUS_CD_07 Monthly Medicare-Medicaid dual eligibility code - July
56 DUAL_STUS_CD_08 Monthly Medicare-Medicaid dual eligibility code - August
57 DUAL_STUS_CD_09 Monthly Medicare-Medicaid dual eligibility code - September
58 DUAL_STUS_CD_10 Monthly Medicare-Medicaid dual eligibility code - October
59 DUAL_STUS_CD_11 Monthly Medicare-Medicaid dual eligibility code - November
60 DUAL_STUS_CD_12 Monthly Medicare-Medicaid dual eligibility code - December
61 CST_SHR_GRP_CD_01 Monthly cost sharing group under Part D low-income subsidy - January
62 CST_SHR_GRP_CD_02 Monthly cost sharing group under Part D low-income subsidy - February
63 CST_SHR_GRP_CD_03 Monthly cost sharing group under Part D low-income subsidy - March
64 CST_SHR_GRP_CD_04 Monthly cost sharing group under Part D low-income subsidy - April
65 CST_SHR_GRP_CD_05 Monthly cost sharing group under Part D low-income subsidy - May
66 CST_SHR_GRP_CD_06 Monthly cost sharing group under Part D low-income subsidy - June
67 CST_SHR_GRP_CD_07 Monthly cost sharing group under Part D low-income subsidy - July
68 CST_SHR_GRP_CD_08 Monthly cost sharing group under Part D low-income subsidy - August
69 CST_SHR_GRP_CD_09 Monthly cost sharing group under Part D low-income subsidy - September
70 CST_SHR_GRP_CD_10 Monthly cost sharing group under Part D low-income subsidy - October
71 CST_SHR_GRP_CD_11 Monthly cost sharing group under Part D low-income subsidy - November
72 CST_SHR_GRP_CD_12 Monthly cost sharing group under Part D low-income subsidy - December