File Version:
K, CCW Data Documentation April, 2020

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.

File Version:
K, CCW Data Documentation April, 2020

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.

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 CLM_ID Claim ID
3 NCH_NEAR_LINE_REC_IDENT_CD NCH Near Line Record Identification Code (RIC)
4 NCH_CLM_TYPE_CD NCH Claim Type Code
5 CLM_FROM_DT Claim From Date (FFS)
6 CLM_THRU_DT Claim Through Date (FFS)
7 NCH_WKLY_PROC_DT NCH Weekly Claim Processing Date
8 FI_CLM_PROC_DT FI Claim Process Date
9 CLAIM_QUERY_CODE Claim Query Code
10 PRVDR_NUM Provider Number
11 PRVDR_FULL_CCN_NUM Full CMS Certification Number for Provider
12 CLM_FAC_TYPE_CD Claim Facility Type Code (FFS)
13 CLM_SRVC_CLSFCTN_TYPE_CD Claim Service Classification Type Code (FFS)
14 CLM_FREQ_CD Claim Frequency Code (FFS)
15 FI_NUM FI or MAC Number
16 CLM_MDCR_NON_PMT_RSN_CD Claim Medicare Non-Payment Reason Code
17 CLM_PMT_AMT Claim (Medicare) Payment Amount
18 NCH_PRMRY_PYR_CLM_PD_AMT NCH Primary Payer (if not Medicare) Claim Paid Amount
19 NCH_PRMRY_PYR_CD NCH Primary Payer Code (if not Medicare)
20 FI_CLM_ACTN_CD FI or MAC Claim Action Code
21 PRVDR_STATE_CD NCH Provider SSA State Code
22 ORG_NPI_NUM Organization (or group) NPI Number
23 AT_PHYSN_UPIN Claim Attending Physician UPIN Number
24 AT_PHYSN_NPI Claim Attending Physician NPI Number (FFS)
25 AT_PHYSN_SPCLTY_CD Claim Attending Physician Specialty Code
26 OP_PHYSN_UPIN Claim Operating Physician UPIN Number
27 OP_PHYSN_NPI Claim Operating Physician NPI Number (FFS)
28 OP_PHYSN_SPCLTY_CD Claim Operating Physician Specialty Code
29 OT_PHYSN_UPIN Claim Other Physician UPIN Number
30 OT_PHYSN_NPI Claim Other Physician NPI Number (FFS)
31 OT_PHYSN_SPCLTY_CD Claim Other Physician Specialty Code
32 RNDRNG_PHYSN_NPI Rendering Physician NPI (FFS)
33 CLM_RNDRNG_PHYSN_SPCLTY_CD Claim Rendering Physician Specialty Code
34 CLM_MCO_PD_SW Claim MCO Paid Switch
35 PTNT_DSCHRG_STUS_CD Patient Discharge Status Code (FFS)
36 CLM_PPS_IND_CD Claim PPS Indicator Code
37 CLM_TOT_CHRG_AMT Claim Total Charge Amount
38 CLM_ADMSN_DT Claim Admission Date (FFS)
39 CLM_IP_ADMSN_TYPE_CD Claim Inpatient Admission Type Code (FFS)
40 CLM_SRC_IP_ADMSN_CD Claim Source Inpatient Admission Code (FFS)
41 NCH_PTNT_STUS_IND_CD NCH Patient Status Indicator Code
42 NCH_BENE_IP_DDCTBL_AMT NCH Beneficiary Inpatient (or other Part A) Deductible Amount
43 NCH_BENE_PTA_COINSRNC_LBLTY_AM NCH Beneficiary Part A Coinsurance Liability Amount
44 NCH_BENE_BLOOD_DDCTBL_LBLTY_AM NCH Beneficiary Blood Deductible Liability Amount
45 NCH_IP_NCVRD_CHRG_AMT NCH Inpatient (or other Part A) Non-covered Charge Amount
46 NCH_IP_TOT_DDCTN_AMT NCH Inpatient (or other Part A) Total Deductible/Coinsurance Amount
47 CLM_PPS_CPTL_FSP_AMT Claim PPS Capital Federal Specific Portion (FSP) Amount
48 CLM_PPS_CPTL_OUTLIER_AMT Claim PPS Capital Outlier Amount
49 CLM_PPS_CPTL_DSPRPRTNT_SHR_AMT Claim PPS Capital Disproportionate Share Amount
50 CLM_PPS_CPTL_IME_AMT Claim PPS Capital Indirect Medical Education (IME) Amount
51 CLM_PPS_CPTL_EXCPTN_AMT Claim PPS Capital Exception Amount
52 CLM_PPS_OLD_CPTL_HLD_HRMLS_AMT Claim PPS Old Capital Hold Harmless Amount
53 CLM_UTLZTN_DAY_CNT Claim Medicare Utilization Day Count
54 BENE_TOT_COINSRNC_DAYS_CNT Beneficiary Total Coinsurance Days Count
55 CLM_NON_UTLZTN_DAYS_CNT Claim Medicare Non Utilization Days Count
56 NCH_BLOOD_PNTS_FRNSHD_QTY NCH Blood Pints Furnished Quantity
57 NCH_QLFYD_STAY_FROM_DT NCH Qualified Stay From Date
58 NCH_QLFYD_STAY_THRU_DT NCH Qualified Stay Through Date
59 NCH_VRFD_NCVRD_STAY_FROM_DT NCH Verified Non-covered Stay From Date
60 NCH_VRFD_NCVRD_STAY_THRU_DT NCH Verified Non-covered Stay Through Date
61 NCH_ACTV_OR_CVRD_LVL_CARE_THRU NCH Active or Covered Level Care Thru Date
62 NCH_BENE_MDCR_BNFTS_EXHTD_DT_I NCH Beneficiary Medicare Benefits Exhausted Date
63 NCH_BENE_DSCHRG_DT NCH Beneficiary Discharge Date
64 CLM_DRG_CD Claim Diagnosis Related Group Code (or MS-DRG Code) (FFS)
65 MS_DRG_GRPR_VRSN_CD MS-DRG Grouper Version Code
66 ADMTG_DGNS_CD Claim Admitting Diagnosis Code (FFS)
67 PRNCPAL_DGNS_CD Claim Principal Diagnosis Code (FFS)
68 ICD_DGNS_CD1 Claim Diagnosis Code I (FFS)
69 ICD_DGNS_CD2 Claim Diagnosis Code II (FFS)
70 ICD_DGNS_CD3 Claim Diagnosis Code III (FFS)
71 ICD_DGNS_CD4 Claim Diagnosis Code IV (FFS)
72 ICD_DGNS_CD5 Claim Diagnosis Code V (FFS)
73 ICD_DGNS_CD6 Claim Diagnosis Code VI (FFS)
74 ICD_DGNS_CD7 Claim Diagnosis Code VII (FFS)
75 ICD_DGNS_CD8 Claim Diagnosis Code VIII (FFS)
76 ICD_DGNS_CD9 Claim Diagnosis Code IX (FFS)
77 ICD_DGNS_CD10 Claim Diagnosis Code X (FFS)
78 ICD_DGNS_CD11 Claim Diagnosis Code XI (FFS)
79 ICD_DGNS_CD12 Claim Diagnosis Code XII (FFS)
80 ICD_DGNS_CD13 Claim Diagnosis Code XIII (FFS)
81 ICD_DGNS_CD14 Claim Diagnosis Code XIV (FFS)
82 ICD_DGNS_CD15 Claim Diagnosis Code XV (FFS)
83 ICD_DGNS_CD16 Claim Diagnosis Code XVI (FFS)
84 ICD_DGNS_CD17 Claim Diagnosis Code XVII (FFS)
85 ICD_DGNS_CD18 Claim Diagnosis Code XVIII (FFS)
86 ICD_DGNS_CD19 Claim Diagnosis Code XIX (FFS)
87 ICD_DGNS_CD20 Claim Diagnosis Code XX (FFS)
88 ICD_DGNS_CD21 Claim Diagnosis Code XXI (FFS)
89 ICD_DGNS_CD22 Claim Diagnosis Code XXII (FFS)
90 ICD_DGNS_CD23 Claim Diagnosis Code XXIII (FFS)
91 ICD_DGNS_CD24 Claim Diagnosis Code XXIV (FFS)
92 ICD_DGNS_CD25 Claim Diagnosis Code XXV (FFS)
93 FST_DGNS_E_CD First Claim Diagnosis E Code (FFS)
4 ICD_DGNS_E_CD1 Claim Diagnosis E Code I (FFS)
95 ICD_DGNS_E_CD2 Claim Diagnosis E Code II (FFS)
96 ICD_DGNS_E_CD3 Claim Diagnosis E Code III (FFS)
97 ICD_DGNS_E_CD4 Claim Diagnosis E Code IV (FFS)
98 ICD_DGNS_E_CD5 Claim Diagnosis E Code V (FFS)
99 ICD_DGNS_E_CD6 Claim Diagnosis E Code VI (FFS)
100 ICD_DGNS_E_CD7 Claim Diagnosis E Code VII (FFS)
101 ICD_DGNS_E_CD8 Claim Diagnosis E Code VIII (FFS)
102 ICD_DGNS_E_CD9 Claim Diagnosis E Code IX (FFS)
103 ICD_DGNS_E_CD10 Claim Diagnosis E Code X (FFS)
104 ICD_DGNS_E_CD11 Claim Diagnosis E Code XI
105 ICD_DGNS_E_CD12 Claim Diagnosis E Code XII
106 ICD_PRCDR_CD1 Claim Procedure Code I (FFS)
107 PRCDR_DT1 Claim Procedure Code I Date (FFS)
108 ICD_PRCDR_CD2 Claim Procedure Code II (FFS)
109 PRCDR_DT2 Claim Procedure Code II Date (FFS)
110 ICD_PRCDR_CD3 Claim Procedure Code III (FFS)
111 PRCDR_DT3 Claim Procedure Code III Date (FFS)
112 ICD_PRCDR_CD4 Claim Procedure Code IV (FFS)
113 PRCDR_DT4 Claim Procedure Code IV Date (FFS)
114 ICD_PRCDR_CD5 Claim Procedure Code V (FFS)
115 PRCDR_DT5 Claim Procedure Code V Date (FFS)
116 ICD_PRCDR_CD6 Claim Procedure Code VI (FFS)
117 PRCDR_DT6 Claim Procedure Code VI Date (FFS)
118 ICD_PRCDR_CD7 Claim Procedure Code VII (FFS)
119 PRCDR_DT7 Claim Procedure Code VII Date (FFS)
120 ICD_PRCDR_CD8 Claim Procedure Code VIII (FFS)
121 PRCDR_DT8 Claim Procedure Code VIII Date (FFS)
122 ICD_PRCDR_CD9 Claim Procedure Code IX (FFS)
123 PRCDR_DT9 Claim Procedure Code IX Date (FFS)
124 ICD_PRCDR_CD10 Claim Procedure Code X (FFS)
125 PRCDR_DT10 Claim Procedure Code X Date (FFS)
126 ICD_PRCDR_CD11 Claim Procedure Code XI (FFS)
127 PRCDR_DT11 Claim Procedure Code XI Date (FFS)
128 ICD_PRCDR_CD12 Claim Procedure Code XII (FFS)
129 PRCDR_DT12 Claim Procedure Code XII Date (FFS)
130 ICD_PRCDR_CD13 Claim Procedure Code XIII (FFS)
131 PRCDR_DT13 Claim Procedure Code XIII Date (FFS)
132 ICD_PRCDR_CD14 Claim Procedure Code XIV
133 PRCDR_DT14 Claim Procedure Code XIV Date
134 ICD_PRCDR_CD15 Claim Procedure Code XV
135 PRCDR_DT15 Claim Procedure Code XV Date
136 ICD_PRCDR_CD16 Claim Procedure Code XVI
137 PRCDR_DT16 Claim Procedure Code XVI Date
138 ICD_PRCDR_CD17 Claim Procedure Code XVII
139 PRCDR_DT17 Claim Procedure Code XVII Date
140 ICD_PRCDR_CD18 Claim Procedure Code XVIII
141 PRCDR_DT18 Claim Procedure Code XVIII Date
142 ICD_PRCDR_CD19 Claim Procedure Code XIX
143 PRCDR_DT19 Claim Procedure Code XIX Date
144 ICD_PRCDR_CD20 Claim Procedure Code XX
145 PRCDR_DT20 Claim Procedure Code XX Date
146 ICD_PRCDR_CD21 Claim Procedure Code XXI
147 PRCDR_DT21 Claim Procedure Code XXI Date
148 ICD_PRCDR_CD22 Claim Procedure Code XXII
149 PRCDR_DT22 Claim Procedure Code XXII Date
150 ICD_PRCDR_CD23 Claim Procedure Code XXIII
151 PRCDR_DT23 Claim Procedure Code XXIII Date
152 ICD_PRCDR_CD24 Claim Procedure Code XXIV
153 PRCDR_DT24 Claim Procedure Code XXIV Date
154 ICD_PRCDR_CD25 Claim Procedure Code XXV
155 PRCDR_DT25 Claim Procedure Code XXV Date
156 DOB_DT Date of Birth from Claim
157 GNDR_CD Gender Code from Claim
158 BENE_RACE_CD Beneficiary Race Code (FFS)
159 BENE_CNTY_CD County Code from Claim (SSA)
160 BENE_STATE_CD Beneficiary Residence (SSA) State Code (FFS)
161 BENE_MLG_CNTCT_ZIP_CD Zip Code of Residence from Claim
162 CLM_MDCL_REC Claim Medical Record Number (FFS)
163 CLM_TRTMT_AUTHRZTN_NUM Claim Treatment Authorization Number
164 CLM_PRCR_RTRN_CD Claim Pricer Return Code
165 CLM_PRCR_VRSN_CD Claim Pricer Version Code
166 CLM_SRVC_FAC_ZIP_CD Claim service facility ZIP code (where service was provided)
167 NCH_PROFNL_CMPNT_CHRG_AMT Professional Component Charge Amount
168 CLM_NEXT_GNRTN_ACO_IND_CD1 Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Population-Based Payment (PBP)
169 CLM_NEXT_GNRTN_ACO_IND_CD2 Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Telehealth
170 CLM_NEXT_GNRTN_ACO_IND_CD3 Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Post Discharge HH visits
171 CLM_NEXT_GNRTN_ACO_IND_CD4 Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - 3-day SNF waiver
172 CLM_NEXT_GNRTN_ACO_IND_CD5 Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Capitation
173 ACO_ID_NUM Claim Accountable Care Organization (ACO) Identification Number
174 CLM_BENE_ID_TYPE_CD Claim Beneficiary Identifier Type Code
175 CLM_RSDL_PYMT_IND_CD Claim Residual Payment Indicator Code
176 PRVDR_VLDTN_TYPE_CD Provider Validation Type Code
177 RR_BRD_EXCLSN_IND_SW Railroad Board Exclusion Indicator Switch
178 CLM_MODEL_REIMBRSMT_AMT Claim Model Reimbursement Amount
179 CLM_ADJUST_GRP_CD Claim Adjustment Group Code
180 CLM_ADJUST_RSN_CD Claim Adjustment Reason Code

