Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PREMPGARN FILE

Used to store information to identify a particular garnishment per employee
per company. Information in this file is used to determine the priority,
calculation, limits, balances, and fees for this garnishment, as well as
information to be passed to AP for paying the garnishment and printing the
check stub.

REFERENCED BY

PR05.1    PR226     PR247     PR277     PR560     BN66.1
PR139     PR140     PR141     PR189     PR195     PR198
PR275     PR39.3    PR80.1    PR89.1    PR115

UPDATED BY

PR26.1    PR26.2    PR47.1    PR47.2    PR514

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PEG-COMPANY          Numeric 4                                   PR26.1  PR47.1
Company              The company number represents an            PR514
                     established company and is entered on
                     all function codes.


PEG-EMPLOYEE         Numeric 9                                   PR26.1  PR47.1
Employee             Contains the employee number. Each          PR514
                     person employed by the company is
                     assigned a unique number. The system
                     uses the employee number to correlate
                     all of the information related to that
                     person.


PEG-CASE-NUMBER      Alpha 20                                    PR26.1  PR47.1
Case Number          Identifies the particular garnishment.      PR514
                     A unique ID is required for each
                     garnishment. (For example, case number
                     in child support case, social security
                     number for the IRS.)

PEG-FILE-NUMBER      Alpha 15                                    PR26.1  PR47.1
File Number          Used with the case number to identify       PR514
                     the garnishment. Used to break out
                     different orders with same case number.

PEG-DESC             Alpha 30  (Lower Case)                      PR26.1  PR47.1
Description          Contains a detail description of the        PR514
                     garnishment. Used in reporting.

PEG-TAX-ID-CODE      Alpha 10                                    PR26.1  PR47.1
Tax Id Code          Contains the state, county, or province     PR514
                     that governs the attachment. Determines
                     the rules that apply to this
                     garnishment.

PEG-TYPE             Alpha 2                                     PR26.1  PR47.1
Type                 Defines the garnishment and determines      PR514
                     which set of rules apply from the
                     Garnishment table.

PEG-GARN-OBJ-ID      Numeric 12                                  PR26.1  PR47.1
Garn Obj Id          Assigned when an employee garnishment       PR514
                     table (PREMPGARN) is added and
                     deductions are created. This ID links
                     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.

PEG-DED-CODE         Alpha 4                                     PR26.1  PR47.1
Deduction Code       Defines which deduction will be used in     PR514
                     withholding the garnishment amount.

PEG-SEQ-NBR          Numeric 4                                   PR26.1  PR47.1
Sequence Number      An automatically assigned sequence          PR514
                     number.

PEG-VENDOR           Alpha 9  (Right Justified)                  PR26.1  PR47.1
Vendor ID            Contains the vendor for AP invoices         PR514
                     created for the amount to be withheld.

PEG-ORIG-BALANCE     Signed 13.2                                 PR26.1  PR47.1
Orig Balance         Contains the beginning balance for          PR514
                     garnishments that are for a total amount
                     to be paid in installments. This is the
                     maximum amount that can be deducted.

PEG-EXEM-FORM        Alpha 2                                     PR26.1  PR47.1
Exem Form            Defines how exempt earnings (protected      PR514
                     income) is calculated. If entered, this
                     overrides the rules table.

PEG-RATE-X-FED-MIN   Numeric 3                                   PR26.1  PR47.1
Rate X Fed Min       This number is multiplied by the            PR514
                     federal minimum wage to determine exempt
                     wages. If entered, this number overrides
                     the rules table.

PEG-FACTOR-1         Signed 7.2                                  PR26.1  PR47.1
Factor 1             Parameter used to calculate exempt          PR514
                     wages. If entered, this number overrides
                     the rules table.

PEG-FACTOR-2         Signed 7.2                                  PR26.1  PR47.1
Factor 2             Parameter used to calculate the exempt      PR514
                     wages. If entered, this number overrides
                     the rules table.

PEG-FACTOR-3         Signed 7.2                                  PR26.1  PR47.1
Factor 3             Parameter used to calculate exempt          PR514
                     wages. If entered, this number overrides
                     the rules table.

PEG-FACTOR-4         Signed 7.2                                  PR26.1  PR47.1
Factor 4             Parameter used to calculate exempt          PR514
                     wages. If entered, this number overrides
                     the rules table.

