Data Documentation

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.

CCW Codebook TAF Claims_Version 022023.pdf1.39 MB

If you are unable to locate the information you need, please contact ResDAC.

CCW Record Layout TAF Claims_Version 022023.xlsx88.04 KB

Base Claim File

Number	SAS Name	Variable 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	PRSN_CLM_IND	Indicator of a Claim for a Person
19	SRVC_TRKNG_TYPE_CD	Service Tracking Type Code
20	FED_SRVC_CTGRY_CD	Federally Assigned Service Category Code Added During TAF Production
21	BIRTH_DT	Date of Birth
22	PTNT_DSCHRG_STUS_CD	Patient Status at Ending Date of Service
23	BIRTH_WT	Birth Weight in Grams
24	PGM_TYPE_CD	Program Type Code
25	MC_PLAN_ID	Managed Care Plan Identification Number
26	WVR_TYPE_CD	Waiver Type Code
27	WVR_ID	Waiver Identification Number
28	OTHR_INSRNC_IND	Indicator Insured is Covered by Another Plan (Not Medicare or Medicaid)
29	SECT_1115A_DEMO_IND	1115(A) Demonstration Participation Indicator
30	SRVC_BGN_DT	Claim Beginning Date of Service
31	SRVC_END_DT	Claim Ending Date of Service
32	SRVC_END_DT_CD	Identifies the Date Field Used to Populate SRVC_END_DT
33	HOSP_TYPE_CD	Hospital Type Code
34	ADMSN_TYPE_CD	Admission Type Code
35	ADMSM_DT	Admission Date (TAF)
36	ADMSN_HR	Admission Hour
37	DSCHRG_DT	Discharge Date
38	DSCHRG_HR	Discharge Hour
39	ADMTG_DGNS_CD	Admitting Diagnosis Code
40	ADMTG_DGNS_VRSN_CD	Admitting Diagnosis Version Code (ICD-9 or ICD-10)
41	DGNS_CD_1	Primary or Principal Diagnosis Code
42	DGNS_VRSN_CD_1	Diagnosis Version Code 1 (ICD-9 or ICD-10)
43	DGNS_POA_IND_1	Diagnosis Present on Admission Indicator 1
44	DGNS_1_CCSR_CTGRY_CD	AHRQ Clinical Classifications Software Refined (CCSR) Diagnosis 1 Category Code
45	DGNS_CD_2	Diagnosis Code 2
46	DGNS_VRSN_CD_2	Diagnosis Version Code 2 (ICD-9 or ICD-10)
47	DGNS_POA_IND_2	Diagnosis Present on Admission Indicator 2
48	DGNS_CD_3	Diagnosis Code 3
49	DGNS_VRSN_CD_3	Diagnosis Version Code 3 (ICD-9 or ICD-10)
50	DGNS_POA_IND_3	Diagnosis Present on Admission Indicator 3
51	DGNS_CD_4	Diagnosis Code 4
52	DGNS_VRSN_CD_4	Diagnosis Version Code 4 (ICD-9 or ICD-10)
53	DGNS_POA_IND_4	Diagnosis Present on Admission Indicator 4
54	DGNS_CD_5	Diagnosis Code 5
55	DGNS_VRSN_CD_5	Diagnosis Version Code 5 (ICD-9 or ICD-10)
56	DGNS_POA_IND_5	Diagnosis Present on Admission Indicator 5
57	DGNS_CD_6	Diagnosis Code 6
58	DGNS_VRSN_CD_6	Diagnosis Version Code 6 (ICD-9 or ICD-10)
59	DGNS_POA_IND_6	Diagnosis Present on Admission Indicator 6
60	DGNS_CD_7	Diagnosis Code 7
61	DGNS_VRSN_CD_7	Diagnosis Version Code 7 (ICD-9 or ICD-10)
62	DGNS_POA_IND_7	Diagnosis Present on Admission Indicator 7
63	DGNS_CD_8	Diagnosis Code 8
64	DGNS_VRSN_CD_8	Diagnosis Version Code 8 (ICD-9 or ICD-10)
65	DGNS_POA_IND_8	Diagnosis Present on Admission Indicator 8
66	DGNS_CD_9	Diagnosis Code 9
67	DGNS_VRSN_CD_9	Diagnosis Version Code 9 (ICD-9 or ICD-10)
68	DGNS_POA_IND_9	Diagnosis Present on Admission Indicator 9
69	DGNS_CD_10	Diagnosis Code 10
70	DGNS_VRSN_CD_10	Diagnosis Version Code 10 (ICD-9 or ICD-10)
71	DGNS_POA_IND_10	Diagnosis Present on Admission Indicator 10
72	DGNS_CD_11	Diagnosis Code 11
73	DGNS_VRSN_CD_11	Diagnosis Version Code 11 (ICD-9 or ICD-10)
74	DGNS_POA_IND_11	Diagnosis Present on Admission Indicator 11
75	DGNS_CD_12	Diagnosis Code 12
76	DGNS_VRSN_CD_12	Diagnosis Version Code 12 (ICD-9 or ICD-10)
77	DGNS_POA_IND_12	Diagnosis Present on Admission Indicator 12
78	HAC_IND	Health Care Acquired Condition (HAC) Indicator
79	IP_MH_DGNS_IND	Mental Health Diagnosis Indicator
80	IP_SUD_DGNS_IND	Substance Use Disorder Diagnosis Indicator
81	DRG_CD	Diagnosis Related Group (DRG) Code
82	DRG_CD_SYS	DRG Code System/Nomenclature
83	DRG_DESC	Description of DRG Code
84	MDC_CD	Major Diagnostic Category (MDC) Code
85	PRCDR_CD_DT_1	Date Procedures 1 Performed
86	PRCDR_CD_1	Procedure Code 1
87	PRCDR_CD_SYS_1	Procedure Code 1 System/Nomenclature
88	PRCDR_CD_DT_2	Date Procedures 2 Performed
89	PRCDR_CD_2	Procedure Code 2
90	PRCDR_CD_SYS_2	Procedure Code 2 System/Nomenclature
91	PRCDR_CD_DT_3	Date Procedures 3 Performed
92	PRCDR_CD_3	Procedure Code 3
93	PRCDR_CD_SYS_3	Procedure Code 3 System/Nomenclature
94	PRCDR_CD_DT_4	Date Procedures 4 Performed
95	PRCDR_CD_4	Procedure Code 4
96	PRCDR_CD_SYS_4	Procedure Code 4 System/Nomenclature
97	PRCDR_CD_DT_5	Date Procedures 5 Performed
98	PRCDR_CD_5	Procedure Code 5
99	PRCDR_CD_SYS_5	Procedure Code 5 System/Nomenclature
100	PRCDR_CD_DT_6	Date Procedures 6 Performed
101	PRCDR_CD_6	Procedure Code 6
102	PRCDR_CD_SYS_6	Procedure Code 6 System/Nomenclature
103	ADMTG_PRVDR_ID	Admitting Provider Identification Number
104	ADMTG_PRVDR_NPI	Admitting Provider NPI
105	ADMTG_PRVDR_TXNMY_CD	Admitting Provider Taxonomy Code
106	ADMTG_PRVDR_TYPE_CD	Admitting Provider Type Code
107	ADMTG_PRVDR_SPCLTY_CD	Admitting Provider Specialty Code
108	BLG_PRVDR_ID	Billing Provider Identification Number (TAF)
109	BLG_PRVDR_NPI	Billing Provider NPI
110	BLG_PRVDR_TXNMY_CD	Billing Provider Taxonomy Code
111	BLG_PRVDR_NPPES_TXNMY_CD	Billing Provider NPPES Taxonomy Code
112	BLG_PRVDR_TYPE_CD	Billing Provider Type Code
113	BLG_PRVDR_SPCLTY_CD	Billing Provider Specialty Code
114	RFRG_PRVDR_ID	Referring Provider Identification Number
115	RFRG_PRVDR_NPI	Referring Provider NPI
116	RFRG_PRVDR_TYPE_CD	Referring Provider Type Code
117	RFRG_PRVDR_SPCLTY_CD	Referring Provider Specialty Code
118	PRVDR_LCTN_CD	Provider Location Code
119	BRDR_STATE_IND	Border State Indicator
120	IP_MH_TXNMY_IND	Mental Health Provider Taxonomy Indicator
121	IP_SUD_TXNMY_IND	Substance Use Disorder Provider Taxonomy Indicator
122	NCVRD_DAYS	Medicaid Non-covered Days Count
123	CVRD_DAYS	Medicaid Covered Inpatient Days Count
124	OUTLIER_DAYS	Outlier Days Count
125	OUTLIER_TYPE_CD	Outlier Type Code
126	DRG_OUTLIER_AMT	DRG Outlier Additional Payment Amount
127	FIXD_PYMT_IND	Fixed Payment Indicator
128	SRVC_TRKNG_PYMT_AMT	Service Tracking Payment Amount
129	DRG_RLTV_WT	DRG Relative Weight
130	PYMT_LVL_IND	Payment Level Indicator - Header or Line
131	BILLED_AMT	Total Claim Billed Amount
132	NCVRD_CHRG_AMT	Non-covered Charges Amount
133	MDCD_ALOWD_AMT	Total Medicaid Allowed Amount
134	MDCD_PD_AMT	Total Amount Paid By Medicaid
135	MDCD_COPAY_AMT	Total Copay Amount Paid by Beneficiary
136	MDCD_DSH_PD_AMT	Medicaid Amount Paid Disproportionate Share Hospital (DSH)
137	MDCR_PD_AMT	Medicare Paid Amount
138	MDCR_DDCTBL_PD_AMT	Total Medicare Deductible Amount
139	MDCR_COINSRNC_PD_AMT	Total Medicare Coinsurance Amount
140	MDCR_CMBND_DDCTBL_IND	Medicare Combined Deductible and Coinsurance Indicator
141	MDCR_REIMBRSMT_TYPE_CD	Medicare Reimbursement Type Code
142	COINSRNC_AMT	Beneficiary Coinsurance Amount
143	COPAY_AMT	Beneficiary Copayment Amount
144	DDCTBL_AMT	Beneficiary Deductible Amount
145	COPAY_WVD_IND	Indicator Signifying Copay was Waived by Provider
146	TP_PD_AMT	Total Third Party Liability Paid Amount
147	TP_COINSRNC_PD_AMT	Third Party Coinsurance Paid Amount
148	TP_COPAY_PD_AMT	Third Party Copayment Paid Amount
149	OTHR_INSRNC_PD_AMT	Total Other Than Medicare or Medicaid -Insurance Paid Amount
150	OTHR_TP_CLCTN_CD	Other Third Party Collection Code
151	FUNDNG_CD	Code To Indicate Source of Non-Federal Funding
152	FUNDNG_SRC_NON_FED_SHR_CD	Funding Source Non-Federal Share Code
153	DA_RUN_ID	TAF Production Run Identifier (unique for each TAF run)
154	TMSIS_RUN_ID	TMSIS State Data Processing Run Identifier
155	IP_VRSN	Inpatient Version Representing the Iteration of the File
156	IP_FIL_DT	Inpatient File Date - Represents the Year and Month of the Reporting Period
157	CCW_LD_DT	CCW Load Date

