PRBATCH – Payroll Time Record Batch Head
- System
- Payroll (PR)
- Prefix
PRB- Primary key
COMPANY,BATCH-NBR- Fields
- 16
- Updated by
- 40 programs
- Referenced by
- 3 programs
PRBATCH is the Payroll Time Record Batch Head table in Lawson Payroll (prefix PRB). It is indexed by COMPANY, BATCH-NBR (PRBSET1). It is related 1:1 to ATTENDCODE, PRSYSTEM, DEPTCODE, PERSGROUP and PCODES and 1:M to TIMERECORD. It is updated by BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 and 32 more and referenced by HR55.1, HR55.2 and HR55.3. The table has 16 fields, 1 index and 7 documented relations.
About PRBATCH
This file is used to group time records into batches for clearer error evaluation. When you create time records in Batch state, the system creates Payroll Time Card Batch Header file records and updates the actual hours and amount totals. There are many programs that create time records in Batch state. PR33.1 (Speed Entry Setup) uses this file to set up selection parameters for time record speed entry. PR37.1 (Batch Time Control) is the program that changes time records from Batch to Future status. You can require hash totaling in PR37.1. To prevent releasing a batch of time records that does not balance, select Yes in the Batch Control field on the Payroll form tab in HR00.1 (Company).
Fields (16)
Column = COBOL field name without the PRB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#PRB-COMPANY PKCOMPANY | Numeric 4 | — | BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more |
#PRB-BATCH-NBR PKBATCH_NBR | Numeric 6 | Contains the batch number. Batch numbers are assigned by the system if automatic batch numbering is defined for the company on the Payroll form tab in HR00.1 (Company). | BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more |
#PRB-TR-DATETR_DATE | Numeric 8 (yyyymmdd) | Contains the time record date. | BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more |
#PRB-TOTAL-HOURSTOTAL_HOURS | Signed 9.2 | Contains the total hours the system uses to compare with actual hours for batch control edits. | BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more |
#PRB-TOTAL-AMOUNTTOTAL_AMOUNT | Signed 13.4 | Contains the total amount the system uses to compare with the actual amount for batch control edits. | BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more |
#PRB-ACTUAL-HOURSACTUAL_HOURS | Signed 9.2 | Contains the total hours associated with time records included in this batch. The system updates this field when you add, change, or delete time records associated with the batch. | BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more |
#PRB-ACTUAL-AMOUNTACTUAL_AMOUNT | Signed 13.4 | Contains the total amount associated with the time records included in the batch. The system updates this field when you add, change, or delete time records associated with the batch. | BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more |
#PRB-ATTEND-CODEATTEND_CODE | Alpha 2 Occurs 5 Times ×5 | Contains an attendance code associated with the batch. | BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more |
#PRB-PAY-CODEPAY_CODE | Alpha 4 Occurs 5 Times ×5 | Contain a pay code associated with the batch. | BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more |
#PRB-PROCESS-LEVELPROCESS_LEVEL | Alpha 5 | Contains the process level associated with the batch time record, and is used to display employees in a specific process level for speed time record entry selection in PR33.2 (Speed Entry by Number) and PR33.3 (Speed Entry by Name). | BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more |
#PRB-DEPARTMENTDEPARTMENT | Alpha 5 | Contains the department associated with the batch time record. Used to display employees in a specific department for speed time record entry selection in PR33.2 (Speed Entry by Number) and PR33.3 (Speed entry by Name). | BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more |
#PRB-GROUP-NAMEGROUP_NAME | Alpha 10 | Contains the group name associated with the batch time record. PR33.2 (Speed Entry by Number) and PR33.3 (Speed Entry by Name) use this field to display employees associated with an employee group for speed time record entry selection. | BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more |
#PRB-USER-LEVELUSER_LEVEL | Alpha 10 | Contains the user level associated with a batch time record. PR33.2 (Speed Entry by Number) and PR33.3 (Speed Entry by Name) use this field to display employees for speed time record entry selection. | BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more |
#PRB-DELETE-FLAGDELETE_FLAG | Alpha 1 | Contains the value that determines if the setup parameters created in PR33.1 (Speed Entry Setup) are deleted when the batch is released. If the parameters are not deleted, the actual hours and amount fields are set to zero.
| BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more |
#PRB-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | — |
#PRB-CURR-NDCURR_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | — |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PRBSET1 |
| Primary | BN150, HR55.1, HR55.2, HR55.3, PR521, EXI2.1, EXI4.1, LP130 +22 more (list truncated in source) |
Relations
One to one (6) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Attend Code | ATTENDCODE | Required | When PRB-ATTEND-CODE != Spaces |
| |||||||||
| Company | PRSYSTEM | Required |
| ||||||||||
| Department | DEPTCODE | Required | When PRB-DEPARTMENT != Spaces |
| |||||||||
| Emp Group | PERSGROUP | Required | When PRB-GROUP-NAME != Spaces |
| |||||||||
| Process Level | PRSYSTEM | Required | When PRB-PROCESS-LEVEL != Spaces |
| |||||||||
| User Level | PCODES | Required | When PRB-USER-LEVEL != Spaces |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Timerecords | TIMERECORD | Delete Cascades |
|
Programs
Updated by (40)
- BN150 Life Insurance Reportable Income
- EXI2.1 Invoke for PRTRDPD
- EXI4.1 Invoke for PRPRBPD
- LP130 Absence Plan Payout
- PR128 Offset Time Record Creation
- PR131 Retroactive Pay Calculation
- PR132 FLSA Overtime Calculation
- PR134 Automatic Time Records
- PR135 Time Record Edit
- PR136 Missing Time Records
- PR137 Batch Time Record Update
- PR189 Gross Up Calculation
- PR29.1 Pension Payment Maintenance
- PR32.1 Employee Daily Time Entry
- PR32.2 Employee Daily Time Entry
- PR33.1 Speed Entry Setup
- PR33.2 Speed Entry by Number
- PR33.3 Speed Entry by Name
- PR35.1 Time Entry
- PR35.2 Detail Time Entry
- PR35.3 Speed Time Entry
- PR35.4 Step and Grade, Grade Range Time Entry
- PR35.5 Attendance Time Entry
- PR35.6 Activity Time Entry
- PR35.8 Position Time Entry
- PR35.9 Reason Code Time Entry
- PR36.1 Time Record Entry
- PR36.4 Manual Time Record Maintenance
- PR37.1 Batch Time Control
- PR45.1 Error Processing
- PR521 Nonstandard Pay and Work Period CSV Load
- PR529 Pension Payroll Conversion
- PR530 Time Record Interface CSV
- PR560 Payroll History Load CSV
- PR582 Mass Adjustment Load
- PR80.1 Manual Check
- PR80.4 Manual Payment
- PR82.1 Adjustment
- TA147 Canada Vacation Audit
- UK102 Bonus Pay Update