File Version:
L, CCW Data Documentation February 2021

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.

NumberSAS NameVariable 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 FI_CLM_PROC_DT FI Claim Process Date
9 CLAIM_QUERY_CODE Claim Query Code
10 PRVDR_NUM Provider Number
11 CLM_FAC_TYPE_CD Claim Facility Type Code (FFS)
12 CLM_SRVC_CLSFCTN_TYPE_CD Claim Service Classification Type Code (FFS)
13 CLM_FREQ_CD Claim Frequency Code (FFS)
14 FI_NUM FI or MAC Number
15 CLM_MDCR_NON_PMT_RSN_CD Claim Medicare Non Payment Reason Code
16 CLM_PMT_AMT Claim (Medicare) Payment Amount
17 NCH_PRMRY_PYR_CLM_PD_AMT NCH Primary Payer (if not Medicare) Claim Paid Amount
18 NCH_PRMRY_PYR_CD NCH Primary Payer Code (if not Medicare)
19 FI_CLM_ACTN_CD FI or MAC Claim Action Code
20 PRVDR_STATE_CD NCH Provider SSA State Code
21 ORG_NPI_NUM Organization (or group) NPI Number
22 SRVC_LOC_NPI_NUM Claim Service Location NPI Number
23 AT_PHYSN_UPIN Claim Attending Physician UPIN Number
24 AT_PHYSN_NPI Claim Attending Physician NPI Number (FFS)
25 AT_PHYSN_SPCLTY_CD Claim Attending Physician Specialty Code
26 OP_PHYSN_NPI Claim Operating Physician NPI Number (FFS)
27 OP_PHYSN_SPCLTY_CD Claim Operating Physician Specialty Code
28 OT_PHYSN_NPI Claim Other Physician NPI Number (FFS)
29 OT_PHYSN_SPCLTY_CD Claim Other Physician Specialty Code
30 RNDRNG_PHYSN_NPI Rendering Physician NPI (FFS)
31 RNDRNG_PHYSN_SPCLTY_CD Claim or Revenue Center Rendering Physician Specialty Code
32 RFRG_NPI Claim Referring Physician NPI Number
33 RFRG_SPCLTY_CD Claim Referring Physician Specialty Code
34 PTNT_DSCHRG_STUS_CD Patient Discharge Status Code (FFS)
35 CLM_TOT_CHRG_AMT Claim Total Charge Amount
36 NCH_PTNT_STUS_IND_CD NCH Patient Status Indicator Code
37 CLM_UTLZTN_DAY_CNT Claim Medicare Utilization Day Count
38 NCH_BENE_DSCHRG_DT NCH Beneficiary Discharge Date
39 PRNCPAL_DGNS_CD Claim Principal Diagnosis Code (FFS)
40 ICD_DGNS_CD1 Claim Diagnosis Code I (FFS)
41 ICD_DGNS_CD2 Claim Diagnosis Code II (FFS)
42 ICD_DGNS_CD3 Claim Diagnosis Code III (FFS)
43 ICD_DGNS_CD4 Claim Diagnosis Code IV (FFS)
44 ICD_DGNS_CD5 Claim Diagnosis Code V (FFS)
45 ICD_DGNS_CD6 Claim Diagnosis Code VI (FFS)
46 ICD_DGNS_CD7 Claim Diagnosis Code VII (FFS)
47 ICD_DGNS_CD8 Claim Diagnosis Code VIII (FFS)
48 ICD_DGNS_CD9 Claim Diagnosis Code IX (FFS)
49 ICD_DGNS_CD10 Claim Diagnosis Code X (FFS)
50 ICD_DGNS_CD11 Claim Diagnosis Code XI (FFS)
51 ICD_DGNS_CD12 Claim Diagnosis Code XII (FFS)
52 ICD_DGNS_CD13 Claim Diagnosis Code XIII (FFS)
53 ICD_DGNS_CD14 Claim Diagnosis Code XIV (FFS)
54 ICD_DGNS_CD15 Claim Diagnosis Code XV (FFS)
55 ICD_DGNS_CD16 Claim Diagnosis Code XVI (FFS)
56 ICD_DGNS_CD17 Claim Diagnosis Code XVII (FFS)
57 ICD_DGNS_CD18 Claim Diagnosis Code XVIII (FFS)
58 ICD_DGNS_CD19 Claim Diagnosis Code XIX (FFS)
59 ICD_DGNS_CD20 Claim Diagnosis Code XX (FFS)
60 ICD_DGNS_CD21 Claim Diagnosis Code XXI (FFS)
61 ICD_DGNS_CD22 Claim Diagnosis Code XXII (FFS)
62 ICD_DGNS_CD23 Claim Diagnosis Code XXIII (FFS)
63 ICD_DGNS_CD24 Claim Diagnosis Code XXIV (FFS)
64 ICD_DGNS_CD25 Claim Diagnosis Code XXV (FFS)
65 FST_DGNS_E_CD First Claim Diagnosis E Code (FFS)
66 ICD_DGNS_E_CD1 Claim Diagnosis E Code I (FFS)
67 ICD_DGNS_E_CD2 Claim Diagnosis E Code II (FFS)
68 ICD_DGNS_E_CD3 Claim Diagnosis E Code III (FFS)
69 ICD_DGNS_E_CD4 Claim Diagnosis E Code IV (FFS)
70 ICD_DGNS_E_CD5 Claim Diagnosis E Code V (FFS)
71 ICD_DGNS_E_CD6 Claim Diagnosis E Code VI (FFS)
72 ICD_DGNS_E_CD7 Claim Diagnosis E Code VII (FFS)
73 ICD_DGNS_E_CD8 Claim Diagnosis E Code VIII (FFS)
74 ICD_DGNS_E_CD9 Claim Diagnosis E Code IX (FFS)
75 ICD_DGNS_E_CD10 Claim Diagnosis E Code X (FFS)
76 ICD_DGNS_E_CD11 Claim Diagnosis E Code XI
77 ICD_DGNS_E_CD12 Claim Diagnosis E Code XII
78 CLM_HOSPC_START_DT_ID Claim Hospice Start Date
79 BENE_HOSPC_PRD_CNT Beneficiary's Hospice Period Count
80 DOB_DT Date of Birth from Claim
81 GNDR_CD Gender Code from Claim
82 BENE_RACE_CD Beneficiary Race Code (FFS)
83 BENE_CNTY_CD County Code from Claim (SSA)
84 BENE_STATE_CD Beneficiary Residence (SSA) State Code (FFS)
85 BENE_MLG_CNTCT_ZIP_CD Zip Code of Residence from Claim
86 CLM_MDCL_REC Claim Medical Record Number (FFS)
87 CLM_TRTMT_AUTHRZTN_NUM Claim Treatment Authorization Number
88 CLM_PRCR_RTRN_CD Claim Pricer Return Code
89 CLM_SRVC_FAC_ZIP_CD Claim service facility ZIP code (where service was provided)
90 CLM_NEXT_GNRTN_ACO_IND_CD1 Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Population-Based Payment (PBP)
91 CLM_NEXT_GNRTN_ACO_IND_CD2 Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Telehealth
92 CLM_NEXT_GNRTN_ACO_IND_CD3 Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Post Discharge HH visits
93 CLM_NEXT_GNRTN_ACO_IND_CD4 Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - 3-day SNF waiver
94 CLM_NEXT_GNRTN_ACO_IND_CD5 Claim Next Generation (NG) Accountable Care Organization (ACO) Indicator Code - Capitation
95 ACO_ID_NUM Claim Accountable Care Organization (ACO) Identification Number
96 CLM_BENE_ID_TYPE_CD Claim Beneficiary Identifier Type Code
97 CLM_RSDL_PYMT_IND_CD Claim Residual Payment Indicator Code
98 PRVDR_VLDTN_TYPE_CD Provider Validation Type Code
99 RR_BRD_EXCLSN_IND_SW Railroad Board Exclusion Indicator Switch
100 CLM_MODEL_REIMBRSMT_AMT Claim Model Reimbursement Amount

