|
|
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
|
