Reminder: DUA and VRDC access needs to be extended or renewed annually. Read more.
Skip to main content
Toggle navigation
Find CMS Data Files
Request CMS Data Files
Search Data Variables
Learn About CMS Data
Data Documentation
MAX Prescription Drug File
Back to File Overview
File Version:
CCW record layout accessed May, 2019; CMS MAX 2014 data dictionary Aug 18, 2016
CCW Codebook MAX Drug_Version 2014.pdf
456.55 KB
CCW Record Layout MAX_Version 022023_3.xlsx
95.87 KB
Number
SAS Name
Variable Name
1
BENE_ID
Encrypted 723 CCW Beneficiary ID
2
MSIS_ID
Encrypted MSIS Identification Number
3
STATE_CD
State
4
YR_NUM
Year of MAX Record
5
EL_DOB
Birth date
6
EL_SEX_CD
Sex (MAX)
7
EL_RACE_ETHNCY_CD
Race/ethnicity (from MSIS)
8
RACE_CODE_1
Race - White (from MSIS)
9
RACE_CODE_2
Race - Black (from MSIS)
10
RACE_CODE_3
Race - Am Indian/Alaskan (from MSIS)
11
RACE_CODE_4
Race - Asian (from MSIS)
12
RACE_CODE_5
Race - Hawaiian/Pac Islands (from MSIS)
13
ETHNICITY_CODE
Ethnicity - Hispanic (from MSIS)
14
EL_SS_ELGBLTY_CD_LTST
State specific eligibility - most recent
15
EL_SS_ELGBLTY_CD_MO
State specific eligibility - mo of svc
16
EL_MAX_ELGBLTY_CD_LTST
MAX eligibility - most recent
17
EL_MAX_ELGBLTY_CD_MO
MAX eligibility - mo of svc
18
EL_MDCR_ANN_XOVR_OLD
Medicare Crossover code (Annual) old values
19
MSNG_ELG_DATA
Missing eligibility data
20
EL_MDCR_XOVR_CLM_BSD_CD
Crossover code (from claims only)
21
EL_MDCR_ANN_XOVR_99
Crossover code (Annual)
22
MSIS_TOS
MSIS Type of Service (TOS)
23
MSIS_TOP
MSIS Type of Program (TOP)
24
MAX_TOS
MAX Type of Service (TOS)
25
PRVDR_ID_NMBR
Billing provider identification number (MAX)
26
NPI
National Provider Identifier (MAX)
27
TAXONOMY
Provider Taxonomy
28
TYPE_CLM_CD
Type of claim
29
ADJUST_CD
Adjustment code
30
PHP_TYPE
Managed care type of plan code
31
PHP_ID
Managed care plan identification code
32
MDCD_PYMT_AMT
Medicaid payment amount
33
TP_PYMT_AMT
Third party payment amount
34
PYMT_DT
Payment/adjudication date
35
CHRG_AMT
Charge amount
36
PHP_VAL
Prepaid plan value
37
MDCR_COINSUR_PYMT_AMT
Medicare coinsurance payment amount
38
MDCR_DED_PYMT_AMT
Medicare deductible payment amount
39
PRES_PHYSICIAN_ID_NUM
Prescribing physician id number
40
PRSC_WRTE_DT
Prescribed date
41
PRSCRPTN_FILL_DT
Prescription fill date (MAX)
42
NEW_REFILL_IND
New or refill indicator
43
NDC
National Drug Code (NDC)
44
QTY_SRVC_UNITS
Quantity of service
45
DAYS_SUPPLY
Days Supply (MAX)