Back to top

File Version: K, CCW Data Documentation May, 2019

Short SAS NameLong SAS NameVariable Name
1BENE_IDBENE_IDEncrypted CCW Beneficiary ID
2CLM_IDCLM_IDClaim ID
3RIC_CDNCH_NEAR_LINE_REC_IDENT_CDNCH Near Line Record Identification Code (RIC)
4CLM_TYPENCH_CLM_TYPE_CDNCH Claim Type Code
5FROM_DTCLM_FROM_DTClaim From Date (FFS)
6THRU_DTCLM_THRU_DTClaim Through Date (FFS)
7WKLY_DTNCH_WKLY_PROC_DTNCH Weekly Claim Processing Date
8ENTRY_CDCARR_CLM_ENTRY_CDCarrier Claim Entry Code
9DISP_CDCLM_DISP_CDClaim Disposition Code
10CARR_NUMCARR_NUMCarrier or MAC Number
11PMTDNLCDCARR_CLM_PMT_DNL_CDCarrier Claim Payment Denial Code
12PMT_AMTCLM_PMT_AMTClaim (Medicare) Payment Amount
13PRPAYAMTNCH_PRMRY_PYR_CLM_PD_AMTNCH Primary Payer (if not Medicare) Claim Paid Amount
14ASGMNTCDCARR_CLM_PRVDR_ASGNMT_IND_SWCarrier Claim Provider Assignment Indicator Switch
15PROV_PMTNCH_CLM_PRVDR_PMT_AMTNCH Claim Provider Payment Amount
16BENE_PMTNCH_CLM_BENE_PMT_AMTNCH Claim Payment Amount to Beneficiary
17SBMTCHRGNCH_CARR_CLM_SBMTD_CHRG_AMTNCH Carrier Claim Submitted Charge Amount (sum of all line-level submitted charges)
18ALOWCHRGNCH_CARR_CLM_ALOWD_AMTNCH Carrier Claim Allowed Charge Amount (sum of all line-level allowed charges)
19DEDAPPLYCARR_CLM_CASH_DDCTBL_APLD_AMTCarrier Claim Cash Deductible Applied Amount (sum of all line-level deductible amounts)
20HCPCS_YRCARR_CLM_HCPCS_YR_CDClaim Healthcare Common Procedure Coding System (HCPCS) Year Code
21PRNCPAL_DGNS_CDPRNCPAL_DGNS_CDClaim Principal Diagnosis Code (FFS)
22PRNCPAL_DGNS_VRSN_CDPRNCPAL_DGNS_VRSN_CDClaim Principal Diagnosis Version Code (FFS)
23ICD_DGNS_CD1ICD_DGNS_CD1Claim Diagnosis Code I (FFS)
24ICD_DGNS_VRSN_CD1ICD_DGNS_VRSN_CD1Claim Diagnosis Code I Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
25ICD_DGNS_CD2ICD_DGNS_CD2Claim Diagnosis Code II (FFS)
26ICD_DGNS_VRSN_CD2ICD_DGNS_VRSN_CD2Claim Diagnosis Code II Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
27ICD_DGNS_CD3ICD_DGNS_CD3Claim Diagnosis Code III (FFS)
28ICD_DGNS_VRSN_CD3ICD_DGNS_VRSN_CD3Claim Diagnosis Code III Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
29ICD_DGNS_CD4ICD_DGNS_CD4Claim Diagnosis Code IV (FFS)
30ICD_DGNS_VRSN_CD4ICD_DGNS_VRSN_CD4Claim Diagnosis Code IV Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
31ICD_DGNS_CD5ICD_DGNS_CD5Claim Diagnosis Code V (FFS)
32ICD_DGNS_VRSN_CD5ICD_DGNS_VRSN_CD5Claim Diagnosis Code V Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
33ICD_DGNS_CD6ICD_DGNS_CD6Claim Diagnosis Code VI (FFS)
34ICD_DGNS_VRSN_CD6ICD_DGNS_VRSN_CD6Claim Diagnosis Code VI Diagnosis Version Code (ICD-9/ICD-10) (FFS)
35ICD_DGNS_CD7ICD_DGNS_CD7Claim Diagnosis Code VII (FFS)
36ICD_DGNS_VRSN_CD7ICD_DGNS_VRSN_CD7Claim Diagnosis Code VII Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
37ICD_DGNS_CD8ICD_DGNS_CD8Claim Diagnosis Code VIII (FFS)
38ICD_DGNS_VRSN_CD8ICD_DGNS_VRSN_CD8Claim Diagnosis Code VIII Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
39ICD_DGNS_CD9ICD_DGNS_CD9Claim Diagnosis Code IX (FFS)
40ICD_DGNS_VRSN_CD9ICD_DGNS_VRSN_CD9Claim Diagnosis Code IX Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
41ICD_DGNS_CD10ICD_DGNS_CD10Claim Diagnosis Code X (FFS)
42ICD_DGNS_VRSN_CD10ICD_DGNS_VRSN_CD10Claim Diagnosis Code X Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
43ICD_DGNS_CD11ICD_DGNS_CD11Claim Diagnosis Code XI (FFS)
44ICD_DGNS_VRSN_CD11ICD_DGNS_VRSN_CD11Claim Diagnosis Code XI Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
45ICD_DGNS_CD12ICD_DGNS_CD12Claim Diagnosis Code XII (FFS)
46ICD_DGNS_VRSN_CD12ICD_DGNS_VRSN_CD12Claim Diagnosis Code XII Diagnosis Version Code (ICD-9 or ICD-10) (FFS)
47RFR_UPINRFR_PHYSN_UPINCarrier/DMERC Claim Ordering Physician UPIN Number
48RFR_PHYSN_NPIRFRG_NPIClaim Referring Physician NPI Number
49CCLTRNUMCLM_CLNCL_TRIL_NUMClinical Trial Number
50DOB_DTDOB_DTDate of Birth from Claim
51GNDR_CDGNDR_CDGender Code from Claim
52RACE_CDBENE_RACE_CDBeneficiary Race Code (FFS)
53CNTY_CDBENE_CNTY_CDCounty Code from Claim (SSA)
54BENE_STATE_CDBENE_STATE_CDBeneficiary Residence (SSA) State Code (FFS)
55ZIP_CDBENE_MLG_CNTCT_ZIP_CDZip Code of Residence from Claim
56ACO_ID_NUMACO_ID_NUMClaim Accountable Care Organization (ACO) Identification Number
200CLM_BENE_ID_TYPE_CDCLM_BENE_ID_TYPE_CDClaim Beneficiary Identifier Type Code
205CLM_RSDL_PYMT_IND_CDCLM_RSDL_PYMT_IND_CDClaim Residual Payment Indicator Code

