Data Documentation

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

Number	SAS Name	Variable Name
1	BENE_ID	Encrypted CCW Beneficiary ID
2	SAMPLE_GROUP	CCW Beneficiary Random Sample Group
3	ENC_JOIN_KEY	Unique Encounter Join Key
4	CLM_TYPE_CD	Claim Type Code
5	CLM_FROM_DT	Claim From Date (Encounter)
6	CLM_THRU_DT	Claim Through Date (Encounter)
7	SRVC_MONTH	Service Month
8	CLM_CHRT_RVW_SW	Claim Chart Review Switch
9	CLM_CNTL_NUM	Claim Control Number
10	CLM_ORIG_CNTL_NUM	Claim Original Control Number
11	CLM_FINL_ACTN_IND	Claim Final Action Indicator
12	CLM_LTST_CLM_IND	Latest Claim Indicator
13	EDPS_CREATE_DT	Encounter Data Processing System (EDPS) Create Date
14	CLM_RCPT_DT	Claim Receipt Date
15	CLM_FAC_TYPE_CD	Claim Facility Type Code (Encounter)
16	CLM_SRVC_CLSFCTN_TYPE_CD	Claim Service Classification Type Code (Encounter)
17	CLM_FREQ_CD	Claim Frequency Code (Encounter)
18	CNTRCT_NUM	Medicare Part C Contract Number
19	CNTRCT_PBP_NUM	Medicare Part C Plan Benefit Package (PBP) Number
20	CLM_MDCL_REC	Claim Medical Record Number (Encounter)
21	ORG_NPI	Organization NPI Number (Encounter)
22	ORG_TXNMY_CD	Organization Taxonomy Code
23	RNDRNG_PHYSN_NPI	Rendering Physician NPI (Encounter)
24	RFRG_PHYSN_NPI	Carrier/DME Referring Physician NPI Number
25	AT_PHYSN_NPI	Claim Attending Physician NPI Number (Encounter)
26	AT_PHYSN_TXNMY_CD	Claim Attending Physician Taxonomy Code
27	OP_PHYSN_NPI	Claim Operating Physician NPI Number (Encounter)
28	OT_PHYSN_NPI	Claim Other Physician NPI Number (Encounter)
29	CLM_ADMSN_DT	Claim Admission Date (Encounter)
30	PTNT_DSCHRG_STUS_CD	Patient Discharge Status Code (Encounter)
31	BENE_DSCHRG_DT	Beneficiary Discharge Date
32	PRNCPAL_DGNS_CD	Claim Principal Diagnosis Code (Encounter)
33	ICD_DGNS_CD1	Claim Diagnosis Code 1 (Encounter)
34	ICD_DGNS_CD2	Claim Diagnosis Code 2 (Encounter)
35	ICD_DGNS_CD3	Claim Diagnosis Code 3 (Encounter)
36	ICD_DGNS_CD4	Claim Diagnosis Code 4 (Encounter)
37	ICD_DGNS_CD5	Claim Diagnosis Code 5 (Encounter)
38	ICD_DGNS_CD6	Claim Diagnosis Code 6 (Encounter)
39	ICD_DGNS_CD7	Claim Diagnosis Code 7 (Encounter)
40	ICD_DGNS_CD8	Claim Diagnosis Code 8 (Encounter)
41	ICD_DGNS_CD9	Claim Diagnosis Code 9 (Encounter)
42	ICD_DGNS_CD10	Claim Diagnosis Code 10 (Encounter)
43	ICD_DGNS_CD11	Claim Diagnosis Code 11 (Encounter)
44	ICD_DGNS_CD12	Claim Diagnosis Code 12 (Encounter)
45	ICD_DGNS_CD13	Claim Diagnosis Code 13 (Encounter)
46	ICD_DGNS_CD14	Claim Diagnosis Code 14 (Encounter)
47	ICD_DGNS_CD15	Claim Diagnosis Code 15 (Encounter)
48	ICD_DGNS_CD16	Claim Diagnosis Code 16 (Encounter)
49	ICD_DGNS_CD17	Claim Diagnosis Code 17 (Encounter)
50	ICD_DGNS_CD18	Claim Diagnosis Code 18 (Encounter)
51	ICD_DGNS_CD19	Claim Diagnosis Code 19 (Encounter)
52	ICD_DGNS_CD20	Claim Diagnosis Code 20 (Encounter)
53	ICD_DGNS_CD21	Claim Diagnosis Code 21 (Encounter)
54	ICD_DGNS_CD22	Claim Diagnosis Code 22 (Encounter)
55	ICD_DGNS_CD23	Claim Diagnosis Code 23 (Encounter)
56	ICD_DGNS_CD24	Claim Diagnosis Code 24 (Encounter)
57	ICD_DGNS_CD25	Claim Diagnosis Code 25 (Encounter)
58	CLM_1ST_DGNS_E_CD	First Claim Diagnosis E Code (Encounter)
59	ICD_DGNS_E_CD1	Claim Diagnosis E Code 1 (Encounter)
60	ICD_DGNS_E_CD2	Claim Diagnosis E Code 2 (Encounter)
61	ICD_DGNS_E_CD3	Claim Diagnosis E Code 3 (Encounter)
62	RSN_VISIT_CD1	Reason for Visit Diagnosis Code 1 (Encounter)
63	RSN_VISIT_CD2	Reason for Visit Diagnosis Code 2 (Encounter)
64	RSN_VISIT_CD3	Reason for Visit Diagnosis Code 3 (Encounter)
65	CLM_OBSLT_DT	Claim Obsolete Date
66	CLM_BPRVDR_CITY_NAME	Billing Provider Address - City
67	CLM_BPRVDR_USPS_STATE_CD	Billing Provider Address - USPS State Code
68	CLM_BPRVDR_ADR_ZIP_CD	Billing Provider Zip Code
69	CLM_SUBSCR_CITY_NAME	Medicare Subscriber Address - City
70	CLM_SUBSCR_USPS_STATE_CD	Medicare Subscriber Address - USPS State Code
71	CLM_SUBSCR_ADR_ZIP_CD	Medicare Subscriber Address - ZIP Code
72	BENE_CNTY_CD	Beneficiary County Code from Claim (SSA)
73	BENE_STATE_CD	Beneficiary Residence (SSA) State Code (Encounter)
74	BENE_MLG_CNTCT_ZIP_CD	Beneficiary ZIP Code of Residence from Claim
75	GNDR_CD	Gender Code from Encounter record
76	BENE_RACE_CD	Beneficiary Race Code (Encounter)
77	DOB_DT	Date of Birth from Encounter
78	BENE_MDCR_STUS_CD	Beneficiary Medicare Status Code
79	TAX_NUM	Provider Tax Number
80	BENE_STATE	State of beneficiary (postal abbreviation)

