PRGARNRULX – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
PGX
Primary key
COMPANY, COUNTRY-CODE, TAX-ID-CODE, GARN-CAT, TYPE, SEQ-NBR
Fields
17
Updated by
1 program
Referenced by
13 programs

PRGARNRULX is a Lawson Payroll table (prefix PGX); no description in the lawson data dictionary. It is indexed by COMPANY, COUNTRY-CODE, TAX-ID-CODE, GARN-CAT, TYPE, SEQ-NBR (PGXSET1); alternate indexes: PGXSET3, PGXSET4 and PGXSET5. It is related 1:1 to PRGARNTYPE, PRSYSTEM and PRTAXAUTH. It is updated by PR46.2 and referenced by BN66.1, PR139, PR140, PR189, PR195, PR246, PR26.1, PR47.1 and 5 more. The table has 17 fields, 4 indexes and 4 documented relations.

About PRGARNRULX

No description in the Lawson data dictionary.

Fields (17)

Column = COBOL field name without the PGX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PGX-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).PR46.2
#PGX-COMPANY PK
COMPANY		Numeric 4—PR46.2
#PGX-GARN-CAT PK
GARN_CAT		Alpha 1Identifies a group of garnishments. Rules may be defined by category. Reporting may be done by category.PR46.2
#PGX-TYPE PK
TYPE		Alpha 2Defines a type of garnishment. Rules are then defined for this type.PR46.2
#PGX-SEQ-NBR PK
SEQ_NBR		Numeric 4Sequence number for the multiple variable rule records.PR46.2
#PGX-TAX-ID-CODE PK
TAX_ID_CODE		Alpha 10Contains the federal or provincial jurisdiction governing the garnishment. Determines the rules that apply to a specific garnishment.PR46.2
#PGX-CA-GRN-MARITAL SET3
CA_GRN_MARITAL		Alpha 2Contains 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
PR46.2
#PGX-BASIC-EXEMPT
BASIC_EXEMPT		Signed 7.2Contains the basic amount or percent that is exempted from seizure.PR46.2
#PGX-BASIC-CALC-TYP
BASIC_CALC_TYP		Numeric 1Determines if the value in the Basic Exempt field is an amount or percent.
  • 1 Amount
  • 2 Percent
PR46.2
#PGX-WAGE-LEVEL SET4
WAGE_LEVEL		Numeric 7Defines the starting value of a range of the employee wages that an additional exempt amount would be calculated on.PR46.2
#PGX-ADDL-EXEMPT
ADDL_EXEMPT		Signed 7.2Contains the value that represents the additional exempt amount or percent of the employee wage that is exempt from seizure.PR46.2
#PGX-ADDL-CALC-TYPE
ADDL_CALC_TYPE		Numeric 1Determines if the value in the Addl Exempt Amount field is an amount or percent.PR46.2
#PGX-MIN-EXEMPT
MIN_EXEMPT		Signed 7.2Contains the minimum exempt amount or percentage that an employee should have exempted from seizure.PR46.2
#PGX-MIN-CALC-TYPE
MIN_CALC_TYPE		Numeric 1Determines if the value in the Minimum Exempt field is an amount or percent.
  • 1 Amount
  • 2 Percent
PR46.2
#PGX-MAX-EXEMPT
MAX_EXEMPT		Signed 7.2Contains the maximum exempt amount or percentage that an employee can have exempted from seizure.PR46.2
#PGX-MAX-CALC-TYPE
MAX_CALC_TYPE		Numeric 1Determines if the value in the Maximum Exempt field is an amount or percent.
  • 1 Amount
  • 2 Percent
PR46.2
#PGX-NBR-DEPS-MIN SET5
NBR_DEPS_MIN		Numeric 2Contains the number of dependents used in determining the minimum exempt amount.PR46.2

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PGXSET1
  1. COMPANY
  2. COUNTRY-CODE
  3. TAX-ID-CODE
  4. GARN-CAT
  5. TYPE
  6. SEQ-NBR
PrimaryBN66.1, PR139, PR140, PR189, PR195, PR246, PR46.2, PR80.1 +3 more
PGXSET3
  1. COMPANY
  2. COUNTRY-CODE
  3. TAX-ID-CODE
  4. GARN-CAT
  5. TYPE
  6. CA-GRN-MARITAL
  7. SEQ-NBR
BN66.1, PR139, PR140, PR189, PR195, PR26.1, PR46.2, PR47.1 +5 more
PGXSET4
  1. COMPANY
  2. COUNTRY-CODE
  3. TAX-ID-CODE
  4. GARN-CAT
  5. TYPE
  6. WAGE-LEVEL
  7. SEQ-NBR
PR46.2
PGXSET5
  1. COMPANY
  2. COUNTRY-CODE
  3. TAX-ID-CODE
  4. GARN-CAT
  5. TYPE
  6. NBR-DEPS-MIN
  7. SEQ-NBR
BN66.1, PR139, PR140, PR189, PR195, PR46.2, PR80.1, PR80.4 +2 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRGARNTYPEPRSYSTEMPRTAXAUTHPRGARNRULX

One to one (4) — lookups and parents

RelationTableRulesConditionField map
PrgarncatPRGARNTYPERequired
PGX-COUNTRY-CODE→GRT-COUNTRY-CODE
PGX-GARN-CAT→GRT-GARN-CAT
PGX-TYPE→GRT-TYPE
PrgarntypePRGARNTYPERequired
PGX-COUNTRY-CODE→GRT-COUNTRY-CODE
PGX-TYPE→GRT-TYPE
PrsystemPRSYSTEMRequired
PGX-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
PrtaxauthPRTAXAUTHRequired
PGX-TAX-ID-CODE→PRX-TAX-ID-CODE

Programs

Updated by (1)

Referenced by (13)