Click here to skip navigation
This website uses features which update page content based on user actions. If you are using assistive technology to view web content, please ensure your settings allow for the page content to update after initial load (this is sometimes called "forms mode"). Additionally, if you are using assistive technology and would like to be notified of items via alert boxes, please follow this link to enable alert boxes for your session profile.
An official website of the United States Government.

Healthcare Carriers

2005-01: Appendix D

Sample Crosswalk

Every data submission that your CAHPS®3.0H Survey vendors sends to OPM must be accompanied by a "crosswalk" that will allow OPM to map your plan's data to the appropriate FEHB Sub-Code. This is the only way that OPM will be able to identify submissions and allocate data correctly. The crosswalk must include the following information:

  • Member-level file name
  • Summary-level file name
  • NCQA Submission ID
  • NCQA Plan Name
  • FEHB Sub-Code
  • FEHB Plan Name

The Member-level and Summary-level filenames must follow the NCQA naming conventions.

Example of a Crosswalk For a Vendor Submission

Row

Member-level File Name

Summary-level File Name

NCQA Sub-ID

NCQA Plan Name

FEHB Sub-Code

FEHB Plan Name

1

CAM1234.txt

CAS1234.txt

1234

XYZ Healthplan, Inc.

AA-HMO-UT-000

XYZ Healthplan

2

CAM2345.txt

CAS2345.txt

2345

QRS Healthcare

BB-POS-IL-000

QRS Healthcare

3

CAM2345.txt

CAS2345.txt

2345

QRS Healthcare

BB-POS-IN-000

QRS Healthcare

4

CAM3456.txt

CAS3456.txt

3456

MNO Health Providers S. Cal

CC-HMO-CA-000

MNO Health Network

5

CAM4567.txt

CAS4567.txt

4567

MNO Health Providers N. Cal

CC-HMO-CA-000

MNO Health Network

  • Sample row 1 shows the most straightforward example where it is a one-to-one mapping between the NCQA Sub ID and FEHB Sub-Code.
  • Sample rows 2 and 3 show how the crosswalk should appear when one set of NCQA data is mapped to two FEHB Sub-Codes. In this case, only one member-level file and one summary-level file should be submitted to OPM.
  • Sample rows 4 and 5 show how the crosswalk should appear when two sets of NCQA data are mapped to one FEHB Sub-Code. In this case, two member-level files and two summary-level files must be submitted to OPM.
Control Panel