Payroll-Related Tables

Payroll for North America is a set of input tables, processes, and output tables. You set up your input tables, run a process, and the process, in turn, writes new data to the output tables.

This table lists examples of Payroll for North America input tables with their associated processes and output tables

Input Tables	Processes	Output Tables
Employee Data	Payroll	Paycheck
Job	Create Paysheet	Checks
Benefits	Pay Calculation	Deductions
Deductions	Pay Confirmation	Taxes
	Actuals Distribution	Balances
Pay Process	Reversal Processing	Messages
Earnings	Calendar Build
Deductions	Delete Balances (U.S.), Delete Balances (Canada)
Taxes	Check Reprint
	Unconfirm Pay
	Payroll Unsheet
	Benefits
	Calculate Deductions
	Confirm Deductions
	Savings Management Balances
	Leave Accrual
	Human Resources
	Batch Encumbrance Process
	Tenure/Flexible Service Calc'n (tenure/flexible service calculation)

Note:

This chart doesn't list actual table names, but are generic classifications for the various tables in the system.

Running Payroll for North America processes might be labeled a quiet task. The processes start, run, and stop, rarely putting out more than five or ten lines of output, which typically consist of messages to the effect that the process began at a certain time, a certain pay group is being processed, and finally, that the run has finished.

The system writes all results of the Payroll for North America processes back into the database. Any tangible outputs from these processes, such as paychecks, are all reports based on database tables. To get the physical paychecks, for example, you run an Structured Query Report (SQR) against the database.

So what does a typical Payroll for North America process do? It reads some input from various tables, writes new data back into the database, and goes away. A process might send a message that says "Check Messages!!!". That means it wrote at least one message into the message table. In that case, you must go back and run a report against the message table to get the messages, or view the messages online on the Paysheets page, Payroll Messages page.