Data Documentation

For most files, a table of variables will display below, with links to the variable definitions. If no table displays, or if you need additional information for a specific variable, please see the CCW website. Data documentation is available for all files and codebooks for many.

If you are unable to locate the information you need, please contact ResDAC.

record-layout-max.xlsx95.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