PEG-SND-FAM-YES      Signed 5.2                                  PR26.1  PR47.1
Snd Fam Yes          Contains the percent to be deducted for     PR514
                     employee with a second family. If
                     entered, this number  overrides the
                     rules table.

PEG-SND-FAM-NO       Signed 5.2                                  PR26.1  PR47.1
Snd Fam No           Contains the percent deducted if the        PR514
                     employee does not have a second family.
                     If entered, this number overrides the
                     rules table.

PEG-ARR-ADD-PCT      Signed 5.2                                  PR26.1  PR47.1
Arr Add Pct          Contains the additional percent if          PR514
                     outstanding arrears are more than 12
                     weeks old. This is used with child
                     support or alimony garnishments. If
                     entered, this number overrides the rules
                     table.

PEG-PCT-PER-DEP      Signed 7.2                                  PR26.1  PR47.1
Pct Per Dep          Defines the amount or percent per           PR514
                     dependent used to calculate exempt
                     earnings. If entered, this number
                     overrides the rules table.

PEG-CALC-TYPE        Alpha 1                                     PR26.1  PR47.1
Calculation Type     Determines if the value in the Per          PR514
                     Dependent field is an amount or a
                     percent. If entered, this value
                     overrides the rules table.
                     A = Amount
                     P = Percent

PEG-NUM-OF-DEP       Numeric 2                                   PR26.1  PR47.1
Num Of Dep           Contains the number of dependents. This     PR514
                     can be used to calculate the wage
                     exception rule.

PEG-SND-FAMILY       Alpha 1                                     PR26.1  PR47.1
Snd Family           Indicates whether the employee has a        PR514
                     second family. This can be used to
                     calculate the wage exemption rule.

PEG-HEAD-OF-FAM      Alpha 1                                     PR26.1  PR47.1
Head Of Fam          Indicates whether employee is the head      PR514
                     of the family. This can be used to
                     calculate the wage exemption rule.
                     Y = Yes
                     N = No

PEG-ARR-DED-CODE     Alpha 4                                     PR26.1  PR47.1
Arr Ded Code         Contains the deduction code that will       PR514
                     be used to track arrears withheld for
                     this order.

PEG-ARR-SEQ-NBR      Numeric 4                                   PR26.1  PR47.1
Arr Seq Nbr          An automatically assigned sequence          PR514
                     number.

PEG-ARR-ORIG-BAL     Signed 13.2                                 PR26.1  PR47.1
Arr Orig Bal         Contains the beginning balance for the      PR514
                     arrears that are for a total given
                     amount to be paid in installments. This
                     is the maximum amount that can be
                     deducted.

PEG-OVER-12-WEEKS    Alpha 1                                     PR26.1  PR47.1
Over 12 Weeks        Indicates whether the arrears are in        PR514
                     arrears more than 12 weeks. If so, a
                     different formula is used.

                     This is used in calculating the exempt
                     wage formula.
                     Y = Yes
                     N = No

PEG-FEES-DED-CODE    Alpha 4                                     PR26.1  PR47.1
Fees Ded Code        Displays the deduction description from     PR514
                     the DEDCODE file for the fees deduction
                     if entered on Garnishment Rules.

PEG-FEES-SEQ-NBR     Numeric 4                                   PR26.1  PR47.1
Fees Seq Nbr         An automatically assigned sequence          PR514
                     number.

PEG-FEES-OVERRIDE    Alpha 1                                     PR26.1  PR47.1
Fees Override        Indicates whether the fees in the XXX       PR514
                     field override the Rules table.

PEG-EXCL-PAY-CODE    Alpha 4 Occurs 30 Times                     PR26.1  PR47.1
Excl Pay Code        Excludes certain pay in calculating         PR514
                     disposable income. If anything is
                     entered, it will override the rules
                     table.

PEG-EXCL-DED-CODE    Alpha 4 Occurs 30 Times                     PR26.1  PR47.1
Excl Ded Code        Excludes certain deductions in              PR514
                     calculating disposable income. If
                     anything is entered, it will override
                     the rules table.

PEG-COUNTRY-CODE     Alpha 2                                     PR26.1  PR47.1
Country Code         Distinguishes the records by country        PR514
                     code.

PEG-EFF-DATE-ORDER   Numeric 8  (yyyymmdd)                       PR26.1  PR47.1
Eff Date Order       Contains the effective date of the          PR514
                     order. Used as an informational field
                     for the user.

