|
|
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 The company number represents an
established company and is entered on
all function codes.
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 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
PGXSET2 TYPE
COMPANY
COUNTRY-CODE
TAX-ID-CODE
GARN-CAT
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
|
