IPBB

Table of Contents

ADMINISTER BATCHES BY BATCH NUMBER#

Payroll Batches are used to group pay headers together for data entry and payroll processing purposes.

Through the Administer Payroll Batches By Batch Number (IPBB) form you may retrieve/update batches.

A Batch may be manually created in IPBE or by one of the payroll processes such as the transaction generator or the transaction loader. An automatic number is assigned to the batch when it is created. Sequence must be defined in Define Code Sequence Fields (IMCS) form. A single batch may be used for either Pay Transactions (IPTR) or Pay Headers (IPPH), but not for both. When Pay Transactions are generated by the Transaction Generator or Loader, a batch number is assigned. When those pay transactions are turned into time sheets by the UPTR process, a new batch will be created for the time sheets. Batch_Number is a mandatory numeric field that will be automatically assigned by the Application.

The Controls tab enables you to supply batch totals for the data attached to the batch via Pay Headers and Pay Lines. The system compares the Given Totals provided to the Actual Totals calculated by the Audit process.

Before payroll calculation can be processed, batches must be flagged as Eligible, Audited, and Balanced. The Audit process audits the pay lines of the pay headers and sets the Balanced and Audited flags on if:

Batch Elements must be defined in the Define Payrolls (IPPR) form (through the Batch Balancing Elements tab) in order to be accessible for balancing.

Payroll Batch data is stored on the P2K_PR_BATCHES, P2K_PR_BATCH_CONTROLS, P2K_PR_PAY_HEADERS, P2K_PR_PAY_TRANSACTIONS, and P2K_PR_BATCH_ELEMENT_GIVENS tables.


Details tab#

Identification#

Entity
The entity for which the payroll batch was created is displayed in this field.
Payroll
The payroll for which the payroll batch was created is displayed in this field.
Account
The bank account for which the funds are withdrawn for deposit/checks is held in this field. Bank_Account from P2K_PR_PAYROLL_BANK_ACCOUNTS is an optional 30 character alphanumeric field that will default from the payroll entered.
User Name
This field will indicate the user ID of the user that created the batch.
Department
Through this field, a specific department may be assigned to the batch to limit user access. Department_Code from P2K_CM_DEPARTMENTS is an optional 16-character alphanumeric field that you must manually enter or use the LOV (F9).
Authorization
A specific authorization area may be assigned to the batch to limit user access. Authorization_Area_Code from P2K_CM_AUTHORIZATION_AREAS is an optional 16-character alphanumeric field that you must manually enter or use the LOV (F9).

Details#

Batch Code
If used, the Batch_Code will display in this field.
Batch Source
This field will display how the batch was created:
Batch_Source is a mandatory fixed lexicon (X_BATCH_SOURCE) that is system updated and cannot be overridden.
Batch Status
This field indicates that the batch is one of the following:
Batch_Status is a mandatory fixed lexicon (X_BATCH_STATUS) that is system updated and may not be overridden.
Batch Type
This field displays if the batch is a pay header (IPPH) or pay transaction (IPTR) batch.
Pay Category
This field displays the pay category for the pays in this batch.
Pay Period
This field displays the pay period being paid for the pays in this batch.
Eligible
The Eligible toggle is a mandatory flag that is set manually by you in IPBB or IPBE or automatically by the process that created the batch. If the ‘Eligible’ toggle is ON, the batch has been marked as eligible for processing through the payroll calculation process (UPCALC). If the toggle is OFF, the payroll calculation process will ignore the batch. Eligible is system updated but may be overridden.
Audited
If the ‘Audited’ toggle is ON, the batch has passed successfully through the audit process (UPAUDT). If the toggle is OFF, either the batch has not yet been audited, or it has failed to pass the audit process. Audited is system updated and cannot be overridden.
Balanced
If the ‘Balanced’ toggle is ON, the batch has passed successfully through the Batch Balancing Check of the audit process (UPAUDT) through the ‘Batch Balance Element’ tab from IPPR. If Batch Balance Element is not specified on IPPR, then the batch is always ‘balanced’. If the toggle is OFF, the batch has not yet passed successfully through the balance check. Balanced is system updated and cannot be overridden.

Controls tab#

Batch Date
If you wish to provide given totals, the date of the batch control totals must be entered. Batch_Date is mandatory date field.
Given Pays
If you wish to provide given totals you must enter the number of pays that must be compared against the Actuals. Pay_Count is an optional 5 digit numeric field that you may manually enter.
Element
The Batch Elements define the pay elements used to derive the system-calculated total when balancing a batch of payroll transactions. The IPPR form must define a list of elements for batch balancing before the user can supply the element total in this field. This field displays the name of the element containing the pay components that you may want to total and balance against.
i.e. Regular Time only or Reg. Time and Reg. Earnings, etc.
Element_Code from P2K_PR_ELEMENTS is an optional 16-character alphanumeric field that you may manually enter or use the LOV (F9).
Amount
This field shows the Given amount for the element indicated to be compared against the Actuals. Given_Amount is an optional 5 digit numeric field that you may manually enter.

Pays tab#

This area allows you to view a list of all of the pay headers attached to the batch.

All fields in this area are display only; you will not be able to edit the information.

Person
This field shows the Person Code of the employee for the pay being added.
Last name
The employee’s last name will be displayed here.
First Name
The employee’s first name will be displayed here.
Period
This field displays the pay period of the pay being loaded.
End Date
This field shows the end date of the pay.
Pay #
This field will display the pay number attached to the pay transaction.
Category
The Pay category of the pay being loaded is displayed here.
Stage
This field will indicate where the pay is in the payroll process.

Transactions tab#

This area allows you to view a list of all of the pay transactions attached to the current batch. These pay transactions are either generated by the Transaction Generator, Loader or manually entered on the IPTR screen.

All fields in this area are display only; you will not be able to edit the information.

Trans Status
This field indicates the status of the transaction as ‘Newly Entered’, ‘Verified’, or ‘Processed’. Pay_Tran_Status is for viewing only, you may not edit information found in this field.
Tran. Source
This field displays the source of the transaction, namely, ‘IPTR Screen’, ‘UPTL Loader’, ‘UPTG Generator’, ‘External Source’, and ‘UTTG Generator’. Pay_Tran_Source is for viewing only, you may not edit information found in this field.
Start Date
This field displays the start date of the transaction. Start_Date is for viewing only, you may not edit information found in this field.
End Date
This field displays the end date of the transaction. End_Date is for viewing only, you may not edit information found in this field.
Wage Rate
This field displays the wage rate of the transaction. Wage_Rate is for viewing only, you may not edit information found in this field.
Basis
This field displays the rate basis of the wage. Rate_Basis is for viewing only, you may not edit information found in this field.

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation