Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRGARNHIST


                            PRGARNHIST FILE

Contains the history for a particular garnishment (case number and file
number). It is used to link a garnishment to AP payment information. A new
record is created every time payroll is run.

Updated by PR199 (Payroll Close) and used for reporting.

REFERENCED BY

PR139     PR141     UK141     PR277     UK277     PR226
PR247

UPDATED BY

BN66.1    PR140     PR189     PR195     PR197     PR198
PR300     PR45.1    PR80.1    PR82.1    PR85.1    PR89.1
PR36.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GRH-COMPANY            Numeric 4                                 BN66.1  PR140
Element: Company       Contains the company number.              PR189   PR195
                                                                 PR80.1  PR82.1
                                                                 PR89.1

GRH-EMPLOYEE           Numeric 9                                 BN66.1  PR140
Element: Employee      Contains the employee number.             PR189   PR195
                                                                 PR80.1  PR82.1
                                                                 PR89.1

GRH-CHECK-ID           Numeric 12                                BN66.1  PR140
Internal Check ID      Contains the payment identification       PR189   PR195
Number                 number (unique payment identifier used    PR80.1  PR82.1
                       in tracking payment information).         PR85.1  PR89.1

GRH-GARN-OBJ-ID        Numeric 12                                BN66.1  PR140
Element: Garn Obj Id   Assigned when an employee garnishment     PR189   PR195
                       table (PREMPGARN) is added and            PR80.1  PR82.1
                       deductions are created. This ID links     PR89.1
                       the employee deductions to this
                       garnishment (case number/file number).
                       If the same deduction is created for
                       this employee, this ID along with the
                       sequence number keeps the record unique.

GRH-AP-COMPANY         Numeric 4                                 BN66.1  PR140
Element: Ap Company    Contains the AP company.                  PR189   PR195
                                                                 PR198   PR80.1
                                                                 PR82.1  PR89.1

GRH-VENDOR             Alpha 9  (Right Justified)                BN66.1  PR140
Element: Vendor ID     The vendor's identification code.         PR189   PR195
                                                                 PR198   PR80.1
                                                                 PR82.1  PR89.1

GRH-INVOICE            Alpha 22                                  BN66.1  PR140
Element: Invoice NumberUsed to identify the invoice.             PR189   PR195
                                                                 PR198   PR80.1
                                                                 PR82.1  PR89.1

GRH-STATUS             Numeric 1                                 BN66.1  PR140
Element: Status        Indicates the payment status.             PR189   PR195
                                                                 PR197   PR80.1
                       Records are created with a status of      PR82.1  PR85.1
                       zero and  are updated to a status of "9"  PR89.1
                       by PR199 (Payroll Close).
                       0 = Created
                       9 = Closed

GRH-DISP-INCOME        Signed 9.2                                BN66.1  PR140
Element: Disp Income   Contains the disposable income            PR189   PR195
                       calculated in PR140 (Earnings and         PR80.1  PR82.1
                       Deductions Calculations).                 PR85.1  PR89.1

GRH-WAGES-EXEMPT       Signed 9.2                                BN66.1  PR140
Element: Wages Exempt  Contains the exempt wages calculated in   PR189   PR195
                       PR140 (Earnings and Deductions            PR80.1  PR82.1
                       Calculations).                            PR85.1  PR89.1

GRH-MSG-NBR            Numeric 3 Occurs 10 Times                 BN66.1  PR140
Element: Msg Nbr       Contains a message number assigned in     PR189   PR195
                       PR140 (Earnings and Deductions            PR80.1  PR82.1
                       Calculations) for garnishment history.    PR85.1  PR89.1
                       Messages are stored in Message
                       Maintenance (msgmnt) for category PRGAR.
                       PRGARNPD and PR140 access these
                       messages.

GRH-CREATE-DATE        Numeric 8  (yyyymmdd)                     BN66.1  PR140
Element: Date          Contains the date when PR140 (Earnings    PR189   PR195
                       and Deductions Calculations) are run and  PR80.1  PR82.1
                       records are created.                      PR89.1

GRH-CREATE-TIME        Numeric 6  (hhmmss)                       BN66.1  PR140
Element: Sys Time      Contains the time when PR140 (Earnings    PR189   PR195
                       and Deductions Calculations) is run and   PR80.1  PR82.1
                       records are created.                      PR89.1

GRH-COURT-FEE          Signed 11.2                               BN66.1  PR140
Element: Court Fee                                               PR189   PR195
                                                                 PR80.1  PR89.1

GRH-COURT-ARR-FEE      Signed 11.2                               BN66.1  PR140
Element: Court Arr Fee                                           PR189   PR195
                                                                 PR80.1  PR89.1

GRH-CURRENCY-CODE      Alpha 5                                   BN66.1  PR140
Element: Currency Code This field contains the company base      PR189   PR195
                       currency code established in Company      PR80.1  PR82.1
                       (GL10.1 ).                                PR89.1

GRH-CURR-ND            Numeric 1                                 BN66.1  PR140
Account Currency                                                 PR189   PR195
Code                                                             PR80.1  PR82.1
                                                                 PR89.1

GRH-REMIT-TO-CODE      Alpha 4                                   PR198
Purchase From
Location Code

                         PRGARNHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GRHSET1   COMPANY                                                BN66.1  PR139
          EMPLOYEE                                               PR140   PR141
          CHECK-ID                                               PR189   PR195
          GARN-OBJ-ID                                            PR197   PR198
                                                                 PR300   PR36.1
                                                                 PR45.1  PR80.1
                                                                 PR82.1  PR85.1
                                                                 PR89.1  UK141

GRHSET2   COMPANY       Subset                                   PR277   UK277
          CREATE-DATE   Where STATUS = 9
          EMPLOYEE
          CHECK-ID
          GARN-OBJ-ID

GRHSET3   COMPANY                                                BN66.1  PR139
          EMPLOYEE                                               PR140   PR189
          GARN-OBJ-ID                                            PR195   PR226
          CREATE-DATE                                            PR247   PR277
          CHECK-ID                                               PR80.1  PR89.1
                                                                 UK277

                         PRGARNHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            GRH-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            GRH-COMPANY       -> EMP-COMPANY
                            GRH-EMPLOYEE      -> EMP-EMPLOYEE

Invoice        APINVOICE    Not Required
                            Valid When (GRH-INVOICE != Spaces )

                            GRH-AP-COMPANY    -> API-COMPANY
                            GRH-VENDOR        -> API-VENDOR
                            GRH-INVOICE       -> API-INVOICE
                            Zeroes            -> API-SUFFIX
                            Zeroes            -> API-CANCEL-SEQ

Paymastr       PAYMASTR     Required

                            GRH-COMPANY       -> PYM-COMPANY
                            GRH-EMPLOYEE      -> PYM-EMPLOYEE
                            GRH-CHECK-ID      -> PYM-CHECK-ID