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

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary Identifier
2 MSIS_ID Encrypted State Assigned Beneficiary Unique Identifier
3 STATE_CD Submitting State Alpha Abbreviation
4 SUBMTG_STATE_CD Submitting State FIPS Code
5 CLM_ID CCW Claim Identifier
6 CLM_NUM_ORIG Original Claim Identifier
7 CLM_NUM_ADJ Adjustment Claim Identifier
8 CLM_TYPE_CD Claim Type Code (TAF)
9 BILL_TYPE_CD Bill Type Code
10 CROSSOVER_CLM_IND Code To Indicate if a Portion of Claim is Paid by Medicare
11 ADJUST_CD Claim Adjustment Code
12 ADJUST_RSN_CD Adjustment Reason Code
13 ADJDCTN_DT Adjudication Date
14 MDCD_PD_DT Medicaid Paid Date
15 SPLIT_CLM_IND Split Claim Indicator
16 CLL_CNT Claim Line Count - Original
17 CLL_CNT_CALC Claim Line Count - Calculated
18 SRVC_TRKNG_TYPE_CD Service Tracking Type Code
19 BIRTH_DT Date of Birth
20 PTNT_DSCHRG_STUS_CD Patient Status at Ending Date of Service
21 BIRTH_WT Birth Weight in Grams
22 PGM_TYPE_CD Program Type Code
23 MC_PLAN_ID Managed Care Plan Identification Number
24 WVR_TYPE_CD Waiver Type Code
25 WVR_ID Waiver Identification Number
26 OTHR_INSRNC_IND Indicator Insured is Covered by Another Plan (Not Medicare or Medicaid)
27 SECT_1115A_DEMO_IND 1115(A) Demonstration Participation Indicator
28 SRVC_BGN_DT Claim Beginning Date of Service
29 SRVC_END_DT Claim Ending Date of Service
30 SRVC_END_DT_CD Identifies the Date Field Used to Populate SRVC_END_DT
31 HOSP_TYPE_CD Hospital Type Code
32 ADMSN_TYPE_CD Admission Type Code
33 ADMSM_DT Admission Date (TAF)
34 ADMSN_HR Admission Hour
35 DSCHRG_DT Discharge Date
36 DSCHRG_HR Discharge Hour
37 ADMTG_DGNS_CD Admitting Diagnosis Code
38 ADMTG_DGNS_VRSN_CD Admitting Diagnosis Version Code (ICD-9 or ICD-10)
39 DGNS_CD_1 Primary or Principal Diagnosis Code
40 DGNS_VRSN_CD_1 Diagnosis Version Code 1 (ICD-9 or ICD-10)
41 DGNS_POA_IND_1 Diagnosis Present on Admission Indicator 1
42 DGNS_CD_2 Diagnosis Code 2
43 DGNS_VRSN_CD_2 Diagnosis Version Code 2 (ICD-9 or ICD-10)
44 DGNS_POA_IND_2 Diagnosis Present on Admission Indicator 2
45 DGNS_CD_3 Diagnosis Code 3
46 DGNS_VRSN_CD_3 Diagnosis Version Code 3 (ICD-9 or ICD-10)
47 DGNS_POA_IND_3 Diagnosis Present on Admission Indicator 3
48 DGNS_CD_4 Diagnosis Code 4
49 DGNS_VRSN_CD_4 Diagnosis Version Code 4 (ICD-9 or ICD-10)
50 DGNS_POA_IND_4 Diagnosis Present on Admission Indicator 4
51 DGNS_CD_5 Diagnosis Code 5
52 DGNS_VRSN_CD_5 Diagnosis Version Code 5 (ICD-9 or ICD-10)
53 DGNS_POA_IND_5 Diagnosis Present on Admission Indicator 5
54 DGNS_CD_6 Diagnosis Code 6
55 DGNS_VRSN_CD_6 Diagnosis Version Code 6 (ICD-9 or ICD-10)
56 DGNS_POA_IND_6 Diagnosis Present on Admission Indicator 6
57 DGNS_CD_7 Diagnosis Code 7
58 DGNS_VRSN_CD_7 Diagnosis Version Code 7 (ICD-9 or ICD-10)
59 DGNS_POA_IND_7 Diagnosis Present on Admission Indicator 7
60 DGNS_CD_8 Diagnosis Code 8
61 DGNS_VRSN_CD_8 Diagnosis Version Code 8 (ICD-9 or ICD-10)
62 DGNS_POA_IND_8 Diagnosis Present on Admission Indicator 8
63 DGNS_CD_9 Diagnosis Code 9
64 DGNS_VRSN_CD_9 Diagnosis Version Code 9 (ICD-9 or ICD-10)
65 DGNS_POA_IND_9 Diagnosis Present on Admission Indicator 9
66 DGNS_CD_10 Diagnosis Code 10
67 DGNS_VRSN_CD_10 Diagnosis Version Code 10 (ICD-9 or ICD-10)
68 DGNS_POA_IND_10 Diagnosis Present on Admission Indicator 10
69 DGNS_CD_11 Diagnosis Code 11
70 DGNS_VRSN_CD_11 Diagnosis Version Code 11 (ICD-9 or ICD-10)
71 DGNS_POA_IND_11 Diagnosis Present on Admission Indicator 11
72 DGNS_CD_12 Diagnosis Code 12
73 DGNS_VRSN_CD_12 Diagnosis Version Code 12 (ICD-9 or ICD-10)
74 DGNS_POA_IND_12 Diagnosis Present on Admission Indicator 12
75 HAC_IND Health Care Acquired Condition (HAC) Indicator
76 IP_MH_DGNS_IND Mental Health Diagnosis Indicator
77 IP_SUD_DGNS_IND Substance Use Disorder Diagnosis Indicator
78 DRG_CD Diagnosis Related Group (DRG) Code
79 DRG_CD_SYS DRG Code System/Nomenclature
80 DRG_DESC Description of DRG Code
81 MDC_CD Major Diagnostic Category (MDC) Code
82 PRCDR_CD_DT_1 Date Procedures 1 Performed
83 PRCDR_CD_1 Procedure Code 1
84 PRCDR_CD_SYS_1 Procedure Code 1 System/Nomenclature
85 PRCDR_CD_DT_2 Date Procedures 2 Performed
86 PRCDR_CD_2 Procedure Code 2
87 PRCDR_CD_SYS_2 Procedure Code 2 System/Nomenclature
88 PRCDR_CD_DT_3 Date Procedures 3 Performed
89 PRCDR_CD_3 Procedure Code 3
90 PRCDR_CD_SYS_3 Procedure Code 3 System/Nomenclature
91 PRCDR_CD_DT_4 Date Procedures 4 Performed
92 PRCDR_CD_4 Procedure Code 4
93 PRCDR_CD_SYS_4 Procedure Code 4 System/Nomenclature
94 PRCDR_CD_DT_5 Date Procedures 5 Performed
95 PRCDR_CD_5 Procedure Code 5
96 PRCDR_CD_SYS_5 Procedure Code 5 System/Nomenclature
97 PRCDR_CD_DT_6 Date Procedures 6 Performed
98 PRCDR_CD_6 Procedure Code 6
99 PRCDR_CD_SYS_6 Procedure Code 6 System/Nomenclature
100 ADMTG_PRVDR_ID Admitting Provider Identification Number
101 ADMTG_PRVDR_NPI Admitting Provider NPI
102 ADMTG_PRVDR_TXNMY_CD Admitting Provider Taxonomy Code
103 ADMTG_PRVDR_TYPE_CD Admitting Provider Type Code
104 ADMTG_PRVDR_SPCLTY_CD Admitting Provider Specialty Code
105 BLG_PRVDR_ID Billing Provider Identification Number (TAF)
106 BLG_PRVDR_NPI Billing Provider NPI
107 BLG_PRVDR_TXNMY_CD Billing Provider Taxonomy Code
108 BLG_PRVDR_TYPE_CD Billing Provider Type Code
109 BLG_PRVDR_SPCLTY_CD Billing Provider Specialty Code
110 RFRG_PRVDR_ID Referring Provider Identification Number
111 RFRG_PRVDR_NPI Referring Provider NPI
112 RFRG_PRVDR_TYPE_CD Referring Provider Type Code
113 RFRG_PRVDR_SPCLTY_CD Referring Provider Specialty Code
114 PRVDR_LCTN_CD Provider Location Code
115 BRDR_STATE_IND Border State Indicator
116 IP_MH_TXNMY_IND Mental Health Provider Taxonomy Indicator
117 IP_SUD_TXNMY_IND Substance Use Disorder Provider Taxonomy Indicator
118 NCVRD_DAYS Medicaid Non-covered Days Count
119 CVRD_DAYS Medicaid Covered Inpatient Days Count
120 OUTLIER_DAYS Outlier Days Count
121 OUTLIER_TYPE_CD Outlier Type Code
122 DRG_OUTLIER_AMT DRG Outlier Additional Payment Amount
123 FIXD_PYMT_IND Fixed Payment Indicator
124 SRVC_TRKNG_PYMT_AMT Service Tracking Payment Amount
125 DRG_RLTV_WT DRG Relative Weight
126 PYMT_LVL_IND Payment Level Indicator - Header or Line
127 BILLED_AMT Total Claim Billed Amount
128 NCVRD_CHRG_AMT Non-covered Charges Amount
129 MDCD_ALOWD_AMT Total Medicaid Allowed Amount
130 MDCD_PD_AMT Total Amount Paid By Medicaid
131 MDCD_COPAY_AMT Total Copay Amount Paid by Beneficiary
132 MDCD_DSH_PD_AMT Medicaid Amount Paid Disproportionate Share Hospital (DSH)
133 MDCR_PD_AMT Medicare Paid Amount
134 MDCR_DDCTBL_PD_AMT Total Medicare Deductible Amount
135 MDCR_COINSRNC_PD_AMT Total Medicare Coinsurance Amount
136 MDCR_CMBND_DDCTBL_IND Medicare Combined Deductible and Coinsurance Indicator
137 MDCR_REIMBRSMT_TYPE_CD Medicare Reimbursement Type Code
138 COINSRNC_AMT Beneficiary Coinsurance Amount
139 COPAY_AMT Beneficiary Copayment Amount
140 DDCTBL_AMT Beneficiary Deductible Amount
141 COPAY_WVD_IND Indicator Signifying Copay was Waived by Provider
142 TP_PD_AMT Total Third Party Liability Paid Amount
143 TP_COINSRNC_PD_AMT Third Party Coinsurance Paid Amount
144 TP_COPAY_PD_AMT Third Party Copayment Paid Amount
145 OTHR_INSRNC_PD_AMT Total Other Than Medicare or Medicaid -Insurance Paid Amount
146 OTHR_TP_CLCTN_CD Other Third Party Collection Code
147 FUNDNG_CD Code To Indicate Source of Non-Federal Funding
148 FUNDNG_SRC_NON_FED_SHR_CD Funding Source Non-Federal Share Code
149 DA_RUN_ID TAF Production Run Identifier (unique for each TAF run)
150 TMSIS_RUN_ID TMSIS State Data Processing Run Identifier
151 IP_VRSN Inpatient Version Representing the Iteration of the File
152 IP_FIL_DT Inpatient File Date - Represents the Year and Month of the Reporting Period
153 CCW_LD_DT CCW Load Date

