Back to top

File Version: CCW data documentation April, 2019

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

Short SAS NameLong SAS NameVariable Name
1BENE_IDBENE_IDEncrypted CCW Beneficiary ID
2SAMPLE_GROUPSAMPLE_GROUPCCW Beneficiary Random Sample Group
3ENC_JOIN_KEYENC_JOIN_KEYUnique Encounter Join Key
4CLM_TYPE_CDCLM_TYPE_CDClaim Type Code
5CLM_FROM_DTClaim From Date (Encounter)
6CLM_THRU_DTClaim Through Date (Encounter)
7SRVC_MONTHSRVC_MONTHService Month
8CLM_CHRT_RVW_SWCLM_CHRT_RVW_SWClaim Chart Review Switch
9CLM_CNTL_NUMCLM_CNTL_NUMClaim Control Number
10CLM_ORIG_CNTL_NUMCLM_ORIG_CNTL_NUMClaim Original Control Number
11CLM_FINL_ACTN_INDCLM_FINL_ACTN_INDClaim Final Action Indicator
12CLM_LTST_CLM_INDCLM_LTST_CLM_INDLatest Claim Indicator
13EDPS_CREATE_DTEDPS_CREATE_DTEncounter Data Processing System (EDPS) Create Date
14CLM_RCPT_DTCLM_RCPT_DTClaim Receipt Date
15CLM_FAC_TYPE_CDClaim Facility Type Code (Encounter)
16Medicare Advantage Organizations (MAOs)Claim Service Classification Type Code (Encounter)
17CLM_FREQ_CDClaim Frequency Code (Encounter)
18CNTRCT_NUMCNTRCT_NUMMedicare Part C Contract Number
19CNTRCT_PBP_NUMCNTRCT_PBP_NUMMedicare Part C Plan Benefit Package (PBP) Number
20CLM_MDCL_RECClaim Medical Record Number (Encounter)
21ORG_NPI Organization NPI Number (Encounter)
22ORG_TXNMY_CDORG_TXNMY_CDOrganization Taxonomy Code
23RNDRNG_PHYSN_NPIRendering Physician NPI (Encounter)
24RFRG_PHYSN_NPICarrier/DME Referring Physician NPI Number
25AT_PHYSN_NPIClaim Attending Physician NPI Number (Encounter)
26AT_PHYSN_TXNMY_CDAT_PHYSN_TXNMY_CDClaim Attending Physician Taxonomy Code
27OP_PHYSN_NPI Claim Operating Physician NPI Number (Encounter)
28OT_PHYSN_NPI Claim Other Physician NPI Number (Encounter)
29PTNT_DSCHRG_STUS_CDPatient Discharge Status Code (Encounter)
30PRNCPAL_DGNS_CDClaim Principal Diagnosis Code (Encounter)
31ICD_DGNS_CD1Claim Diagnosis Code I (Encounter)
32ICD_DGNS_CD2 Claim Diagnosis Code II (Encounter)
33ICD_DGNS_CD3Claim Diagnosis Code III (Encounter)
34ICD_DGNS_CD4Claim Diagnosis Code IV (Encounter)
35ICD_DGNS_CD5 Claim Diagnosis Code V (Encounter)
36ICD_DGNS_CD6Claim Diagnosis Code VI (Encounter)
37ICD_DGNS_CD7 Claim Diagnosis Code VII (Encounter)
38ICD_DGNS_CD8Claim Diagnosis Code VIII (Encounter)
39ICD_DGNS_CD9 Claim Diagnosis Code IX (Encounter)
40ICD_DGNS_CD10Claim Diagnosis Code X (Encounter)
41ICD_DGNS_CD11Claim Diagnosis Code XI (Encounter)
42ICD_DGNS_CD12Claim Diagnosis Code XII (Encounter)
43ICD_DGNS_CD13 Claim Diagnosis Code XIII (Encounter)
44ICD_DGNS_CD14Claim Diagnosis Code XIV (Encounter)
45ICD_DGNS_CD15Claim Diagnosis Code XV (Encounter)
46ICD_DGNS_CD16 Claim Diagnosis Code XVI (Encounter)
47ICD_DGNS_CD17 Claim Diagnosis Code XVII (Encounter)
48ICD_DGNS_CD18 Claim Diagnosis Code XVIII (Encounter)
49ICD_DGNS_CD19 Claim Diagnosis Code XIX (Encounter)
50ICD_DGNS_CD20 Claim Diagnosis Code XX (Encounter)
51ICD_DGNS_CD21Claim Diagnosis Code XXI (Encounter)
52ICD_DGNS_CD22Claim Diagnosis Code XXII (Encounter)
53ICD_DGNS_CD23 Claim Diagnosis Code XXIII (Encounter)
54ICD_DGNS_CD24Claim Diagnosis Code XXIV (Encounter)
55ICD_DGNS_CD25 Claim Diagnosis Code XXV (Encounter)
56CLM_1ST_DGNS_E_CDFirst Claim Diagnosis E Code (Encounter)
57ICD_DGNS_E_CD1Claim Diagnosis E Code I (Encounter)
58ICD_DGNS_E_CD2Claim Diagnosis E Code II (Encounter)
59ICD_DGNS_E_CD3Claim Diagnosis E Code III (Encounter)
60ICD_DGNS_E_CD4Claim Diagnosis E Code IV (Encounter)
61ICD_DGNS_E_CD5Claim Diagnosis E Code V (Encounter)
62ICD_DGNS_E_CD6Claim Diagnosis E Code VI (Encounter)
63ICD_DGNS_E_CD7Claim Diagnosis E Code VII (Encounter)
64ICD_DGNS_E_CD8Claim Diagnosis E Code VIII (Encounter)
65ICD_DGNS_E_CD9Claim Diagnosis E Code IX (Encounter)
66ICD_DGNS_E_CD10Claim Diagnosis E Code X (Encounter)
250RSN_VISIT_CD1Reason for Visit Diagnosis Code I (Encounter)
251RSN_VISIT_CD2Reason for Visit Diagnosis Code II (Encounter)
252RSN_VISIT_CD3Reason for Visit Diagnosis Code III (Encounter)
254ICD_PRCDR_CD1Claim Procedure Code I (Encounter)
255ICD_PRCDR_CD2Claim Procedure Code II (Encounter)
256ICD_PRCDR_CD3Claim Procedure Code III (Encounter)
257ICD_PRCDR_CD4Claim Procedure Code IV (Encounter)
258ICD_PRCDR_CD5Claim Procedure Code V (Encounter)
259ICD_PRCDR_CD6Claim Procedure Code VI (Encounter)
260ICD_PRCDR_CD7Claim Procedure Code VII (Encounter)
261ICD_PRCDR_CD8Claim Procedure Code VIII (Encounter)
262ICD_PRCDR_CD9Claim Procedure Code IX (Encounter)
263ICD_PRCDR_CD10Claim Procedure Code X (Encounter)
264ICD_PRCDR_CD11Claim Procedure Code XI (Encounter)
265ICD_PRCDR_CD12Claim Procedure Code XII (Encounter)
266ICD_PRCDR_CD13Claim Procedure Code XIII (Encounter)
70PRCDR_DT1Claim Procedure Code I Date (Encounter)
71PRCDR_DT2Claim Procedure Code II Date (Encounter)
72PRCDR_DT3Claim Procedure Code III Date (Encounter)
73PRCDR_DT4Claim Procedure Code IV Date (Encounter)
74PRCDR_DT5Claim Procedure Code V Date (Encounter)
75PRCDR_DT6Claim Procedure Code VI Date (Encounter)
76PRCDR_DT7Claim Procedure Code VII Date (Encounter)
77PRCDR_DT8Claim Procedure Code VIII Date (Encounter)
78PRCDR_DT9Claim Procedure Code IX Date (Encounter)
79PRCDR_DT10Claim Procedure Code X Date (Encounter)
80PRCDR_DT11Claim Procedure Code XI Date (Encounter)
81PRCDR_DT12Claim Procedure Code XII Date (Encounter)
82PRCDR_DT13Claim Procedure Code XIII Date (Encounter)
83CLM_OBSLT_DTCLM_OBSLT_DTClaim Obsolete Date
84CLM_BPRVDR_CITY_NAMECLM_BPRVDR_CITY_NAMEBilling Provider Address - City
85CLM_BPRVDR_USPS_STATE_CDCLM_BPRVDR_USPS_STATE_CDBilling Provider Address - USPS State Code
86CLM_BPRVDR_ADR_ZIP_CDCLM_BPRVDR_ADR_ZIP_CDBilling Provider Zip Code
87CLM_SUBSCR_CITY_NAMECLM_SUBSCR_CITY_NAMEMedicare Subscriber Address - City
88CLM_SUBSCR_USPS_STATE_CDCLM_SUBSCR_USPS_STATE_CDMedicare Subscriber Address - USPS State Code
89CLM_SUBSCR_ADR_ZIP_CDCLM_SUBSCR_ADR_ZIP_CDMedicare Subscriber Address - ZIP Code
90BENE_CNTY_CDBENE_CNTY_CDBeneficiary County Code from Claim (SSA)
91BENE_STATE_CDBeneficiary Residence (SSA) State Code (Encounter)
92BENE_MLG_CNTCT_ZIP_CDBENE_MLG_CNTCT_ZIP_CDBeneficiary ZIP Code of Residence from Claim
93GNDR_CDGNDR_CDGender Code from Encounter record
94RACEBENE_RACE_CDBeneficiary Race Code (Encounter)
95DOB_DTDOB_DTDate of Birth from Encounter
96BENE_MDCR_STUS_CDBENE_MDCR_STUS_CDBeneficiary Medicare Status Code
97TAX_NUMTAX_NUMProvider Tax Number
98BENE_STATEBENE_STATEState of beneficiary (postal abbreviation)

