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
8FI_CLM_PROC_DTFI_CLM_PROC_DTFI Claim Process Date
9QUERY_CDCLAIM_QUERY_CODEClaim Query Code
10PROVIDERPRVDR_NUMProvider Number
11FAC_TYPECLM_FAC_TYPE_CDClaim Facility Type Code (FFS)
12TYPESRVCCLM_SRVC_CLSFCTN_TYPE_CDClaim Service Classification Type Code (FFS)
13FREQ_CDCLM_FREQ_CDClaim Frequency Code (FFS)
14FI_NUMFI_NUMFI or MAC Number
15NOPAY_CDCLM_MDCR_NON_PMT_RSN_CDClaim Medicare Non Payment Reason Code
16PMT_AMTCLM_PMT_AMTClaim (Medicare) Payment Amount
18PRPAYAMTNCH_PRMRY_PYR_CLM_PD_AMTNCH Primary Payer (if not Medicare) Claim Paid Amount
300PRPAY_CDNCH_PRMRY_PYR_CDNCH Primary Payer Code (if not Medicare)
19ACTIONCDFI_CLM_ACTN_CDFI or MAC Claim Action Code
20PRVSTATEPRVDR_STATE_CDNCH Provider SSA State Code
21ORGNPINMORG_NPI_NUMOrganization (or group) NPI Number
22AT_UPINAT_PHYSN_UPINClaim Attending Physician UPIN Number
23AT_NPIAT_PHYSN_NPIClaim Attending Physician NPI Number (FFS)
24AT_PHYSN_SPCLTY_CDAT_PHYSN_SPCLTY_CDClaim Attending Physician Specialty Code
25OP_UPINOP_PHYSN_UPINClaim Operating Physician UPIN Number
26OP_NPIOP_PHYSN_NPIClaim Operating Physician NPI Number (FFS)
29OP_PHYSN_SPCLTY_CDOP_PHYSN_SPCLTY_CDClaim Operating Physician Specialty Code
28OT_UPINOT_PHYSN_UPINClaim Other Physician UPIN Number
27OT_NPIOT_PHYSN_NPIClaim Other Physician NPI Number (FFS)
30OT_PHYSN_SPCLTY_CDOT_PHYSN_SPCLTY_CDClaim Other Physician Specialty Code
500RNDRNG_PHYSN_NPIRNDRNG_PHYSN_NPIRendering Physician NPI (FFS)
32RNDRNG_PHYSN_SPCLTY_CDCLM_RNDRNG_PHYSN_SPCLTY_CDClaim Rendering Physician Specialty Code
33MCOPDSWCLM_MCO_PD_SWClaim MCO Paid Switch
34STUS_CDPTNT_DSCHRG_STUS_CDPatient Discharge Status Code (FFS)
35PPS_INDCLM_PPS_IND_CDClaim PPS Indicator Code
36TOT_CHRGCLM_TOT_CHRG_AMTClaim Total Charge Amount
37ADMSN_DTCLM_ADMSN_DTClaim Admission Date (FFS)
38TYPE_ADMCLM_IP_ADMSN_TYPE_CDClaim Inpatient Admission Type Code (FFS)
39SRC_ADMSCLM_SRC_IP_ADMSN_CDClaim Source Inpatient Admission Code (FFS)
40PTNTSTUSNCH_PTNT_STATUS_IND_CDNCH Patient Status Indicator Code
41DED_AMTNCH_BENE_IP_DDCTBL_AMTNCH Beneficiary Inpatient (or other Part A) Deductible Amount
42COIN_AMTNCH_BENE_PTA_COINSRNC_LBLTY_AMNCH Beneficiary Part A Coinsurance Liability Amount
43BLDDEDAMNCH_BENE_BLOOD_DDCTBL_LBLTY_AMNCH Beneficiary Blood Deductible Liability Amount
44NCCHGAMTNCH_IP_NCVRD_CHRG_AMTNCH Inpatient (or other Part A) Non-covered Charge Amount
45TDEDAMTNCH_IP_TOT_DDCTN_AMTNCH Inpatient (or other Part A) Total Deductible/Coinsurance Amount
46CPTL_FSPCLM_PPS_CPTL_FSP_AMTClaim PPS Capital Federal Specific Portion (FSP) Amount
47CPTLOUTLCLM_PPS_CPTL_OUTLIER_AMTClaim PPS Capital Outlier Amount
48DISP_SHRCLM_PPS_CPTL_DSPRPRTNT_SHR_AMTClaim PPS Capital Disproportionate Share Amount
49IME_AMTCLM_PPS_CPTL_IME_AMTClaim PPS Capital Indirect Medical Education (IME) Amount
50CPTL_EXPCLM_PPS_CPTL_EXCPTN_AMTClaim PPS Capital Exception Amount
51HLDHRMLSCLM_PPS_OLD_CPTL_HLD_HRMLS_AMTClaim PPS Old Capital Hold Harmless Amount
52UTIL_DAYCLM_UTLZTN_DAY_CNTClaim Medicare Utilization Day Count
53COIN_DAYBENE_TOT_COINSRNC_DAYS_CNTBeneficiary Total Coinsurance Days Count
54NUTILDAYCLM_NON_UTLZTN_DAYS_CNTClaim Medicare Non Utilization Days Count
55BLDFRNSHNCH_BLOOD_PNTS_FRNSHD_QTYNCH Blood Pints Furnished Quantity
56QLFYFROMNCH_QLFYD_STAY_FROM_DTNCH Qualified Stay From Date
57QLFYTHRUNCH_QLFYD_STAY_THRU_DTNCH Qualified Stay Through Date
58NCOVFROMNCH_VRFD_NCVRD_STAY_FROM_DTNCH Verified Non-covered Stay From Date
59NCOVTHRUNCH_VRFD_NCVRD_STAY_THRU_DTNCH Verified Non-covered Stay Through Date
60CARETHRUNCH_ACTV_OR_CVRD_LVL_CARE_THRUNCH Active or Covered Level Care Thru Date
61EXHST_DTNCH_BENE_MDCR_BNFTS_EXHTD_DT_INCH Beneficiary Medicare Benefits Exhausted Date
62DSCHRGDTNCH_BENE_DSCHRG_DTNCH Beneficiary Discharge Date
63DRG_CDCLM_DRG_CDClaim Diagnosis Related Group Code (or MS-DRG Code)
64ADMTG_DGNS_CDADMTG_DGNS_CDClaim Admitting Diagnosis Code (FFS)
65PRNCPAL_DGNS_CDPRNCPAL_DGNS_CDClaim Principal Diagnosis Code (FFS)
66ICD_DGNS_CD1ICD_DGNS_CD1Claim Diagnosis Code I (FFS)
67ICD_DGNS_CD2ICD_DGNS_CD2Claim Diagnosis Code II (FFS)
68ICD_DGNS_CD3ICD_DGNS_CD3Claim Diagnosis Code III (FFS)
69ICD_DGNS_CD4ICD_DGNS_CD4Claim Diagnosis Code IV (FFS)
70ICD_DGNS_CD5ICD_DGNS_CD5Claim Diagnosis Code V (FFS)
71ICD_DGNS_CD6ICD_DGNS_CD6Claim Diagnosis Code VI (FFS)
72ICD_DGNS_CD7ICD_DGNS_CD7Claim Diagnosis Code VII (FFS)
73ICD_DGNS_CD8ICD_DGNS_CD8Claim Diagnosis Code VIII (FFS)
74ICD_DGNS_CD9ICD_DGNS_CD9Claim Diagnosis Code IX (FFS)
75ICD_DGNS_CD10ICD_DGNS_CD10Claim Diagnosis Code X (FFS)
76ICD_DGNS_CD11ICD_DGNS_CD11Claim Diagnosis Code XI (FFS)
77ICD_DGNS_CD12ICD_DGNS_CD12Claim Diagnosis Code XII (FFS)
78ICD_DGNS_CD13ICD_DGNS_CD13Claim Diagnosis Code XIII (FFS)
79ICD_DGNS_CD14ICD_DGNS_CD14Claim Diagnosis Code XIV (FFS)
80ICD_DGNS_CD15ICD_DGNS_CD15Claim Diagnosis Code XV (FFS)
81ICD_DGNS_CD16ICD_DGNS_CD16Claim Diagnosis Code XVI (FFS)
82ICD_DGNS_CD17ICD_DGNS_CD17Claim Diagnosis Code XVII (FFS)
83ICD_DGNS_CD18ICD_DGNS_CD18Claim Diagnosis Code XVIII (FFS)
84ICD_DGNS_CD19ICD_DGNS_CD19Claim Diagnosis Code XIX (FFS)
85ICD_DGNS_CD20ICD_DGNS_CD20Claim Diagnosis Code XX (FFS)
86ICD_DGNS_CD21ICD_DGNS_CD21Claim Diagnosis Code XXI (FFS)
87ICD_DGNS_CD22ICD_DGNS_CD22Claim Diagnosis Code XXII (FFS)
88ICD_DGNS_CD23ICD_DGNS_CD23Claim Diagnosis Code XXIII (FFS)
89ICD_DGNS_CD24ICD_DGNS_CD24Claim Diagnosis Code XXIV (FFS)
90ICD_DGNS_CD25ICD_DGNS_CD25Claim Diagnosis Code XXV (FFS)
91FST_DGNS_E_CDFST_DGNS_E_CDFirst Claim Diagnosis E Code (FFS)
92ICD_DGNS_E_CD1ICD_DGNS_E_CD1Claim Diagnosis E Code I (FFS)
93ICD_DGNS_E_CD2ICD_DGNS_E_CD2Claim Diagnosis E Code II (FFS)
94ICD_DGNS_E_CD3ICD_DGNS_E_CD3Claim Diagnosis E Code III (FFS)
95ICD_DGNS_E_CD4ICD_DGNS_E_CD4Claim Diagnosis E Code IV (FFS)
96ICD_DGNS_E_CD5ICD_DGNS_E_CD5Claim Diagnosis E Code V (FFS)
97ICD_DGNS_E_CD6ICD_DGNS_E_CD6Claim Diagnosis E Code VI (FFS)
98ICD_DGNS_E_CD7ICD_DGNS_E_CD7Claim Diagnosis E Code VII (FFS)
99ICD_DGNS_E_CD8ICD_DGNS_E_CD8Claim Diagnosis E Code VIII (FFS)
100ICD_DGNS_E_CD9ICD_DGNS_E_CD9Claim Diagnosis E Code IX (FFS)
101ICD_DGNS_E_CD10ICD_DGNS_E_CD10Claim Diagnosis E Code X (FFS)
102ICD_DGNS_E_CD11ICD_DGNS_E_CD11Claim Diagnosis E Code XI
103ICD_DGNS_E_CD12ICD_DGNS_E_CD12Claim Diagnosis E Code XII
104ICD_PRCDR_CD1ICD_PRCDR_CD1Claim Procedure Code I (FFS)
105PRCDR_DT1PRCDR_DT1Claim Procedure Code I Date (FFS)
106ICD_PRCDR_CD2ICD_PRCDR_CD2Claim Procedure Code II (FFS)
107PRCDR_DT2PRCDR_DT2Claim Procedure Code II Date (FFS)
108ICD_PRCDR_CD3ICD_PRCDR_CD3Claim Procedure Code III (FFS)
109PRCDR_DT3PRCDR_DT3Claim Procedure Code III Date (FFS)
110ICD_PRCDR_CD4ICD_PRCDR_CD4Claim Procedure Code IV (FFS)
111PRCDR_DT4PRCDR_DT4Claim Procedure Code IV Date (FFS)
112ICD_PRCDR_CD5ICD_PRCDR_CD5Claim Procedure Code V (FFS)
113PRCDR_DT5PRCDR_DT5Claim Procedure Code V Date (FFS)
114ICD_PRCDR_CD6ICD_PRCDR_CD6Claim Procedure Code VI (FFS)
115PRCDR_DT6PRCDR_DT6Claim Procedure Code VI Date (FFS)
116ICD_PRCDR_CD7ICD_PRCDR_CD7Claim Procedure Code VII (FFS)
117PRCDR_DT7PRCDR_DT7Claim Procedure Code VII Date (FFS)
118ICD_PRCDR_CD8ICD_PRCDR_CD8Claim Procedure Code VIII (FFS)
119PRCDR_DT8PRCDR_DT8Claim Procedure Code VIII Date (FFS)
120ICD_PRCDR_CD9ICD_PRCDR_CD9Claim Procedure Code IX (FFS)
121PRCDR_DT9PRCDR_DT9Claim Procedure Code IX Date (FFS)
122ICD_PRCDR_CD10ICD_PRCDR_CD10Claim Procedure Code X (FFS)
123PRCDR_DT10PRCDR_DT10Claim Procedure Code X Date (FFS)
124ICD_PRCDR_CD11ICD_PRCDR_CD11Claim Procedure Code XI (FFS)
125PRCDR_DT11PRCDR_DT11Claim Procedure Code XI Date (FFS)
126ICD_PRCDR_CD12ICD_PRCDR_CD12Claim Procedure Code XII (FFS)
127PRCDR_DT12PRCDR_DT12Claim Procedure Code XII Date (FFS)
128ICD_PRCDR_CD13ICD_PRCDR_CD13Claim Procedure Code XIII (FFS)
129PRCDR_DT13PRCDR_DT13Claim Procedure Code XIII Date (FFS)
130ICD_PRCDR_CD14ICD_PRCDR_CD14Claim Procedure Code XIV
131PRCDR_DT14PRCDR_DT14Claim Procedure Code XIV Date
132ICD_PRCDR_CD15ICD_PRCDR_CD15Claim Procedure Code XV
133PRCDR_DT15PRCDR_DT15Claim Procedure Code XV Date
134ICD_PRCDR_CD16ICD_PRCDR_CD16Claim Procedure Code XVI
135PRCDR_DT16PRCDR_DT16Claim Procedure Code XVI Date
136ICD_PRCDR_CD17ICD_PRCDR_CD17Claim Procedure Code XVII
137PRCDR_DT17PRCDR_DT17Claim Procedure Code XVII Date
138ICD_PRCDR_CD18ICD_PRCDR_CD18Claim Procedure Code XVIII
139PRCDR_DT18PRCDR_DT18Claim Procedure Code XVIII Date
140ICD_PRCDR_CD19ICD_PRCDR_CD19Claim Procedure Code XIX
141PRCDR_DT19PRCDR_DT19Claim Procedure Code XIX Date
142ICD_PRCDR_CD20ICD_PRCDR_CD20Claim Procedure Code XX
143PRCDR_DT20PRCDR_DT20Claim Procedure Code XX Date
144ICD_PRCDR_CD21ICD_PRCDR_CD21Claim Procedure Code XXI
145PRCDR_DT21PRCDR_DT21Claim Procedure Code XXI Date
146ICD_PRCDR_CD22ICD_PRCDR_CD22Claim Procedure Code XXII
147PRCDR_DT22PRCDR_DT22Claim Procedure Code XXII Date
148ICD_PRCDR_CD23ICD_PRCDR_CD23Claim Procedure Code XXIII
149PRCDR_DT23PRCDR_DT23Claim Procedure Code XXIII Date
150ICD_PRCDR_CD24ICD_PRCDR_CD24Claim Procedure Code XXIV
151PRCDR_DT24PRCDR_DT24Claim Procedure Code XXIV Date
152ICD_PRCDR_CD25ICD_PRCDR_CD25Claim Procedure Code XXV
153PRCDR_DT25PRCDR_DT25Claim Procedure Code XXV Date
154DOB_DTDOB_DTDate of Birth from Claim
155GNDR_CDGNDR_CDGender Code from Claim
156RACE_CDBENE_RACE_CDBeneficiary Race Code (FFS)
157CNTY_CDBENE_CNTY_CDCounty Code from Claim (SSA)
158BENE_STATE_CDBENE_STATE_CDBeneficiary Residence (SSA) State Code (FFS)
159ZIP_CDBENE_MLG_CNTCT_ZIP_CDZip Code of Residence from Claim
160CLM_MDCL_RECCLM_MDCL_RECClaim Medical Record Number (FFS)
161CLM_TRTMT_AUTHRZTN_NUM CLM_TRTMT_AUTHRZTN_NUMClaim Treatment Authorization Number
310CLM_PRCR_RTRN_CDCLM_PRCR_RTRN_CDClaim Pricer Return Code
311CLM_SRVC_FAC_ZIP_CDCLM_SRVC_FAC_ZIP_CDClaim service facility ZIP code (where service was provided)
312PCCHGAMTNCH_PROFNL_CMPNT_CHRG_AMTProfessional Component Charge Amount
314CLM_NEXT_GNRTN_ACO_IND_1_CDCLM_NEXT_GNRTN_ACO_IND_CD1Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Population-Based Payment (PBP)
315CLM_NEXT_GNRTN_ACO_IND_2_CDCLM_NEXT_GNRTN_ACO_IND_CD2Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Telehealth
316CLM_NEXT_GNRTN_ACO_IND_3_CDCLM_NEXT_GNRTN_ACO_IND_CD3Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Post Discharge HH visits
317CLM_NEXT_GNRTN_ACO_IND_4_CDCLM_NEXT_GNRTN_ACO_IND_CD4Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - 3-day SNF waiver
318CLM_NEXT_GNRTN_ACO_IND_5_CDCLM_NEXT_GNRTN_ACO_IND_CD5Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Capitation
170ACO_ID_NUMACO_ID_NUMClaim Accountable Care Organization (ACO) Identification Number
313CLM_BENE_ID_TYPE_CDCLM_BENE_ID_TYPE_CDClaim Beneficiary Identifier Type Code
300CLM_RSDL_PYMT_IND_CDCLM_RSDL_PYMT_IND_CDClaim Residual Payment Indicator Code
301PRVDR_VLDTN_TYPE_CDPRVDR_VLDTN_TYPE_CDProvider Validation Type Code
302RR_BRD_EXCLSN_IND_SWRR_BRD_EXCLSN_IND_SWRailroad Board Exclusion Indicator Switch

