Data Documentation

Medicaid Analytic Extract Other Services

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