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

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
21CLM_PLACE_OF_SRVC_CDClaim Place of Service Code
22CLM_RNDRNG_PHYSN_NPI_NUMClaim Rendering Physician NPI Number
23RFRG_NPIClaim Referring Physician NPI Number
24PRNCPAL_DGNS_CDClaim Principal Diagnosis Code (Encounter)
25PRNCPAL_DGNS_VRSN_CDClaim Principal Diagnosis Version Code (Encounter)
26ICD_DGNS_CD1Claim Diagnosis Code I (Encounter)
27ICD_DGNS_VRSN_CD1Claim Diagnosis Code I Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
28ICD_DGNS_CD2 Claim Diagnosis Code II (Encounter)
29ICD_DGNS_VRSN_CD2Claim Diagnosis Code II Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
30ICD_DGNS_CD3Claim Diagnosis Code III (Encounter)
31ICD_DGNS_VRSN_CD3Claim Diagnosis Code III Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
32ICD_DGNS_CD4Claim Diagnosis Code IV (Encounter)
33ICD_DGNS_VRSN_CD4Claim Diagnosis Code IV Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
34ICD_DGNS_CD5 Claim Diagnosis Code V (Encounter)
35ICD_DGNS_VRSN_CD5Claim Diagnosis Code V Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
36ICD_DGNS_CD6Claim Diagnosis Code VI (Encounter)
37ICD_DGNS_VRSN_CD6Claim Diagnosis Code VI Diagnosis Version Code (ICD-9/ICD-10) (Encounter)
38ICD_DGNS_CD7 Claim Diagnosis Code VII (Encounter)
39ICD_DGNS_VRSN_CD7Claim Diagnosis Code VII Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
40ICD_DGNS_CD8Claim Diagnosis Code VIII (Encounter)
41ICD_DGNS_VRSN_CD8Claim Diagnosis Code VIII Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
42ICD_DGNS_CD9 Claim Diagnosis Code IX (Encounter)
43ICD_DGNS_VRSN_CD9Claim Diagnosis Code IX Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
44ICD_DGNS_CD10Claim Diagnosis Code X (Encounter)
45ICD_DGNS_VRSN_CD10Claim Diagnosis Code X Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
46ICD_DGNS_CD11Claim Diagnosis Code XI (Encounter)
47ICD_DGNS_VRSN_CD11Claim Diagnosis Code XI Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
48ICD_DGNS_CD12Claim Diagnosis Code XII (Encounter)
49ICD_DGNS_VRSN_CD12Claim Diagnosis Code XII Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
50ICD_DGNS_CD13 Claim Diagnosis Code XIII (Encounter)
51ICD_DGNS_VRSN_CD13Claim Diagnosis Code XIII Diagnosis Version Code (ICD-9 or ICD-10) (Encounter)
52CLM_OBSLT_DTClaim Obsolete Date
53CLM_BPRVDR_CITY_NAMEBilling Provider Address - City
54CLM_BPRVDR_USPS_STATE_CDBilling Provider Address - USPS State Code
55CLM_BPRVDR_ADR_ZIP_CDBilling Provider Zip Code
56CLM_SUBSCR_CITY_NAMEMedicare Subscriber Address - City
57CLM_SUBSCR_USPS_STATE_CDMedicare Subscriber Address - USPS State Code
58CLM_SUBSCR_ADR_ZIP_CDMedicare Subscriber Address - ZIP Code
59BENE_CNTY_CDBeneficiary County Code from Claim (SSA)
60BENE_STATE_CDBeneficiary Residence (SSA) State Code (Encounter)
61Beneficiary ZIP Code of Residence
62GNDR_CDGender Code from Encounter record
63BENE_RACE_CDBeneficiary Race Code (Encounter)
64DOB_DTDate of Birth from Encounter
65BENE_MDCR_STUS_CDBeneficiary Medicare Status Code
66TAX_NUMProvider Tax Number
67BENE_STATEState of beneficiary (postal abbreviation)

LINE FILE

SAS NameVariable Name
1BENE_IDEncrypted CCW Beneficiary ID
2ENC_JOIN_KEYUnique Encounter Join Key
3CLM_TYPE_CDClaim Type Code
20CLM_LINE_NUMClaim Line Number (Encounter)
21LINE_NUM_ORIGOriginal Claim 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
CSV