Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PREMPGARN


                             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     UK145
UK201     UK202     UK277     UK560     PR139     PR141
PR198     PR275     PR39.3    UK141     PR115

UPDATED BY

AC542     BN66.1    PR140     PR189     PR195     PR197
PR26.1    PR26.2    PR47.1    PR47.2    PR514     PR80.1
PR82.1    PR85.1    PR89.1    UK47.1    UK47.2    HR11.1
PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

PEG-EMPLOYEE           Numeric 9                                 PR26.1  PR47.1
Element: Employee      Contains the employee number. Each        PR514   UK47.1
                       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
Element: Case Number   Identifies the particular garnishment.    PR514   UK47.1
                       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
Element: File Number   Used with the case number to identify     PR514   UK47.1
                       the garnishment. Used to break out
                       different orders with same case number.

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

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

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

PEG-GARN-OBJ-ID        Numeric 12                                PR26.1  PR47.1
Element: Garn Obj Id   Assigned when an employee garnishment     PR514   UK47.1
                       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
Element: Deduction CodeDefines which deduction will be used in   PR514   UK47.1
                       withholding the garnishment amount.

PEG-SEQ-NBR            Numeric 4                                 PR26.1  PR47.1
Element: Sequence NumbeAn automatically assigned sequence        PR514   UK47.1
                       number.

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

PEG-ORIG-BALANCE       Signed 13.2                               PR26.1  PR47.1
Element: Orig Balance  Contains the beginning balance for        PR514   UK47.1
                       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
Element: Exem Form     Defines how exempt earnings (protected    PR514   UK47.1
                       income) is calculated. If entered, this
                       overrides the rules table.

PEG-RATE-X-FED-MIN     Numeric 3                                 PR26.1  PR47.1
Element: Rate X Fed MinThis number is multiplied by the          PR514   UK47.1
                       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
Element: Factor 1      Parameter used to calculate exempt        PR514   UK47.1
                       wages. If entered, this number overrides
                       the rules table.

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

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

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

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

PEG-SND-FAM-NO         Signed 5.2                                PR26.1  PR47.1
Element: Snd Fam No    Contains the percent deducted if the      PR514   UK47.1
                       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
Element: Arr Add Pct   Contains the additional percent if        PR514   UK47.1
                       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
Element: Pct Per Dep   Defines the amount or percent per         PR514   UK47.1
                       dependent used to calculate exempt
                       earnings. If entered, this number
                       overrides the rules table.

PEG-CALC-TYPE          Alpha 1                                   PR26.1  PR47.1
Element: Calculation TyDetermines if the value in the Per        PR514   UK47.1
                       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
Element: Num Of Dep    Contains the number of dependents. This   PR514   UK47.1
                       can be used to calculate the wage
                       exception rule.

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

PEG-HEAD-OF-FAM        Alpha 1                                   PR26.1  PR47.1
Element: Head Of Fam   Indicates whether employee is the head    PR514   UK47.1
                       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
Element: Arr Ded Code  Contains the deduction code that will     PR514   UK47.1
                       be used to track arrears withheld for
                       this order.

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

PEG-ARR-ORIG-BAL       Signed 13.2                               PR26.1  PR47.1
Element: Arr Orig Bal  Contains the beginning balance for the    PR514   UK47.1
                       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
Element: Over 12 Weeks Indicates whether the arrears are in      PR514   UK47.1
                       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
Element: Fees Ded Code Displays the deduction description from   PR514   UK47.1
                       the DEDCODE file for the fees deduction
                       if entered on Garnishment Rules.

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

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

PEG-EXCL-PAY-CODE      Alpha 4 Occurs 30 Times                   PR26.1  PR47.1
Element: Excl Pay Code Excludes certain pay in calculating       PR514   UK47.1
                       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
Element: Excl Ded Code Excludes certain deductions in            PR514   UK47.1
                       calculating disposable income. If
                       anything is entered, it will override
                       the rules table.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PEG-CA-OVR-MARITAL     Alpha 2                                   PR26.1  PR47.1
Element: Ca Ovr MaritalC1 = Single                               PR514   UK47.1
                       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
Element: Dep Calc Type Contains the value that determines        PR514   UK47.1
                       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
Element: Court Fee     Contains the value which determines the   PR514   UK47.1
                       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
Element: Crt Calc Type Contains the value that determines        PR514   UK47.1
                       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
Element: Court Arr Fee Contains the value to determine the       PR514   UK47.1
                       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
Element: Arr Calc Type Contains the value that determines        PR514   UK47.1
                       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
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

PEG-CURR-ND            Numeric 1
Account Currency
Code

PEG-EXEMPT-ARRS-TD     Signed 7.2                                AC542   PR195
Element: Exempt Arrs Td                                          PR197   PR26.1
                                                                 PR47.1  PR514
                                                                 PR82.1  PR85.1
                                                                 UK47.1

PEG-EXEMPT-ARRS-TP     Signed 7.2                                AC542   BN66.1
Element: Exempt Arrs Tp                                          PR140   PR189
                                                                 PR195   PR197
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1

PEG-DED-FREQ           Alpha 1
Element: Ded Freq

PEG-DED-ARRS-TD        Signed 7.2                                AC542   PR195
Element: Ded Arrs Td                                             PR197   PR26.1
                                                                 PR47.1  PR514
                                                                 PR82.1  PR85.1
                                                                 UK47.1

PEG-DED-ARRS-TP        Signed 7.2                                AC542   BN66.1
Element: Ded Arrs Tp                                             PR140   PR189
                                                                 PR195   PR197
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1

PEG-REMIT-TO-CODE      Alpha 4                                   PR26.1  PR47.1
Purchase From                                                    PR514   UK47.1
Location Code

                         PREMPGARN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PEGSET1   COMPANY                                                AC542   HR11.1
          EMPLOYEE                                               PA115   PR05.1
          CASE-NUMBER                                            PR195   PR197
          FILE-NUMBER                                            PR226   PR247
                                                                 PR26.1  PR26.2
                                                                 PR277   PR47.1
                                                                 PR47.2  PR514
                                                                 PR560   PR82.1
                                                                 PR85.1  UK145
                                                                 UK201   UK202
                                                                 UK277   UK47.1
                                                                 UK47.2  UK560

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

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