Paycheck Output Tables

Paycheck output tables are result tables written to and maintained by the batch processes. Some paycheck output tables are, in turn, inputs to other batch processes:

This table lists the Payroll for North American payroll input tables (paysheets) and their corresponding output, or balance, tables.

Payroll Input Tables (Paysheets)	Payroll Output Tables (Balance Tables)
PAY_CTX_OVRD	PAY_CHECK
PAY_EARNINGS	PAY_DEDUCTION
PAY_GARN_OVRD	PAY_DISTRIBUTN
PAY_LINE	PAY_EARNINGS
PAY_ONE_TIME	PAY_GARNISH
PAY_OTH_EARNS	PAY_INS_EARNS (CAN ONLY)
PAY_PAGE	PAY_MESSAGE
PAY_TAX_OVRD	PAY_OTH_EARNS
	PAY_SPCL_EARNS
	PAY_TAX
	PAY_TAX_1042
	PAY_TAX_CAN

The tables on the left are payroll input tables. Often, they are populated with data during the Create Paysheet process, so in that sense they are output tables. But after they are created, they serve as inputs to the other payroll batch processes, such as Pay Calculation and Pay Confirmation. Create Paysheet is a process that goes through the database and forms a proposal to pay someone; it creates the paysheets. When you view paysheets online, you're looking at data from the payroll input tables. When you make one-time tax, deduction, or garnishment changes to an employee's paysheet, you are writing data to these tables, data that the batch processes uses in the next step of converting input to output.

The tables on the right are payroll output tables; most of them also have corresponding balance tables. These tables are the result of running one of the payroll batch processes. These tables are maintained by the Payroll for North America system. That is, these are tables that the system uses to write back to the database during processing.

Notice that the PAY_EARNINGS table functions both as a payroll input table and as a payroll output table. The Create Paysheet process initially generates information in PAY_EARNINGS. Your online users might then update the table. However, the Pay Calculation and Pay Confirmation processes subsequently write results back into PAY_EARNINGS, because PAY_EARNINGS also serves as the history record of the employee's earnings.

PAY_EARNINGS before and after pay confirmation is the same table, but there is a difference. The PeopleCode behind the data-entry paysheets pages doesn't read any data that you've already confirmed. That is, the system considers information on a confirmed PAY_EARNINGS row ineligible to display on a paysheet. The information, however, is still there; it exists until you purge it.

PAY_OTH_EARNS is treated in a similar fashion.