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

SAS NameVariable Name
1BENE_IDEncrypted CCW Beneficiary ID
2SAMPLE_GROUPCCW Beneficiary Random Sample Group
3ENC_JOIN_KEYUnique Encounter Join Key
4CLM_TYPE_CDClaim Type Code
5CLM_FROM_DTClaim From Date (Encounter)
6CLM_THRU_DTClaim Through Date (Encounter)
7SRVC_MONTHService Month
8CLM_CHRT_RVW_SWClaim Chart Review Switch
9CLM_CNTL_NUMClaim Control Number
10CLM_ORIG_CNTL_NUMClaim Original Control Number
11CLM_FINL_ACTN_INDClaim Final Action Indicator
12CLM_LTST_CLM_INDLatest Claim Indicator
13EDPS_CREATE_DTEncounter Data Processing System (EDPS) Create Date
14CLM_RCPT_DTClaim Receipt Date
15CLM_FREQ_CDClaim Frequency Code (Encounter)
16CNTRCT_NUMMedicare Part C Contract Number
17CNTRCT_PBP_NUMMedicare Part C Plan Benefit Package (PBP) Number
18CLM_MDCL_RECClaim Medical Record Number (Encounter)
19ORG_NPI Organization NPI Number (Encounter)
20ORG_TXNMY_CDOrganization Taxonomy Code
21RFRG_NPIClaim Referring Physician NPI Number
22PRNCPAL_DGNS_CDClaim Principal Diagnosis Code (Encounter)
23PRNCPAL_DGNS_VRSN_CDClaim Principal Diagnosis Version Code (Encounter)
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_DTClaim Obsolete Date
51CLM_BPRVDR_CITY_NAMEBilling Provider Address - City
52CLM_BPRVDR_USPS_STATE_CDBilling Provider Address - USPS State Code
53CLM_BPRVDR_ADR_ZIP_CDBilling Provider Zip Code
54CLM_SUBSCR_CITY_NAMEMedicare Subscriber Address - City
55CLM_SUBSCR_USPS_STATE_CDMedicare Subscriber Address - USPS State Code
56CLM_SUBSCR_ADR_ZIP_CDMedicare Subscriber Address - ZIP Code
57BENE_CNTY_CDBeneficiary County Code from Claim (SSA)
58BENE_STATE_CDBeneficiary Residence (SSA) State Code (Encounter)
59Beneficiary ZIP Code of Residence
60GNDR_CDGender Code from Encounter record
61BENE_RACE_CDBeneficiary Race Code (Encounter)
62DOB_DTDate of Birth from Encounter
63BENE_MDCR_STUS_CDBeneficiary Medicare Status Code
64TAX_NUMProvider Tax Number
65BENE_STATEState of beneficiary (postal abbreviation)


SAS NameVariable Name
1BENE_IDEncrypted CCW Beneficiary ID
2ENC_JOIN_KEYUnique Encounter Join Key
3CLM_TYPE_CDClaim Type Code
4CLM_LINE_NUMClaim Line Number
5CLM_THRU_DTClaim Through Date (Encounter)
6PRVDR_NPILine Rendering Physician NPI
7PRVDR_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_RX_NUMCarrier Line RX Number
19LINE_LTST_CLM_INDLine Latest Claim Indicator