CLER for NFC

Viewing Payroll Discrepancy Listing (Report 1)

The Payroll Discrepancy Listing (Report 1) option on the Reports Selection page allows users to view the Payroll Discrepancy Listing report. This report provides a listing by payroll office identification number of payroll office and carrier enrollee records that match, as well as records marked with payroll office warning and discrepancy codes.

To View a Payroll Discrepancy Listing Report:

1. Select the Reports tab at the top of the CLER Federal Employees Health Benefits, Centralized Enrollment Clearinghouse System Main Menu. The Reports Selection is displayed.

   

2. Click the drop-down menu on the Reports Selection page and select 1. Payroll Discrepancy Listing.
3. Click GO to display the Payroll Discrepancy Listing (Report 1) page.

   

4. Complete the fields on the Payroll Discrepancy Listing (Report 1) page.

   Field	Instruction
   Payroll Office ID*	Required Select the payroll office identification number from the drop-down menu.
   Year*	Optional, default Select the reconciliation year from the drop-down menu. If no year is selected, this field automatically defaults to the current reconciliation year.
   Quarter*	Optional, default Select the reconciliation quarter from the drop-down menu. If no quarter is selected, this field automatically defaults to the current reconciliation quarter.
   Fail Count From	Optional, numeric, 3 positions maximum To search for enrollee records by a specific fail count number, enter the number, then proceed to the To field. To search for enrollee records by a range of fail count numbers, enter the number that starts the range, then proceed to the To field.
   Fail Count To	Optional, numeric, 3 positions maximum To search for enrollee records by a specific fail count number, enter the number that was typed in the From field. To search for enrollee records by a range of fail count numbers, enter the number that ends the range.
   SSN Social Security number - From	Optional, alphanumeric, 9 positions To search for a specific enrollee record by Social Security number (SSN), enter the SSN Social Security number and skip the To field. To search for a range of enrollee records by a range of SSN Social Security numbers, enter the SSN Social Security number that starts the range, then proceed to the To field. Note: A search for enrollee records by complete enrollee SSN Social Security numbers will display the records without the need to complete another optional data entry field (e.g., Agency, POI, etc.) on this page.
   SSN Social Security number - To	Optional, alphanumeric, 9 positions To search for a range of enrollee records by a range of SSN Social Security numbers, enter the SSN Social Security number that ends the range; otherwise, leave blank. Note: A search for enrollee records by complete enrollee SSN Social Security numbers will display the records without the need to complete another optional data entry field (e.g., Agency, POI, etc.) on this page.
   Other ID - From	Optional, alphanumeric, 15 positions maximum To search for a specific enrollee record by Other ID, enter the Other ID and skip the To field. To search for a range of enrollee records by a range of Other IDs, type the Other ID that starts the range, then go to the To field. Note for RSP: Enter the civil service annuitant (CSA) or civil service final (CSF) identifier without the first two characters (i.e., CS). For example, the CSA identifier is typed as AXXXXXXXX, and the CSF identifier is typed as FXXXXXXXX. These fields are used by the RSP Retirement Services Program and OWCP Office of Workers' Compensation Programs. RSP personnel use these fields to search for enrollee records by CSA or CSF identifier. OWCP personnel use these fields to search for enrollee records by claim identifier. To search for enrollee records using these fields, follow the instructions below. Note: A search for enrollee records by complete Other IDs will display the records without the need to complete another optional data entry field (e.g., Agency, POI, etc.) on this page.
   Other ID - To	Optional, alphanumeric, 15 positions maximum To search for a range of enrollee records by a range of Other IDs, enter the Other ID that ends the range; otherwise, leave blank. Note for RSP: Enter the CSA or CSF identifier without the first two characters (i.e., CS). For example, the CSA identifier is typed as AXXXXXXXX, and the CSF identifier is typed as FXXXXXXXX. These fields are used by the RSP Retirement Services Program and OWCP Office of Workers' Compensation Programs. RSP personnel use these fields to search for enrollee records by CSA or CSF identifier. OWCP personnel use these fields to search for enrollee records by claim identifier. To search for enrollee records using these fields, follow the instructions below. Note: A search for enrollee records by complete Other IDs will display the records without the need to complete another optional data entry field (e.g., Agency, POI, etc.) on this page.
   Agency	Optional, alphanumeric, 4 positions Enter the Agency identification code of the office where the enrollee is employed (example: AG90 for U.S. Department of Agriculture, Office of the Chief Financial Officer).
   Personnel Office ID	Optional, alphanumeric, 4 positions Enter the personnel office identification number.
   Carrier	Optional, default Select your organization’s carrier code from the drop-down menu. If no code is selected, this field automatically defaults to your organization’s carrier code.
   Enrollment Code	Optional Select the enrollment code from the drop-down list.
   Error Code	Optional Select the applicable error code from the drop-down menu. For a list and descriptions of error codes, see Discrepancy Codes Table.
   Warning Code	Optional Select the warning code from the drop-down menu. For a list and descriptions of these codes, see Warning Codes Table.
   Display	Optional, default Allows users to display search results by the options listed below. If no display option is selected, this field automatically defaults to the All option. To choose another type of option, select the radio button next to one of the following options: All - Displays all records related to the search criteria. Unreconciled - Displays all records with unreconciled discrepancies related to the search criteria. Errors - Displays all records with errors related to the search criteria. Warnings - Displays all records with warnings related to the search criteria. Reconciled - Displays all records with reconciled discrepancies related to the search criteria. Matches - Displays all records with matches related to the search criteria. Not Validated - Displays records related to the search criteria that have not been validated.
   Order By 1st	Optional, default Defaults to the Name sort option. This field allows users to sort search results by the options listed below. To choose a sort option, select one of the following options from the drop-down menu to display the selected criteria in first sort search order: Agency - Search by Agency code. Enrollment Code - Search by enrollment code. Fail Count - Search by the number of times a discrepancy or warning record has failed the quarterly edit process. Name - Search by enrollee name. Pers. Office ID - Search by personnel office identification number. SSNO - Search by enrollee Social Security number. Other ID - Search by the identifier used by RSP Retirement Services Program/OWCP Office of Workers' Compensation Programs to identify the enrollee.
   Order By 2nd	Optional, default Defaults to the SSNO sort option. This field allows users to sort search results by the options listed below. To choose a sort option, select one of the following options from the drop-down menu to display the selected criteria in second sort search order: Agency - Sorts search results by Agency code. Enrollment Code - Search by enrollment code. Fail Count - Search by the number of times a discrepancy or warning record has failed the quarterly edit process. Name - Search by enrollee name. Pers. Office ID - Search by personnel office identification number. SSNO - Search by enrollee Social Security number. Other ID - Search by the identifier used by RSP Retirement Services Program/ OWCP Office of Workers' Compensation Programs to identify the enrollee.
   Order By 3rd	Optional Select one of the following options from the drop-down menu to display the selected criteria in third sort search order: Agency - Search by Agency code. Enrollment Code - Search by enrollment code. Fail Count - Search by the number of times a discrepancy or warning record has failed the quarterly edit process. Name - Search by enrollee name. Pers. Office ID - Search by personnel office identification number. SSNO - Search by enrollee Social Security number. Other ID - Search by the identifier used by RSP Retirement Services Program/OWCP Office of Workers' Compensation Programs to identify the enrollee.
   Order By 4th	Optional Select one of the following options from the drop-down menu to display the selected criteria in fourth sort search order: Agency - Search by Agency code. Enrollment Code - Search by enrollment code. Fail Count - Search by the number of times a discrepancy or warning record has failed the quarterly edit process. Name - Search by enrollee name. Pers. Office ID - Search by personnel office identification number. SSNO - Search by enrollee Social Security number. Other ID - Search by the identifier used by RSP Retirement Services Program/OWCP Office of Workers' Compensation Programs to identify the enrollee.
   Order By 5th	Optional Select one of the following options from the drop-down menu to display the selected criteria in fifth sort search order: Agency - Search by Agency code. Enrollment Code - Search by enrollment code. Fail Count - Search by the number of times a discrepancy or warning record has failed the quarterly edit process. Name - Search by enrollee name. Pers. Office ID - Search by personnel office identification number. SSNO - Search by enrollee Social Security number. Other ID - Search by the identifier used by RSP Retirement Services Program/OWCP Office of Workers' Compensation Programs to identify the enrollee.
   Order By 6th	Optional Select one of the following options from the drop-down menu to display the selected criteria in sixth sort search order: Agency - Search by Agency code. Enrollment Code - Search by enrollment code. Fail Count - Search by the number of times a discrepancy or warning record has failed the quarterly edit process. Name - Search by enrollee name. Pers. Office ID - Search by personnel office identification number. SSNO - Search by enrollee Social Security number. Other ID - Search by the identifier used by RSP Retirement Services Program/OWCP Office of Workers' Compensation Programs to identify the enrollee.
   Check box to create report without totals	Optional Select this check box to omit totals from the report.