PEG-TAX-DED-ORDER    Alpha 1                                     PR26.1  PR47.1
Tax Ded Order        Defines whether or not the order is to      PR514
                     be a tax deductible order. Used to
                     validate tax  status on deduction code.

PEG-CA-GRN-MARITAL   Alpha 2                                     PR26.1  PR47.1
Ca Grn Marital       Contains the Canadian marital statuses      PR514
                     for purpose of calculating wages exempt
                     from seizure.

PEG-BASIC-EXEMPT     Signed 7.2                                  PR26.1  PR47.1
Basic Exempt         Contains the value that represents the      PR514
                     basic exempt amount or percent of the
                     employee wages that is exempt from
                     seizure.

PEG-BASIC-CALC-TYP   Numeric 1                                   PR26.1  PR47.1
Basic Calc Typ       Contains the value that determines if       PR514
                     the basic exempt factor is a percent or
                     amount.

PEG-WAGE-LEVEL       Numeric 7                                   PR26.1  PR47.1
Wage Level           Contains the starting value of a range      PR514
                     of the employee wages that an
                     additional exempt amount is calculated
                     on.

PEG-ADDL-EXEMPT      Signed 7.2                                  PR26.1  PR47.1
Addl Exempt          Contains the value that represents the      PR514
                     additional exempt amount or percent of
                     the employee wages that is exempt from
                     seizure.

PEG-ADDL-CALC-TYPE   Numeric 1                                   PR26.1  PR47.1
Addl Calc Type       Contains the value that determines if       PR514
                     the additional exempt factor is a
                     percent or amount.

PEG-MIN-EXEMPT       Signed 7.2                                  PR26.1  PR47.1
Min Exempt           Contains the value that represents the      PR514
                     minimum exempt amount or percent of the
                     employee wages that is exempt from
                     seizure.

PEG-MIN-CALC-TYPE    Numeric 1                                   PR26.1  PR47.1
Min Calc Type        Contains the value that determines if       PR514
                     the minimum exempt factor is a percent
                     or amount.

PEG-MAX-EXEMPT       Signed 7.2                                  PR26.1  PR47.1
Max Exempt           Contains the value that represents the      PR514
                     maximum exempt amount or percent of the
                     employee wages that is exempt from
                     seizure.

PEG-MAX-CALC-TYPE    Numeric 1                                   PR26.1  PR47.1
Max Calc Type        Contains the value that determines if       PR514
                     the maximum exempt factor is a percent
                     or amount.

PEG-INCL-ADD-NET     Alpha 4 Occurs 10 Times                     PR26.1  PR47.1
Incl Add Net         Contains the deduction code for the add     PR514
                     to net deductions that should be
                     included in calculating the wages
                     available for garnishment.

PEG-CA-OVR-MARITAL   Alpha 2                                     PR26.1  PR47.1
Ca Ovr Marital       C1 = Single                                 PR514
                     C2 = Married
                     C3 = Married w/spouse
                     C4 = Family
                     C5 = Widow
                     C6 = Widower
                     C7 = Divorced
                     C8 = Unmarried

PEG-DEP-CALC-TYPE    Numeric 1                                   PR26.1  PR47.1
Dep Calc Type        Contains the value that determines          PR514
                     whether the value in PEG-DEP-AMOUNT is
                     an amount or percent.
                     1 = Amount
                     2 = Percent

PEG-COURT-FEE        Signed 11.2                                 PR26.1  PR47.1
Court Fee            Contains the value which determines the     PR514
                     amount  that should be deducted from the
                     employee for a court ordered fee. This
                     amount is added to the garnishment
                     deduction amount and is remitted to the
                     court. This fee is court ordered vs an
                     employer fee deducted to cover the
                     administrative costs.

PEG-CRT-CALC-TYPE    Numeric 1                                   PR26.1  PR47.1
Crt Calc Type        Contains the value that determines          PR514
                     whether the value in PEG-COURT-FEE is an
                     amount or percent and whether it is a
                     continuous or one time fee.
                     1 = Continuous Flat Amount
                     2 = Continuous Percent of Garn Ded
                     3 = One Time Flat Amount
                     4 = One Time Percent of Garn Ded

