PaySheet Creation Process

Paysheets contain the data required to calculate employee pay for each pay period.

During the Paysheet Creation process, the system scans all employees and selects the employees scheduled to be paid for the specified pay period. It recognizes them because their pay groups are assigned to a pay calendar entry that is associated with the pay run ID.

Paysheets are used to enter time and any additional payroll-related information such as earnings, frequency, one-time deductions, one-time garnishments, one-time taxes, accounting data, and tax periods.

Payroll for North America > Payroll Processing USA > Create and Load Paysheets > Create Paysheets > Create Paysheet (PSPPYBLD - COBOL SQL)

PSPPYBLD selects data from below tables:

PS_PAYSHEET_RUNCTL         
The process selects the run control record that was added by the  user prior to running the process.

PS_PAY_CALENDAR               
Using the Run ID, the process selects the appropriate pay calendar information.

PS_INSTALLATION                  
The process selects the Balance ID for the calendar year.

PSPPYBLD  inserts data into below tables:

PS_PAY_PAGE                           
This table contains the Paysheet pages that are created.  Each page may be the parent to several paylines.

PS_PAY_LINE                            
This table contains individual paylines.  Each employee will be created on a separate payline during on-cycle processing.   Each payline may be the parent to several pay earnings records.  These pay earnings records may represent one or more checks.

PS_PAY_EARNINGS                
This table contains individual pay earnings records.  Each paycheck may contain several pay earnings records. Some key fields on this table are:

• SEPCHK - Determines whether these earnings are associated with a separate check.

• PAY_LINE_STATUS - Indicates whether the earnings record has been calculated or confirmed successfully. Valid values are I-Initial Load, U-Updated by operator, C- Calculated successfully, E-Error, F-Confirmed successfully, P-Pay in Progress.

• JOB_PAY - Directs the process to update the paysheet with the most current job information.

• OK_TO_PAY - Indicates whether this record should be processed.  If this field is set to ‘N’, this record will be bypassed by the calculation process.

• DED_TAKEN - Directs the system how to take deductions.  If this field is set to ‘N’, no deductions will be taken for this check.

PS_PAY_OTH_EARNS             
This table contains other earnings records which are added to the paysheet.  The PAYSHEET process may generate these records automatically from the additional pay data records under Employee Payroll Data.  Records added from additional pay will have the ADDL_SEQ field set to a value > 0.  Other Earnings records may also be added online or through a time interface.  Records added in this manner should have the ADDL_SEQ field set = 0.  Otherwise, additional pay will not be processed correctly.  There may be multiple other earnings records for one PS_PAY_EARNINGS record.

PS_PAY_MESSAGE                  
This table is updated with standard payroll error messages that are encountered during the process.

PSPPYBLD updates data in below tables:

PS_PAY_CALENDAR               
The PAY_SHEETS_RUN flag on the pay calendar is set to ‘Y’ to indicate that the PAYSHEET process has run successfully.

PSPPYBLD deletes data from below tables:

PS_PAYSHEET_RUNCTL         
The run control is deleted after the process is initiated.

PS_PAY_MESSAGE                 
Messages from the prior run are deleted by company, pay group, pay end date and off-cycle indicator.  Page number is also used for off-cycle check processing.