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     PR141     PR198     PR275
PR39.3    UK141     PR115

UPDATED BY

PR197     PR26.1    PR26.2    PR47.1    PR47.2    PR82.1
PR85.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 Hr    Identifies the AP company if the          UK47.1
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PEG-EMPLOYEE           Numeric 9                                 PR26.1  PR47.1
Element: Employee      Contains the employee number. Each        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.    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     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      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   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    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     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   UK47.1
                       withholding the garnishment amount.

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

PEG-VENDOR             Alpha 9  (Right Justified)                PR26.1  PR47.1
Element: Vendor ID     Contains the vendor for AP invoices       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        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    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          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        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    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        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        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   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      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        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         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        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   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      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    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     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        UK47.1
                       number.

PEG-ARR-ORIG-BAL       Signed 13.2                               PR26.1  PR47.1
Element: Arr Orig Bal  Contains the beginning balance for the    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      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   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        UK47.1
                       number.

PEG-FEES-OVERRIDE      Alpha 1                                   PR26.1  PR47.1
Element: Fees Override Indicates whether the fees in the XXX     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       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            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      UK47.1
                       code.

PEG-EFF-DATE-ORDER     Numeric 8  (yyyymmdd)                     PR26.1  PR47.1
Element: Eff Date OrderContains the effective date of the        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    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    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    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     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    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    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     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    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     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    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     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   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                               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        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   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        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       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        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       Represents the number of decimals
Code                   defined for the currency of the object.

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

PEG-EXEMPT-ARRS-TP     Signed 7.2                                PR197   PR82.1
Element: Exempt Arrs Tp                                          PR85.1

PEG-DED-FREQ           Alpha 1
Element: Ded Freq

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

PEG-DED-ARRS-TP        Signed 7.2                                PR197   PR82.1
Element: Ded Arrs Tp                                             PR85.1

PEG-REMIT-TO-CODE      Alpha 4                                   PR26.1  PR47.1
Remit To Location      A user-defined code that represents a     UK47.1
Code                   vendor's remittance address.

                         PREMPGARN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

PEGSET2   GARN-OBJ-ID                                            PR141   PR198
                                                                 PR275   PR277
                                                                 PR39.3  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