Back to top

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

SAS NameVariable Name
1BENE_IDEncrypted CCW Beneficiary Identifier
2MSIS_IDEncrypted State Assigned Beneficiary Unique Identifier
3STATE_CDSubmitting State Alpha Abbreviation
4SUBMTG_STATE_CDSubmitting State FIPS Code
5CLM_IDCCW Claim Identifier
6CLM_NUM_ORIGOriginal Claim Identifier
7CLM_NUM_ADJAdjustment Claim Identifier
8CLM_TYPE_CDClaim Type Code
9CROSSOVER_CLM_INDCode To Indicate if a Portion of Claim is Paid by Medicare
10ADJUST_CDClaim Adjustment Code
11ADJUST_RSN_CDAdjustment Reason Code
12ADJDCTN_DTAdjudication Date
13MDCD_PD_DTMedicaid Paid Date
14CMPND_DRUG_INDCompound Drug Indicator
15CLL_CNTClaim Line Count - Original
16CLL_CNT_CALCClaim Line Count - Calculated
17SRVC_TRKNG_TYPE_CDService Tracking Type Code
18BIRTH_DTDate of Birth
19PGM_TYPE_CDProgram Type Code
20MC_PLAN_IDManaged Care Plan Identification Number
21WVR_TYPE_CDWaiver Type Code
22WVR_IDWaiver Identification Number
23OTHR_INSRNC_INDIndicator Insured is Covered by Another Plan (Not Medicare or Medicaid)
24SECT_1115A_DEMO_IND1115(A) Demonstration Participation Indicator
25PRSCRBD_DTPrescribed Date (TAF)
26RX_FILL_DTPrescription Fill Date (TAF)
27BLG_PRVDR_IDBilling Provider Identification Number (TAF)
28BLG_PRVDR_NPIBilling Provider NPI
29BLG_PRVDR_TXNMY_CDBilling Provider Taxonomy Code
30BLG_PRVDR_SPCLTY_CDBilling Provider Specialty Code
31PRSCRBNG_PRVDR_IDPrescribing Provider Identification Number
32PRSCRBNG_PRVDR_NPIPrescribing Provider NPI
33DSPNSNG_PRVDR_IDDispensing Provider Identification Number
34DSPNSNG_PRVDR_NPIDispensing Provider NPI
35PRVDR_LCTN_CDProvider Location Code
36BRDR_STATE_INDBorder State Indicator
37FIXD_PYMT_INDFixed Payment Indicator
38SRVC_TRKNG_PYMT_AMTService Tracking Payment Amount
39PYMT_LVL_INDPayment Level Indicator - Header or Line
40BILLED_AMTTotal Claim Billed Amount
41MDCD_ALOWD_AMTTotal Medicaid Allowed Amount
42MDCD_PD_AMTTotal Amount Paid By Medicaid
43MDCD_COPAY_AMTTotal Copay Amount Paid by Beneficiary
44MDCR_DDCTBL_PD_AMTTotal Medicare Deductible Amount
45MDCR_COINSRNC_PD_AMTTotal Medicare Coinsurance Amount
46COINSRNC_AMTBeneficiary Coinsurance Amount
47COPAY_AMTBeneficiary Copayment Amount
48DDCTBL_AMTBeneficiary Deductible Amount
49COPAY_WVD_INDIndicator Signifying Copay was Waived by Provider
50TP_PD_AMTTotal Third Party Liability Paid Amount
51TP_COINSRNC_PD_AMTThird Party Coinsurance Paid Amount
52TP_COPAY_PD_AMTThird Party Copayment Paid Amount
53OTHR_INSRNC_PD_AMTTotal Other Than Medicare or Medicaid -Insurance Paid Amount
54OTHR_TP_CLCTN_CDOther Third Party Collection Code
55FUNDNG_CDCode To Indicate Source of Non-Federal Funding
56FUNDNG_SRC_NON_FED_SHR_CDFunding Source Non-Federal Share Code
57DA_RUN_IDTAF Production Run Identifier (unique for each TAF run)
58TMSIS_RUN_IDTMSIS State Data Processing Run Identifier
59RX_VRSNRx Version Representing the Iteration of the File
60RX_FIL_DTRX File Date - Represents the Year and Month of the Reporting Period
61CCW_LD_DTCCW Load Date (Claims)

LINE FILE

SAS NameVariable Name
62BENE_IDEncrypted CCW Beneficiary Identifier
63MSIS_IDEncrypted State Assigned Beneficiary Unique Identifier
64STATE_CDSubmitting State Alpha Abbreviation
65SUBMTG_STATE_CDSubmitting State FIPS Code
66CLM_IDCCW Claim Identifier
67LINE_NUMSequential Claim Line Number
68CLM_NUM_ORIGOriginal Claim Identifier
69LINE_NUM_ORIGOriginal Claim Line Number (TAF)
70CLM_NUM_ADJAdjustment Claim Identifier
71LINE_NUM_ADJAdjustment Claim Line Number
72ADJDCTN_DTAdjudication Date
73LINE_CLAIM_STUS_CDClaim Line Status Code
74LINE_ADJUST_CDClaim Line Adjustment Code
75BNFT_TYPE_CDBenefit Type Code
76TOS_CDType of Service Code
77XIX_SRVC_CTGRY_CDCMS-64 Form Category of Service for the Paid Claim
78XXI_SRVC_CTGRY_CDCMS-21 Form Category of Service for the Paid Claim
79CMS_64_FED_CTGRY_CDCMS-64 Form Code for Federal Reimbursement
80RX_FILL_DTPrescription Fill Date (TAF)
81NDCNational Drug Code
82NDC_UOM_CDNDC Unit of Measure Code
83NDC_QTYNDC Quantity Dispensed
84MTRC_DCML_QTYMetric Decimal Quantity of Product
85NDC_QTY_ALOWDNDC Quantity Allowed
86DAYS_SUPPLYDays Supply (TAF)
87NEW_RX_REFILL_NUMNew Prescription Indicator (00) or Number of Refills
88BRND_GNRC_CDBrand - Generic Code
89DOSAGE_FORM_CDMedication Dosage Form Code
90REBT_ELGBL_CDRebate Eligible Code
91DRUG_UTLZTN_CDDrug Utilization Code
92RSN_SRVC_CDReason for Service Code
93PROF_SRVC_CDProfessional Service Code
94RSLT_SRVC_CDResult of Service Code
95IMNZTN_TYPE_CDImmunization Type Code
96DSPNSNG_FEE_AMTDispensing Fee Amount
97LINE_BILLED_AMTLine Billed Amount
98LINE_MDCD_ALOWD_AMTLine Medicaid Allowed Amount
99LINE_MDCD_PD_AMTLine Medicaid Paid Amount
100LINE_MDCD_FFS_EQUIV_AMTLine Medicaid Fee For Service Equivalent Amount
101LINE_MDCR_PD_AMTLine Medicare Paid Amount
102LINE_MDCR_DDCTBL_PD_AMTLine Medicare Deductible Amount
103LINE_MDCR_COINSRNC_PD_AMTLine Medicare Coinsurance Amount
104LINE_COPAY_AMTLine Beneficiary Copayment Amount
105LINE_TP_PD_AMTLine Third Party Liability Paid Amount
106LINE_OTHR_INSRNC_PD_AMTLine Other Than Medicare or Medicaid -Insurance Paid Amount
107DA_RUN_IDTAF Production Run Identifier (unique for each TAF run)
108TMSIS_RUN_IDTMSIS State Data Processing Run Identifier
CSV