Revenue Center File

Number	SAS Name	Variable Name
1	BENE_ID	Encrypted CCW Beneficiary ID
2	ENC_JOIN_KEY	Unique Encounter Join Key
3	CLM_TYPE_CD	Claim Type Code
4	CLM_LINE_NUM	Claim Line Number (Encounter)
5	LINE_NUM_ORIG	Original Claim Line Number
6	CLM_THRU_DT	Claim Through Date (Encounter)
7	REV_CNTR	Revenue Center Code (Encounter)
8	REV_CNTR_FROM_DT	Revenue Center From Date
9	REV_CNTR_THRU_DT	Revenue Center Thru Date
10	REV_CNTR_UNIT_CNT	Revenue Center Unit Count (Encounter)
11	HCPCS_CD	Healthcare Common Procedure Coding System (HCPCS) Code (Encounter)
12	HCPCS_1ST_MDFR_CD	HCPCS Initial Modifier Code (Encounter)
13	HCPCS_2ND_MDFR_CD	HCPCS Second Modifier Code (Encounter)
14	HCPCS_3RD_MDFR_CD	HCPCS Third Modifier Code (Encounter)
15	REV_CNTR_IDE_NDC_UPC_NUM	Revenue Center IDE, NDC, or UPC Number (Encounter)
16	REV_CNTR_NDC_QTY	Revenue Center National Drug Code (NDC) Quantity (Encounter)
17	REV_CNTR_NDC_QTY_QLFR_CD	Revenue Center NDC Quantity Qualifier Code (Encounter)
18	REV_CNTR_RNDRNG_PHYSN_NPI_NUM	Revenue Center Rendering Physician NPI
19	LINE_LTST_CLM_IND	Line Latest Claim Indicator

Condition Code File

Number	SAS Name	Variable Name
1	BENE_ID	Encrypted CCW Beneficiary ID
2	ENC_JOIN_KEY	Unique Encounter Join Key
3	CLM_TYPE_CD	Claim Type Code
4	RLT_COND_CD_SEQ	Claim Related Condition Code Sequence
5	CLM_RLT_COND_CD	Claim Related Condition Code (Encounter)

Occurrence Code File

Number	SAS Name	Variable Name
1	BENE_ID	Encrypted CCW Beneficiary ID
2	ENC_JOIN_KEY	Unique Encounter Join Key
3	CLM_TYPE_CD	Claim Type Code
4	RLT_OCRNC_CD_SEQ	Claim Related Occurrence Code Sequence
5	CLM_RLT_OCRNC_CD	Claim Related Occurrence Code (Encounter)
6	CLM_RLT_OCRNC_DT	Claim Related Occurrence Date (Encounter)

Span Code File

Number	SAS Name	Variable Name
1	BENE_ID	Encrypted CCW Beneficiary ID
2	ENC_JOIN_KEY	Unique Encounter Join Key
3	CLM_TYPE_CD	Claim Type Code
4	RLT_SPAN_CD_SEQ	Claim Related Span Code Sequence
5	CLM_SPAN_CD	Claim Occurrence Span Code (Encounter)
6	CLM_SPAN_FROM_DT	Claim Occurrence Span From Date (Encounter)
7	CLM_SPAN_THRU_DT	Claim Occurrence Span Through Date (Encounter)

Value Code File

Number	SAS Name	Variable Name
1	BENE_ID	Encrypted CCW Beneficiary ID
2	ENC_JOIN_KEY	Unique Encounter Join Key
3	CLM_TYPE_CD	Claim Type Code
4	RLT_VAL_CD_SEQ	Claim Related Value Code Sequence
5	CLM_VAL_CD	Claim Value Code (Encounter)