CLER for NFC

Viewing Payroll Office Reconciliation (Report 3)

The Payroll Office Reconciliation (Report 3) option on the Reports Selection page allows users to view the Payroll Office Reconciliation report. This report lists each enrollee record that has a discrepancy and indicates whether that discrepancy has been reconciled.

To View a Payroll Office Reconciliation 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 page is displayed.

   

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

   

4. Complete the fields on the Payroll Office Reconciliation (Report 3) 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.
   Reconciliation Date From	Optional To select this date, select the month from the first drop-down menu, select the day from the second drop-down menu; and select the year from the third drop-down menu. This is the date that begins the range of reconciliation dates.
   Reconciliation Date To	Optional To select this date, select the month from the first drop-down menu, select the day from the second drop-down menu; and select the year from the third drop-down menu. This is the date that ends the range of reconciliation dates.
   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.
   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*	Required Select the carrier code from the drop-down menu.
   Enrollment Code	Optional Select the enrollment code from the drop-down list.
   User ID	Optional, alphanumeric, 8 positions maximum Enter the user identification number of the person creating the report.
   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.
   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 results by Agency code. Carrier - Search by carrier 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. Reconciliation Date - Search by reconciliation date. 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. User ID - Search by user identification number.
   Order By 2nd	Optional Select one of the following options from the drop-down menu to display the selected criteria in second sort search order: Agency - Search by Agency code. Carrier - Search by carrier 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. Reconciliation Date - Search by reconciliation date. 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. User ID - Search by user identification number.
   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. Carrier - Search by carrier 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. Reconciliation Date - Search by reconciliation date. 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. User ID - Search by user identification number.
   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. Carrier - Search by carrier 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. Reconciliation Date - Search by reconciliation date. 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. User ID - Search by user identification number.
   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. Carrier - Search by carrier 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. Reconciliation Date - Search by reconciliation date. 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. User ID - Search by user identification number.
   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. Carrier - Search by carrier 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. Reconciliation Date - Search by reconciliation date. 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. User ID - Search by user identification number.
   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 Office Reconciliation 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 Office Reconciliation (Report 3) page, the Payroll Office Reconciliation (Other ID) report is displayed.

   To return to the Payroll Office Reconciliation (Report 3) page, close the report.

   

   Field	Description
   SSN	System generated Displays the enrollee’s SSN.
   Name	System generated Displays the enrollee’s name submitted by the payroll office/carrier.
   Carrier	System generated Displays the carrier identification code.
   Agency	System generated Displays 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). 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 Office Enrollees page.
   POI	System generated Displays the personnel office identifier of the office where the enrollee’s records are maintained. 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 Office Enrollees page.
   Code	System generated Displays the enrollment code.
   Reconciliation Reason	System generated Displays the is the reconciliation reason code. For a list and descriptions of reconciliation reason codes, see Reconciliation Reason Codes Table.
   Reconciliation Date	System generated Displays the reconciliation date.
   Reconciliation User ID	System generated Displays the user identification number of the person who entered the reconciliation reason code.
   Reconciliation Action	System generated Displays the reconciliation action code. For a list and descriptions of reconciliation action codes, see Reconciliation Action Codes Table.
   Reconciliation Fail Count	System generated Displays the number of times the initial discrepancy has been identified.
   With Errors	System generated Displays the sum of enrollee records with codes in the Reason and Action fields. Note: If the check box used to omit totals from a report is selected, this field is not displayed.
   Without Errors	System generated Displays the sum of enrollee records with no codes in the Reason and Action fields. 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.