1. Payroll Implementation Guide
  2. Understanding Timecards and Interim Header Records

Understanding Timecards and Interim Header Records

To convert payroll history into the JD Edwards EnterpriseOne Payroll system, you must first upload time entry information into the F06116Z1 table. You can upload pay types, lump sum amounts, and hours. Every employee for whom you want to upload DBA and tax history must have a record in the F06116Z1 table. If no record exists in this table, then no tax or DBA information is converted into the JD Edwards EnterpriseOne system for that employee.

After the time entry records have been uploaded, you can revise the records, if necessary, using the Payroll Batch File Review program (P05116Z1). After reviewing the timecards, run the Time Entry Batch Processor (R05116Z1I) in proof mode.

After you have run the Batch Time Entry Processor in proof mode, review the Transaction Errors report and ensure that:

  • No errors exist in the Employee Transactions Detail table.

  • The data selection for the report includes only those records for which you are converting payroll history.

    Typically, you include a date or a batch number in the data selection.

You must then generate the interim header records. You generate interim header records so that you can transfer the original payment numbers for the imported payment information into the payroll history tables in the JD Edwards EnterpriseOne system. You use the Payroll Conversion - Create Interim Header Records program (R8907350) to update the F07350 table. The system creates one record in the F07350 table for each address book number and EDI line number combination in the F06116Z1 table. When you run the Interims Only payroll, the system uses the information in the F07350 table to update the payroll history tables.

When you run the Create Interim Header Records program, the system updates information in these tables, as indicated:

  • F07350. The system updates the check control number, pay period end date, and payment date.

  • F06116Z1. The system updates the check control number.

  • F07300. The system updates the address book number, payroll ID, payroll lockout ID, and pay frequency.

    Note:

    The Create Interim Header Records program is a table conversion program. You might need to contact the system administrator for assistance with this task.

    See JD Edwards EnterpriseOne Tools Table Conversion Guide

After you have created the interim header records, you must run the Batch Time Entry Processor in final mode. This populates the F06116 table with the time entry records that you uploaded to the F06116Z1 table. You must have records in the F06116 table to process through an interims-only payroll cycle, which updates the payroll history files.

The Batch Time Entry File Processor program verifies that the information within the Employee Transactions - Batch File table is processed correctly and is updated to the Employee Transaction Detail File table.