5. Click the drop-down menu at the bottom of the page and select one of the following format options:
   • Display the report
   • Save report as a spreadsheet
   • Save report as a text file
6. Click Submit to display the Payroll Discrepancy Listing report in the selected format.

   OR

   Click Reset to clear all data entered.

   Note: If 24900002, 24900003, or 160099XX was entered in the Payroll Office ID field on the Payroll Discrepancy Listing (Report 1) page, the Payroll Discrepancy Listing (Other ID) report is displayed.

   To return to the Payroll Discrepancy Listing (Report 1) page, close the report.

   

   Field	Description
   SSN Social Security number	System generated Displays the enrollee’s Social Security number submitted by the payroll office.
   Name	System generated Displays the enrollee’s name submitted by the payroll office/carrier.
   Code	System generated Displays the enrollment code submitted by the payroll office/carrier.
   Eff. Date	System generated Displays the effective date (MM/DD/YYYY) submitted by the payroll office/carrier.
   Whld Amt	System generated Displays the enrollee’s withholding amount submitted by the payroll office.
   Agency	System generated Displays the Agency identification code. This code consists of the Department code and Agency code. Note: The Other ID field is displayed in lieu of this field when 24900002, 24900003, or 160099XX is entered in the Payroll Office ID field on the Payroll Discrepancy Listing page.
   POI	System generated Displays the personnel office identification number. Note: The Other ID field is displayed in lieu of this field when 24900002, 24900003, or 160099XX is entered in the Payroll Office ID field on the Payroll Discrepancy Listing page.
   Name	System generated Displays the enrollee’s name submitted by the payroll office/carrier.
   Code	System generated Displays the enrollment code submitted by the payroll office/carrier.
   Eff. Date	System generated Displays the effective date (MM/DD/YYYY) submitted by the payroll office/carrier.
   Discrepancy	System generated Displays the error or warning code generated by CLER Federal Employees Health Benefits, Centralized Enrollment Clearinghouse System. For lists and descriptions of error and warning codes, see Discrepancy Codes Table and Warning Codes Table.
   Fail Count	Displays the number of times the initial discrepancy has been identified and reported.
   Errors	System generated Displays the sum of error codes displayed in the Discrepancy field. Note: If the check box used to omit totals from a report is selected, this field is not displayed.
   Warnings	System generated Displays the sum of warning codes displayed in the Discrepancy field. Note: If the check box used to omit totals from a report is selected, this field is not displayed.
   Total Records	System generated Displays the total number of enrollee records displayed on the report. Note: If the check box used to omit totals from a report is selected, this field is not displayed.