Revenue Center File

Short SAS NameLong SAS NameVariable Name
1BENE_IDBENE_IDEncrypted CCW Beneficiary ID
2CLM_IDCLM_IDClaim ID
3THRU_DTCLM_THRU_DTClaim Through Date (FFS)
4CLM_LNCLM_LINE_NUMClaim Line Number
5CLM_TYPENCH_CLM_TYPE_CDNCH Claim Type Code
6REV_CNTRREV_CNTRRevenue Center Code (FFS)
7HCPCS_CDHCPCS_CDHealthcare Common Procedure Coding System (HCPCS) Code (FFS)
8MDFR_CD1HCPCS_1st_mdfr_cdHCPCS Initial Modifier Code (FFS)
9MDFR_CD2HCPCS_2ND_MDFR_CDHCPCS Second Modifier Code (FFS)
10MDFR_CD3HCPCS_3RD_MDFR_CDHCPCS Third Modifier Code (FFS)
11REV_UNITREV_CNTR_UNIT_CNTRevenue Center Unit Count (FFS)
12REV_RATEREV_CNTR_RATE_AMTRevenue Center Rate Amount
13REV_CHRGREV_CNTR_TOT_CHRG_AMTRevenue Center Total Charge Amount
14REV_NCVRREV_CNTR_NCVRD_CHRG_AMTRevenue Center Non-Covered Charge Amount
15REVDEDCDREV_CNTR_DDCTBL_COINSRNC_CDRevenue Center Deductible Coinsurance Code
16REV_CNTR_NDC_QTYREV_CNTR_NDC_QTYRevenue Center National Drug Code (NDC) Quantity (FFS)
17REV_CNTR_NDC_QTY_QLFR_CDREV_CNTR_NDC_QTY_QLFR_CDRevenue Center NDC Quantity Qualifier Code (FFS)
18RNDRNG_PHYSN_UPINRNDRNG_PHYSN_UPINRevenue Center Rendering Physician UPIN
501RNDRNG_PHYSN_NPIRNDRNG_PHYSN_NPIRendering Physician NPI (FFS)
20RNDRNG_PHYSN_SPCLTY_CDRNDRNG_PHYSN_SPCLTY_CDClaim or Revenue Center Rendering Physician Specialty Code
21IDENDCREV_CNTR_IDE_NDC_UPC_NUMRevenue Center IDE, NDC, or UPC Number (FFS)
22REV_CNTR_PRCNG_IND_CDREV_CNTR_PRCNG_IND_CDRevenue Center Pricing Indicator Code
23THRPY_CAP_IND_CD1THRPY_CAP_IND_CD1Therapy cap Indicator 1 Code
24THRPY_CAP_IND_CD2THRPY_CAP_IND_CD2Therapy cap Indicator 2 Code
303REV_CNTR_RP_IND_CDREV_CNTR_RP_IND_CDRevenue Center Representative Payee (RP) Indicator Code

