Data Documentation

Durable Medical Equipment (Fee-for-Service)

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 - Medicare Fee-For-Service (FFS) Claims

CCW Record Layout - Medicare Fee-For-Service (FFS) Claims

Number	SAS Name	Variable Name
1	BENE_ID	Encrypted CCW Beneficiary ID
2	CLM_ID	Claim ID
3	NCH_NEAR_LINE_REC_IDENT_CD	NCH Near Line Record Identification Code (RIC)
4	NCH_CLM_TYPE_CD	NCH Claim Type Code
5	CLM_FROM_DT	Claim From Date (FFS)
6	CLM_THRU_DT	Claim Through Date (FFS)
7	NCH_WKLY_PROC_DT	NCH Weekly Claim Processing Date
8	CARR_CLM_ENTRY_CD	Carrier Claim Entry Code
9	CLM_DISP_CD	Claim Disposition Code
10	CARR_NUM	Carrier or MAC Number
11	CARR_CLM_PMT_DNL_CD	Carrier Claim Payment Denial Code
12	CLM_PMT_AMT	Claim (Medicare) Payment Amount
13	NCH_PRMRY_PYR_CLM_PD_AMT	NCH Primary Payer (if not Medicare) Claim Paid Amount
14	CARR_CLM_PRVDR_ASGNMT_IND_SW	Carrier Claim Provider Assignment Indicator Switch
15	NCH_CLM_PRVDR_PMT_AMT	NCH Claim Provider Payment Amount
16	NCH_CLM_BENE_PMT_AMT	NCH Claim Payment Amount to Beneficiary
17	CLM_BENE_PD_AMT	Carrier Claim Beneficiary Paid Amount
18	NCH_CARR_CLM_SBMTD_CHRG_AMT	NCH Carrier Claim Submitted Charge Amount (sum of all line-level submitted charges)
19	NCH_CARR_CLM_ALOWD_AMT	NCH Carrier Claim Allowed Charge Amount (sum of all line-level allowed charges)
20	CARR_CLM_CASH_DDCTBL_APLD_AMT	Carrier Claim Cash Deductible Applied Amount (sum of all line-level deductible amounts)
21	CARR_CLM_HCPCS_YR_CD	Claim Healthcare Common Procedure Coding System (HCPCS) Year Code
22	PRNCPAL_DGNS_CD	Claim Principal Diagnosis Code (FFS)
23	PRNCPAL_DGNS_VRSN_CD	Claim Principal Diagnosis Version Code (FFS)
24	ICD_DGNS_CD1	Claim Diagnosis Code I (FFS)
25	ICD_DGNS_VRSN_CD1	Claim Diagnosis Code I Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
26	ICD_DGNS_CD2	Claim Diagnosis Code II (FFS)
27	ICD_DGNS_VRSN_CD2	Claim Diagnosis Code II Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
28	ICD_DGNS_CD3	Claim Diagnosis Code III (FFS)
29	ICD_DGNS_VRSN_CD3	Claim Diagnosis Code III Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
30	ICD_DGNS_CD4	Claim Diagnosis Code IV (FFS)
31	ICD_DGNS_VRSN_CD4	Claim Diagnosis Code IV Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
32	ICD_DGNS_CD5	Claim Diagnosis Code V (FFS)
33	ICD_DGNS_VRSN_CD5	Claim Diagnosis Code V Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
34	ICD_DGNS_CD6	Claim Diagnosis Code VI (FFS)
35	ICD_DGNS_VRSN_CD6	Claim Diagnosis Code VI Diagnosis Version Code (ICD-9/ICD-10) (FFS)
36	ICD_DGNS_CD7	Claim Diagnosis Code VII (FFS)
37	ICD_DGNS_VRSN_CD7	Claim Diagnosis Code VII Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
38	ICD_DGNS_CD8	Claim Diagnosis Code VIII (FFS)
39	ICD_DGNS_VRSN_CD8	Claim Diagnosis Code VIII Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
40	ICD_DGNS_CD9	Claim Diagnosis Code IX (FFS)
41	ICD_DGNS_VRSN_CD9	Claim Diagnosis Code IX Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
42	ICD_DGNS_CD10	Claim Diagnosis Code X (FFS)
43	ICD_DGNS_VRSN_CD10	Claim Diagnosis Code X Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
44	ICD_DGNS_CD11	Claim Diagnosis Code XI (FFS)
45	ICD_DGNS_VRSN_CD11	Claim Diagnosis Code XI Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
46	ICD_DGNS_CD12	Claim Diagnosis Code XII (FFS)
47	ICD_DGNS_VRSN_CD12	Claim Diagnosis Code XII Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
48	RFR_PHYSN_UPIN	Carrier/DMERC Claim Ordering Physician UPIN Number
49	RFR_PHYSN_NPI	Claim Referring Physician NPI Number
50	CLM_CLNCL_TRIL_NUM	Clinical Trial Number
51	DOB_DT	Date of Birth from Claim
53	BENE_RACE_CD	Beneficiary Race Code (FFS)
54	BENE_CNTY_CD	County Code from Claim (SSA)
55	BENE_STATE_CD	Beneficiary Residence (SSA) State Code (FFS)
56	BENE_MLG_CNTCT_ZIP_CD	Zip Code of Residence from Claim
57	ACO_ID_NUM	Claim Accountable Care Organization (ACO) Identification Number
58	CLM_BENE_ID_TYPE_CD	Claim Beneficiary Identifier Type Code
59	CLM_RSDL_PYMT_IND_CD	Claim Residual Payment Indicator Code

