Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRGARNRULX


                            PRGARNRULX FILE

REFERENCED BY

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

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: Sequence NumbeSequence 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                                                PR246   PR46.2
          COUNTRY-CODE                                           UK46.2
          TAX-ID-CODE
          GARN-CAT
          TYPE
          SEQ-NBR

PGXSET2   TYPE
          COMPANY
          COUNTRY-CODE
          TAX-ID-CODE
          GARN-CAT
          SEQ-NBR

PGXSET3   COMPANY                                                PR26.1  PR46.2
          COUNTRY-CODE                                           PR47.1  UK47.1
          TAX-ID-CODE
          GARN-CAT
          TYPE
          CA-GRN-MARITAL
          SEQ-NBR

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

PGXSET5   COMPANY                                                PR46.2
          COUNTRY-CODE
          TAX-ID-CODE
          GARN-CAT
          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