PEG-COURT-ARR-FEE    Signed 11.2                                 PR26.1  PR47.1
Court Arr Fee        Contains the value to determine the         PR514
                     amount  that should be deducted from the
                     employee for an arrears court ordered
                     fee. This amount is added to the arrears
                     deduction amount and is remitted to the
                     court. This fee is court ordered vs an
                     employer fee deducted to cover the
                     administrative costs.

PEG-ARR-CALC-TYPE    Numeric 1                                   PR26.1  PR47.1
Arr Calc Type        Contains the value that determines          PR514
                     whether the value in PEG-COURT-ARR-FEE
                     is an amount or percent and whether it
                     is a continuous or one time fee.
                     1 = Continuous Flat Amount
                     2 = Continuous Pct of Arr Ded
                     3 = One Time Flat Amount
                     4 = One Time Pct of Arr Deduction

PEG-CURRENCY-CODE    Alpha 5
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).


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

                         PREMPGARN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PEGSET1   COMPANY                                                PR05.1  PR226
          EMPLOYEE                                               PR247   PR26.1
          CASE-NUMBER                                            PR26.2  PR277
          FILE-NUMBER                                            PR47.1  PR47.2
                                                                 PR514   PR560

PEGSET2   GARN-OBJ-ID                                            BN66.1  PR139
                                                                 PR140   PR141
                                                                 PR189   PR195
                                                                 PR198   PR275
                                                                 PR277   PR39.3
                                                                 PR80.1  PR89.1

PEGSET4   COMPANY                                                PR115
          TAX-ID-CODE
          EMPLOYEE
          GARN-OBJ-ID

                         PREMPGARN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arr Ded        DEDCODE      Required

                            PEG-COMPANY          -> DDC-COMPANY
                            PEG-ARR-DED-CODE     -> DDC-DED-CODE

Arr Emded      EMDEDMASTR   Required

                            PEG-COMPANY          -> EDM-COMPANY
                            PEG-EMPLOYEE         -> EDM-EMPLOYEE
                            PEG-ARR-DED-CODE     -> EDM-DED-CODE
                            PEG-ARR-SEQ-NBR      -> EDM-SEQ-NBR

Employee       EMPLOYEE     Required

                            PEG-COMPANY          -> EMP-COMPANY
                            PEG-EMPLOYEE         -> EMP-EMPLOYEE

Fees Ded       DEDCODE      Required

                            PEG-COMPANY          -> DDC-COMPANY
                            PEG-FEES-DED-CODE    -> DDC-DED-CODE

Fees Emded     EMDEDMASTR   Required

                            PEG-COMPANY          -> EDM-COMPANY
                            PEG-EMPLOYEE         -> EDM-EMPLOYEE
                            PEG-FEES-DED-CODE    -> EDM-DED-CODE
                            PEG-FEES-SEQ-NBR     -> EDM-SEQ-NBR

Garn Ded       DEDCODE      Required

                            PEG-COMPANY          -> DDC-COMPANY
                            PEG-DED-CODE         -> DDC-DED-CODE

Garn Emded     EMDEDMASTR   Required

                            PEG-COMPANY          -> EDM-COMPANY
                            PEG-EMPLOYEE         -> EDM-EMPLOYEE
                            PEG-DED-CODE         -> EDM-DED-CODE
                            PEG-SEQ-NBR          -> EDM-SEQ-NBR

Garn Rule      PRGARNRULE   Required

                            PEG-COMPANY          -> PGR-COMPANY
                            PEG-COUNTRY-CODE     -> PGR-COUNTRY-CODE
                            PEG-TAX-ID-CODE      -> PGR-TAX-ID-CODE
                            GRT-GARN-CAT         -> PGR-GARN-CAT
                            PEG-TYPE             -> PGR-TYPE

Prgarntype     PRGARNTYPE   Required

                            PEG-COUNTRY-CODE     -> GRT-COUNTRY-CODE
                            PEG-TYPE             -> GRT-TYPE

Prsystem       PRSYSTEM     Required

                            PEG-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Prtaxauth      PRTAXAUTH    Required

                            PEG-TAX-ID-CODE      -> PRX-TAX-ID-CODE

                         PREMPGARN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Emp Garn Hist  PRGARNHIST

                            PEG-COMPANY          -> GRH-COMPANY
                            PEG-EMPLOYEE         -> GRH-EMPLOYEE
                            PEG-GARN-OBJ-ID      -> GRH-GARN-OBJ-ID
                                                    GRH-CREATE-DATE
                                                    GRH-CHECK-ID