Occurrence Code File

NumberSAS NameVariable Name
154 BENE_ID Encrypted CCW Beneficiary Identifier
155 MSIS_ID Encrypted State Assigned Beneficiary Unique Identifier
156 STATE_CD Submitting State Alpha Abbreviation
157 SUBMTG_STATE_CD Submitting State FIPS Code
158 CLM_ID CCW Claim Identifier
159 OCRNC_CD_SEQ  Occurrence Code Sequence
160 OCRNC_CD Occurrence Code
161 OCRNC_CD_START_DT Occurrence Code Start Date
162 OCRNC_CD_END_DT Occurrence Code End Date

LINE FILE

NumberSAS NameVariable Name
163 BENE_ID Encrypted CCW Beneficiary Identifier
164 MSIS_ID Encrypted State Assigned Beneficiary Unique Identifier
165 STATE_CD Submitting State Alpha Abbreviation
166 SUBMTG_STATE_CD Submitting State FIPS Code
167 CLM_ID CCW Claim Identifier
168 LINE_NUM Sequential Claim Line Number
169 CLM_NUM_ORIG Original Claim Identifier
170 LINE_NUM_ORIG Original Claim Line Number (TAF)
171 CLM_NUM_ADJ Adjustment Claim Identifier
172 LINE_NUM_ADJ Adjustment Claim Line Number
173 ADJDCTN_DT Adjudication Date
174 LINE_CLAIM_STUS_CD Claim Line Status Code
175 LINE_ADJUST_CD Claim Line Adjustment Code
176 LINE_SRVC_BGN_DT Claim Line Beginning Date of Service
177 LINE_SRVC_END_DT Claim Line Ending Date of Service
178 BNFT_TYPE_CD Benefit Type Code
179 TOS_CD Type of Service Code
180 XIX_SRVC_CTGRY_CD CMS-64 Form Category of Service for the Paid Claim
181 XXI_SRVC_CTGRY_CD CMS-21 Form Category of Service for the Paid Claim
182 CMS_64_FED_CTGRY_CD CMS-64 Form Code for Federal Reimbursement
183 REV_CNTR_CD Revenue Center Code (TAF)
184 ACTL_SRVC_QTY Actual Service Quantity
185 ALOWD_SRVC_QTY Maximum Allowed Service Quantity
186 NDC National Drug Code
187 NDC_UOM_CD NDC Unit of Measure Code
188 NDC_QTY NDC Quantity Dispensed
189 IMNZTN_TYPE_CD Immunization Type Code
190 PRVDR_FAC_TYPE_CD Provider Facility Type Code
191 SRVC_PRVDR_ID Servicing Provider Identification Number (TAF)
192 SRVC_PRVDR_NPI Servicing Provider NPI
193 SRVC_PRVDR_TXNMY_CD Servicing Provider Taxonomy Code
194 SRVC_PRVDR_TYPE_CD Servicing Provider Type Code
195 SRVC_PRVDR_SPCLTY_CD Servicing Provider Specialty Code (TAF)
196 OPRTG_PRVDR_NPI Operating Provider NPI
197 REV_CNTR_CHRG_AMT Revenue Center Charge Amount
198 LINE_MDCD_ALOWD_AMT Line Medicaid Allowed Amount
199 LINE_MDCD_PD_AMT Line Medicaid Paid Amount
200 LINE_MDCD_FFS_EQUIV_AMT Line Medicaid Fee For Service Equivalent Amount
201 LINE_OTHR_INSRNC_PD_AMT Line Other Than Medicare or Medicaid -Insurance Paid Amount
202 IP_ACCMDTN_HCPCS_RATE Inpatient Hospital Accommodation Rate
203 DA_RUN_ID TAF Production Run Identifier (unique for each TAF run)
204 TMSIS_RUN_ID TMSIS State Data Processing Run Identifier