Back to top

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

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)
29CLM_ADMSN_DTClaim Admission Date (Encounter)
30PTNT_DSCHRG_STUS_CDPatient Discharge Status Code (Encounter)
31BENE_DSCHRG_DTBENE_DSCHRG_DTBeneficiary Discharge Date
32PRNCPAL_DGNS_CDClaim Principal Diagnosis Code (Encounter)
33ICD_DGNS_CD1Claim Diagnosis Code I (Encounter)
34ICD_DGNS_CD2 Claim Diagnosis Code II (Encounter)
35ICD_DGNS_CD3Claim Diagnosis Code III (Encounter)
36ICD_DGNS_CD4Claim Diagnosis Code IV (Encounter)
37ICD_DGNS_CD5 Claim Diagnosis Code V (Encounter)
38ICD_DGNS_CD6Claim Diagnosis Code VI (Encounter)
39ICD_DGNS_CD7 Claim Diagnosis Code VII (Encounter)
40ICD_DGNS_CD8Claim Diagnosis Code VIII (Encounter)
41ICD_DGNS_CD9 Claim Diagnosis Code IX (Encounter)
42ICD_DGNS_CD10Claim Diagnosis Code X (Encounter)
43ICD_DGNS_CD11Claim Diagnosis Code XI (Encounter)
44ICD_DGNS_CD12Claim Diagnosis Code XII (Encounter)
45ICD_DGNS_CD13 Claim Diagnosis Code XIII (Encounter)
46ICD_DGNS_CD14Claim Diagnosis Code XIV (Encounter)
47ICD_DGNS_CD15Claim Diagnosis Code XV (Encounter)
48ICD_DGNS_CD16 Claim Diagnosis Code XVI (Encounter)
49ICD_DGNS_CD17 Claim Diagnosis Code XVII (Encounter)
50ICD_DGNS_CD18 Claim Diagnosis Code XVIII (Encounter)
51ICD_DGNS_CD19 Claim Diagnosis Code XIX (Encounter)
52ICD_DGNS_CD20 Claim Diagnosis Code XX (Encounter)
53ICD_DGNS_CD21Claim Diagnosis Code XXI (Encounter)
54ICD_DGNS_CD22Claim Diagnosis Code XXII (Encounter)
55ICD_DGNS_CD23 Claim Diagnosis Code XXIII (Encounter)
56ICD_DGNS_CD24Claim Diagnosis Code XXIV (Encounter)
57ICD_DGNS_CD25 Claim Diagnosis Code XXV (Encounter)
58CLM_1ST_DGNS_E_CDFirst Claim Diagnosis E Code (Encounter)
59ICD_DGNS_E_CD1Claim Diagnosis E Code I (Encounter)
60ICD_DGNS_E_CD2Claim Diagnosis E Code II (Encounter)
61ICD_DGNS_E_CD3Claim Diagnosis E Code III (Encounter)
62RSN_VISIT_CD1Reason for Visit Diagnosis Code I (Encounter)
63RSN_VISIT_CD2Reason for Visit Diagnosis Code II (Encounter)
64RSN_VISIT_CD3Reason for Visit Diagnosis Code III (Encounter)
65CLM_OBSLT_DTCLM_OBSLT_DTClaim Obsolete Date
66CLM_BPRVDR_CITY_NAMECLM_BPRVDR_CITY_NAMEBilling Provider Address - City
67CLM_BPRVDR_USPS_STATE_CDCLM_BPRVDR_USPS_STATE_CDBilling Provider Address - USPS State Code
68CLM_BPRVDR_ADR_ZIP_CDCLM_BPRVDR_ADR_ZIP_CDBilling Provider Zip Code
69CLM_SUBSCR_CITY_NAMECLM_SUBSCR_CITY_NAMEMedicare Subscriber Address - City
70CLM_SUBSCR_USPS_STATE_CDCLM_SUBSCR_USPS_STATE_CDMedicare Subscriber Address - USPS State Code
71CLM_SUBSCR_ADR_ZIP_CDCLM_SUBSCR_ADR_ZIP_CDMedicare Subscriber Address - ZIP Code
72BENE_CNTY_CDBENE_CNTY_CDBeneficiary County Code from Claim (SSA)
73BENE_STATE_CDBeneficiary Residence (SSA) State Code (Encounter)
74BENE_MLG_CNTCT_ZIP_CDBENE_MLG_CNTCT_ZIP_CDBeneficiary ZIP Code of Residence from Claim
75GNDR_CDGNDR_CDGender Code from Encounter record
76RACEBENE_RACE_CDBeneficiary Race Code (Encounter)
77DOB_DTDOB_DTDate of Birth from Encounter
78BENE_MDCR_STUS_CDBENE_MDCR_STUS_CDBeneficiary Medicare Status Code
79TAX_NUMTAX_NUMProvider Tax Number
80BENE_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
19CLM_LINE_NUMClaim Line Number (Encounter)
20LINE_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)
14REV_CNTR_IDE_NDC_UPC_NUMRevenue Center IDE, NDC, or UPC Number (Encounter)
15REV_CNTR_NDC_QTYRevenue Center National Drug Code (NDC) Quantity (Encounter)
16REV_CNTR_NDC_QTY_QLFR_CDRevenue Center NDC Quantity Qualifier Code (Encounter)
17RNDRNG_PHYSN_NPIREV_CNTR_RNDRNG_PHYSN_NPI_NUMRevenue Center Rendering Physician NPI
18LINE_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