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
15SPLIT_CLM_INDSplit Claim Indicator
16CLL_CNTClaim Line Count - Original
17CLL_CNT_CALCClaim Line Count - Calculated
18SRVC_TRKNG_TYPE_CDService Tracking Type Code
19BIRTH_DTDate of Birth
20PTNT_DSCHRG_STUS_CDPatient Status at Ending Date of Service
21BIRTH_WTBirth Weight in Grams
22PGM_TYPE_CDProgram Type Code
23MC_PLAN_IDManaged Care Plan Identification Number
24WVR_TYPE_CDWaiver Type Code
25WVR_IDWaiver Identification Number
26OTHR_INSRNC_INDIndicator Insured is Covered by Another Plan (Not Medicare or Medicaid)
27SECT_1115A_DEMO_IND1115(A) Demonstration Participation Indicator
28SRVC_BGN_DTClaim Beginning Date of Service
29SRVC_END_DTClaim Ending Date of Service
30SRVC_END_DT_CDIdentifies the Date Field Used to Populate SRVC_END_DT
31HOSP_TYPE_CDHospital Type Code
32ADMSN_TYPE_CDAdmission Type Code
33ADMSM_DTAdmission Date (TAF)
34ADMSN_HRAdmission Hour
35DSCHRG_DTDischarge Date
36DSCHRG_HRDischarge Hour
37ADMTG_DGNS_CDAdmitting Diagnosis Code
38ADMTG_DGNS_VRSN_CD Admitting Diagnosis Version Code (ICD-9 or ICD-10)
39DGNS_CD_1Primary or Principal Diagnosis Code
40DGNS_VRSN_CD_1Diagnosis Version Code 1 (ICD-9 or ICD-10)
41DGNS_POA_IND_1Diagnosis Present on Admission Indicator 1
42DGNS_CD_2Diagnosis Code 2
43DGNS_VRSN_CD_2Diagnosis Version Code 2 (ICD-9 or ICD-10)
44DGNS_POA_IND_2Diagnosis Present on Admission Indicator 2
45DGNS_CD_3Diagnosis Code 3
46DGNS_VRSN_CD_3Diagnosis Version Code 3 (ICD-9 or ICD-10)
47DGNS_POA_IND_3Diagnosis Present on Admission Indicator 3
48DGNS_CD_4Diagnosis Code 4
49DGNS_VRSN_CD_4Diagnosis Version Code 4 (ICD-9 or ICD-10)
50DGNS_POA_IND_4Diagnosis Present on Admission Indicator 4
51DGNS_CD_5Diagnosis Code 5
52DGNS_VRSN_CD_5Diagnosis Version Code 5 (ICD-9 or ICD-10)
53DGNS_POA_IND_5Diagnosis Present on Admission Indicator 5
54DGNS_CD_6Diagnosis Code 6
55DGNS_VRSN_CD_6Diagnosis Version Code 6 (ICD-9 or ICD-10)
56DGNS_POA_IND_6Diagnosis Present on Admission Indicator 6
57DGNS_CD_7Diagnosis Code 7
58DGNS_VRSN_CD_7Diagnosis Version Code 7 (ICD-9 or ICD-10)
59DGNS_POA_IND_7Diagnosis Present on Admission Indicator 7
60DGNS_CD_8Diagnosis Code 8
61DGNS_VRSN_CD_8Diagnosis Version Code 8 (ICD-9 or ICD-10)
62DGNS_POA_IND_8Diagnosis Present on Admission Indicator 8
63DGNS_CD_9Diagnosis Code 9
64DGNS_VRSN_CD_9Diagnosis Version Code 9 (ICD-9 or ICD-10)
65DGNS_POA_IND_9Diagnosis Present on Admission Indicator 9
66DGNS_CD_10Diagnosis Code 10
67DGNS_VRSN_CD_10Diagnosis Version Code 10 (ICD-9 or ICD-10)
68DGNS_POA_IND_10Diagnosis Present on Admission Indicator 10
69DGNS_CD_11Diagnosis Code 11
70DGNS_VRSN_CD_11Diagnosis Version Code 11 (ICD-9 or ICD-10)
71DGNS_POA_IND_11Diagnosis Present on Admission Indicator 11
72DGNS_CD_12Diagnosis Code 12
73DGNS_VRSN_CD_12Diagnosis Version Code 12 (ICD-9 or ICD-10)
74DGNS_POA_IND_12Diagnosis Present on Admission Indicator 12
75HAC_INDHealth Care Acquired Condition (HAC) Indicator
76IP_MH_DGNS_INDMental Health Diagnosis Indicator
77IP_SUD_DGNS_INDSubstance Use Disorder Diagnosis Indicator
78DRG_CDDiagnosis Related Group (DRG) Code
79DRG_CD_SYSDRG Code System/Nomenclature
80DRG_DESCDescription of DRG Code
81MDC_CDMajor Diagnostic Category (MDC) Code
82PRCDR_CD_DT_1Date Procedures 1 Performed
83PRCDR_CD_1Procedure Code 1
84PRCDR_CD_SYS_1Procedure Code 1 System/Nomenclature
85PRCDR_CD_DT_2Date Procedures 2 Performed
86PRCDR_CD_2Procedure Code 2
87PRCDR_CD_SYS_2Procedure Code 2 System/Nomenclature
88PRCDR_CD_DT_3Date Procedures 3 Performed
89PRCDR_CD_3Procedure Code 3
90PRCDR_CD_SYS_3Procedure Code 3 System/Nomenclature
91PRCDR_CD_DT_4Date Procedures 4 Performed
92PRCDR_CD_4Procedure Code 4
93PRCDR_CD_SYS_4Procedure Code 4 System/Nomenclature
94PRCDR_CD_DT_5Date Procedures 5 Performed
95PRCDR_CD_5Procedure Code 5
96PRCDR_CD_SYS_5Procedure Code 5 System/Nomenclature
97PRCDR_CD_DT_6Date Procedures 6 Performed
98PRCDR_CD_6Procedure Code 6
99PRCDR_CD_SYS_6Procedure Code 6 System/Nomenclature
100ADMTG_PRVDR_IDAdmitting Provider Identification Number
101ADMTG_PRVDR_NPIAdmitting Provider NPI
102ADMTG_PRVDR_TXNMY_CDAdmitting Provider Taxonomy Code
103ADMTG_PRVDR_TYPE_CDAdmitting Provider Type Code
104ADMTG_PRVDR_SPCLTY_CDAdmitting Provider Specialty Code
105BLG_PRVDR_IDBilling Provider Identification Number (TAF)
106BLG_PRVDR_NPIBilling Provider NPI
107BLG_PRVDR_TXNMY_CDBilling Provider Taxonomy Code
108BLG_PRVDR_TYPE_CDBilling Provider Type Code
109BLG_PRVDR_SPCLTY_CDBilling Provider Specialty Code
110RFRG_PRVDR_IDReferring Provider Identification Number
111RFRG_PRVDR_NPIReferring Provider NPI
112RFRG_PRVDR_TYPE_CDReferring Provider Type Code
113RFRG_PRVDR_SPCLTY_CDReferring Provider Specialty Code
114PRVDR_LCTN_CDProvider Location Code
115BRDR_STATE_INDBorder State Indicator
116IP_MH_TXNMY_INDMental Health Provider Taxonomy Indicator
117IP_SUD_TXNMY_INDSubstance Use Disorder Provider Taxonomy Indicator
118NCVRD_DAYSMedicaid Non-covered Days Count
119CVRD_DAYSMedicaid Covered Inpatient Days Count
120OUTLIER_DAYSOutlier Days Count
121OUTLIER_TYPE_CDOutlier Type Code
122DRG_OUTLIER_AMTDRG Outlier Additional Payment Amount
123FIXD_PYMT_INDFixed Payment Indicator
124SRVC_TRKNG_PYMT_AMTService Tracking Payment Amount
125DRG_RLTV_WTDRG Relative Weight
126PYMT_LVL_INDPayment Level Indicator - Header or Line
127BILLED_AMTTotal Claim Billed Amount
128NCVRD_CHRG_AMTNon-covered Charges Amount
129MDCD_ALOWD_AMTTotal Medicaid Allowed Amount
130MDCD_PD_AMTTotal Amount Paid By Medicaid
131MDCD_COPAY_AMTTotal Copay Amount Paid by Beneficiary
132MDCD_DSH_PD_AMTMedicaid Amount Paid Disproportionate Share Hospital (DSH)
133MDCR_PD_AMTMedicare Paid Amount
134MDCR_DDCTBL_PD_AMTTotal Medicare Deductible Amount
135MDCR_COINSRNC_PD_AMTTotal Medicare Coinsurance Amount
136MDCR_CMBND_DDCTBL_INDMedicare Combined Deductible and Coinsurance Indicator
137MDCR_REIMBRSMT_TYPE_CDMedicare Reimbursement Type Code
138COINSRNC_AMTBeneficiary Coinsurance Amount
139COPAY_AMTBeneficiary Copayment Amount
140DDCTBL_AMTBeneficiary Deductible Amount
141COPAY_WVD_INDIndicator Signifying Copay was Waived by Provider
142TP_PD_AMTTotal Third Party Liability Paid Amount
143TP_COINSRNC_PD_AMTThird Party Coinsurance Paid Amount
144TP_COPAY_PD_AMTThird Party Copayment Paid Amount
145OTHR_INSRNC_PD_AMTTotal Other Than Medicare or Medicaid -Insurance Paid Amount
146OTHR_TP_CLCTN_CDOther Third Party Collection Code
147FUNDNG_CDCode To Indicate Source of Non-Federal Funding
148FUNDNG_SRC_NON_FED_SHR_CDFunding Source Non-Federal Share Code
149DA_RUN_IDTAF Production Run Identifier (unique for each TAF run)
150TMSIS_RUN_IDTMSIS State Data Processing Run Identifier
151IP_VRSNInpatient Version Representing the Iteration of the File
152IP_FIL_DTInpatient File Date - Represents the Year and Month of the Reporting Period
153CCW_LD_DTCCW Load Date