Revenue Center File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 CLM_ID Claim ID
3 CLM_THRU_DT Claim Through Date (FFS)
4 CLM_LINE_NUM Claim Line Number
5 NCH_CLM_TYPE_CD NCH Claim Type Code
6 REV_CNTR Revenue Center Code (FFS)
7 REV_CNTR_DT Revenue Center Date
8 HCPCS_CD Healthcare Common Procedure Coding System (HCPCS) Code (FFS)
9 HCPCS_1st_mdfr_cd HCPCS Initial Modifier Code (FFS)
10 HCPCS_2ND_MDFR_CD HCPCS Second Modifier Code (FFS)
11 HCPCS_3RD_MDFR_CD HCPCS Third Modifier Code (FFS)
12 REV_CNTR_UNIT_CNT Revenue Center Unit Count (FFS)
13 REV_CNTR_RATE_AMT Revenue Center Rate Amount
14 REV_CNTR_PRVDR_PMT_AMT Revenue Center (Medicare) Provider Payment Amount
15 REV_CNTR_PMT_AMT_AMT Revenue Center (Medicare) Payment Amount
16 REV_CNTR_TOT_CHRG_AMT Revenue Center Total Charge Amount
17 REV_CNTR_NCVRD_CHRG_AMT Revenue Center Non-Covered Charge Amount
18 REV_CNTR_DDCTBL_COINSRNC_CD Revenue Center Deductible Coinsurance Code
19 REV_CNTR_BENE_PMT_AMT Revenue Center Payment Amount to Beneficiary
20 REV_CNTR_NDC_QTY Revenue Center National Drug Code (NDC) Quantity (FFS)
21 REV_CNTR_NDC_QTY_QLFR_CD Revenue Center NDC Quantity Qualifier Code (FFS)
22 RNDRNG_PHYSN_UPIN Revenue Center Rendering Physician UPIN
23 RNDRNG_PHYSN_NPI Rendering Physician NPI (FFS)
24 RNDRNG_PHYSN_SPCLTY_CD Claim or Revenue Center Rendering Physician Specialty Code
25 REV_CNTR_IDE_NDC_UPC_NUM Revenue Center IDE, NDC, or UPC Number (FFS)
26 REVSTIND Revenue Center Status Indicator Code
27 REV_CNTR_PRCNG_IND_CD Revenue Center Pricing Indicator Code
28 THRPY_CAP_IND_CD1 Therapy cap Indicator 1 Code
29 THRPY_CAP_IND_CD2 Therapy cap Indicator 2 Code
30 REV_CNTR_RP_IND_CD Revenue Center Representative Payee (RP) Indicator Code
31 RC_MODEL_REIMBRSMT_AMT Revenue Center Model Reimbursement Amount
32 RC_VLNTRY_SRVC_IND_CD Revenue Center Voluntary Service Indicator Code
33 ORDRG_PHYSN_NPI Revenue Center Ordering Physician NPI

