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 PGM_TYPE_CD Program Type Code
22 MC_PLAN_ID Managed Care Plan Identification Number
23 WVR_TYPE_CD Waiver Type Code
24 WVR_ID Waiver Identification Number
25 OTHR_INSRNC_IND Indicator Insured is Covered by Another Plan (Not Medicare or Medicaid)
26 SECT_1115A_DEMO_IND 1115(A) Demonstration Participation Indicator
27 SRVC_BGN_DT Claim Beginning Date of Service
28 SRVC_END_DT Claim Ending Date of Service
29 SRVC_END_DT_CD Identifies the Date Field Used to Populate SRVC_END_DT
30 ADMSM_DT Admission Date (TAF)
31 ADMSN_HR Admission Hour
32 DSCHRG_DT Discharge Date
33 DSCHRG_HR Discharge Hour
34 ADMTG_DGNS_CD Admitting Diagnosis Code
35 ADMTG_DGNS_VRSN_CD Admitting Diagnosis Version Code (ICD-9 or ICD-10)
36 DGNS_CD_1 Primary or Principal Diagnosis Code
37 DGNS_VRSN_CD_1 Diagnosis Version Code 1 (ICD-9 or ICD-10)
38 DGNS_POA_IND_1 Diagnosis Present on Admission Indicator 1
39 DGNS_CD_2 Diagnosis Code 2
40 DGNS_VRSN_CD_2 Diagnosis Version Code 2 (ICD-9 or ICD-10)
41 DGNS_POA_IND_2 Diagnosis Present on Admission Indicator 2
42 DGNS_CD_3 Diagnosis Code 3
43 DGNS_VRSN_CD_3 Diagnosis Version Code 3 (ICD-9 or ICD-10)
44 DGNS_POA_IND_3 Diagnosis Present on Admission Indicator 3
45 DGNS_CD_4 Diagnosis Code 4
46 DGNS_VRSN_CD_4 Diagnosis Version Code 4 (ICD-9 or ICD-10)
47 DGNS_POA_IND_4 Diagnosis Present on Admission Indicator 4
48 DGNS_CD_5 Diagnosis Code 5
49 DGNS_VRSN_CD_5 Diagnosis Version Code 5 (ICD-9 or ICD-10)
50 DGNS_POA_IND_5 Diagnosis Present on Admission Indicator 5
51 HAC_IND Health Care Acquired Condition (HAC) Indicator
52 IP_MH_DGNS_IND Mental Health Diagnosis Indicator
53 IP_SUD_DGNS_IND Substance Use Disorder Diagnosis Indicator
54 ADMTG_PRVDR_ID Admitting Provider Identification Number
55 ADMTG_PRVDR_NPI Admitting Provider NPI
56 ADMTG_PRVDR_TXNMY_CD Admitting Provider Taxonomy Code
57 ADMTG_PRVDR_TYPE_CD Admitting Provider Type Code
58 ADMTG_PRVDR_SPCLTY_CD Admitting Provider Specialty Code
59 BLG_PRVDR_ID Billing Provider Identification Number (TAF)
60 BLG_PRVDR_NPI Billing Provider NPI
61 BLG_PRVDR_TXNMY_CD Billing Provider Taxonomy Code
62 BLG_PRVDR_TYPE_CD Billing Provider Type Code
63 BLG_PRVDR_SPCLTY_CD Billing Provider Specialty Code
64 RFRG_PRVDR_ID Referring Provider Identification Number
65 RFRG_PRVDR_NPI Referring Provider NPI
66 RFRG_PRVDR_TYPE_CD Referring Provider Type Code
67 RFRG_PRVDR_SPCLTY_CD Referring Provider Specialty Code
68 PRVDR_LCTN_CD Provider Location Code
69 BRDR_STATE_IND Border State Indicator
70 IP_MH_TXNMY_IND Mental Health Provider Taxonomy Indicator
71 IP_SUD_TXNMY_IND Substance Use Disorder Provider Taxonomy Indicator
72 NCVRD_DAYS Medicaid Non-covered Days Count
73 CVRD_DAYS_ICF_IID Count of Medicaid Covered Days in ICF for Patients with Intellectual Disability
74 CVRD_DAYS_NF Count of Medicaid Covered Days in a Nursing Facility
75 CVRD_DAYS_IP_PSYCH Count of Medicaid Covered Days in an Inpatient Psychiatric Facility (IPF)
76 CVRD_DAYS_IP_PSYCH_OVER_65 Count of Medicaid Covered Days in an IPF (Beneficiary Over 65 Years)
77 CVRD_DAYS_IP_PSYCH_UNDER_21 Count of Medicaid Covered Days in an IPF (Beneficiary Under 21 Years)
78 LEAVE_DAYS Count of Days During Medicaid Coverage Period Patient was not Residing in LTC
79 FIXD_PYMT_IND Fixed Payment Indicator
80 SRVC_TRKNG_PYMT_AMT Service Tracking Payment Amount
81 PYMT_LVL_IND Payment Level Indicator - Header or Line
82 BILLED_AMT Total Claim Billed Amount
83 NCVRD_CHRG_AMT Non-covered Charges Amount
84 MDCD_ALOWD_AMT Total Medicaid Allowed Amount
85 MDCD_PD_AMT Total Amount Paid By Medicaid
86 DAILY_RATE Daily Rate that a Policy will Pay for a Covered Service
87 MDCD_ACMDTN_PD_AMT Medicaid Amount Paid for All Accommodation (Room and Board) Revenue Lines
88 MDCD_ANCLRY_PD_AMT Medicaid Amount Paid for All Ancillary (Non-Room & Board) Revenue Lines
89 MDCR_PD_AMT Medicare Paid Amount
90 MDCR_DDCTBL_PD_AMT Total Medicare Deductible Amount
91 MDCR_COINSRNC_PD_AMT Total Medicare Coinsurance Amount
92 MDCR_CMBND_DDCTBL_IND Medicare Combined Deductible and Coinsurance Indicator
93 MDCR_REIMBRSMT_TYPE_CD Medicare Reimbursement Type Code
94 BENE_LIABILITY_AMT Total Beneficiary Long-Term Care Liability Amount
95 COINSRNC_AMT Beneficiary Coinsurance Amount
96 COPAY_AMT Beneficiary Copayment Amount
97 DDCTBL_AMT Beneficiary Deductible Amount
98 COPAY_WVD_IND Indicator Signifying Copay was Waived by Provider
99 TP_PD_AMT Total Third Party Liability Paid Amount
100 TP_COINSRNC_PD_AMT Third Party Coinsurance Paid Amount
101 TP_COPAY_PD_AMT Third Party Copayment Paid Amount
102 OTHR_INSRNC_PD_AMT Total Other Than Medicare or Medicaid -Insurance Paid Amount
103 OTHR_TP_CLCTN_CD Other Third Party Collection Code
104 FUNDNG_CD Code To Indicate Source of Non-Federal Funding
105 FUNDNG_SRC_NON_FED_SHR_CD Funding Source Non-Federal Share Code
106 DA_RUN_ID TAF Production Run Identifier (unique for each TAF run)
107 TMSIS_RUN_ID TMSIS State Data Processing Run Identifier
108 LT_VRSN Long-Term Version Representing the Iteration of the File
109 LT_FIL_DT Long-Term File Date - Represents the Year and Month of the Reporting Period
110 CCW_LD_DT CCW Load Date (Claims)

