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 Long Term Care File
Back to File Overview
File Version:
CCW record layout accessed May, 2019; CMS MAX 2014 data dictionary Aug 18, 2016
CCW Codebook MAX Long Term Care_Version 2014.pdf
444.08 KB
CCW Record Layout MAX_Version 022023_2.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
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