File Version:
CCW data documentation 4/26/2018

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.

File Version:
CCW data documentation 4/26/2018

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.

Base Claim File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 SAMPLE_GROUP CCW Beneficiary Random Sample Group
3 ENC_JOIN_KEY Unique Encounter Join Key
4 CLM_TYPE_CD Claim Type Code
5 CLM_FROM_DT Claim From Date (Encounter)
6 CLM_THRU_DT Claim Through Date (Encounter)
7 SRVC_MONTH Service Month
8 CLM_CHRT_RVW_SW Claim Chart Review Switch
9 CLM_CNTL_NUM Claim Control Number
10 CLM_ORIG_CNTL_NUM Claim Original Control Number
11 CLM_FINL_ACTN_IND Claim Final Action Indicator
12 CLM_LTST_CLM_IND Latest Claim Indicator
13 EDPS_CREATE_DT Encounter Data Processing System (EDPS) Create Date
14 CLM_RCPT_DT Claim Receipt Date
15 CLM_FAC_TYPE_CD Claim Facility Type Code (Encounter)
16 CLM_SRVC_CLSFCTN_TYPE_CD Claim Service Classification Type Code (Encounter)
17 CLM_FREQ_CD Claim Frequency Code (Encounter)
18 CNTRCT_NUM Medicare Part C Contract Number
19 CNTRCT_PBP_NUM Medicare Part C Plan Benefit Package (PBP) Number
20 CLM_MDCL_REC Claim Medical Record Number (Encounter)
21 ORG_NPI Organization NPI Number (Encounter)
22 ORG_TXNMY_CD Organization Taxonomy Code
23 RNDRNG_PHYSN_NPI Rendering Physician NPI (Encounter)
24 RFRG_PHYSN_NPI Carrier/DME Referring Physician NPI Number
25 AT_PHYSN_NPI Claim Attending Physician NPI Number (Encounter)
26 AT_PHYSN_TXNMY_CD Claim Attending Physician Taxonomy Code
27 OP_PHYSN_NPI Claim Operating Physician NPI Number (Encounter)
28 OT_PHYSN_NPI Claim Other Physician NPI Number (Encounter)
29 CLM_ADMSN_DT Claim Admission Date (Encounter)
30 PTNT_DSCHRG_STUS_CD Patient Discharge Status Code (Encounter)
31 BENE_DSCHRG_DT Beneficiary Discharge Date
32 PRNCPAL_DGNS_CD Claim Principal Diagnosis Code (Encounter)
33 ICD_DGNS_CD1 Claim Diagnosis Code 1 (Encounter)
34 ICD_DGNS_CD2 Claim Diagnosis Code 2 (Encounter)
35 ICD_DGNS_CD3 Claim Diagnosis Code 3 (Encounter)
36 ICD_DGNS_CD4 Claim Diagnosis Code 4 (Encounter)
37 ICD_DGNS_CD5 Claim Diagnosis Code 5 (Encounter)
38 ICD_DGNS_CD6 Claim Diagnosis Code 6 (Encounter)
39 ICD_DGNS_CD7 Claim Diagnosis Code 7 (Encounter)
40 ICD_DGNS_CD8 Claim Diagnosis Code 8 (Encounter)
41 ICD_DGNS_CD9 Claim Diagnosis Code 9 (Encounter)
42 ICD_DGNS_CD10 Claim Diagnosis Code 10 (Encounter)
43 ICD_DGNS_CD11 Claim Diagnosis Code 11 (Encounter)
44 ICD_DGNS_CD12 Claim Diagnosis Code 12 (Encounter)
45 ICD_DGNS_CD13 Claim Diagnosis Code 13 (Encounter)
46 ICD_DGNS_CD14 Claim Diagnosis Code 14 (Encounter)
47 ICD_DGNS_CD15 Claim Diagnosis Code 15 (Encounter)
48 ICD_DGNS_CD16 Claim Diagnosis Code 16 (Encounter)
49 ICD_DGNS_CD17 Claim Diagnosis Code 17 (Encounter)
50 ICD_DGNS_CD18 Claim Diagnosis Code 18 (Encounter)
51 ICD_DGNS_CD19 Claim Diagnosis Code 19 (Encounter)
52 ICD_DGNS_CD20 Claim Diagnosis Code 20 (Encounter)
53 ICD_DGNS_CD21 Claim Diagnosis Code 21 (Encounter)
54 ICD_DGNS_CD22 Claim Diagnosis Code 22 (Encounter)
55 ICD_DGNS_CD23 Claim Diagnosis Code 23 (Encounter)
56 ICD_DGNS_CD24 Claim Diagnosis Code 24 (Encounter)
57 ICD_DGNS_CD25 Claim Diagnosis Code 25 (Encounter)
58 CLM_1ST_DGNS_E_CD First Claim Diagnosis E Code (Encounter)
59 ICD_DGNS_E_CD1 Claim Diagnosis E Code 1 (Encounter)
60 ICD_DGNS_E_CD2 Claim Diagnosis E Code 2 (Encounter)
61 ICD_DGNS_E_CD3 Claim Diagnosis E Code 3 (Encounter)
62 RSN_VISIT_CD1 Reason for Visit Diagnosis Code 1 (Encounter)
63 RSN_VISIT_CD2 Reason for Visit Diagnosis Code 2 (Encounter)
64 RSN_VISIT_CD3 Reason for Visit Diagnosis Code 3 (Encounter)
65 CLM_OBSLT_DT Claim Obsolete Date
66 CLM_BPRVDR_CITY_NAME Billing Provider Address - City
67 CLM_BPRVDR_USPS_STATE_CD Billing Provider Address - USPS State Code
68 CLM_BPRVDR_ADR_ZIP_CD Billing Provider Zip Code
69 CLM_SUBSCR_CITY_NAME Medicare Subscriber Address - City
70 CLM_SUBSCR_USPS_STATE_CD Medicare Subscriber Address - USPS State Code
71 CLM_SUBSCR_ADR_ZIP_CD Medicare Subscriber Address - ZIP Code
72 BENE_CNTY_CD Beneficiary County Code from Claim (SSA)
73 BENE_STATE_CD Beneficiary Residence (SSA) State Code (Encounter)
74 BENE_MLG_CNTCT_ZIP_CD Beneficiary ZIP Code of Residence from Claim
75 GNDR_CD Gender Code from Encounter record
76 BENE_RACE_CD Beneficiary Race Code (Encounter)
77 DOB_DT Date of Birth from Encounter
78 BENE_MDCR_STUS_CD Beneficiary Medicare Status Code
79 TAX_NUM Provider Tax Number
80 BENE_STATE State of beneficiary (postal abbreviation)

