Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRGARNRULE


                            PRGARNRULE FILE

The Garnishment Rules files contains garnishment rules by governing tax
authority and category for wage formulas, disposable income, and fee
definitions.

REFERENCED BY

BN66.1    PR05.1    PR139     PR140     PR189     PR195
PR225     PR246     PR80.1    PR89.1

UPDATED BY

PR115     PR25.2    PR26.1    PR46.2    PR47.1    PR514
PR925     UK46.2    UK47.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PGR-COMPANY            Numeric 4                                 PR25.2  PR46.2
Element: Company       Contains the company number.              PR925   UK46.2

PGR-TAX-ID-CODE        Alpha 10                                  PR25.2  PR46.2
Element: Tax Id Code   Defines the state, county, or province    PR925   UK46.2
                       governing the attachment. Determines the
                       rules that apply to a type of a
                       garnishment.

                       Note: You cannot define federal rules.

PGR-GARN-CAT           Alpha 1                                   PR25.2  PR46.2
Element: Garn Cat      Identifies a group of garnishments.       PR925   UK46.2
                       Rules may be defined by category.
                       Reporting may be done by category.

                       Garnishment types are tied to
                       categories on the garnishment types
                       table.
                       A = Assignment
                       B = Bankruptcy
                       G = Garnishment
                       L = Student Loans
                       S = Support
                       T = Tax Levies

PGR-TYPE               Alpha 2                                   PR25.2  PR46.2
Element: Type          Defines a type of garnishment. Rules      PR925   UK46.2
                       are then defined for this type.

PGR-EXEM-FORM          Alpha 2                                   PR25.2  PR46.2
Element: Exem Form     Defines how exempt earnings (protected    PR925
                       income) are calculated.

PGR-RATE-X-FED-MIN     Numeric 3                                 PR25.2  PR925
Element: Rate X Fed MinThis number is multiplied by the
                       federal minimum wage to determine exempt
                       wages.

PGR-FACTOR-1           Signed 7.2                                PR25.2  PR925
Element: Factor 1      Parameter used in calculating exempt
                       wages.

PGR-FACTOR-2           Signed 7.2                                PR25.2
Element: Factor 2      Parameter used to calculate exempt
                       wages.

PGR-FACTOR-3           Signed 7.2                                PR25.2
Element: Factor 3      Parameter used to calculate exempt
                       wages.

PGR-FACTOR-4           Signed 7.2                                PR25.2
Element: Factor 4      Parameter used to calculate exempt
                       wages.

PGR-SND-FAM-YES        Signed 5.2                                PR25.2  PR925
Element: Snd Fam Yes   Contains the percent to withhold for an
                       employee with a second family.

PGR-SND-FAM-NO         Signed 5.2                                PR25.2  PR925
Element: Snd Fam No    Contains the percent to withhold for an
                       employee without a second family.

PGR-ARR-ADD-PCT        Signed 5.2                                PR25.2  PR925
Element: Arr Add Pct   Used with child support or alimony
                       garnishments and represents the
                       additional percent if outstanding
                       arrearages are more than 12 weeks old on
                       the employee record.

PGR-PCT-PER-DEP        Signed 7.2                                PR25.2
Element: Pct Per Dep   Defines the amount or percent per
                       dependent used to calculate exempt
                       earnings.

PGR-CALC-TYPE          Alpha 1                                   PR25.2
Element: Calculation TyDetermines if the value in the Per
                       Dependent field is an amount or a
                       percent.
                       A = Amount
                       P = Percent

PGR-MULT-GARN-RULE     Alpha 1                                   PR25.2  PR46.2
Element: Mult Garn RuleDefines how to distribute the amount to   PR925   UK46.2
                       be withheld when the amount is
                       insufficient and multiple orders exist
                       (for the same category) for an employee.
                       1 = Prorate Based On Farn Amount
                       2 = Equal Amount To Each Other
                       3 = Effective Date Order
                       4 = Withhold One Garn At A Time

PGR-FEES-DED-CODE      Alpha 4                                   PR25.2  PR46.2
Element: Fees Ded Code Contains the deduction code used to       UK46.2
                       track the fee amount withheld separately
                       from the order amount.

PGR-AMOUNT             Currency 15.2                             PR25.2  PR46.2
Element: Amount        Contains the amount to be charged for     UK46.2
                       this garnishment.

PGR-FREQUENCY          Alpha 1                                   PR25.2  PR46.2
Element: Frequency     Indicates when the fee will be withheld.  UK46.2
                       1 = Only When Garn Amt is Withheld
                       2 = Every Cyc Garn Should be Taken

PGR-FEES-LMT-TYPE      Alpha 2                                   PR25.2  PR46.2
Element: Fees Lmt Type Identifies which rules formula is used    UK46.2
                       in determining the fee amount.

PGR-FEES-LMT-AMT-1     Signed 7.2                                PR25.2  PR46.2
Element: Fees Lmt Amt 1Contains a limit amount or percent.       UK46.2
                       This used in calculation based on the
                       limit rule.

PGR-FEES-LMT-AMT-2     Signed 7.2                                PR25.2  PR46.2
Element: Fees Lmt Amt 2If the limit rule has two calculations,   UK46.2
                       contains the amount or percent of the
                       second part of the calculation.