Revenue Center File

Short SAS NameLong SAS NameVariable Name
1BENE_IDBENE_IDEncrypted CCW Beneficiary ID
2ENC_JOIN_KEYENC_JOIN_KEYUnique Encounter Join Key
3CLM_TYPE_CDCLM_TYPE_CDClaim Type Code
20CLM_LINE_NUMClaim Line Number (Encounter)
21LINE_NUM_ORIGOriginal Claim Line Number
5CLM_THRU_DTClaim Through Date (Encounter)
6REV_CNTRRevenue Center Code (Encounter)
7REV_CNTR_FROM_DTREV_CNTR_FROM_DTRevenue Center From Date
8REV_CNTR_THRU_DTREV_CNTR_THRU_DTRevenue Center Thru Date
9REV_CNTR_UNIT_CNTRevenue Center Unit Count (Encounter)
10HCPCS_CDHealthcare Common Procedure Coding System (HCPCS) Code (Encounter)
11HCPCS_1ST_MDFR_CDHCPCS Initial Modifier Code (Encounter)
12HCPCS_2ND_MDFR_CDHCPCS Second Modifier Code (Encounter)
13HCPCS_3RD_MDFR_CDHCPCS Third Modifier Code (Encounter)
14HCPCS_4TH_MDFR_CDHCPCS Fourth Modifier Code (Encounter)
15REV_CNTR_IDE_NDC_UPC_NUMRevenue Center IDE, NDC, or UPC Number (Encounter)
16REV_CNTR_NDC_QTYRevenue Center National Drug Code (NDC) Quantity (Encounter)
17REV_CNTR_NDC_QTY_QLFR_CDRevenue Center NDC Quantity Qualifier Code (Encounter)
18RNDRNG_PHYSN_NPIREV_CNTR_RNDRNG_PHYSN_NPI_NUMRevenue Center Rendering Physician NPI
19LINE_LTST_CLM_INDLINE_LTST_CLM_INDLine Latest Claim Indicator

