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     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