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.

CCW Codebook - Medicare Encounter Records

CCW Record Layout - Medicare Encounter Records

Base Claim File

Line File

Base Claim File
SAS Name	Variable Name
BENE_ID	Encrypted CCW Beneficiary ID
SAMPLE_GROUP	CCW Beneficiary Random Sample Group
ENC_JOIN_KEY	Unique Encounter Join Key
CLM_TYPE_CD	Claim Type Code
CLM_FROM_DT	Claim From Date (Encounter)
CLM_THRU_DT	Claim Through Date (Encounter)
SRVC_MONTH	Service Month
CLM_CHRT_RVW_SW	Claim Chart Review Switch
CLM_CNTL_NUM	Claim Control Number
CLM_ORIG_CNTL_NUM	Claim Original Control Number
CLM_FINL_ACTN_IND	Claim Final Action Indicator
CLM_LTST_CLM_IND	Latest Claim Indicator
EDPS_CREATE_DT	Encounter Data Processing System (EDPS) Create Date
CLM_RCPT_DT	Claim Receipt Date
CLM_FREQ_CD	Claim Frequency Code (Encounter)
CNTRCT_NUM	Medicare Part C Contract Number
CNTRCT_PBP_NUM	Medicare Part C Plan Benefit Package (PBP) Number
CLM_MDCL_REC	Claim Medical Record Number (Encounter)
ORG_NPI	Organization NPI Number (Encounter)
ORG_TXNMY_CD	Organization Taxonomy Code
CLM_PLACE_OF_SRVC_CD	Claim Place of Service Code
CLM_RNDRNG_PHYSN_NPI_NUM	Claim Rendering Physician NPI Number
RFR_PHYSN_NPI	Claim Referring Physician NPI Number
PRNCPAL_DGNS_CD	Claim Principal Diagnosis Code (Encounter)
PRNCPAL_DGNS_VRSN_CD	Claim Principal Diagnosis Version Code (Encounter)
ICD_DGNS_CD1	Claim Diagnosis Code 1 (Encounter)
ICD_DGNS_VRSN_CD1	Claim Diagnosis Code 1 Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
ICD_DGNS_CD2	Claim Diagnosis Code 2 (Encounter)
ICD_DGNS_VRSN_CD2	Claim Diagnosis Code 2 Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
ICD_DGNS_CD3	Claim Diagnosis Code 3 (Encounter)
ICD_DGNS_VRSN_CD3	Claim Diagnosis Code 3 Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
ICD_DGNS_CD4	Claim Diagnosis Code 4 (Encounter)
ICD_DGNS_VRSN_CD4	Claim Diagnosis Code 4 Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
ICD_DGNS_CD5	Claim Diagnosis Code 5 (Encounter)
ICD_DGNS_VRSN_CD5	Claim Diagnosis Code 5 Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
ICD_DGNS_CD6	Claim Diagnosis Code 6 (Encounter)
ICD_DGNS_VRSN_CD6	Claim Diagnosis Code 6 Diagnosis Version Code (ICD-9/ICD-10) (Encounter)
ICD_DGNS_CD7	Claim Diagnosis Code 7 (Encounter)
ICD_DGNS_VRSN_CD7	Claim Diagnosis Code 7 Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
ICD_DGNS_CD8	Claim Diagnosis Code 8 (Encounter)
ICD_DGNS_VRSN_CD8	Claim Diagnosis Code 8 Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
ICD_DGNS_CD9	Claim Diagnosis Code 9 (Encounter)
ICD_DGNS_VRSN_CD9	Claim Diagnosis Code 9 Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
ICD_DGNS_CD10	Claim Diagnosis Code 10 (Encounter)
ICD_DGNS_VRSN_CD10	Claim Diagnosis Code 10 Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
ICD_DGNS_CD11	Claim Diagnosis Code 11 (Encounter)
ICD_DGNS_VRSN_CD11	Claim Diagnosis Code 11 Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
ICD_DGNS_CD12	Claim Diagnosis Code 12 (Encounter)
ICD_DGNS_VRSN_CD12	Claim Diagnosis Code 12 Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
ICD_DGNS_CD13	Claim Diagnosis Code 13 (Encounter)
ICD_DGNS_VRSN_CD13	Claim Diagnosis Code 13 Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
CLM_OBSLT_DT	Claim Obsolete Date
CLM_BPRVDR_CITY_NAME	Billing Provider Address - City
CLM_BPRVDR_USPS_STATE_CD	Billing Provider Address - USPS State Code
CLM_BPRVDR_ADR_ZIP_CD	Billing Provider Zip Code
CLM_SUBSCR_CITY_NAME	Medicare Subscriber Address - City
CLM_SUBSCR_USPS_STATE_CD	Medicare Subscriber Address - USPS State Code
CLM_SUBSCR_ADR_ZIP_CD	Medicare Subscriber Address - ZIP Code
BENE_CNTY_CD	Beneficiary County Code from Claim (SSA)
BENE_STATE_CD	Beneficiary Residence (SSA) State Code (Encounter)
BENE_MLG_CNTCT_ZIP_CD	Beneficiary ZIP Code of Residence from Claim
BENE_RACE_CD	Beneficiary Race Code (Encounter)
DOB_DT	Date of Birth from Encounter
BENE_MDCR_STUS_CD	Beneficiary Medicare Status Code
TAX_NUM	Provider Tax Number
BENE_STATE	State of beneficiary (postal abbreviation)

Line File
SAS Name	Variable Name
BENE_ID	Encrypted CCW Beneficiary ID
ENC_JOIN_KEY	Unique Encounter Join Key
CLM_TYPE_CD	Claim Type Code
CLM_LINE_NUM	Claim Line Number (Encounter)
LINE_NUM_ORIG	Original Claim Line Number
CLM_THRU_DT	Claim Through Date (Encounter)
PRVDR_NPI	Line Rendering Physician NPI
PRVDR_SPCLTY	Line CMS Provider Specialty Code
LINE_SRVC_CNT	Line Service Count (Encounter)
LINE_PLACE_OF_SRVC_CD	Line Place of Service Code (Encounter)
LINE_1ST_EXPNS_DT	Line First Expense Date (Encounter)
LINE_LAST_EXPNS_DT	Line Last Expense Date (Encounter)
HCPCS_CD	Healthcare Common Procedure Coding System (HCPCS) Code (Encounter)
HCPCS_1ST_MDFR_CD	HCPCS Initial Modifier Code (Encounter)
HCPCS_2ND_MDFR_CD	HCPCS Second Modifier Code (Encounter)
HCPCS_3RD_MDFR_CD	HCPCS Third Modifier Code (Encounter)
HCPCS_4TH_MDFR_CD	HCPCS Fourth Modifier Code (Encounter)
LINE_NDC_CD	Line National Drug Code (NDC) (Encounter)
LINE_RX_NUM	Carrier Line RX Number (Encounter)
LINE_LTST_CLM_IND	Line Latest Claim Indicator