PGR-FEES-1ST-TIME      Signed 7.2                                PR25.2  PR46.2
Element: Fees 1st Time Contains a fee used for the first time    UK46.2
                       garnishment is processed for an
                       employee.

PGR-GL-DIST-COMP       Numeric 4                                 PR25.2  PR46.2
Element: Gl Dist Comp  Contains the distribution company for     UK46.2
                       the accrual account on the deduction for
                       fees.

PGR-GL-ACCT-UNIT       Alpha 15                                  PR25.2  PR46.2
General Ledger         Contains the accounting unit used for     UK46.2
Accounting Unit        the accrual on the deduction for fees.

PGR-GL-ACCOUNT         Numeric 6                                 PR25.2  PR46.2
General Ledger         Contains the account for the accrual      UK46.2
Account                account on the deduction for fees.

PGR-GL-SUB-ACCT        Numeric 4                                 PR25.2  PR46.2
General Ledger         Contains the subaccount for the accrual   UK46.2
Subaccount             account used on the fee deduction.

PGR-EXCL-PAY-CODE      Alpha 4 Occurs 30 Times                   PR25.2  PR46.2
Element: Excl Pay Code Excludes certain pay in calculating the   UK46.2
                       disposable income.

PGR-EXCL-DED-CODE      Alpha 4 Occurs 30 Times                   PR25.2  PR46.2
Element: Excl Ded Code Excludes certain deductions in            UK46.2
                       calculating the disposable income.

PGR-CHANGE-FLAG        Alpha 1                                   PR115   PR25.2
Element: Change Flag   Indicates whether the fee amount is       PR46.2  UK46.2
                       changed for the garnishment rule.
                       Y = Yes

PGR-USED-FLAG          Alpha 1                                   PR25.2  PR26.1
Element: Used          This flag is updated when an employee     PR46.2  PR47.1
                       garnishment is added for this             PR514   PR925
                       garnishment rule in PR26.1  (Employee     UK46.2  UK47.1
                       Garnishment) based on the governing
                       taxing authority, category, and type.
                       Y = YEs
                       N = No

PGR-COUNTRY-CODE       Alpha 2                                   PR25.2  PR46.2
Element: Country Code  The country code.  Required for VAT and   PR925   UK46.2
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

PGR-NBR-DEPS           Numeric 2 Occurs 20 Times                 PR46.2
Element: Nbr Deps      Contains the number of dependents used
                       in the calculation of the dependent
                       exempt amount.

PGR-DEP-AMOUNT         Signed 7.2 Occurs 20 Times                PR46.2
Element: Dep Amount    Contains the amount per dependent that
                       is  exempt from seizure.

PGR-INCL-ADD-NET       Alpha 4 Occurs 10 Times                   PR46.2  UK46.2
Element: Incl Add Net  Contains the deduction code of the add
                       to net deduction(s) that should be
                       included in calculating the wages
                       available for garnishment.

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

PGR-CURR-ND            Numeric 1
Account Currency
Code

                         PRGARNRULE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PGRSET1   COMPANY                                                BN66.1  PR05.1
          COUNTRY-CODE                                           PR115   PR139
          TAX-ID-CODE                                            PR140   PR189
          GARN-CAT                                               PR195   PR225
          TYPE                                                   PR246   PR25.2
                                                                 PR26.1  PR46.2
                                                                 PR47.1  PR514
                                                                 PR80.1  PR89.1
                                                                 PR925   UK46.2
                                                                 UK47.1

PGRSET2   TYPE                                                   PR25.1  PR46.1
          COMPANY                                                UK46.1
          COUNTRY-CODE
          TAX-ID-CODE
          GARN-CAT

PGRSET3   COMPANY       Subset                                   PR115   PR140
          COUNTRY-CODE  Where CHANGE-FLAG = "Y"                  PR189   PR80.1
          TAX-ID-CODE   And   USED-FLAG   = "Y"
          GARN-CAT
          TYPE

                         PRGARNRULE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Fees Ded       DEDCODE      Required

                            PGR-COMPANY          -> DDC-COMPANY
                            PGR-FEES-DED-CODE    -> DDC-DED-CODE

Incl Add Net   DEDCODE      Required

                            PGR-COMPANY          -> DDC-COMPANY
                            PGR-INCL-ADD-NET     -> DDC-DED-CODE

Prgarncat      PRGARNTYPE   Required

                            PGR-COUNTRY-CODE     -> GRT-COUNTRY-CODE
                            PGR-GARN-CAT         -> GRT-GARN-CAT
                            PGR-TYPE             -> GRT-TYPE

Prgarntype     PRGARNTYPE   Required

                            PGR-COUNTRY-CODE     -> GRT-COUNTRY-CODE
                            PGR-TYPE             -> GRT-TYPE

Prsystem       PRSYSTEM     Required

                            PGR-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Prtaxauth      PRTAXAUTH    Required

                            PGR-TAX-ID-CODE      -> PRX-TAX-ID-CODE

                         PRGARNRULE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Prgarnrulx     PRGARNRULX   Delete Cascades

                            PGR-COMPANY          -> PGX-COMPANY
                            PGR-COUNTRY-CODE     -> PGX-COUNTRY-CODE
                            PGR-TAX-ID-CODE      -> PGX-TAX-ID-CODE
                            PGR-GARN-CAT         -> PGX-GARN-CAT
                            PGR-TYPE             -> PGX-TYPE
                                                    PGX-SEQ-NBR