File Version:
CCW record layout accessed May, 2019; CMS MAX 2014 data dictionary Aug 18, 2016
File Version:
CCW record layout accessed May, 2019; CMS MAX 2014 data dictionary Aug 18, 2016
NumberSAS NameVariable 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)