Back to top

File Version: CCW record layout accessed May, 2019; CMS MAX 2014 data dictionary Aug 18, 2016

Short SAS NameLong SAS NameVariable Name
1BENE_IDBENE_IDEncrypted 723 CCW Beneficiary ID
2 MSIS_IDEncrypted MSIS Identification Number
3 STATE_CDState
4 YR_NUMYear of MAX Record
5 EL_DOB Birth date
6EL_SEX_CDSex (MAX)
7 EL_RACE_ETHNCY_CDRace/ethnicity (from MSIS)
8RACE_CODE_1Race - White (from MSIS)
9 RACE_CODE_2Race - Black (from MSIS)
10 RACE_CODE_3Race - Am Indian/Alaskan (from MSIS)
11 RACE_CODE_4Race - Asian (from MSIS)
12 RACE_CODE_5Race - Hawaiian/Pac Islands (from MSIS)
13 ETHNICITY_CODEEthnicity - Hispanic (from MSIS)
14 EL_SS_ELGBLTY_CD_LTSTState specific eligibility - most recent
15 EL_SS_ELGBLTY_CD_MOState specific eligibility - mo of svc
16EL_MAX_ELGBLTY_CD_LTSTMAX eligibility - most recent
17EL_MAX_ELGBLTY_CD_MOMAX eligibility - mo of svc
18 EL_MDCR_ANN_XOVR_OLDCrossover code (Annual) old values
19 MSNG_ELG_DATA Missing eligibility data
20 EL_MDCR_XOVR_CLM_BSD_CDCrossover code (from claims only)
21EL_MDCR_ANN_XOVR_99Crossover code (Annual)
22 MSIS_TOS MSIS Type of Service (TOS)
23 MSIS_TOPMSIS Type of Program (TOP)
24 MAX_TOSMAX Type of Service (TOS)
25 PRVDR_ID_NMBR Billing provider identification number
26 NPI National Provider Identifier
27 TAXONOMY Provider Taxonomy
28 TYPE_CLM_CD Type of claim
29 ADJUST_CDAdjustment code
30 PHP_TYPEManaged care type of plan code
31 PHP_IDManaged care plan identification code
32 MDCD_PYMT_AMTMedicaid payment amount
33 TP_PYMT_AMTThird party payment amount
34 PYMT_DTPayment/adjudication date
35 CHRG_AMTCharge amount
36 PHP_VALPrepaid plan value
37 MDCR_COINSUR_PYMT_AMTMedicare coinsurance payment amount
38 MDCR_DED_PYMT_AMTMedicare deductible payment amount
39 ADMSN_DTAdmission date
40 SRVC_BGN_DTBeginning date of service
41 SRVC_END_DTEnding date of service
42 DIAG_CD_1Principle Diagnosis code
43 DIAG_CD_2 Diagnosis codes (2nd diagnosis)
44 DIAG_CD_3 Diagnosis codes (3rd diagnosis)
45 DIAG_CD_4Diagnosis codes (4th diagnosis)
46 DIAG_CD_5Diagnosis codes (5th diagnosis)
47 MDCD_CVRD_MENTL_DAY_CNTMental hospital for the aged days
48 MDCD_CVRD_PSYCH_DAY_CNTInpatient Psychiatric (age < 21) days
49 INTRMDT_FAC_MR_DAY_CNTICF-MR days
50 NRSNG_FAC_DAY_CNT Nursing facility days
51 LT_CARE_LVE_DAY_CNTLeave days
52 PATIENT_STATUS_CDPatient status
53 PATIENT_LIB_AMTPatient liability amount
CSV