Revenue Center File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 ENC_JOIN_KEY Unique Encounter Join Key
3 CLM_TYPE_CD Claim Type Code
4 CLM_LINE_NUM Claim Line Number (Encounter)
5 LINE_NUM_ORIG Original Claim Line Number
6 CLM_THRU_DT Claim Through Date (Encounter)
7 REV_CNTR Revenue Center Code (Encounter)
8 REV_CNTR_FROM_DT Revenue Center From Date
9 REV_CNTR_THRU_DT Revenue Center Thru Date
10 REV_CNTR_UNIT_CNT Revenue Center Unit Count (Encounter)
11 HCPCS_CD Healthcare Common Procedure Coding System (HCPCS) Code (Encounter)
12 HCPCS_1ST_MDFR_CD HCPCS Initial Modifier Code (Encounter)
13 HCPCS_2ND_MDFR_CD HCPCS Second Modifier Code (Encounter)
14 HCPCS_3RD_MDFR_CD HCPCS Third Modifier Code (Encounter)
15 REV_CNTR_IDE_NDC_UPC_NUM Revenue Center IDE, NDC, or UPC Number (Encounter)
16 REV_CNTR_NDC_QTY Revenue Center National Drug Code (NDC) Quantity (Encounter)
17 REV_CNTR_NDC_QTY_QLFR_CD Revenue Center NDC Quantity Qualifier Code (Encounter)
18 REV_CNTR_RNDRNG_PHYSN_NPI_NUM Revenue Center Rendering Physician NPI
19 LINE_LTST_CLM_IND Line Latest Claim Indicator

Condition Code File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 ENC_JOIN_KEY Unique Encounter Join Key
3 CLM_TYPE_CD Claim Type Code
4 RLT_COND_CD_SEQ Claim Related Condition Code Sequence
5 CLM_RLT_COND_CD Claim Related Condition Code (Encounter)

Occurrence Code File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 ENC_JOIN_KEY Unique Encounter Join Key
3 CLM_TYPE_CD Claim Type Code
4 RLT_OCRNC_CD_SEQ Claim Related Occurrence Code Sequence
5 CLM_RLT_OCRNC_CD Claim Related Occurrence Code (Encounter)
6 CLM_RLT_OCRNC_DT Claim Related Occurrence Date (Encounter)

Span Code File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 ENC_JOIN_KEY Unique Encounter Join Key
3 CLM_TYPE_CD Claim Type Code
4 RLT_SPAN_CD_SEQ Claim Related Span Code Sequence
5 CLM_SPAN_CD Claim Occurrence Span Code (Encounter)
6 CLM_SPAN_FROM_DT Claim Occurrence Span From Date (Encounter)
7 CLM_SPAN_THRU_DT Claim Occurrence Span Through Date (Encounter)

Value Code File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 ENC_JOIN_KEY Unique Encounter Join Key
3 CLM_TYPE_CD Claim Type Code
4 RLT_VAL_CD_SEQ Claim Related Value Code Sequence
5 CLM_VAL_CD Claim Value Code (Encounter)