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 ADMSN_DT Admission date (MAX)
40 SRVC_BGN_DT Beginning date of service
41 SRVC_END_DT Ending date of service
42 DIAG_CD_1 Principle Diagnosis code
43 ICD_DGNS_VRSN_CD1 Claim Diagnosis Code 1 Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
44 DIAG_CD_2 Diagnosis codes (2nd diagnosis)
45 DIAG_CD_3 Diagnosis codes (3rd diagnosis)
46 DIAG_CD_4 Diagnosis codes (4th diagnosis)
47 DIAG_CD_5 Diagnosis codes (5th diagnosis)
48 MDCD_CVRD_MENTL_DAY_CNT Mental hospital for the aged days
49 MDCD_CVRD_PSYCH_DAY_CNT Inpatient Psychiatric (age < 21) days
50 INTRMDT_FAC_MR_DAY_CNT ICF-MR days
51 NRSNG_FAC_DAY_CNT Nursing facility days
52 LT_CARE_LVE_DAY_CNT Leave days
53 PATIENT_STATUS_CD Patient status
54 PATIENT_LIB_AMT Patient liability amount
55 UPDT_DT MAX File Update Date