Revenue Center File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 CLM_ID Claim ID
3 CLM_THRU_DT Claim Through Date (FFS)
4 CLM_LINE_NUM Claim Line Number
5 NCH_CLM_TYPE_CD NCH Claim Type Code
6 REV_CNTR Revenue Center Code (FFS)
7 HCPCS_CD Healthcare Common Procedure Coding System (HCPCS) Code (FFS)
8 HCPCS_1st_mdfr_cd HCPCS Initial Modifier Code (FFS)
9 HCPCS_2ND_MDFR_CD HCPCS Second Modifier Code (FFS)
10 HCPCS_3RD_MDFR_CD HCPCS Third Modifier Code (FFS)
11 REV_CNTR_UNIT_CNT Revenue Center Unit Count (FFS)
12 REV_CNTR_RATE_AMT Revenue Center Rate Amount
13 REV_CNTR_TOT_CHRG_AMT Revenue Center Total Charge Amount
14 REV_CNTR_NCVRD_CHRG_AMT Revenue Center Non-Covered Charge Amount
15 REV_CNTR_DDCTBL_COINSRNC_CD Revenue Center Deductible Coinsurance Code
16 REV_CNTR_NDC_QTY Revenue Center National Drug Code (NDC) Quantity (FFS)
17 REV_CNTR_NDC_QTY_QLFR_CD Revenue Center NDC Quantity Qualifier Code (FFS)
18 RNDRNG_PHYSN_UPIN Revenue Center Rendering Physician UPIN
19 RNDRNG_PHYSN_NPI Rendering Physician NPI (FFS)
20 RNDRNG_PHYSN_SPCLTY_CD Claim or Revenue Center Rendering Physician Specialty Code
21 REV_CNTR_IDE_NDC_UPC_NUM Revenue Center IDE, NDC, or UPC Number (FFS)
22 REV_CNTR_PRCNG_IND_CD Revenue Center Pricing Indicator Code
23 THRPY_CAP_IND_CD1 Therapy cap Indicator 1 Code
24 THRPY_CAP_IND_CD2 Therapy cap Indicator 2 Code
25 REV_CNTR_RP_IND_CD Revenue Center Representative Payee (RP) Indicator Code
26 RC_MODEL_REIMBRSMT_AMT Revenue Center Model Reimbursement Amount
27 REV_CNTR_ADJUST_GRP_CD Revenue Center Adjustment Group Code
28 REV_CNTR_ADJUST_RSN_CD Revenue Center Adjustment Reason Code

