Click here to skip navigation
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