Skip to Main Content

CLER for Carriers

Previous Topic

Next Topic

Book Contents

Book Index

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 Main Menu.

    CLER Main Menu Page

  2. The Reports Selection page is displayed.

    Reports Selection Page

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

    Payroll Office Reconciliation (Report 3) Page

  5. Complete the fields on the Payroll Office Reconciliation (Report 3) page.

    Field

    Instruction/Description

    Payroll Office ID*

    Required

    Select the payroll office identification number from the drop-down menu.

    Year*

    Required, 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*

    Required 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.

    Enter a specific fail count number to search for enrollee records by a specific fail count number, then proceed to the To field.

    OR

    Enter the number that starts the range of fail count numbers to search for enrollee records by a range of fail count numbers, then proceed to the To field.

    Fail Count To

    Optional, numeric, 3 positions maximum

    Entered the number that was entered in the From field to search enrollee records by a specific fail count number.

    OR

    Enter the number that ends the range of fail count numbers to search for enrollee records by a range of fail count numbers.

    Reconciliation Date From

    Optional

    This is the date that begins the range of reconciliation dates. 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.

    Reconciliation Date To

    Optional

    This is the date that ends the range of reconciliation dates. 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.

    SSN - From

    Optional, alphanumeric, 9 positions

    To search for a specific enrollee record by SSN, enter the SSN and skip the To field.

    To search for a range of enrollee records by a range of SSNs, enter the SSN that starts the range, then proceed to the To field.

    Note: A search for enrollee records by complete enrollee SSNs will display the records without the need to complete another optional data entry field (e.g., Agency or POI) on this page.

    SSN - To

    Optional, alphanumeric, 9 positions

    To search for a range of enrollee records by a range of SSNs, enter the SSN that ends the range; otherwise, leave blank.

    Note: A search for enrollee records by complete enrollee SSNs will display the records without the need to complete another optional data entry field (e.g., Agency or POI) on this page.

    Agency

    Optional, alphanumeric, 4 positions

    Enter the Agency ID 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 (POI) number.

    Carrier

    Optional

    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 and OWCP. 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 or POI) 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 and OWCP. 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 or POI) 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 POI number.

    Reconciliation Date - Search by reconciliation date.

    SSNO - Search by enrollee SSN.

    Other ID - Search by the identifier used by RSP/OWCP to identify the enrollee.

    User ID - Search by user ID 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 POI number.

    Reconciliation Date - Search by reconciliation date.

    SSNO - Search by enrollee SSN.

    Other ID - Search by the identifier used by RSP/OWCP to identify the enrollee.

    User ID - Search by user ID 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 POI number.

    Reconciliation Date - Search by reconciliation date.

    SSNO - Search by enrollee SSN.

    Other ID - Search by the identifier used by RSP/OWCP to identify the enrollee.

    User ID - Search by user ID 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 POI number.

    Reconciliation Date - Search by reconciliation date.

    SSNO - Search by enrollee SSN.

    Other ID - Search by the identifier used by RSP/OWCP to identify the enrollee.

    User ID - Search by user ID 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 POI number.

    Reconciliation Date - Search by reconciliation date.

    SSNO - Search by enrollee SSN.

    Other ID - Search by the identifier used by RSP/OWCP 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 POI number.

    Reconciliation Date - Search by reconciliation date.

    SSNO - Search by enrollee SSN.

    Other ID - Search by the identifier used by RSP/OWCP 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.
  6. 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
  7. 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.

    Payroll Office Reconciliation Report Page

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 ID code.

Agency

System generated

Displays the Agency ID 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 POI 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 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 the sum of enrollee records on the report.

Note: If the check box used to omit totals from a report is selected, this field is not displayed.

Payroll Office Reconciliation (Other ID) Report Page

See Also

Viewing Reports

Viewing Payroll Discrepancy Listing (Report 1)

Viewing Discrepancy Summary (Report 2)

Viewing Payroll Office Reconciliation (Report 3)

Viewing Carrier Validation (Report 4)

Viewing Payroll Office Enrollment Transmission (Report 5)

Viewing Carrier Enrollment Transmission (Report 6)

Viewing Enrollment Change Summary (Report 7)

Viewing Carrier Gain/Loss Summary (Report 8)

Viewing Reconciliation Reason Summary (Report 9)

Viewing Reconciliation Action Summary (Report 10)

Viewing Reconciliation Summary (Report 11)

Viewing Carrier Discrepancy Listing (Report 12)

Viewing Pay Period Transmissions Payment Amounts (Report 13)