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
-
Early Retiree List: File Formats (PDF 149 KB) – This document details the specific formats for submitting ERLs via the ERRP Secure Website (SWS) or via mainframe connection. Updated 12/17/10
-
Early Retiree List: File Upload Template – This template is used to create ERLs for upload via the ERRP Secure Website (SWS).
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/11The 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
Claim List Response File (CLRF) Review
-
Claim List: Response File Reference Guide (PDF 413 KB) – This document provides a CLRF overview, describes the CLRF layout, and reviews CLRF
reason codes. -
Claim List: Response File Reason Codes (PDF 830 KB) – This document describes the CLRF reason codes and explains what Plan Sponsors should do to resolve the errors. Updated 12/16/11
-
Claim List: Response File Layout (PDF 54 KB) – This document demonstrates how to interpret a CLRF. Updated 10/06/11
Problems viewing files?
Get Adobe Reader FREE