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)
24AT_PHYSN_NPIClaim Attending Physician NPI Number (Encounter)
25AT_PHYSN_TXNMY_CDAT_PHYSN_TXNMY_CDClaim Attending Physician Taxonomy Code
26OP_PHYSN_NPI Claim Operating Physician NPI Number (Encounter)
27OT_PHYSN_NPI Claim Other Physician NPI Number (Encounter)
28CLM_ADMSN_DTClaim Admission Date (Encounter)
29CLM_IP_ADMSN_TYPE_CDClaim Inpatient Admission Type Code (Encounter)
30CLM_SRC_IP_ADMSN_CD Claim Source Inpatient Admission Code (Encounter)
31PTNT_DSCHRG_STUS_CDPatient Discharge Status Code (Encounter)
32CLM_DAY_CNTCLM_DAY_CNTDay Count (Length of Stay)
33BENE_DSCHRG_DTBENE_DSCHRG_DTBeneficiary Discharge Date
34Claim MS-Diagnosis Related Group Code (MS-DRG)
35DRVD_DRG_CDDRVD_DRG_CDDerived MS-Diagnosis Related Group Code (MS-DRG)
36ADMTG_DGNS_CDClaim Admitting Diagnosis Code (Encounter)
37PRNCPAL_DGNS_CDClaim Principal Diagnosis Code (Encounter)
38ICD_DGNS_CD1Claim Diagnosis Code I (Encounter)
39ICD_DGNS_CD2 Claim Diagnosis Code II (Encounter)
40ICD_DGNS_CD3Claim Diagnosis Code III (Encounter)
41ICD_DGNS_CD4Claim Diagnosis Code IV (Encounter)
42ICD_DGNS_CD5 Claim Diagnosis Code V (Encounter)
43ICD_DGNS_CD6Claim Diagnosis Code VI (Encounter)
44ICD_DGNS_CD7 Claim Diagnosis Code VII (Encounter)
45ICD_DGNS_CD8Claim Diagnosis Code VIII (Encounter)
46ICD_DGNS_CD6Claim Diagnosis Code VI (Encounter)
47ICD_DGNS_CD10Claim Diagnosis Code X (Encounter)
48ICD_DGNS_CD11Claim Diagnosis Code XI (Encounter)
49ICD_DGNS_CD12Claim Diagnosis Code XII (Encounter)
50ICD_DGNS_CD13 Claim Diagnosis Code XIII (Encounter)
51ICD_DGNS_CD14Claim Diagnosis Code XIV (Encounter)
52ICD_DGNS_CD15Claim Diagnosis Code XV (Encounter)
53ICD_DGNS_CD16 Claim Diagnosis Code XVI (Encounter)
54ICD_DGNS_CD17 Claim Diagnosis Code XVII (Encounter)
55ICD_DGNS_CD18 Claim Diagnosis Code XVIII (Encounter)
56ICD_DGNS_CD19 Claim Diagnosis Code XIX (Encounter)
57ICD_DGNS_CD20 Claim Diagnosis Code XX (Encounter)
58ICD_DGNS_CD21Claim Diagnosis Code XXI (Encounter)
59ICD_DGNS_CD22Claim Diagnosis Code XXII (Encounter)
60ICD_DGNS_CD23 Claim Diagnosis Code XXIII (Encounter)
61ICD_DGNS_CD24Claim Diagnosis Code XXIV (Encounter)
62ICD_DGNS_CD25 Claim Diagnosis Code XXV (Encounter)
63CLM_POA_IND_SW1Claim Diagnosis Code I Diagnosis Present on Admission (POA) Indicator Code (Encounter)
64CLM_POA_IND_SW2 Claim Diagnosis Code II Diagnosis Present on Admission (POA) Indicator Code (Encounter)
65CLM_POA_IND_SW3 Claim Diagnosis Code III Diagnosis Present on Admission (POA) Indicator Code (Encounter)
66CLM_POA_IND_SW4Claim Diagnosis Code IV Diagnosis Present on Admission (POA) Indicator Code (Encounter)
67CLM_POA_IND_SW5 Claim Diagnosis Code V Diagnosis Present on Admission (POA) Indicator Code (Encounter)
68CLM_POA_IND_SW6Claim Diagnosis Code VI Diagnosis Present on Admission (POA) Indicator Code (Encounter)
69CLM_POA_IND_SW7 Claim Diagnosis Code VII Diagnosis Present on Admission (POA) Indicator Code (Encounter)
70CLM_POA_IND_SW8 Claim Diagnosis Code VIII Diagnosis Present on Admission (POA) Indicator Code (Encounter)
71CLM_POA_IND_SW9 Claim Diagnosis Code IX Diagnosis Present on Admission (POA) Indicator Code (Encounter)
72CLM_POA_IND_SW10 Claim Diagnosis Code X Diagnosis Present on Admission (POA) Indicator Code (Encounter)
73CLM_POA_IND_SW11 Claim Diagnosis Code XI Diagnosis Present on Admission (POA) Indicator Code (Encounter)
74CLM_POA_IND_SW12 Claim Diagnosis Code XII Diagnosis Present on Admission (POA) Indicator Code (Encounter)
75CLM_POA_IND_SW13 Claim Diagnosis Code XIII Diagnosis Present on Admission (POA) Indicator Code (Encounter)
76CLM_POA_IND_SW14Claim Diagnosis Code XIV Diagnosis Present on Admission (POA) Indicator Code (Encounter)
77CLM_POA_IND_SW15 Claim Diagnosis Code XV Diagnosis Present on Admission (POA) Indicator Code (Encounter)
78CLM_POA_IND_SW16Claim Diagnosis Code XVI Diagnosis Present on Admission (POA) Indicator Code (Encounter)
79CLM_POA_IND_SW17Claim Diagnosis Code XVII Diagnosis Present on Admission (POA) Indicator Code (Encounter)
80CLM_POA_IND_SW18 Claim Diagnosis Code XVIII Diagnosis Present on Admission (POA) Indicator Code (Encounter)
81CLM_POA_IND_SW19Claim Diagnosis Code XIX Diagnosis Present on Admission (POA) Indicator Code (Encounter)
82CLM_POA_IND_SW20Claim Diagnosis Code XX Diagnosis Present on Admission (POA) Indicator Code (Encounter)
83CLM_POA_IND_SW21 Claim Diagnosis Code XXI Diagnosis Present on Admission (POA) Indicator Code (Encounter)
84CLM_POA_IND_SW22Claim Diagnosis Code XXII Diagnosis Present on Admission (POA) Indicator Code (Encounter)
85CLM_POA_IND_SW23 Claim Diagnosis Code XXIII Diagnosis Present on Admission (POA) Indicator Code (Encounter)
86CLM_POA_IND_SW24Claim Diagnosis Code XXIV Diagnosis Present on Admission (POA) Indicator Code (Encounter)
87CLM_POA_IND_SW25 Claim Diagnosis Code XXV Diagnosis Present on Admission (POA) Indicator Code (Encounter)
88CLM_1ST_DGNS_E_CDFirst Claim Diagnosis E Code (Encounter)
89ICD_DGNS_E_CD1Claim Diagnosis E Code I (Encounter)
90ICD_DGNS_E_CD2Claim Diagnosis E Code II (Encounter)
91ICD_DGNS_E_CD3Claim Diagnosis E Code III (Encounter)
92ICD_DGNS_E_CD4Claim Diagnosis E Code IV (Encounter)
93ICD_DGNS_E_CD5Claim Diagnosis E Code V (Encounter)
94ICD_DGNS_E_CD6Claim Diagnosis E Code VI (Encounter)
95ICD_DGNS_E_CD7Claim Diagnosis E Code VII (Encounter)
96ICD_DGNS_E_CD8Claim Diagnosis E Code VIII (Encounter)
97ICD_DGNS_E_CD9Claim Diagnosis E Code IX (Encounter)
98ICD_DGNS_E_CD10Claim Diagnosis E Code X (Encounter)
99CLM_E_POA_IND_SW1Claim Diagnosis E Code I Diagnosis Present on Admission (POA) Indicator Code (Encounter)
100CLM_E_POA_IND_SW2 Claim Diagnosis E Code II Diagnosis Present on Admission (POA) Indicator Code (Encounter)
101CLM_E_POA_IND_SW3Claim Diagnosis E Code III Diagnosis Present on Admission (POA) Indicator Code (Encounter)
102CLM_E_POA_IND_SW4Claim Diagnosis E Code IV Diagnosis Present on Admission (POA) Indicator Code (Encounter)
103CLM_E_POA_IND_SW5Claim Diagnosis E Code V Diagnosis Present on Admission (POA) Indicator Code (Encounter)
104CLM_E_POA_IND_SW6Claim Diagnosis E Code VI Diagnosis Present on Admission (POA) Indicator Code (Encounter)
105CLM_E_POA_IND_SW7Claim Diagnosis E Code VII Diagnosis Present on Admission (POA) Indicator Code (Encounter)
106CLM_E_POA_IND_SW8Claim Diagnosis E Code VIII Diagnosis Present on Admission (POA) Indicator Code (Encounter)
107CLM_E_POA_IND_SW9Claim Diagnosis E Code IX Diagnosis Present on Admission (POA) Indicator Code (Encounter)
108CLM_E_POA_IND_SW10Claim Diagnosis E Code X Diagnosis Present on Admission (POA) Indicator Code (Encounter)
109ICD_PRCDR_CD1Claim Procedure Code I (Encounter)
110ICD_PRCDR_CD2Claim Procedure Code II (Encounter)
111ICD_PRCDR_CD3Claim Procedure Code III (Encounter)
112ICD_PRCDR_CD4Claim Procedure Code IV (Encounter)
113ICD_PRCDR_CD5Claim Procedure Code V (Encounter)
114ICD_PRCDR_CD6Claim Procedure Code VI (Encounter)
115ICD_PRCDR_CD7Claim Procedure Code VII (Encounter)
116ICD_PRCDR_CD8Claim Procedure Code VIII (Encounter)
117ICD_PRCDR_CD9Claim Procedure Code IX (Encounter)
118ICD_PRCDR_CD10Claim Procedure Code X (Encounter)
119ICD_PRCDR_CD11Claim Procedure Code XI (Encounter)
120ICD_PRCDR_CD12Claim Procedure Code XII (Encounter)
121ICD_PRCDR_CD13Claim Procedure Code XIII (Encounter)
122PRCDR_DT1Claim Procedure Code I Date (Encounter)
123PRCDR_DT2Claim Procedure Code II Date (Encounter)
124PRCDR_DT3Claim Procedure Code III Date (Encounter)
125PRCDR_DT4Claim Procedure Code IV Date (Encounter)
126PRCDR_DT5Claim Procedure Code V Date (Encounter)
127PRCDR_DT6Claim Procedure Code VI Date (Encounter)
128PRCDR_DT7Claim Procedure Code VII Date (Encounter)
129PRCDR_DT8Claim Procedure Code VIII Date (Encounter)
130PRCDR_DT9Claim Procedure Code IX Date (Encounter)
131PRCDR_DT10Claim Procedure Code X Date (Encounter)
132PRCDR_DT11Claim Procedure Code XI Date (Encounter)
133PRCDR_DT12Claim Procedure Code XII Date (Encounter)
134PRCDR_DT13Claim Procedure Code XIII Date (Encounter)
135CLM_OBSLT_DTCLM_OBSLT_DTClaim Obsolete Date
136CLM_BPRVDR_CITY_NAMECLM_BPRVDR_CITY_NAMEBilling Provider Address - City
137CLM_BPRVDR_USPS_STATE_CDCLM_BPRVDR_USPS_STATE_CDBilling Provider Address - USPS State Code
138CLM_BPRVDR_ADR_ZIP_CDCLM_BPRVDR_ADR_ZIP_CDBilling Provider Zip Code
139CLM_SUBSCR_CITY_NAMECLM_SUBSCR_CITY_NAMEMedicare Subscriber Address - City
140CLM_SUBSCR_USPS_STATE_CDCLM_SUBSCR_USPS_STATE_CDMedicare Subscriber Address - USPS State Code
141CLM_SUBSCR_ADR_ZIP_CDCLM_SUBSCR_ADR_ZIP_CDMedicare Subscriber Address - ZIP Code
142BENE_CNTY_CDBENE_CNTY_CDBeneficiary County Code from Claim (SSA)
143BENE_STATE_CDBeneficiary Residence (SSA) State Code (Encounter)
144BENE_MLG_CNTCT_ZIP_CDBENE_MLG_CNTCT_ZIP_CDBeneficiary ZIP Code of Residence from Claim
145GNDR_CDGNDR_CDGender Code from Encounter record
146RACEBENE_RACE_CDBeneficiary Race Code (Encounter)
147DOB_DTDOB_DTDate of Birth from Encounter
148BENE_MDCR_STUS_CDBENE_MDCR_STUS_CDBeneficiary Medicare Status Code
149TAX_NUMTAX_NUMProvider Tax Number
150BENE_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
4CLM_LNCLM_LINE_NUMClaim 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