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.

Field / column	Type	Description & values	Updated by
`PRB-COMPANY` PK COMPANY	Numeric 4	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`PRB-BATCH-NBR` PK BATCH_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-DATE` TR_DATE	Numeric 8 (yyyymmdd)	Contains the time record date.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`PRB-TOTAL-HOURS` TOTAL_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-AMOUNT` TOTAL_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-HOURS` ACTUAL_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-AMOUNT` ACTUAL_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-CODE` ATTEND_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-CODE` PAY_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-LEVEL` PROCESS_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-DEPARTMENT` DEPARTMENT	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-NAME` GROUP_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-LEVEL` USER_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-FLAG` DELETE_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. `N` No `Y` Yes	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`PRB-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	—
`PRB-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	—

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PRBSET1`	`COMPANY`, `BATCH-NBR`	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	`PRB-COMPANY` → `ATC-COMPANY`, `PRB-ATTEND-CODE` → `ATC-ATTEND-CODE`
Company	PRSYSTEM	Required		`PRB-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Department	DEPTCODE	Required	When PRB-DEPARTMENT != Spaces	`PRB-COMPANY` → `DPT-COMPANY`, `PRB-PROCESS-LEVEL` → `DPT-PROCESS-LEVEL`, `PRB-DEPARTMENT` → `DPT-DEPARTMENT`
Emp Group	PERSGROUP	Required	When PRB-GROUP-NAME != Spaces	`PRB-COMPANY` → `PRG-COMPANY`, `PRB-GROUP-NAME` → `PRG-GROUP-NAME`
Process Level	PRSYSTEM	Required	When PRB-PROCESS-LEVEL != Spaces	`PRB-COMPANY` → `PRS-COMPANY`, `PRB-PROCESS-LEVEL` → `PRS-PROCESS-LEVEL`
User Level	PCODES	Required	When PRB-USER-LEVEL != Spaces	`"UL"` → `PCO-TYPE`, `PRB-USER-LEVEL` → `PCO-CODE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Timerecords	TIMERECORD	Delete Cascades		`PRB-COMPANY` → `TRD-COMPANY`, `PRB-BATCH-NBR` → `TRD-BATCH-NBR`, → `TRD-EMPLOYEE`, → `TRD-WRK-END-DATE`, → `TRD-PAY-CODE`, → `TRD-JOB-CODE`, → `TRD-TR-DATE`, → `TRD-TIME-SEQ`

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

Referenced by (3)

HR55.1 Employee Group Definition
HR55.2 Employee Groups By Employees
HR55.3 Employee Groups By Criteria