26 Overview to Payroll History Integrity

This chapter contains these topics:

26.1 Objectives

  • To verify the integrity of payroll history

  • To delete unwanted history records from the system

26.2 About Payroll History Integrity

After you process a payroll, you should verify the integrity of your payroll history. This history is used for:

  • Government reports

  • Year-end forms

  • Internal reporting purposes

To verify the integrity of your payroll history, run reports that identify discrepancies between your detail history tables and the corresponding summary history tables. Integrity reports locate missing, inaccurate or incomplete information in the summary tables. You should run them monthly, quarterly, and before you begin year-end processing.

Working with payroll history integrity includes:

  • Verifying the integrity of payroll summary history

  • Verifying the integrity of payroll detail history

  • Revising payroll history manually

  • Updating available leave

  • Reposting payroll history

You should review each error listed on your payroll history integrity reports and determine what action, if any, you must take to correct it. Depending on the error, you must either update the appropriate constants tables or make changes to the history tables. The Payroll system provides several revision programs that you can use to manually correct payroll history. Other types of errors might not require manual corrections. The system corrects some errors automatically when you run the integrity reports in update mode. The Payroll system includes error code tables that can help you research integrity errors.

In rare instances, you might encounter a history integrity problem that you cannot correct by running an integrity report in update mode or by entering a correction on an online review form. In these instances, you can run a repost to correct the problem. During a repost, the system uses the information in a detail history table to recalculate the totals in the corresponding summary history table. The repost program overwrites existing information in the summary table.

Caution:

Before you run a repost, contact JD Edwards World for customer support.

26.2.1 What Are the Types of Payroll History?

The two basic types of payroll history are:

  • Detail history

  • Summary history

Each time you run the final update step of the payroll cycle, the system creates payroll history records and stores them in the history tables. Detail history records contain each tax type, pay type, and DBA that the system calculated for each payment. The system stores these records in detail history tables.

After the system stores records in the detail history tables, it totals and summarizes the information in these tables and creates summary history records. The system then writes the summary history records to the corresponding summary history tables. The system uses the summary history tables to retrieve tax and earnings information for government reports and year-end forms. Using summary history tables to report tax and earnings information reduces processing time.

The following list identifies the detail history tables and their corresponding summary tables.

History Table Summary Tables
Pay and Taxes by Check (F06166)
  • Taxation Summary History (F06136)
DBA Detail History (F0619)
  • Calendar Month DBA Summary History (F06145)
  • Payroll Month PDBA Summary History (F06146)

  • Tax Area Transaction Summary History (F06148)

  • Fiscal/Anniversary Year History (F06147)

Payroll Transaction History Detail (F0618)
  • Payroll Month PDBA Summary History (F06146)
  • Workers Compensation Summary History (F0627)