Condition Code File

Short SAS NameLong SAS NameVariable Name
1BENE_IDBENE_IDEncrypted CCW Beneficiary ID
2CLM_IDCLM_IDClaim ID
3CLM_TYPENCH_CLM_TYPE_CDNCH Claim Type Code
4RLTCNDSQRLT_COND_CD_SEQClaim Related Condition Code Sequence
5RLT_CONDCLM_RLT_COND_CDClaim Related Condition Code (FFS)

Occurence Code File

Short SAS NameLong SAS NameVariable Name
1BENE_IDBENE_IDEncrypted CCW Beneficiary ID
2CLM_IDCLM_IDClaim ID
3CLM_TYPENCH_CLM_TYPE_CDNCH Claim Type Code
4RLTOCRSQRLT_OCRNC_CD_SEQClaim Related Occurrence Code Sequence
5OCRNC_CDCLM_RLT_OCRNC_CDClaim Related Occurrence Code (FFS)
6OCRNCDTCLM_RLT_OCRNC_DTClaim Related Occurrence Date (FFS)

Span Code File

Short SAS NameLong SAS NameVariable Name
1BENE_IDBENE_IDEncrypted CCW Beneficiary ID
2CLM_IDCLM_IDClaim ID
3CLM_TYPENCH_CLM_TYPE_CDNCH Claim Type Code
4RLTSPNSQRLT_SPAN_CD_SEQClaim Related Span Code Sequence
5SPAN_CDCLM_SPAN_CDClaim Occurrence Span Code (FFS)
6SPANFROMCLM_SPAN_FROM_DTClaim Occurrence Span From Date (FFS)
7SPANTHRUCLM_SPAN_THRU_DTClaim Occurrence Span Through Date (FFS)

Value Code File

Short SAS NameLong SAS NameVariable Name
1BENE_IDBENE_IDEncrypted CCW Beneficiary ID
2CLM_IDCLM_IDClaim ID
3CLM_TYPENCH_CLM_TYPE_CDNCH Claim Type Code
4RLTVALSQRLT_VAL_CD_SEQClaim Related Value Code Sequence
5VAL_CDCLM_VAL_CDClaim Value Code (FFS)
6VAL_AMTCLM_VAL_AMTClaim Value Amount

Demonstrations/Innovations Code File

Short SAS NameLong SAS NameVariable Name
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