Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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
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
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
Time Record Date     Contains 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
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
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
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
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
Attendance Code      Contains 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
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
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
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
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
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
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
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).

PRB-CURR-ND          Numeric 1
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

                         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