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 (TAF)
9BILL_TYPE_CDBill Type Code
10CROSSOVER_CLM_INDCode To Indicate if a Portion of Claim is Paid by Medicare
11ADJUST_CDClaim Adjustment Code
12ADJUST_RSN_CDAdjustment Reason Code
13ADJDCTN_DTAdjudication Date
14MDCD_PD_DTMedicaid Paid Date
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
25SRVC_BGN_DTClaim Beginning Date of Service
26SRVC_END_DTClaim Ending Date of Service
27SRVC_END_DT_CDIdentifies the Date Field Used to Populate SRVC_END_DT
28DGNS_CD_1Primary or Principal Diagnosis Code
29DGNS_VRSN_CD_1Diagnosis Version Code 1 (ICD-9 or ICD-10)
30DGNS_POA_IND_1Diagnosis Present on Admission Indicator 1
31DGNS_CD_2Diagnosis Code 2
32DGNS_VRSN_CD_2Diagnosis Version Code 2 (ICD-9 or ICD-10)
33DGNS_POA_IND_2Diagnosis Present on Admission Indicator 2
34HAC_INDHealth Care Acquired Condition (HAC) Indicator
35IP_MH_DGNS_INDMental Health Diagnosis Indicator
36IP_SUD_DGNS_INDSubstance Use Disorder Diagnosis Indicator
37POS_CDPlace of Service Code
38BLG_PRVDR_IDBilling Provider Identification Number (TAF)
39BLG_PRVDR_NPIBilling Provider NPI
40BLG_PRVDR_TXNMY_CDBilling Provider Taxonomy Code
41BLG_PRVDR_TYPE_CDBilling Provider Type Code
42BLG_PRVDR_SPCLTY_CDBilling Provider Specialty Code
43RFRG_PRVDR_IDReferring Provider Identification Number
44RFRG_PRVDR_NPIReferring Provider NPI
45RFRG_PRVDR_TXNMY_CDReferring Provider Taxonomy Code
46RFRG_PRVDR_TYPE_CDReferring Provider Type Code
47RFRG_PRVDR_SPCLTY_CDReferring Provider Specialty Code
48DRCTNG_PRVDR_NPINPI of Provider Directing the Patient's Care
49DRCTNG_PRVDR_TXNMY_CDTaxonomy Code of Provider Directing the Patient's Care
50SPRVSNG_PRVDR_NPISupervising Provider NPI
51SPRVSNG_PRVDR_TXNMY_CDSupervising Provider Taxonomy Code
52HLTH_HOME_PRVDR_INDHealth Home Provider Indicator
53HLTH_HOME_PRVDR_NPIHealth Home Provider NPI
54HLTH_HOME_ENT_NAMEHealth Home Entity Name
55PRVDR_LCTN_CDProvider Location Code
56BRDR_STATE_INDBorder State Indicator
57IP_MH_TXNMY_INDMental Health Provider Taxonomy Indicator
58IP_SUD_TXNMY_INDSubstance Use Disorder Provider Taxonomy Indicator
59FIXD_PYMT_INDFixed Payment Indicator
60SRVC_TRKNG_PYMT_AMTService Tracking Payment Amount
61PYMT_LVL_INDPayment Level Indicator - Header or Line
62CPTATD_PYMT_BILLED_AMTCapitated Payment Billed Amount
63CPTATD_PYMT_BILLED_DTCapitated Payment Billed Date
64BILLED_AMTTotal Claim Billed Amount
65MDCD_ALOWD_AMTTotal Medicaid Allowed Amount
66MDCD_PD_AMTTotal Amount Paid By Medicaid
67DAILY_RATEDaily Rate that a Policy will Pay for a Covered Service
68MDCD_COPAY_AMTTotal Copay Amount Paid by Beneficiary
69MDCR_DDCTBL_PD_AMTTotal Medicare Deductible Amount
70MDCR_COINSRNC_PD_AMTTotal Medicare Coinsurance Amount
71MDCR_CMBND_DDCTBL_INDMedicare Combined Deductible and Coinsurance Indicator
72MDCR_REIMBRSMT_TYPE_CDMedicare Reimbursement Type Code
73COINSRNC_AMTBeneficiary Coinsurance Amount
74COINSRNC_PD_DTBeneficiary Coinsurance Paid Date
75COPAY_AMTBeneficiary Copayment Amount
76COPAY_PD_DTBeneficiary Copayment Paid Date
77DDCTBL_AMTBeneficiary Deductible Amount
78DDCTBL_PD_DTBeneficiary Deductible Paid Date
79COPAY_WVD_INDIndicator Signifying Copay was Waived by Provider
80TP_PD_AMTTotal Third Party Liability Paid Amount
81TP_COINSRNC_PD_AMTThird Party Coinsurance Paid Amount
82TP_COPAY_PD_AMTThird Party Copayment Paid Amount
83OTHR_INSRNC_PD_AMTTotal Other Than Medicare or Medicaid -Insurance Paid Amount
84OTHR_TP_CLCTN_CDOther Third Party Collection Code
85FUNDNG_CDCode To Indicate Source of Non-Federal Funding
86FUNDNG_SRC_NON_FED_SHR_CDFunding Source Non-Federal Share Code
87REMITTANCE_NUMRemittance Number
88DA_RUN_IDTAF Production Run Identifier (unique for each TAF run)
89TMSIS_RUN_IDTMSIS State Data Processing Run Identifier
90OT_VRSNOther Services Version Representing the Iteration of the File
91OT_FIL_DTOther Services File Date - Represents the Year and Month of the Reporting Period
92CCW_LD_DTCCW Load Date (Claims)

