Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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     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    PR37.1    PR530

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PRB-COMPANY            Numeric 4                                 BN150   PR134
Element: Company       The company number represents an          PR136   PR32.1
                       established company and is entered on     PR32.2  PR33.1
                       all function codes.                       PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR37.1
                                                                 PR530

PRB-BATCH-NBR          Numeric 6                                 BN150   PR134
Element: Batch Number  Contains the batch number. Batch          PR136   PR32.1
                       numbers are assigned by the system if     PR32.2  PR33.1
                       automatic batch numbering is defined for  PR33.2  PR33.3
                       the company on the Payroll form tab in    PR35.1  PR35.2
                       HR00.1 (Company).                         PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR37.1
                                                                 PR530

PRB-TR-DATE            Numeric 8  (yyyymmdd)                     BN150   PR134
Element: Time Record DaContains the time record date.            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  PR37.1
                                                                 PR530

PRB-TOTAL-HOURS        Signed 9.2                                PR134   PR136
Element: Total Hours   Contains the total hours the system       PR32.1  PR32.2
                       uses to compare with actual hours for     PR33.1  PR33.2
                       batch control edits.                      PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR37.1  PR530

PRB-TOTAL-AMOUNT       Signed 13.4                               PR134   PR136
Element: Total Amount  Contains the total amount the system      PR32.1  PR32.2
                       uses to compare with the actual amount    PR33.1  PR33.2
                       for batch control edits.                  PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR37.1  PR530

PRB-ACTUAL-HOURS       Signed 9.2                                PR134   PR136
Element: Actual Hours  Contains the total hours associated       PR137   PR32.1
                       with time records included in this        PR32.2  PR33.1
                       batch. The system updates this field      PR33.2  PR33.3
                       when you add, change, or delete time      PR35.1  PR35.2
                       records associated with the batch.        PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR37.1
                                                                 PR530

PRB-ACTUAL-AMOUNT      Signed 13.4                               BN150   PR134
Element: Actual Amount Contains the total amount associated      PR136   PR137
                       with the time records included in the     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
                                                                 PR37.1  PR530

PRB-ATTEND-CODE        Alpha 2 Occurs 5 Times                    PR134   PR136
Element: Attendance CodContains an attendance code associated    PR32.1  PR32.2
                       with the batch.                           PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR37.1  PR530

PRB-PAY-CODE           Alpha 4 Occurs 5 Times                    PR134   PR136
Element: Payment Code  Contain a pay code associated with the    PR32.1  PR32.2
                       batch.                                    PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR37.1  PR530

PRB-PROCESS-LEVEL      Alpha 5                                   PR134   PR136
Element: Process Level Contains the process level associated     PR32.1  PR32.2
                       with the batch time record, and is used   PR33.1  PR33.2
                       to display employees in a specific        PR33.3  PR35.1
                       process level for speed time record       PR35.2  PR35.3
                       entry selection in PR33.2 (Speed Entry    PR35.4  PR35.5
                       by Number) and PR33.3 (Speed Entry by     PR35.6  PR35.8
                       Name).                                    PR37.1  PR530

PRB-DEPARTMENT         Alpha 5                                   PR134   PR136
Element: Department    Contains the department associated with   PR32.1  PR32.2
                       the batch time record. Used to display    PR33.1  PR33.2
                       employees in a specific department for    PR33.3  PR35.1
                       speed time record entry selection in      PR35.2  PR35.3
                       PR33.2 (Speed Entry by Number) and        PR35.4  PR35.5
                       PR33.3 (Speed entry by Name).             PR35.6  PR35.8
                                                                 PR37.1  PR530

PRB-GROUP-NAME         Alpha 10                                  PR134   PR136
Element: Group Name    Contains the group name associated with   PR32.1  PR32.2
                       the batch time record. PR33.2 (Speed      PR33.1  PR33.2
                       Entry by Number) and PR33.3 (Speed Entry  PR33.3  PR35.1
                       by Name) use this field to display        PR35.2  PR35.3
                       employees associated with an employee     PR35.4  PR35.5
                       group for speed time record entry         PR35.6  PR35.8
                       selection.                                PR37.1  PR530

PRB-USER-LEVEL         Alpha 10                                  PR134   PR136
Element: User Level    Contains the user level associated with   PR32.1  PR32.2
                       a batch time record. PR33.2 (Speed Entry  PR33.1  PR33.2
                       by Number) and PR33.3 (Speed Entry by     PR33.3  PR35.1
                       Name) use this field to display           PR35.2  PR35.3
                       employees for speed time record entry     PR35.4  PR35.5
                       selection.                                PR35.6  PR35.8
                                                                 PR37.1  PR530

PRB-DELETE-FLAG        Alpha 1                                   PR134   PR136
Element: Delete Flag   Contains the value that determines if     PR32.1  PR32.2
                       the setup parameters created in PR33.1    PR33.1  PR33.2
                       (Speed  Entry Setup) are deleted when     PR33.3  PR35.1
                       the batch is released. If the parameters  PR35.2  PR35.3
                       are not deleted, the actual hours and     PR35.4  PR35.5
                       amount fields are set to zero.            PR35.6  PR35.8
                       N = No                                    PR37.1  PR530
                       Y = Yes

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
Account Currency
Code

                         PRBATCH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRBSET1   COMPANY                                                BN150   HR55.1
          BATCH-NBR                                              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
                                                                 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