LINE FILE

Number	SAS Name	Variable Name
1	BENE_ID	Encrypted CCW Beneficiary ID
2	CLM_ID	Claim ID
3	CLM_LINE_NUM	Claim Line Number
4	NCH_CLM_TYPE_CD	NCH Claim Type Code
5	CLM_THRU_DT	Claim Through Date (FFS)
6	TAX_NUM	Line Provider Tax Number
7	PRVDR_SPCLTY	Line CMS Provider Specialty Code
8	PRTCPTNG_IND_CD	Line Provider Participating Indicator Code
9	LINE_SRVC_CNT	Line Service Count (FFS)
10	LINE_CMS_TYPE_SRVC_CD	Line CMS Type Service Code
11	LINE_PLACE_OF_SRVC_CD	Line Place Of Service Code (FFS)
12	LINE_1ST_EXPNS_DT	Line First Expense Date (FFS)
13	LINE_LAST_EXPNS_DT	Line Last Expense Date (FFS)
14	HCPCS_CD	Healthcare Common Procedure Coding System (HCPCS) Code (FFS)
15	HCPCS_1ST_MDFR_CD	HCPCS Initial Modifier Code (FFS)
16	HCPCS_2ND_MDFR_CD	HCPCS Second Modifier Code (FFS)
17	HCPCS_3RD_MDFR_CD	HCPCS Third Modifier Code (FFS)
18	HCPCS_4TH_MDFR_CD	HCPCS Fourth Modifier Code (FFS)
19	BETOS_CD	Line Berenson-Eggers Type of Service (BETOS) Code
20	LINE_NCH_PMT_AMT	Line NCH Medicare Payment Amount
21	LINE_BENE_PMT_AMT	Line Payment Amount to Beneficiary
22	LINE_PRVDR_PMT_AMT	Line Provider Payment Amount
23	LINE_BENE_PTB_DDCTBL_AMT	Line Beneficiary Part B Deductible Amount
24	LINE_BENE_PRMRY_PYR_CD	Line Primary Payer Code (if not Medicare)
25	LINE_BENE_PRMRY_PYR_PD_AMT	Line Primary Payer (if not Medicare) Paid Amount
26	LINE_COINSRNC_AMT	Line Beneficiary Coinsurance Amount
27	LINE_PRMRY_ALOWD_CHRG_AMT	Line Primary Payer Allowed Charge Amount
28	LINE_SBMTD_CHRG_AMT	Line Submitted Charge Amount
29	LINE_ALOWD_CHRG_AMT	Line Allowed Charge Amount
30	LINE_PRCSG_IND_CD	Line Processing Indicator Code
31	LINE_PMT_80_100_CD	Line Payment 80%/100% Code
32	LINE_SERVICE_DEDUCTIBLE	Line Service Deductible Indicator Switch
33	LINE_ICD_DGNS_CD	Line Diagnosis Code
34	LINE_ICD_DGNS_VRSN_CD	Line Diagnosis Code Diagnosis Version Code (ICD-9 or ICD-10)
35	LINE_DME_PRCHS_PRICE_AMT	Line DME Purchase Price Amount
36	PRVDR_NUM	DMERC Line Supplier Provider Number
37	PRVDR_NPI	DMERC Line-Item Supplier NPI Number
38	DMERC_LINE_PRCNG_STATE_CD	DMERC Line Pricing State Code (SSA)
39	PRVDR_STATE_CD	NCH Provider SSA State Code
40	DMERC_LINE_SUPPLR_TYPE_CD	DMERC Line Supplier Type Code
41	DMERC_LINE_SCRN_SVGS_AMT	DMERC Line Screen Savings Amount
42	DMERC_LINE_MTUS_CNT	DMERC Line Miles/Time/Units/Services (MTUS) Count
43	DMERC_LINE_MTUS_CD	DMERC Line Miles/Time/Units/Services (MTUS) Indicator Code
44	LINE_HCT_HGB_RSLT_NUM	Hematocrit/Hemoglobin Test Results
45	LINE_HCT_HGB_TYPE_CD	Hematocrit/Hemoglobin Test Type Code
46	LINE_NDC_CD	Line National Drug Code (NDC) (FFS)
47	LINE_OTHR_APLD_IND_CD1	Line Other Applied Indicator 1st Code
48	LINE_OTHR_APLD_IND_CD2	Line Other Applied Indicator 2nd Code
49	LINE_OTHR_APLD_IND_CD3	Line Other Applied Indicator 3rd Code
50	LINE_OTHR_APLD_IND_CD4	Line Other Applied Indicator 4th Code
51	LINE_OTHR_APLD_IND_CD5	Line Other Applied Indicator 5th Code
52	LINE_OTHR_APLD_IND_CD6	Line Other Applied Indicator 6th Code
53	LINE_OTHR_APLD_IND_CD7	Line Other Applied Indicator 7th Code
54	LINE_OTHR_APLD_AMT1	Line Other Applied Amount for 1st Code
55	LINE_OTHR_APLD_AMT2	Line Other Applied Amount for 2nd Code
56	LINE_OTHR_APLD_AMT3	Line Other Applied Amount for 3rd Code
57	LINE_OTHR_APLD_AMT4	Line Other Applied Amount for 4th Code
58	LINE_OTHR_APLD_AMT5	Line Other Applied Amount for 5th Code
59	LINE_OTHR_APLD_AMT6	Line Other Applied Amount for 6th Code
60	LINE_OTHR_APLD_AMT7	Line Other Applied Amount for 7th Code
61	LINE_RSDL_PYMT_IND_CD	Line Residual Payment Indicator Code
62	LINE_RP_IND_CD	Line Representative Payee (RP) Indicator Code
63	DMERC_LINE_FRGN_ADR_IND	Line Foreign Address Indicator
64	LINE_RR_BRD_EXCLSN_IND_SW	Line Railroad Board Exclusion Indicator Switch
65	LINE_VLNTRY_SRVC_IND_CD	Line Voluntary Service Indicator Code
66	DMERC_OXGN_EQUIP_INITL_DT	Oxygen Equipment Initial Date
67	DMERC_OXGN_INITL_DT_CD	Oxygen Equipment Initial Date Code
68	DMERC_OXGN_EQUIP_PRVS_DT	Oxygen Equipment Previous Date
69	CLM_NEXT_GNRTN_ACO_IND_CD1	Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Population-Based Payment (PBP)
70	CLM_NEXT_GNRTN_ACO_IND_CD2	Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Telehealth
71	CLM_NEXT_GNRTN_ACO_IND_CD3	Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Post Discharge HH visits
72	CLM_NEXT_GNRTN_ACO_IND_CD4	Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - 3-day SNF waiver
73	CLM_NEXT_GNRTN_ACO_IND_CD5	Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Capitation

Demonstrations/Innovations Code File

Number	SAS Name	Variable Name
1	BENE_ID	Encrypted CCW Beneficiary ID
2	CLM_ID	Claim ID
3	NCH_CLM_TYPE_CD	NCH Claim Type Code
4	DEMO_ID_SQNC_NUM	Demonstration sequence number
5	DEMO_ID_NUM	Demonstration number
6	DEMO_INFO_TXT	Demo information text