Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRGARNRULX


                            PRGARNRULX FILE

REFERENCED BY

BN66.1    PR139     PR140     PR189     PR195     PR246
PR80.1    PR89.1    PR26.1    PR47.1    PR514     UK47.1


UPDATED BY

PR46.2    UK46.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

PGX-COMPANY            Numeric 4                                 PR46.2
Element: Company Hr

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

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

PGX-SEQ-NBR            Numeric 4                                 PR46.2
Element: Seq Nbr       Sequence number for the multiple
                       variable rule records.

PGX-TAX-ID-CODE        Alpha 10                                  PR46.2
Element: Tax Id Code   Contains the federal or provincial
                       jurisdiction governing the garnishment.
                       Determines the rules that apply to a
                       specific garnishment.

PGX-CA-GRN-MARITAL     Alpha 2                                   PR46.2
Element: Ca Grn MaritalContains the value that the garnishment
                       rules apply to. Required for provinces
                       of NF, NS, QE, NW. C preceding the value
                        identifies the values as Canadian.
                       C1 = Single
                       C2 = Married
                       C3 = Married w/ spouse
                       C4 = Family
                       C5 = Widow
                       C6 = Widower
                       C7 = Divorced
                       C8 = Unmarried

PGX-BASIC-EXEMPT       Signed 7.2                                PR46.2
Element: Basic Exempt  Contains the basic amount or percent
                       that is exempted from seizure.

PGX-BASIC-CALC-TYP     Numeric 1                                 PR46.2
Element: Basic Calc TypDetermines if the value in the Basic
                       Exempt field is an amount or percent.
                       1 = Amount
                       2 = Percent

PGX-WAGE-LEVEL         Numeric 7                                 PR46.2
Element: Wage Level    Defines the starting value of a range of
                       the employee wages that an additional
                       exempt amount would be calculated on.

PGX-ADDL-EXEMPT        Signed 7.2                                PR46.2
Element: Addl Exempt   Contains the value that represents the
                       additional exempt amount or percent of
                       the employee wage that is exempt from
                       seizure.

PGX-ADDL-CALC-TYPE     Numeric 1                                 PR46.2
Element: Addl Calc TypeDetermines if the value in the Addl
                       Exempt Amount field is an amount or
                       percent.

PGX-MIN-EXEMPT         Signed 7.2                                PR46.2
Element: Min Exempt    Contains the minimum exempt amount or
                       percentage that an employee should have
                       exempted from seizure.

PGX-MIN-CALC-TYPE      Numeric 1                                 PR46.2
Element: Min Calc Type Determines if the value in the Minimum
                       Exempt field is an amount or percent.
                       1 = Amount
                       2 = Percent

PGX-MAX-EXEMPT         Signed 7.2                                PR46.2
Element: Max Exempt    Contains the maximum exempt amount or
                       percentage that an employee can have
                       exempted from seizure.

PGX-MAX-CALC-TYPE      Numeric 1                                 PR46.2
Element: Max Calc Type Determines if the value in the Maximum
                       Exempt field is an amount or percent.
                       1 = Amount
                       2 = Percent

PGX-NBR-DEPS-MIN       Numeric 2                                 PR46.2
Element: Nbr Deps Min  Contains the number of dependents used
                       in determining the minimum exempt
                       amount.

                         PRGARNRULX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PGXSET1   COMPANY                                                BN66.1  PR139
          COUNTRY-CODE                                           PR140   PR189
          TAX-ID-CODE                                            PR195   PR246
          GARN-CAT                                               PR46.2  PR80.1
          TYPE                                                   PR89.1  UK46.2
          SEQ-NBR

PGXSET3   COMPANY                                                BN66.1  PR139
          COUNTRY-CODE                                           PR140   PR189
          TAX-ID-CODE                                            PR195   PR26.1
          GARN-CAT                                               PR46.2  PR47.1
          TYPE                                                   PR514   PR80.1
          CA-GRN-MARITAL                                         PR89.1  UK47.1
          SEQ-NBR

PGXSET4   COMPANY                                                PR46.2
          COUNTRY-CODE
          TAX-ID-CODE
          GARN-CAT
          TYPE
          WAGE-LEVEL
          SEQ-NBR

PGXSET5   COMPANY                                                BN66.1  PR139
          COUNTRY-CODE                                           PR140   PR189
          TAX-ID-CODE                                            PR195   PR46.2
          GARN-CAT                                               PR80.1  PR89.1
          TYPE
          NBR-DEPS-MIN
          SEQ-NBR

                         PRGARNRULX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Prgarncat      PRGARNTYPE   Required

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

Prgarntype     PRGARNTYPE   Required

                            PGX-COUNTRY-CODE    -> GRT-COUNTRY-CODE
                            PGX-TYPE            -> GRT-TYPE

Prsystem       PRSYSTEM     Required

                            PGX-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Prtaxauth      PRTAXAUTH    Required

                            PGX-TAX-ID-CODE     -> PRX-TAX-ID-CODE