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 CLL_CNT Claim Line Count - Original
16 CLL_CNT_CALC Claim Line Count - Calculated
17 SRVC_TRKNG_TYPE_CD Service Tracking Type Code
18 BIRTH_DT Date of Birth
19 PGM_TYPE_CD Program Type Code
20 MC_PLAN_ID Managed Care Plan Identification Number
21 WVR_TYPE_CD Waiver Type Code
22 WVR_ID Waiver Identification Number
23 OTHR_INSRNC_IND Indicator Insured is Covered by Another Plan (Not Medicare or Medicaid)
24 SECT_1115A_DEMO_IND 1115(A) Demonstration Participation Indicator
25 SRVC_BGN_DT Claim Beginning Date of Service
26 SRVC_END_DT Claim Ending Date of Service
27 SRVC_END_DT_CD Identifies the Date Field Used to Populate SRVC_END_DT
28 DGNS_CD_1 Primary or Principal Diagnosis Code
29 DGNS_VRSN_CD_1 Diagnosis Version Code 1 (ICD-9 or ICD-10)
30 DGNS_POA_IND_1 Diagnosis Present on Admission Indicator 1
31 DGNS_CD_2 Diagnosis Code 2
32 DGNS_VRSN_CD_2 Diagnosis Version Code 2 (ICD-9 or ICD-10)
33 DGNS_POA_IND_2 Diagnosis Present on Admission Indicator 2
34 HAC_IND Health Care Acquired Condition (HAC) Indicator
35 IP_MH_DGNS_IND Mental Health Diagnosis Indicator
36 IP_SUD_DGNS_IND Substance Use Disorder Diagnosis Indicator
37 POS_CD Place of Service Code
38 BLG_PRVDR_ID Billing Provider Identification Number (TAF)
39 BLG_PRVDR_NPI Billing Provider NPI
40 BLG_PRVDR_TXNMY_CD Billing Provider Taxonomy Code
41 BLG_PRVDR_TYPE_CD Billing Provider Type Code
42 BLG_PRVDR_SPCLTY_CD Billing Provider Specialty Code
43 RFRG_PRVDR_ID Referring Provider Identification Number
44 RFRG_PRVDR_NPI Referring Provider NPI
45 RFRG_PRVDR_TXNMY_CD Referring Provider Taxonomy Code
46 RFRG_PRVDR_TYPE_CD Referring Provider Type Code
47 RFRG_PRVDR_SPCLTY_CD Referring Provider Specialty Code
48 DRCTNG_PRVDR_NPI NPI of Provider Directing the Patient's Care
49 DRCTNG_PRVDR_TXNMY_CD Taxonomy Code of Provider Directing the Patient's Care
50 SPRVSNG_PRVDR_NPI Supervising Provider NPI
51 SPRVSNG_PRVDR_TXNMY_CD Supervising Provider Taxonomy Code
52 HLTH_HOME_PRVDR_IND Health Home Provider Indicator
53 HLTH_HOME_PRVDR_NPI Health Home Provider NPI
54 HLTH_HOME_ENT_NAME Health Home Entity Name
55 PRVDR_LCTN_CD Provider Location Code
56 BRDR_STATE_IND Border State Indicator
57 IP_MH_TXNMY_IND Mental Health Provider Taxonomy Indicator
58 IP_SUD_TXNMY_IND Substance Use Disorder Provider Taxonomy Indicator
59 FIXD_PYMT_IND Fixed Payment Indicator
60 SRVC_TRKNG_PYMT_AMT Service Tracking Payment Amount
61 PYMT_LVL_IND Payment Level Indicator - Header or Line
62 CPTATD_PYMT_BILLED_AMT Capitated Payment Billed Amount
63 CPTATD_PYMT_BILLED_DT Capitated Payment Billed Date
64 BILLED_AMT Total Claim Billed Amount
65 MDCD_ALOWD_AMT Total Medicaid Allowed Amount
66 MDCD_PD_AMT Total Amount Paid By Medicaid
67 DAILY_RATE Daily Rate that a Policy will Pay for a Covered Service
68 MDCD_COPAY_AMT Total Copay Amount Paid by Beneficiary
69 MDCR_DDCTBL_PD_AMT Total Medicare Deductible Amount
70 MDCR_COINSRNC_PD_AMT Total Medicare Coinsurance Amount
71 MDCR_CMBND_DDCTBL_IND Medicare Combined Deductible and Coinsurance Indicator
72 MDCR_REIMBRSMT_TYPE_CD Medicare Reimbursement Type Code
73 COINSRNC_AMT Beneficiary Coinsurance Amount
74 COINSRNC_PD_DT Beneficiary Coinsurance Paid Date
75 COPAY_AMT Beneficiary Copayment Amount
76 COPAY_PD_DT Beneficiary Copayment Paid Date
77 DDCTBL_AMT Beneficiary Deductible Amount
78 DDCTBL_PD_DT Beneficiary Deductible Paid Date
79 COPAY_WVD_IND Indicator Signifying Copay was Waived by Provider
80 TP_PD_AMT Total Third Party Liability Paid Amount
81 TP_COINSRNC_PD_AMT Third Party Coinsurance Paid Amount
82 TP_COPAY_PD_AMT Third Party Copayment Paid Amount
83 OTHR_INSRNC_PD_AMT Total Other Than Medicare or Medicaid -Insurance Paid Amount
84 OTHR_TP_CLCTN_CD Other Third Party Collection Code
85 FUNDNG_CD Code To Indicate Source of Non-Federal Funding
86 FUNDNG_SRC_NON_FED_SHR_CD Funding Source Non-Federal Share Code
87 REMITTANCE_NUM Remittance Number
88 DA_RUN_ID TAF Production Run Identifier (unique for each TAF run)
89 TMSIS_RUN_ID TMSIS State Data Processing Run Identifier
90 OT_VRSN Other Services Version Representing the Iteration of the File
91 OT_FIL_DT Other Services File Date - Represents the Year and Month of the Reporting Period
92 CCW_LD_DT CCW Load Date (Claims)

