Data Documentation

MAX Prescription Drug File
Back to File Overview

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.

Document
record-layout-max.xlsx95.87 KB
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)