1. US Payroll Implementation Guide
  2. Understanding the Periodic Flat File

Understanding the Periodic Flat File

The ADP Tax Filing Service Standalone is an automated system that enables you to outsource federal, state, and local payroll tax reporting. You can integrate the data that you create using JD Edwards EnterpriseOne Payroll with ADP Tax Filing Service Standalone. This combination enables you to process payroll with JD Edwards EnterpriseOne Payroll and have ADP report the associated payroll tax information to federal, state, and local tax authorities for you.

To process tax data that you generate using JD Edwards EnterpriseOne Payroll in ADP Tax Filing Service Standalone, you must create the Periodic flat file. Using information created during the payroll cycle, this flat file contains tax data in a format that ADP Tax Filing Service Standalone can read. This flat file contains data that the system extracts from these JD Edwards EnterpriseOne tables:

  • Tax Detail File (F07353).

  • Employee Master Information (F060116).

  • Payroll Transaction Constants (F069116).

  • Tax History (F06136).

To create this flat file, you must first set up a version of the ADP TaxService Periodic File TC program (R89078501). This version requires data selection that matches the data selection for the pre-payroll version. If you are using data selection over an item that does not exist in the data selection for the ADP TaxService Periodic File TC program (R89078501, you must set the data selection equal to the Payroll ID, because the fields selected on the pre-payroll version are not available in the table conversion.

After you create the version of the ADP TaxService Periodic File TC program that you want to process, you must create a version of the ADP TaxService Periodic File program (R078501). Both the ADP TaxService Periodic File TC program and the ADP TaxService Periodic File program can be accessed using the Batch Versions program (P98305).

Before you create the Periodic flat file, you must also create a folder called export. You create this folder so that it is subordinate to the folder that contains the JD Edwards EnterpriseOne version that you installed, in the same location as the res folder. These folders must exist before the system can produce the Periodic flat file.

After you set up versions of the ADP table conversion programs and create the export folder, you must run the pre-payroll step of the payroll cycle. Much of the data that you need to create the Periodic flat file is stored in workfiles that the system creates during pre-payroll. To ensure that the system uses the correct data to create the flat file, you must create the file after you successfully process pre-payroll and before you complete the final update step of the payroll cycle for which you want to process tax information. After you successfully create the Periodic flat file, a 1 appears in the ADP Tax Status field on the Work With Pay Cycle Workbench form (W07210A).

The flat file that you create is stored in the export folder and is named CCCCMMDD.prl, where CCCC is the ADP company code, MM is the month, and DD is the day of the payroll payment date. For example, if the ADP company number for Company A is 5555, the name of the Periodic flat file that the system creates for a payroll with a payment date of December 31, 2000 is 55551231.prl. See the system administrator for information about transferring this flat file to ADP Tax Filing Service Standalone.