Occurrence Code File

NumberSAS NameVariable Name
93 BENE_ID Encrypted CCW Beneficiary Identifier
94 MSIS_ID Encrypted State Assigned Beneficiary Unique Identifier
95 STATE_CD Submitting State Alpha Abbreviation
96 SUBMTG_STATE_CD Submitting State FIPS Code
97 CLM_ID CCW Claim Identifier
98 OCRNC_CD_SEQ  Occurrence Code Sequence
99 OCRNC_CD Occurrence Code
100 OCRNC_CD_START_DT Occurrence Code Start Date
101 OCRNC_CD_END_DT Occurrence Code End Date

LINE FILE

NumberSAS NameVariable Name
102 BENE_ID Encrypted CCW Beneficiary Identifier
103 MSIS_ID Encrypted State Assigned Beneficiary Unique Identifier
104 STATE_CD Submitting State Alpha Abbreviation
105 SUBMTG_STATE_CD Submitting State FIPS Code
106 CLM_ID CCW Claim Identifier
107 LINE_NUM Sequential Claim Line Number
108 CLM_NUM_ORIG Original Claim Identifier
109 LINE_NUM_ORIG Original Claim Line Number (TAF)
110 CLM_NUM_ADJ Adjustment Claim Identifier
111 LINE_NUM_ADJ Adjustment Claim Line Number
112 ADJDCTN_DT Adjudication Date
113 LINE_CLAIM_STUS_CD Claim Line Status Code
114 LINE_ADJUST_CD Claim Line Adjustment Code
115 LINE_ADJUST_RSN_CD Claim Line Adjustment Reason Code
116 LINE_SRVC_BGN_DT Claim Line Beginning Date of Service
117 LINE_SRVC_END_DT Claim Line Ending Date of Service
118 BNFT_TYPE_CD Benefit Type Code
119 TOS_CD Type of Service Code
120 XIX_SRVC_CTGRY_CD CMS-64 Form Category of Service for the Paid Claim
121 XXI_SRVC_CTGRY_CD CMS-21 Form Category of Service for the Paid Claim
122 CMS_64_FED_CTGRY_CD CMS-64 Form Code for Federal Reimbursement
123 REV_CNTR_CD Revenue Center Code (TAF)
124 ACTL_SRVC_QTY Actual Service Quantity
125 ALOWD_SRVC_QTY Maximum Allowed Service Quantity
126 LINE_PRCDR_CD_DT Date Line Procedure Performed
127 LINE_PRCDR_CD Line Procedure Code
128 LINE_PRCDR_CD_SYS Line Procedure Code System/Nomenclature
129 LINE_PRCDR_MDFR_CD_1 Line Procedure Code Modifier Code 1
130 LINE_PRCDR_MDFR_CD_2 Line Procedure Code Modifier Code 2
131 LINE_PRCDR_MDFR_CD_3 Line Procedure Code Modifier Code 3
132 LINE_PRCDR_MDFR_CD_4 Line Procedure Code Modifier Code 4
133 NDC National Drug Code
134 NDC_UOM_CD NDC Unit of Measure Code
135 NDC_QTY NDC Quantity Dispensed
136 IMNZTN_TYPE_CD Immunization Type Code
137 SELF_DRCTN_TYPE_CD Beneficiary Service Self-Direction Type Code
138 PRE_AUTHRZTN_NUM Pre-Authorization Number
139 HCBS_SRVC_CD Home- and Community-Based Services Service Code
140 HCBS_TXNMY_CD Home- and Community-Based Services Taxonomy Code
141 TOOTH_DSGNTN_SYS Tooth Designation System/Nomenclature
142 TOOTH_NUM Tooth Number
143 TOOTH_ORAL_CVTY_AREA_DSGNTD_CD Tooth Oral Cavity Area Designated Code
144 TOOTH_SRFC_CD Tooth Surface Code
145 SRVC_PRVDR_ID Servicing Provider Identification Number (TAF)
146 SRVC_PRVDR_NPI Servicing Provider NPI
147 SRVC_PRVDR_TXNMY_CD Servicing Provider Taxonomy Code
148 SRVC_PRVDR_TYPE_CD Servicing Provider Type Code
149 SRVC_PRVDR_SPCLTY_CD Servicing Provider Specialty Code (TAF)
150 LINE_BILLED_AMT Line Billed Amount
151 LINE_MDCD_ALOWD_AMT Line Medicaid Allowed Amount
152 LINE_MDCD_PD_AMT Line Medicaid Paid Amount
153 LINE_MDCD_FFS_EQUIV_AMT Line Medicaid Fee For Service Equivalent Amount
154 LINE_MDCR_PD_AMT Line Medicare Paid Amount
155 LINE_COPAY_AMT Line Beneficiary Copayment Amount
156 LINE_TP_PD_AMT Line Third Party Liability Paid Amount
157 LINE_OTHR_INSRNC_PD_AMT Line Other Than Medicare or Medicaid -Insurance Paid Amount
158 OT_ACCMDTN_HCPCS_RATE Other Services Accommodation Rate
159 DA_RUN_ID TAF Production Run Identifier (unique for each TAF run)
160 TMSIS_RUN_ID TMSIS State Data Processing Run Identifier