Condition Code File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 CLM_ID Claim ID
3 NCH_CLM_TYPE_CD NCH Claim Type Code
4 RLT_COND_CD_SEQ Claim Related Condition Code Sequence
5 CLM_RLT_COND_CD Claim Related Condition Code (FFS)

Occurence Code File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 CLM_ID Claim ID
3 NCH_CLM_TYPE_CD NCH Claim Type Code
4 RLT_OCRNC_CD_SEQ Claim Related Occurrence Code Sequence
5 CLM_RLT_OCRNC_CD Claim Related Occurrence Code (FFS)
6 CLM_RLT_OCRNC_DT Claim Related Occurrence Date (FFS)

Span Code File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 CLM_ID Claim ID
3 NCH_CLM_TYPE_CD NCH Claim Type Code
4 RLT_SPAN_CD_SEQ Claim Related Span Code Sequence
5 CLM_SPAN_CD Claim Occurrence Span Code (FFS)
6 CLM_SPAN_FROM_DT Claim Occurrence Span From Date (FFS)
7 CLM_SPAN_THRU_DT Claim Occurrence Span Through Date (FFS)

Value Code File

NumberSAS NameVariable Name
1 BENE_ID Encrypted CCW Beneficiary ID
2 CLM_ID Claim ID
3 NCH_CLM_TYPE_CD NCH Claim Type Code
4 RLT_VAL_CD_SEQ Claim Related Value Code Sequence
5 CLM_VAL_CD Claim Value Code (FFS)
6 CLM_VAL_AMT Claim Value Amount

Demonstrations/Innovations Code File

NumberSAS NameVariable 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