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
9 CROSSOVER_CLM_IND Code To Indicate if a Portion of Claim is Paid by Medicare
10 ADJUST_CD Claim Adjustment Code
11 ADJUST_RSN_CD Adjustment Reason Code
12 ADJDCTN_DT Adjudication Date
13 MDCD_PD_DT Medicaid Paid Date
14 CMPND_DRUG_IND Compound Drug Indicator
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 PRSCRBD_DT Prescribed Date (TAF)
26 RX_FILL_DT Prescription Fill Date (TAF)
27 BLG_PRVDR_ID Billing Provider Identification Number (TAF)
28 BLG_PRVDR_NPI Billing Provider NPI
29 BLG_PRVDR_TXNMY_CD Billing Provider Taxonomy Code
30 BLG_PRVDR_SPCLTY_CD Billing Provider Specialty Code
31 PRSCRBNG_PRVDR_ID Prescribing Provider Identification Number
32 PRSCRBNG_PRVDR_NPI Prescribing Provider NPI
33 DSPNSNG_PRVDR_ID Dispensing Provider Identification Number
34 DSPNSNG_PRVDR_NPI Dispensing Provider NPI
35 PRVDR_LCTN_CD Provider Location Code
36 BRDR_STATE_IND Border State Indicator
37 FIXD_PYMT_IND Fixed Payment Indicator
38 SRVC_TRKNG_PYMT_AMT Service Tracking Payment Amount
39 PYMT_LVL_IND Payment Level Indicator - Header or Line
40 BILLED_AMT Total Claim Billed Amount
41 MDCD_ALOWD_AMT Total Medicaid Allowed Amount
42 MDCD_PD_AMT Total Amount Paid By Medicaid
43 MDCD_COPAY_AMT Total Copay Amount Paid by Beneficiary
44 MDCR_DDCTBL_PD_AMT Total Medicare Deductible Amount
45 MDCR_COINSRNC_PD_AMT Total Medicare Coinsurance Amount
46 COINSRNC_AMT Beneficiary Coinsurance Amount
47 COPAY_AMT Beneficiary Copayment Amount
48 DDCTBL_AMT Beneficiary Deductible Amount
49 COPAY_WVD_IND Indicator Signifying Copay was Waived by Provider
50 TP_PD_AMT Total Third Party Liability Paid Amount
51 TP_COINSRNC_PD_AMT Third Party Coinsurance Paid Amount
52 TP_COPAY_PD_AMT Third Party Copayment Paid Amount
53 OTHR_INSRNC_PD_AMT Total Other Than Medicare or Medicaid -Insurance Paid Amount
54 OTHR_TP_CLCTN_CD Other Third Party Collection Code
55 FUNDNG_CD Code To Indicate Source of Non-Federal Funding
56 FUNDNG_SRC_NON_FED_SHR_CD Funding Source Non-Federal Share Code
57 DA_RUN_ID TAF Production Run Identifier (unique for each TAF run)
58 TMSIS_RUN_ID TMSIS State Data Processing Run Identifier
59 RX_VRSN Rx Version Representing the Iteration of the File
60 RX_FIL_DT RX File Date - Represents the Year and Month of the Reporting Period
61 CCW_LD_DT CCW Load Date (Claims)

LINE FILE

NumberSAS NameVariable Name
62 BENE_ID Encrypted CCW Beneficiary Identifier
63 MSIS_ID Encrypted State Assigned Beneficiary Unique Identifier
64 STATE_CD Submitting State Alpha Abbreviation
65 SUBMTG_STATE_CD Submitting State FIPS Code
66 CLM_ID CCW Claim Identifier
67 LINE_NUM Sequential Claim Line Number
68 CLM_NUM_ORIG Original Claim Identifier
69 LINE_NUM_ORIG Original Claim Line Number (TAF)
70 CLM_NUM_ADJ Adjustment Claim Identifier
71 LINE_NUM_ADJ Adjustment Claim Line Number
72 ADJDCTN_DT Adjudication Date
73 LINE_CLAIM_STUS_CD Claim Line Status Code
74 LINE_ADJUST_CD Claim Line Adjustment Code
75 BNFT_TYPE_CD Benefit Type Code
76 TOS_CD Type of Service Code
77 XIX_SRVC_CTGRY_CD CMS-64 Form Category of Service for the Paid Claim
78 XXI_SRVC_CTGRY_CD CMS-21 Form Category of Service for the Paid Claim
79 CMS_64_FED_CTGRY_CD CMS-64 Form Code for Federal Reimbursement
80 RX_FILL_DT Prescription Fill Date (TAF)
81 NDC National Drug Code
82 NDC_UOM_CD NDC Unit of Measure Code
83 NDC_QTY NDC Quantity Dispensed
84 MTRC_DCML_QTY Metric Decimal Quantity of Product
85 NDC_QTY_ALOWD NDC Quantity Allowed
86 DAYS_SUPPLY Days Supply (TAF)
87 NEW_RX_REFILL_NUM New Prescription Indicator (00) or Number of Refills
88 BRND_GNRC_CD Brand - Generic Code
89 DOSAGE_FORM_CD Medication Dosage Form Code
90 REBT_ELGBL_CD Rebate Eligible Code
91 DRUG_UTLZTN_CD Drug Utilization Code
92 RSN_SRVC_CD Reason for Service Code
93 PROF_SRVC_CD Professional Service Code
94 RSLT_SRVC_CD Result of Service Code
95 IMNZTN_TYPE_CD Immunization Type Code
96 DSPNSNG_FEE_AMT Dispensing Fee Amount
97 LINE_BILLED_AMT Line Billed Amount
98 LINE_MDCD_ALOWD_AMT Line Medicaid Allowed Amount
99 LINE_MDCD_PD_AMT Line Medicaid Paid Amount
100 LINE_MDCD_FFS_EQUIV_AMT Line Medicaid Fee For Service Equivalent Amount
101 LINE_MDCR_PD_AMT Line Medicare Paid Amount
102 LINE_MDCR_DDCTBL_PD_AMT Line Medicare Deductible Amount
103 LINE_MDCR_COINSRNC_PD_AMT Line Medicare Coinsurance Amount
104 LINE_COPAY_AMT Line Beneficiary Copayment Amount
105 LINE_TP_PD_AMT Line Third Party Liability Paid Amount
106 LINE_OTHR_INSRNC_PD_AMT Line Other Than Medicare or Medicaid -Insurance Paid Amount
107 DA_RUN_ID TAF Production Run Identifier (unique for each TAF run)
108 TMSIS_RUN_ID TMSIS State Data Processing Run Identifier