Condition Code File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 CLM_ID Claim ID
3 NCH_CLM_TYPE_CD NCH Claim Type Code
4 RLT_COND_CD_SEQ Claim Related Condition Code Sequence
5 CLM_RLT_COND_CD Claim Related Condition Code (FFS)

Occurence Code File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 CLM_ID Claim ID
3 NCH_CLM_TYPE_CD NCH Claim Type Code
4 RLT_OCRNC_CD_SEQ Claim Related Occurrence Code Sequence
5 CLM_RLT_OCRNC_CD Claim Related Occurrence Code (FFS)
6 CLM_RLT_OCRNC_DT Claim Related Occurrence Date (FFS)

Span Code File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 CLM_ID Claim ID
3 NCH_CLM_TYPE_CD NCH Claim Type Code
4 RLT_SPAN_CD_SEQ Claim Related Span Code Sequence
5 CLM_SPAN_CD Claim Occurrence Span Code (FFS)
6 CLM_SPAN_FROM_DT Claim Occurrence Span From Date (FFS)
7 CLM_SPAN_THRU_DT Claim Occurrence Span Through Date (FFS)

Value Code File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 CLM_ID Claim ID
3 NCH_CLM_TYPE_CD NCH Claim Type Code
4 RLT_VAL_CD_SEQ Claim Related Value Code Sequence
5 CLM_VAL_CD Claim Value Code (FFS)
6 CLM_VAL_AMT Claim Value Amount

Demonstrations/Innovations Code File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 CLM_ID Claim ID
3 NCH_CLM_TYPE_CD NCH Claim Type Code
4 DEMO_ID_SQNC_NUM Demonstration sequence number
5 DEMO_ID_NUM Demonstration number
6 DEMO_INFO_TXT Demo information text