Data Documentation

Medicaid Analytic Extract Other Services
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.

CCW Record Layout - MAX

SAS Name Variable Name
BENE_ID Encrypted 723 CCW Beneficiary ID
MSIS_ID Encrypted MSIS Identification Number
STATE_CD State
YR_NUM Year of MAX Record
EL_DOB Birth date
EL_SEX_CD Sex (MAX)
EL_RACE_ETHNCY_CD Race/ethnicity (from MSIS)
RACE_CODE_1 Race - White (from MSIS)
RACE_CODE_2 Race - Black (from MSIS)
RACE_CODE_3 Race - Am Indian/Alaskan (from MSIS)
RACE_CODE_4 Race - Asian (from MSIS)
RACE_CODE_5 Race - Hawaiian/Pac Islands (from MSIS)
ETHNICITY_CODE Ethnicity - Hispanic (from MSIS)
EL_SS_ELGBLTY_CD_LTST State specific eligibility - most recent
EL_SS_ELGBLTY_CD_MO State specific eligibility - mo of svc
EL_MAX_ELGBLTY_CD_LTST MAX eligibility - most recent
EL_MAX_ELGBLTY_CD_MO MAX eligibility - mo of svc
EL_MDCR_ANN_XOVR_OLD Medicare Crossover code (Annual) old values
MSNG_ELG_DATA Missing eligibility data
EL_MDCR_XOVR_CLM_BSD_CD Crossover code (from claims only)
EL_MDCR_ANN_XOVR_99 Crossover code (Annual)
MSIS_TOS MSIS Type of Service (TOS)
MSIS_TOP MSIS Type of Program (TOP)
HCBS_TXNMY_WVR_CD Home and community-based services (HCBS) taxonomy code for waviers
MAX_TOS MAX Type of Service (TOS)
CLTC_FLAG Community-based LT care (CLTC) flag
PRVDR_ID_NMBR Billing provider identification number (MAX)
NPI National Provider Identifier (MAX)
TAXONOMY Provider Taxonomy
TYPE_CLM_CD Type of claim
ADJUST_CD Adjustment code
PHP_TYPE Managed care type of plan code
PHP_ID Managed care plan identification code
MDCD_PYMT_AMT Medicaid payment amount
TP_PYMT_AMT Third party payment amount
PYMT_DT Payment/adjudication date
CHRG_AMT Charge amount
PHP_VAL Prepaid plan value
MDCR_COINSUR_PYMT_AMT Medicare coinsurance payment amount
MDCR_DED_PYMT_AMT Medicare deductible payment amount
SRVC_BGN_DT Beginning date of service
SRVC_END_DT Ending date of service
PRCDR_CD_SYS Procedure (service) coding system
PRCDR_CD Procedure (service) code
PRCDR_SRVC_MDFR_CD Procedure (service) code modifier
DIAG_CD_1 Principle Diagnosis code
ICD_DGNS_VRSN_CD1 Claim Diagnosis Code 1 Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
DIAG_CD_2 Diagnosis codes (2nd diagnosis)
QTY_SRVC_UNITS Quantity of service
SRVC_PRVDR_ID_NMBR Servicing provider identification number (MAX)
SRVC_PRVDR_SPEC_CD Servicing provider specialty code (MAX)
PLC_OF_SRVC_CD Place of service
UB_92_REV_CD UB-92 revenue code