Lawson Insight Technical Documentation |
|
PRBATCH
PRBATCH FILE
Payroll Time Record Batch Head
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).
REFERENCED BY
HR55.1 HR55.2 HR55.3
UPDATED BY
BN150 ET530 PR134 PR136 PR137 PR32.1
PR32.2 PR33.1 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR35.9
PR37.1 PR530
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRB-COMPANY Numeric 4 BN150 ET530
Element: Company Hr PR134 PR136
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR37.1
PR530
PRB-BATCH-NBR Numeric 6 BN150 ET530
Element: Batch Nbr Contains the batch number. Batch PR134 PR136
numbers are assigned by the system if PR32.1 PR32.2
automatic batch numbering is defined for PR33.1 PR33.2
the company on the Payroll form tab in PR33.3 PR35.1
HR00.1 (Company). PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR37.1
PR530
PRB-TR-DATE Numeric 8 (yyyymmdd) BN150 ET530
Element: Tr Date Contains the time record date. PR134 PR136
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR37.1
PR530
PRB-TOTAL-HOURS Signed 9.2 ET530 PR134
Element: Total Hours Contains the total hours the system PR136 PR32.1
uses to compare with actual hours for PR32.2 PR33.1
batch control edits. PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR37.1 PR530
PRB-TOTAL-AMOUNT Signed 13.4 ET530 PR134
Element: Total Amount Contains the total amount the system PR136 PR32.1
uses to compare with the actual amount PR32.2 PR33.1
for batch control edits. PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR37.1 PR530
PRB-ACTUAL-HOURS Signed 9.2 ET530 PR134
Element: Actual Hours Contains the total hours associated PR136 PR137
with time records included in this PR32.1 PR32.2
batch. The system updates this field PR33.1 PR33.2
when you add, change, or delete time PR33.3 PR35.1
records associated with the batch. PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR37.1
PR530
PRB-ACTUAL-AMOUNT Signed 13.4 BN150 ET530
Element: Actual Amount Contains the total amount associated PR134 PR136
with the time records included in the PR137 PR32.1
batch. The system updates this field PR32.2 PR33.1
when you add, change, or delete time PR33.2 PR33.3
records associated with the batch. PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR37.1 PR530
PRB-ATTEND-CODE Alpha 2 Occurs 5 Times ET530 PR134
Element: Attend Code Contains an attendance code associated PR136 PR32.1
with the batch. PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR37.1 PR530
PRB-PAY-CODE Alpha 4 Occurs 5 Times ET530 PR134
Element: Pay Code Contain a pay code associated with the PR136 PR32.1
batch. PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR37.1 PR530
PRB-PROCESS-LEVEL Alpha 5 ET530 PR134
Element: Process Lev HrContains the process level associated PR136 PR32.1
with the batch time record, and is used PR32.2 PR33.1
to display employees in a specific PR33.2 PR33.3
process level for speed time record PR35.1 PR35.2
entry selection in PR33.2 (Speed Entry PR35.3 PR35.4
by Number) and PR33.3 (Speed Entry by PR35.5 PR35.6
Name). PR35.8 PR35.9
PR37.1 PR530
PRB-DEPARTMENT Alpha 5 ET530 PR134
Element: Department Contains the department associated with PR136 PR32.1
the batch time record. Used to display PR32.2 PR33.1
employees in a specific department for PR33.2 PR33.3
speed time record entry selection in PR35.1 PR35.2
PR33.2 (Speed Entry by Number) and PR35.3 PR35.4
PR33.3 (Speed entry by Name). PR35.5 PR35.6
PR35.8 PR35.9
PR37.1 PR530
PRB-GROUP-NAME Alpha 10 ET530 PR134
Element: Group Name Contains the group name associated with PR136 PR32.1
the batch time record. PR33.2 (Speed PR32.2 PR33.1
Entry by Number) and PR33.3 (Speed Entry PR33.2 PR33.3
by Name) use this field to display PR35.1 PR35.2
employees associated with an employee PR35.3 PR35.4
group for speed time record entry PR35.5 PR35.6
selection. PR35.8 PR35.9
PR37.1 PR530
PRB-USER-LEVEL Alpha 10 ET530 PR134
Element: User Level Contains the user level associated with PR136 PR32.1
a batch time record. PR33.2 (Speed Entry PR32.2 PR33.1
by Number) and PR33.3 (Speed Entry by PR33.2 PR33.3
Name) use this field to display PR35.1 PR35.2
employees for speed time record entry PR35.3 PR35.4
selection. PR35.5 PR35.6
PR35.8 PR35.9
PR37.1 PR530
PRB-DELETE-FLAG Alpha 1 ET530 PR134
Element: Delete Flag Contains the value that determines if PR136 PR32.1
the setup parameters created in PR33.1 PR32.2 PR33.1
(Speed Entry Setup) are deleted when PR33.2 PR33.3
the batch is released. If the parameters PR35.1 PR35.2
are not deleted, the actual hours and PR35.3 PR35.4
amount fields are set to zero. PR35.5 PR35.6
N = No PR35.8 PR35.9
Y = Yes PR37.1 PR530
PRB-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PRB-CURR-ND Numeric 1
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
PRBATCH FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRBSET1 COMPANY BN150 ET530
BATCH-NBR HR55.1 HR55.2
HR55.3 PR134
PR136 PR137
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR33.4
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR37.1 PR530
PRBATCH FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
PRBATCH FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|