PRGARNRULX

REFERENCED BY
PR246


UPDATED BY
BN66.1 PR139 PR140 PR189 PR195 PR26.1
PR46.2 PR47.1 PR514 PR80.1 PR80.4 PR89.1
UK47.1 UK46.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGX-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
PR46.2
PGX-COMPANY
Element: Company Hr
Numeric 4
PR46.2
PGX-GARN-CAT
Element: Garn Cat
Alpha 1
Identifies a group of garnishments. Rules may be defined by category. Reporting may be done by category.
PR46.2
PGX-TYPE
Element: Type
Alpha 2
Defines a type of garnishment. Rules are then defined for this type.
PR46.2
PGX-SEQ-NBR
Element: Seq Nbr
Numeric 4
Sequence number for the multiple variable rule records.
PR46.2
PGX-TAX-ID-CODE
Element: Tax Id Code
Alpha 10
Contains the federal or provincial jurisdiction governing the garnishment. Determines the rules that apply to a specific garnishment.
PR46.2
PGX-CA-GRN-MARITAL
Element: Ca Grn Marital
Alpha 2
Contains 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
Element: Basic Exempt
Signed 7.2
Contains the basic amount or percent that is exempted from seizure.
PR46.2
PGX-BASIC-CALC-TYP
Element: Basic Calc Typ
Numeric 1
Determines if the value in the Basic Exempt field is an amount or percent.
1 = Amount
2 = Percent
PR46.2
PGX-WAGE-LEVEL
Element: Wage Level
Numeric 7
Defines the starting value of a range of the employee wages that an additional exempt amount would be calculated on.
PR46.2
PGX-ADDL-EXEMPT
Element: Addl Exempt
Signed 7.2
Contains 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
Element: Addl Calc Type
Numeric 1
Determines if the value in the Addl Exempt Amount field is an amount or percent.
PR46.2
PGX-MIN-EXEMPT
Element: Min Exempt
Signed 7.2
Contains the minimum exempt amount or percentage that an employee should have exempted from seizure.
PR46.2
PGX-MIN-CALC-TYPE
Element: Min Calc Type
Numeric 1
Determines if the value in the Minimum Exempt field is an amount or percent.
1 = Amount
2 = Percent
PR46.2
PGX-MAX-EXEMPT
Element: Max Exempt
Signed 7.2
Contains the maximum exempt amount or percentage that an employee can have exempted from seizure.
PR46.2
PGX-MAX-CALC-TYPE
Element: Max Calc Type
Numeric 1
Determines if the value in the Maximum Exempt field is an amount or percent.
1 = Amount
2 = Percent
PR46.2
PGX-NBR-DEPS-MIN
Element: Nbr Deps Min
Numeric 2
Contains the number of dependents used in determining the minimum exempt amount.
PR46.2


PRGARNRULX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGXSET1 COMPANY
COUNTRY-CODE
TAX-ID-CODE
GARN-CAT
TYPE
SEQ-NBR
BN66.1 PR139
PR140 PR189
PR195 PR246
PR46.2 PR80.1
PR80.4 PR89.1
UK46.2
PGXSET3 COMPANY
COUNTRY-CODE
TAX-ID-CODE
GARN-CAT
TYPE
CA-GRN-MARITAL
SEQ-NBR
BN66.1 PR139
PR140 PR189
PR195 PR26.1
PR46.2 PR47.1
PR514 PR80.1
PR80.4 PR89.1
UK47.1
PGXSET4 COMPANY
COUNTRY-CODE
TAX-ID-CODE
GARN-CAT
TYPE
WAGE-LEVEL
SEQ-NBR
PR46.2
PGXSET5 COMPANY
COUNTRY-CODE
TAX-ID-CODE
GARN-CAT
TYPE
NBR-DEPS-MIN
SEQ-NBR
BN66.1 PR139
PR140 PR189
PR195 PR46.2
PR80.1 PR80.4
PR89.1


PRGARNRULX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:27:15 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.