Occurrence Code File

SAS NameVariable Name
93BENE_IDEncrypted CCW Beneficiary Identifier
94MSIS_IDEncrypted State Assigned Beneficiary Unique Identifier
95STATE_CDSubmitting State Alpha Abbreviation
96SUBMTG_STATE_CDSubmitting State FIPS Code
97CLM_IDCCW Claim Identifier
98OCRNC_CD_SEQ  Occurrence Code Sequence
99OCRNC_CDOccurrence Code
100OCRNC_CD_START_DTOccurrence Code Start Date
101OCRNC_CD_END_DTOccurrence Code End Date

LINE FILE

SAS NameVariable Name
102BENE_IDEncrypted CCW Beneficiary Identifier
103MSIS_IDEncrypted State Assigned Beneficiary Unique Identifier
104STATE_CDSubmitting State Alpha Abbreviation
105SUBMTG_STATE_CDSubmitting State FIPS Code
106CLM_IDCCW Claim Identifier
107LINE_NUMSequential Claim Line Number
108CLM_NUM_ORIGOriginal Claim Identifier
109LINE_NUM_ORIGOriginal Claim Line Number (TAF)
110CLM_NUM_ADJAdjustment Claim Identifier
111LINE_NUM_ADJAdjustment Claim Line Number
112ADJDCTN_DTAdjudication Date
113LINE_CLAIM_STUS_CDClaim Line Status Code
114LINE_ADJUST_CDClaim Line Adjustment Code
115LINE_ADJUST_RSN_CDClaim Line Adjustment Reason Code
116LINE_SRVC_BGN_DTClaim Line Beginning Date of Service
117LINE_SRVC_END_DTClaim Line Ending Date of Service
118BNFT_TYPE_CDBenefit Type Code
119TOS_CDType of Service Code
120XIX_SRVC_CTGRY_CDCMS-64 Form Category of Service for the Paid Claim
121XXI_SRVC_CTGRY_CDCMS-21 Form Category of Service for the Paid Claim
122CMS_64_FED_CTGRY_CDCMS-64 Form Code for Federal Reimbursement
123REV_CNTR_CDRevenue Center Code (TAF)
124ACTL_SRVC_QTYActual Service Quantity
125ALOWD_SRVC_QTYMaximum Allowed Service Quantity
126LINE_PRCDR_CD_DTDate Line Procedure Performed
127LINE_PRCDR_CDLine Procedure Code
128LINE_PRCDR_CD_SYSLine Procedure Code System/Nomenclature
129LINE_PRCDR_MDFR_CD_1Line Procedure Code Modifier Code 1
130LINE_PRCDR_MDFR_CD_2Line Procedure Code Modifier Code 2
131LINE_PRCDR_MDFR_CD_3Line Procedure Code Modifier Code 3
132LINE_PRCDR_MDFR_CD_4Line Procedure Code Modifier Code 4
133NDCNational Drug Code
134NDC_UOM_CDNDC Unit of Measure Code
135NDC_QTYNDC Quantity Dispensed
136IMNZTN_TYPE_CDImmunization Type Code
137SELF_DRCTN_TYPE_CDBeneficiary Service Self-Direction Type Code
138PRE_AUTHRZTN_NUMPre-Authorization Number
139HCBS_SRVC_CDHome- and Community-Based Services Service Code
140HCBS_TXNMY_CDHome- and Community-Based Services Taxonomy Code
141TOOTH_DSGNTN_SYSTooth Designation System/Nomenclature
142TOOTH_NUMTooth Number
143TOOTH_ORAL_CVTY_AREA_DSGNTD_CDTooth Oral Cavity Area Designated Code
144TOOTH_SRFC_CDTooth Surface Code
145SRVC_PRVDR_IDServicing Provider Identification Number (TAF)
146SRVC_PRVDR_NPIServicing Provider NPI
147SRVC_PRVDR_TXNMY_CDServicing Provider Taxonomy Code
148SRVC_PRVDR_TYPE_CDServicing Provider Type Code
149SRVC_PRVDR_SPCLTY_CDServicing Provider Specialty Code (TAF)
150LINE_BILLED_AMTLine Billed Amount
151LINE_MDCD_ALOWD_AMTLine Medicaid Allowed Amount
152LINE_MDCD_PD_AMTLine Medicaid Paid Amount
153LINE_MDCD_FFS_EQUIV_AMTLine Medicaid Fee For Service Equivalent Amount
154LINE_MDCR_PD_AMTLine Medicare Paid Amount
155LINE_COPAY_AMTLine Beneficiary Copayment Amount
156LINE_TP_PD_AMTLine Third Party Liability Paid Amount
157LINE_OTHR_INSRNC_PD_AMTLine Other Than Medicare or Medicaid -Insurance Paid Amount
158OT_ACCMDTN_HCPCS_RATEOther Services Accommodation Rate
159DA_RUN_IDTAF Production Run Identifier (unique for each TAF run)
160TMSIS_RUN_IDTMSIS State Data Processing Run Identifier
CSV