PRBATCH

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).
UPDATED BY
BN150 PR521 EXI2.1 EXI4.1 LP130 LP140
PR128 PR130 PR131 PR132 PR134 PR135
PR136 PR137 PR189 PR29.1 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 PR36.1
PR37.1 PR45.1 PR529 PR530 PR560 PR582
PR80.1 PR80.4 PR82.1 UK102 UK560 TA147
HR55.1 HR55.2 HR55.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRB-COMPANY
Element: Company Hr
Numeric 4
BN150 EXI2.1
EXI4.1 LP130
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 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
PR36.1 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
PRB-BATCH-NBR
Element: 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
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 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
PR36.1 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
PRB-TR-DATE
Element: Tr Date
Numeric 8 (yyyymmdd)
Contains the time record date.
BN150 EXI2.1
EXI4.1 LP130
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 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
PR36.1 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
PRB-TOTAL-HOURS
Element: 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
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 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
PR36.1 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
PRB-TOTAL-AMOUNT
Element: 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
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 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
PR36.1 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
PRB-ACTUAL-HOURS
Element: 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
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 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
PR36.1 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
PRB-ACTUAL-AMOUNT
Element: 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
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 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
PR36.1 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
PRB-ATTEND-CODE
Element: Attend Code
Alpha 2 Occurs 5 Times
Contains an attendance code associated with the batch.
BN150 EXI2.1
EXI4.1 LP130
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 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
PR36.1 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
PRB-PAY-CODE
Element: Pay Code
Alpha 4 Occurs 5 Times
Contain a pay code associated with the batch.
BN150 EXI2.1
EXI4.1 LP130
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 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
PR36.1 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
PRB-PROCESS-LEVEL
Element: Process Lev Hr
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
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 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
PR36.1 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
PRB-DEPARTMENT
Element: 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
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 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
PR36.1 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
PRB-GROUP-NAME
Element: 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
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 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
PR36.1 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
PRB-USER-LEVEL
Element: 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
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 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
PR36.1 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
PRB-DELETE-FLAG
Element: 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
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 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
PR36.1 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
PRB-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
PRB-CURR-ND
Element: Acct Nd
Numeric 1
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
BATCH-NBR
...
BN150 HR55.1
HR55.2 HR55.3
PR521 EXI2.1
EXI4.1 LP130
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR33.4 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5


PRBATCH FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Wed Jun 08 20:51:10 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.