Occurrence Code File

Number	SAS Name	Variable 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	OCRNC_CD_SEQ	Occurrence Code Sequence
7	OCRNC_CD	Occurrence Code
8	OCRNC_CD_START_DT	Occurrence Code Start Date
9	OCRNC_CD_END_DT	Occurrence Code End Date

LINE FILE

Number	SAS Name	Variable 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	LINE_NUM	Sequential Claim Line Number
7	CLM_NUM_ORIG	Original Claim Identifier
8	LINE_NUM_ORIG	Original Claim Line Number (TAF)
9	CLM_NUM_ADJ	Adjustment Claim Identifier
10	LINE_NUM_ADJ	Adjustment Claim Line Number
11	ADJDCTN_DT	Adjudication Date
12	LINE_CLAIM_STUS_CD	Claim Line Status Code
13	LINE_ADJUST_CD	Claim Line Adjustment Code
14	LINE_SRVC_BGN_DT	Claim Line Beginning Date of Service
15	LINE_SRVC_END_DT	Claim Line Ending Date of Service
16	BNFT_TYPE_CD	Benefit Type Code
17	TOS_CD	Type of Service Code
18	XIX_SRVC_CTGRY_CD	CMS-64 Form Category of Service for the Paid Claim
19	XXI_SRVC_CTGRY_CD	CMS-21 Form Category of Service for the Paid Claim
20	CMS_64_FED_CTGRY_CD	CMS-64 Form Code for Federal Reimbursement
21	REV_CNTR_CD	Revenue Center Code (TAF)
22	ACTL_SRVC_QTY	Actual Service Quantity
23	ALOWD_SRVC_QTY	Maximum Allowed Service Quantity
24	NDC	National Drug Code
25	NDC_UOM_CD	NDC Unit of Measure Code
26	NDC_QTY	NDC Quantity Dispensed
27	IMNZTN_TYPE_CD	Immunization Type Code
28	PRVDR_FAC_TYPE_CD	Provider Facility Type Code
29	SRVC_PRVDR_ID	Servicing Provider Identification Number (TAF)
30	SRVC_PRVDR_NPI	Servicing Provider NPI
31	SRVC_PRVDR_TXNMY_CD	Servicing Provider Taxonomy Code
32	SRVC_PRVDR_TYPE_CD	Servicing Provider Type Code
33	SRVC_PRVDR_SPCLTY_CD	Servicing Provider Specialty Code (TAF)
34	OPRTG_PRVDR_NPI	Operating Provider NPI
35	REV_CNTR_CHRG_AMT	Revenue Center Charge Amount
36	LINE_MDCD_ALOWD_AMT	Line Medicaid Allowed Amount
37	LINE_MDCD_PD_AMT	Line Medicaid Paid Amount
38	LINE_MDCD_FFS_EQUIV_AMT	Line Medicaid Fee For Service Equivalent Amount
39	LINE_OTHR_INSRNC_PD_AMT	Line Other Than Medicare or Medicaid -Insurance Paid Amount
40	IP_ACCMDTN_HCPCS_RATE	Inpatient Hospital Accommodation Rate
41	DA_RUN_ID	TAF Production Run Identifier (unique for each TAF run)
42	TMSIS_RUN_ID	TMSIS State Data Processing Run Identifier