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_FREQ_CDClaim Frequency Code (Encounter)
16CNTRCT_NUMCNTRCT_NUMMedicare Part C Contract Number
17CNTRCT_PBP_NUMCNTRCT_PBP_NUMMedicare Part C Plan Benefit Package (PBP) Number
18CLM_MDCL_RECClaim Medical Record Number (Encounter)
19ORG_NPI Organization NPI Number (Encounter)
20ORG_TXNMY_CDORG_TXNMY_CDOrganization Taxonomy Code
21RFR_PHYSN_NPIRFRG_NPIClaim Referring Physician NPI Number
22PRNCPAL_DGNS_CDClaim Principal Diagnosis Code (Encounter)
23PRNCPAL_DGNS_VRSN_CDPRNCPAL_DGNS_VRSN_CDClaim Principal Diagnosis Version Code (FFS)
24ICD_DGNS_CD1Claim Diagnosis Code I (Encounter)
25ICD_DGNS_VRSN_CD1Claim Diagnosis Code I Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
26ICD_DGNS_CD2 Claim Diagnosis Code II (Encounter)
27ICD_DGNS_VRSN_CD2Claim Diagnosis Code II Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
28ICD_DGNS_CD3Claim Diagnosis Code III (Encounter)
29ICD_DGNS_VRSN_CD3Claim Diagnosis Code III Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
30ICD_DGNS_CD4Claim Diagnosis Code IV (Encounter)
31ICD_DGNS_VRSN_CD4Claim Diagnosis Code IV Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
32ICD_DGNS_CD5 Claim Diagnosis Code V (Encounter)
33ICD_DGNS_VRSN_CD5Claim Diagnosis Code V Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
34ICD_DGNS_CD6Claim Diagnosis Code VI (Encounter)
35ICD_DGNS_VRSN_CD6Claim Diagnosis Code VI Diagnosis Version Code (ICD-9/ICD-10) (Encounter)
36ICD_DGNS_CD7 Claim Diagnosis Code VII (Encounter)
37ICD_DGNS_VRSN_CD7Claim Diagnosis Code VII Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
38ICD_DGNS_CD8Claim Diagnosis Code VIII (Encounter)
39ICD_DGNS_VRSN_CD8Claim Diagnosis Code VIII Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
40ICD_DGNS_CD9 Claim Diagnosis Code IX (Encounter)
41ICD_DGNS_VRSN_CD9Claim Diagnosis Code IX Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
42ICD_DGNS_CD10Claim Diagnosis Code X (Encounter)
43ICD_DGNS_VRSN_CD10Claim Diagnosis Code X Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
44ICD_DGNS_CD11Claim Diagnosis Code XI (Encounter)
45ICD_DGNS_VRSN_CD11Claim Diagnosis Code XI Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
46ICD_DGNS_CD12Claim Diagnosis Code XII (Encounter)
47ICD_DGNS_VRSN_CD12Claim Diagnosis Code XII Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
48ICD_DGNS_CD13 Claim Diagnosis Code XIII (Encounter)
49ICD_DGNS_VRSN_CD13Claim Diagnosis Code XIII Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
50CLM_OBSLT_DTCLM_OBSLT_DTClaim Obsolete Date
51CLM_BPRVDR_CITY_NAMECLM_BPRVDR_CITY_NAMEBilling Provider Address - City
52CLM_BPRVDR_USPS_STATE_CDCLM_BPRVDR_USPS_STATE_CDBilling Provider Address - USPS State Code
53CLM_BPRVDR_ADR_ZIP_CDCLM_BPRVDR_ADR_ZIP_CDBilling Provider Zip Code
57CLM_SUBSCR_CITY_NAMECLM_SUBSCR_CITY_NAMEMedicare Subscriber Address - City
58CLM_SUBSCR_USPS_STATE_CDCLM_SUBSCR_USPS_STATE_CDMedicare Subscriber Address - USPS State Code
59CLM_SUBSCR_ADR_ZIP_CDCLM_SUBSCR_ADR_ZIP_CDMedicare Subscriber Address - ZIP Code
54BENE_CNTY_CDBENE_CNTY_CDBeneficiary County Code from Claim (SSA)
55BENE_STATE_CDBeneficiary Residence (SSA) State Code (Encounter)
56Beneficiary ZIP Code of Residence
60GNDR_CDGNDR_CDGender Code from Encounter record
61RACEBENE_RACE_CDBeneficiary Race Code (Encounter)
62DOB_DTDOB_DTDate of Birth from Encounter
63BENE_MDCR_STUS_CDBENE_MDCR_STUS_CDBeneficiary Medicare Status Code
64TAX_NUMTAX_NUMProvider Tax Number
65BENE_STATEBENE_STATEState of beneficiary (postal abbreviation)

LINE 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
4CLM_LNCLM_LINE_NUMClaim Line Number
5CLM_THRU_DTClaim Through Date (Encounter)
6PRVDR_NPIPRVDR_NPILine Rendering Physician NPI
7HCFASPCLPRVDR_SPCLTYLine CMS Provider Specialty Code
8LINE_SRVC_CNTLine Service Count (Encounter)
9LINE_PLACE_OF_SRVC_CDLine Place of Service Code (Encounter)
10LINE_1ST_EXPNS_DTLine First Expense Date (Encounter)
11LINE_LAST_EXPNS_DTLine Last Expense Date (Encounter)
12HCPCS_CDHealthcare Common Procedure Coding System (HCPCS) Code (Encounter)
13HCPCS_1ST_MDFR_CDHCPCS Initial Modifier Code (Encounter)
14HCPCS_2ND_MDFR_CDHCPCS Second Modifier Code (Encounter)
15HCPCS_3RD_MDFR_CDHCPCS Third Modifier Code (Encounter)
16HCPCS_4TH_MDFR_CDHCPCS Fourth Modifier Code (Encounter)
17LINE_NDC_CDLine National Drug Code (NDC) (Encounter)
18LINE_LTST_CLM_INDLINE_LTST_CLM_INDLine Latest Claim Indicator
CSV