Occurrence Code File

NumberSAS NameVariable Name
111 BENE_ID Encrypted CCW Beneficiary Identifier
112 MSIS_ID Encrypted State Assigned Beneficiary Unique Identifier
113 STATE_CD Submitting State Alpha Abbreviation
114 SUBMTG_STATE_CD Submitting State FIPS Code
115 CLM_ID CCW Claim Identifier
116 OCRNC_CD_SEQ  Occurrence Code Sequence
117 OCRNC_CD Occurrence Code
118 OCRNC_CD_START_DT Occurrence Code Start Date
119 OCRNC_CD_END_DT Occurrence Code End Date

LINE FILE

NumberSAS NameVariable Name
120 BENE_ID Encrypted CCW Beneficiary Identifier
121 MSIS_ID Encrypted State Assigned Beneficiary Unique Identifier
122 STATE_CD Submitting State Alpha Abbreviation
123 SUBMTG_STATE_CD Submitting State FIPS Code
124 CLM_ID CCW Claim Identifier
125 LINE_NUM Sequential Claim Line Number
126 CLM_NUM_ORIG Original Claim Identifier
127 LINE_NUM_ORIG Original Claim Line Number (TAF)
128 CLM_NUM_ADJ Adjustment Claim Identifier
129 LINE_NUM_ADJ Adjustment Claim Line Number
130 ADJDCTN_DT Adjudication Date
131 LINE_CLAIM_STUS_CD Claim Line Status Code
132 LINE_ADJUST_CD Claim Line Adjustment Code
133 LINE_SRVC_BGN_DT Claim Line Beginning Date of Service
134 LINE_SRVC_END_DT Claim Line Ending Date of Service
135 BNFT_TYPE_CD Benefit Type Code
136 TOS_CD Type of Service Code
137 XIX_SRVC_CTGRY_CD CMS-64 Form Category of Service for the Paid Claim
138 XXI_SRVC_CTGRY_CD CMS-21 Form Category of Service for the Paid Claim
139 CMS_64_FED_CTGRY_CD CMS-64 Form Code for Federal Reimbursement
140 REV_CNTR_CD Revenue Center Code (TAF)
141 ACTL_SRVC_QTY Actual Service Quantity
142 ALOWD_SRVC_QTY Maximum Allowed Service Quantity
143 BLG_UOM_CD Service Billing Unit of Measure Code
144 NDC National Drug Code
145 NDC_UOM_CD NDC Unit of Measure Code
146 NDC_QTY NDC Quantity Dispensed
147 IMNZTN_TYPE_CD Immunization Type Code
148 PRVDR_FAC_TYPE_CD Provider Facility Type Code
149 SRVC_PRVDR_ID Servicing Provider Identification Number (TAF)
150 SRVC_PRVDR_NPI Servicing Provider NPI
151 SRVC_PRVDR_TXNMY_CD Servicing Provider Taxonomy Code
152 SRVC_PRVDR_TYPE_CD Servicing Provider Type Code
153 SRVC_PRVDR_SPCLTY_CD Servicing Provider Specialty Code (TAF)
154 REV_CNTR_CHRG_AMT Revenue Center Charge Amount
155 LINE_MDCD_ALOWD_AMT Line Medicaid Allowed Amount
156 LINE_MDCD_PD_AMT Line Medicaid Paid Amount
157 LINE_MDCD_FFS_EQUIV_AMT Line Medicaid Fee For Service Equivalent Amount
158 LINE_TP_PD_AMT Line Third Party Liability Paid Amount
159 LINE_OTHR_INSRNC_PD_AMT Line Other Than Medicare or Medicaid -Insurance Paid Amount
160 LT_ACCMDTN_HCPCS_RATE Long-Term Care Accommodation Rate
161 DA_RUN_ID TAF Production Run Identifier (unique for each TAF run)
162 TMSIS_RUN_ID TMSIS State Data Processing Run Identifier