Slider text background image for preloading, non-content

Reference Materials

The documents on this page were designed to assist Plan Sponsors in understanding the following tasks:
Early Retiree List (ERL) Preparation, Submission, and Response File Review | Claim List Preparation and Submission | Claim List Response File (CLRF) Review


Early Retiree List (ERL) Preparation, Submission, and Response File Review

User Tips

  • Make sure to enable macros.

  • When saving the template, do not change the file type. The template will save as both an Excel file and a .CSV file.

  • If data is pasted into the template, the cell formatting and data validation within each cell will be lost. If the data is not in the correct format during upload, the SWS will display an error reason.

  • Early Retiree List: File Error Messages (PDF 20 KB) – This document lists the error messages the ERRP SWS may display if an error occurs during ERL upload. Updated 02/26/11

  • Early Retiree List Response File: Reason Codes (PDF 66 KB) – This document explains the reason codes the ERRP Center may return in the ERL Response File if there is a full or partial denial of an individual’s eligibility as an early retiree or early retiree’s spouse, surviving spouse, or dependent. Updated 04/29/11



Claim List Preparation and Submission

  • Claim List: Secure Website Layouts (PDF 830 KB) – This document details the Claim List layouts for submission via ERRP SWS. Updated 11/11/11

  • Claim List: Mainframe Layouts (PDF 830 KB) – This document details the Claim List layouts for submission via mainframe. Updated 11/11/11

  • Claim List: Upload Errors (PDF 33 KB) – This document contains the errors Plan Sponsors may receive when uploading a Claim List via ERRP SWS or mainframe and explains how to resolve the errors. Updated 04/05/11


  • Claim List: Secure Website Training Example Reference Guide (PDF 295 KB) and Claim List: Mainframe Training Example Reference Guide (PDF 376 KB) –
    The Training Examples demonstrate how to:

    • Identify Professional, Institutional, and Prescription claim record data in the required format as indicated in the Claim List layout. (Illustration 1)

    • Report Costs Paid by Early Retiree (Illustration 2)

    • Report claim data for applications with a transition plan year, i.e., plan year beginning prior to 6/1/2010, with early retiree claim data exceeding the cost threshold prior to 6/1/2010 with cost adjustments. (Illustration 3)

    • Report claim data for an early retiree meeting the limit reduction with cost adjustments. (Illustration 4)

    • Report claim data for applications with a transition plan year, i.e., plan year beginning prior to 6/1/2010, with early retiree claim data exceeding the cost threshold prior to 6/1/2010, meeting the cost limit with cost adjustments. (Illustration 5)

    • Accurately report bundled claims in the Claim List. (Illustration 6)

    • Compile all Claim List record types and all early retiree claim records into a single Claim List and correlate to the ERRP SWS Summary Cost Data. (Illustration Claim List Headers and Formatting)

    • The Secure Website Claim List Training Example explains how to convert Claim List data in Claim List layout to a .CSV format for upload to the ERRP SWS. (Illustration .CSV)
      Note: Use the Reference Guide to understand the Illustrations found in the Secure Website Training Example online Excel workbook. Updated 12/23/11

    • The Mainframe Claim List Training Example shows an example of a Claim List formatted for mainframe submission to the ERRP Center. (Illustration CL Mainframe)
      Note: Use the Reference Guide to understand the Illustrations found in the Secure Website Training Example online Excel workbook. Updated 12/23/11


Back to Top


Claim List Response File (CLRF) Review


Back to Top


Problems viewing files?

Get Adobe Reader FREE PDF icon

Page last updated July 20, 2012 at 3:00PM EST