19 Understanding Pre-Payroll Workfiles and Business Functions

This chapter contains the following topics:

19.1 Understanding Pre-Payroll Workfiles and Business Functions

When you process pre-payroll, the system generates temporary workfiles that are used to calculate employee earnings, create payments, generate journal entries, and create employee payroll history. The system uses business functions when you process pre-payroll to retrieve employee data, perform complex payroll calculations, and produce payment information.

19.2 Pre-Payroll Workfiles

The pre-payroll process creates these temporary workfiles:

  • F05290

  • F063951

  • F0705

  • F0709

  • F07210

  • F07241

  • F07350

  • F07351

  • F07352

  • F07490

  • F07491

  • F07492

19.3 Pre-Payroll Business Functions

The pre-payroll process uses these business functions:

Business Function Description
Employee Lockout Function (B0700021) The Employee Lockout function creates the F07300 table, and performs payroll error message editing to determine whether employees are locked to another payroll ID, or whether employees that you are trying to process do not qualify for the payroll.
Lock Timecards Function (B0700019) The Lock Timecard function locks all of the timecard records in the F06116 table by updating the Check Control Number and the Payroll Lockout ID fields. This function also creates the timecard cache.
Auto Pay Generation Function (B0700027) The Auto Pay Generation function determines whether the system must automatically generate timecards for employees. This function evaluates employee information and existing timecards that should be included in auto pay calculations, and generates additional timecards for auto pay employees.
DBA Lockout Function (B0700016) The DBA Lockout function locks DBA one-time override records in the F0709 table that were manually entered before the payroll was processed.
Create PDBA Cache History Function (B0700013) The Create PDBA Cache History function retrieves employee PDBA history from these files, and then creates the PDBA cache:
  • F06146

  • F06145

If you are using leave balance, this business function also retrieves history from the F06147 table.

Create Tax Workfile History Function (B0700014) The Create Tax Workfile History function retrieves employee tax history from these tables, and then creates the tax detail cache:
  • F06136

  • F07353

Payment Shell Record Server Function (B0700017) The Payment Shell Record Server function creates the initial payment header record in the F07353 table.
Pre-Payroll DBA Calculation Function (B0700005) The Pre-Payroll DBA Calculation function calculates gross DBA amounts, and updates the F0709 table. After the Vertex Tax Calculations function (B0700010) is processed, this function also calculates net DBA amounts and again updates the F0709. Additionally, this function updates the F07350 table with DBA gross, net, and tax information.
Vertex Tax Calculations Function (B0700010) The Vertex Tax Calculations function (B0700010) calculates employee tax details and updates the F07353 table. Additionally, this function calls these functions that are used to calculate employee tax withholding amounts:
  • Set Tax Calculation Inputs (B0700004)

  • Perform Tax Calculations (B0700008)

  • Create Tax Detail Records (B0700009)

Create Stub Detail Records Function (B0700001) The Create Stub Detail Records function creates the payment stub record in the F07352 table.
Create Payment Distribution Records Function (B0700002) The Create Payment Distribution Records function creates records in the F07351 table. Additionally, this function performs the Gross to Net Error edit.
F06116 Update Timecard Component Function (B0501070) The F06116 Update Timecard Component function updates the component pay flag of the component pay and the base pay timecards that are affected when a component pay instruction is added or updated.
F06116 Generate Component Pay Function (B0501030) The F06116 Generate Component Pay function processes all pending base pay timecards in the system and retrieves their corresponding component pay instructions to generate component pay timecards.
Component Pay Timecard Cache Function (B0501031) The Component Pay Timecard Cache function stores the component pay timecards for a given base timecard in a user-defined cache, so that they may be restored and printed on the component pay generation report.