Condition Code File

Short SAS NameLong SAS NameVariable Name
1BENE_IDBENE_IDEncrypted CCW Beneficiary ID
2ENC_JOIN_KEYENC_JOIN_KEYUnique Encounter Join Key
3CLM_TYPE_CDCLM_TYPE_CDClaim Type Code
4RLTCNDSQRLT_COND_CD_SEQClaim Related Condition Code Sequence
5CLM_RLT_COND_CDClaim Related Condition Code (Encounter)

Occurrence Code File

Short SAS NameLong SAS NameVariable Name
1BENE_IDBENE_IDEncrypted CCW Beneficiary ID
2ENC_JOIN_KEYENC_JOIN_KEYUnique Encounter Join Key
3CLM_TYPE_CDCLM_TYPE_CDClaim Type Code
4RLTOCRSQRLT_OCRNC_CD_SEQClaim Related Occurrence Code Sequence
5CLM_RLT_OCRNC_CDClaim Related Occurrence Code (Encounter)
6CLM_RLT_OCRNC_DTClaim Related Occurrence Date (Encounter)

Span Code File

Short SAS NameLong SAS NameVariable Name
1BENE_IDBENE_IDEncrypted CCW Beneficiary ID
2ENC_JOIN_KEYENC_JOIN_KEYUnique Encounter Join Key
3CLM_TYPE_CDCLM_TYPE_CDClaim Type Code
4RLTSPNSQRLT_SPAN_CD_SEQClaim Related Span Code Sequence
5CLM_SPAN_CDClaim Occurrence Span Code (Encounter)
6CLM_SPAN_FROM_DTClaim Occurrence Span From Date (Encounter)
7CLM_SPAN_THRU_DTClaim Occurrence Span Through Date (Encounter)

Value Code File

Short SAS NameLong SAS NameVariable Name
1BENE_IDBENE_IDEncrypted CCW Beneficiary ID
2ENC_JOIN_KEYENC_JOIN_KEYUnique Encounter Join Key
3CLM_TYPE_CDCLM_TYPE_CDClaim Type Code
4RLTVALSQRLT_VAL_CD_SEQClaim Related Value Code Sequence
5CLM_VAL_CDClaim Value Code (Encounter)
CSV