LINE FILE

Short SAS NameLong SAS NameVariable Name
1BENE_IDBENE_IDEncrypted CCW Beneficiary ID
2CLM_IDCLM_IDClaim ID
3CLM_LNCLM_LINE_NUMClaim Line Number
4CLM_TYPENCH_CLM_TYPE_CDNCH Claim Type Code
5THRU_DTCLM_THRU_DTClaim Through Date (FFS)
6TAX_NUMTAX_NUMLine Provider Tax Number
7HCFASPCLPRVDR_SPCLTYLine CMS Provider Specialty Code
8PRTCPTGPRTCPTNG_IND_CDLine Provider Participating Indicator Code
9SRVC_CNTLINE_SRVC_CNTLine Service Count (FFS)
10TYPSRVCBLINE_CMS_TYPE_SRVC_CDLine CMS Type Service Code
11PLCSRVCLINE_PLACE_OF_SRVC_CDLine Place Of Service Code (FFS)
12EXPNSDT1LINE_1ST_EXPNS_DTLine First Expense Date (FFS)
13EXPNSDT2LINE_LAST_EXPNS_DTLine Last Expense Date (FFS)
14HCPCS_CDHCPCS_CDHealthcare Common Procedure Coding System (HCPCS) Code (FFS)
15MDFR_CD1HCPCS_1st_mdfr_cdHCPCS Initial Modifier Code (FFS)
16MDFR_CD2HCPCS_2ND_MDFR_CDHCPCS Second Modifier Code (FFS)
202MDFR_CD3HCPCS_3RD_MDFR_CDHCPCS Third Modifier Code (FFS)
203MDFR_CD4HCPCS_4TH_MDFR_CDHCPCS Fourth Modifier Code (FFS)
17BETOSBETOS_CDLine Berenson-Eggers Type of Service (BETOS) Code
18LINEPMTLINE_NCH_PMT_AMTLine NCH Medicare Payment Amount
19LBENPMTLINE_BENE_PMT_AMTLine Payment Amount to Beneficiary
20LPRVPMTLINE_PRVDR_PMT_AMTLine Provider Payment Amount
21LDEDAMTLINE_BENE_PTB_DDCTBL_AMTLine Beneficiary Part B Deductible Amount
22LPRPAYCDLINE_BENE_PRMRY_PYR_CDLine Primary Payer Code (if not Medicare)
23LPRPDAMTLINE_BENE_PRMRY_PYR_PD_AMTLine Primary Payer (if not Medicare) Paid Amount
24COINAMTLINE_COINSRNC_AMTLine Beneficiary Coinsurance Amount
25PRPYALOWLINE_PRMRY_ALOWD_CHRG_AMTLine Primary Payer Allowed Charge Amount
26LSBMTCHGLINE_SBMTD_CHRG_AMTLine Submitted Charge Amount
27LALOWCHGLINE_ALOWD_CHRG_AMTLine Allowed Charge Amount
28PRCNGINDLINE_PRCSG_IND_CDLine Processing Indicator Code
29PMTINDSWLINE_PMT_80_100_CDLine Payment 80% / 100% Code
30DED_SWLINE_SERVICE_DEDUCTIBLELine Service Deductible Indicator Switch
31LINE_ICD_DGNS_CDLINE_ICD_DGNS_CDLine Diagnosis Code
32LINE_ICD_DGNS_VRSN_CDLINE_ICD_DGNS_VRSN_CDLine Diagnosis Code Diagnosis Version Code (ICD-9 or ICD-10)
33DME_PURCLINE_DME_PRCHS_PRICE_AMTLine DME Purchase Price Amount
34SUPLRNUMPRVDR_NUMDMERC Line Supplier Provider Number
35SUP_NPIPRVDR_NPIDMERC Line Item Supplier NPI Number
36PRCNG_STDMERC_LINE_PRCNG_STATE_CDDMERC Line Pricing State Code (SSA)
37PRVSTATEPRVDR_STATE_CDNCH Provider SSA State Code
38SUP_TYPEDMERC_LINE_SUPPLR_TYPE_CDDMERC Line Supplier Type Code
41SCRNSVGSDMERC_LINE_SCRN_SVGS_AMTDMERC Line Screen Savings Amount
42DME_UNITDMERC_LINE_MTUS_CNTDMERC Line Miles/Time/Units/Services (MTUS) Count
43UNIT_INDDMERC_LINE_MTUS_CDDMERC Line Miles/Time/Units/Services (MTUS) Indicator Code
44HCTHGBRSLINE_HCT_HGB_RSLT_NUMHematocrit/Hemoglobin Test Results
45HCTHGBTPLINE_HCT_HGB_TYPE_CDHematocrit/Hemoglobin Test Type Code
46LNNDCCDLINE_NDC_CDLine National Drug Code (NDC) (FFS)
47LINE_OTHR_APLD_IND_CD1LINE_OTHR_APLD_IND_CD1Line Other Applied Indicator 1st Code
48LINE_OTHR_APLD_IND_CD2LINE_OTHER_APLD_IND_CD2Line Other Applied Indicator 2nd Code
49LINE_OTHR_APLD_IND_CD3LINE_OTHR_APLD_IND_CD3Line Other Applied Indicator 3rd Code
50LINE_OTHR_APLD_IND_CD4LINE_OTHR_APLD_IND_CD4Line Other Applied Indicator 4th Code
51LINE_OTHR_APLD_IND_CD5LINE_OTHR_APLD_IND_CD5Line Other Applied Indicator 5th Code
52LINE_OTHR_APLD_IND_CD6LINE_OTHR_APLD_IND_CD6Line Other Applied Indicator 6th Code
53LINE_OTHR_APLD_IND_CD7LINE_OTHR_APLD_IND_CD7Line Other Applied Indicator 7th Code
54LINE_OTHR_APLD_AMT1LINE_OTHR_APLD_AMT1Line Other Applied Amount for 1st Code
55LINE_OTHR_APLD_AMT2LINE_OTHR_APLD_AMT2Line Other Applied Amount for 2nd Code
56LINE_OTHR_APLD_AMT3LINE_OTHR_APLD_AMT3Line Other Applied Amount for 3rd Code
57LINE_OTHR_APLD_AMT4LINE_OTHR_APLD_AMT4Line Other Applied Amount for 4th Code
58LINE_OTHR_APLD_AMT5LINE_OTHR_APLD_AMT5Line Other Applied Amount for 5th Code
59LINE_OTHR_APLD_AMT6LINE_OTHR_APLD_AMT6Line Other Applied Amount for 6th Code
60LINE_OTHR_APLD_AMT7LINE_OTHR_APLD_AMT7Line Other Applied Amount for 7th Code

Demonstrations/Innovations Code File

Short SAS NameLong SAS NameVariable Name
206LINE_RSDL_PYMT_IND_CDLINE_RSDL_PYMT_IND_CDLine Residual Payment Indicator Code
207LINE_RP_IND_CDLINE_RP_IND_CDLine Representative Payee (RP) Indicator Code
208DMERC_LINE_FRGN_ADR_INDDMERC_LINE_FRGN_ADR_INDLine Foreign Address Indicator
209LINE_RR_BRD_EXCLSN_IND_SWLINE_RR_BRD_EXCLSN_IND_SWLine Railroad Board Exclusion Indicator Switch
1BENE_IDBENE_IDEncrypted CCW Beneficiary ID
2CLM_IDCLM_IDClaim ID
3CLM_TYPENCH_CLM_TYPE_CDNCH Claim Type Code
4DEMO_ID_SQNC_NUMDEMO_ID_SQNC_NUMDemonstration sequence number
5DEMO_ID_NUMDEMO_ID_NUMDemonstration number
6DEMO_INFO_TXTDEMO_INFO_TXTDemo information text
CSV