Occurrence Code File

SAS NameVariable Name
154BENE_IDEncrypted CCW Beneficiary Identifier
155MSIS_IDEncrypted State Assigned Beneficiary Unique Identifier
156STATE_CDSubmitting State Alpha Abbreviation
157SUBMTG_STATE_CDSubmitting State FIPS Code
158CLM_IDCCW Claim Identifier
159OCRNC_CD_SEQ  Occurrence Code Sequence
160OCRNC_CDOccurrence Code
161OCRNC_CD_START_DTOccurrence Code Start Date
162OCRNC_CD_END_DTOccurrence Code End Date

LINE FILE

SAS NameVariable Name
163BENE_IDEncrypted CCW Beneficiary Identifier
164MSIS_IDEncrypted State Assigned Beneficiary Unique Identifier
165STATE_CDSubmitting State Alpha Abbreviation
166SUBMTG_STATE_CDSubmitting State FIPS Code
167CLM_IDCCW Claim Identifier
168LINE_NUMSequential Claim Line Number
169CLM_NUM_ORIGOriginal Claim Identifier
170LINE_NUM_ORIGOriginal Claim Line Number (TAF)
171CLM_NUM_ADJAdjustment Claim Identifier
172LINE_NUM_ADJAdjustment Claim Line Number
173ADJDCTN_DTAdjudication Date
174LINE_CLAIM_STUS_CDClaim Line Status Code
175LINE_ADJUST_CDClaim Line Adjustment Code
176LINE_SRVC_BGN_DTClaim Line Beginning Date of Service
177LINE_SRVC_END_DTClaim Line Ending Date of Service
178BNFT_TYPE_CDBenefit Type Code
179TOS_CDType of Service Code
180XIX_SRVC_CTGRY_CDCMS-64 Form Category of Service for the Paid Claim
181XXI_SRVC_CTGRY_CDCMS-21 Form Category of Service for the Paid Claim
182CMS_64_FED_CTGRY_CDCMS-64 Form Code for Federal Reimbursement
183REV_CNTR_CDRevenue Center Code (TAF)
184ACTL_SRVC_QTYActual Service Quantity
185ALOWD_SRVC_QTYMaximum Allowed Service Quantity
186NDCNational Drug Code
187NDC_UOM_CDNDC Unit of Measure Code
188NDC_QTYNDC Quantity Dispensed
189IMNZTN_TYPE_CDImmunization Type Code
190PRVDR_FAC_TYPE_CDProvider Facility Type Code
191SRVC_PRVDR_IDServicing Provider Identification Number (TAF)
192SRVC_PRVDR_NPIServicing Provider NPI
193SRVC_PRVDR_TXNMY_CDServicing Provider Taxonomy Code
194SRVC_PRVDR_TYPE_CDServicing Provider Type Code
195SRVC_PRVDR_SPCLTY_CDServicing Provider Specialty Code (TAF)
196OPRTG_PRVDR_NPIOperating Provider NPI
197REV_CNTR_CHRG_AMTRevenue Center Charge Amount
198LINE_MDCD_ALOWD_AMTLine Medicaid Allowed Amount
199LINE_MDCD_PD_AMTLine Medicaid Paid Amount
200LINE_MDCD_FFS_EQUIV_AMTLine Medicaid Fee For Service Equivalent Amount
201LINE_OTHR_INSRNC_PD_AMTLine Other Than Medicare or Medicaid -Insurance Paid Amount
202IP_ACCMDTN_HCPCS_RATEInpatient Hospital Accommodation Rate
203DA_RUN_IDTAF Production Run Identifier (unique for each TAF run)
204TMSIS_RUN_IDTMSIS State Data Processing Run Identifier
CSV