PRGARNRULE FILE
The Garnishment Rules files contains garnishment rules by governing tax
authority and category for wage formulas, disposable income, and fee
definitions.
REFERENCED BY
BN66.1 PR05.1 PR139 PR195 PR225 PR246
PR89.1
UPDATED BY
PR115 PR25.2 PR26.1 PR46.2 PR47.1 PR514
PR925
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGR-COMPANY Numeric 4 PR25.2 PR46.2
Company Contains the company number. PR925
PGR-TAX-ID-CODE Alpha 10 PR25.2 PR46.2
Tax Id Code Defines the state, county, or province PR925
governing the attachment. Determines the
rules that apply to a type of a
garnishment.
Note: You cannot define federal rules.
PGR-GARN-CAT Alpha 1 PR25.2 PR46.2
Garn Cat Identifies a group of garnishments. PR925
Rules may be defined by category.
Reporting may be done by category.
Garnishment types are tied to
categories on the garnishment types
table.
A = Assignment
B = Bankruptcy
G = Garnishment
L = Student Loans
S = Support
T = Tax Levies
PGR-TYPE Alpha 2 PR25.2 PR46.2
Type Defines a type of garnishment. Rules PR925
are then defined for this type.
PGR-EXEM-FORM Alpha 2 PR25.2 PR46.2
Exem Form Defines how exempt earnings (protected PR925
income) are calculated.
PGR-RATE-X-FED-MIN Numeric 3 PR25.2 PR925
Rate X Fed Min This number is multiplied by the
federal minimum wage to determine exempt
wages.
PGR-FACTOR-1 Signed 7.2 PR25.2 PR925
Factor 1 Parameter used in calculating exempt
wages.
PGR-FACTOR-2 Signed 7.2 PR25.2
Factor 2 Parameter used to calculate exempt
wages.
PGR-FACTOR-3 Signed 7.2 PR25.2
Factor 3 Parameter used to calculate exempt
wages.
PGR-FACTOR-4 Signed 7.2 PR25.2
Factor 4 Parameter used to calculate exempt
wages.
PGR-SND-FAM-YES Signed 5.2 PR25.2 PR925
Snd Fam Yes Contains the percent to withhold for an
employee with a second family.
PGR-SND-FAM-NO Signed 5.2 PR25.2 PR925
Snd Fam No Contains the percent to withhold for an
employee without a second family.
PGR-ARR-ADD-PCT Signed 5.2 PR25.2 PR925
Arr Add Pct Used with child support or alimony
garnishments and represents the
additional percent if outstanding
arrearages are more than 12 weeks old on
the employee record.
PGR-PCT-PER-DEP Signed 7.2 PR25.2
Pct Per Dep Defines the amount or percent per
dependent used to calculate exempt
earnings.
PGR-CALC-TYPE Alpha 1 PR25.2
Calculation Type Determines if the value in the Per
Dependent field is an amount or a
percent.
A = Amount
P = Percent
PGR-MULT-GARN-RULE Alpha 1 PR25.2 PR46.2
Mult Garn Rule Defines how to distribute the amount to PR925
be withheld when the amount is
insufficient and multiple orders exist
(for the same category) for an employee.
1 = Prorate Based On Farn Amount
2 = Equal Amount To Each Other
3 = Effective Date Order
4 = Withhold One Garn At A Time
PGR-FEES-DED-CODE Alpha 4 PR25.2 PR46.2
Fees Ded Code Contains the deduction code used to
track the fee amount withheld separately
from the order amount.
PGR-AMOUNT Currency 15.2 PR25.2 PR46.2
Amount Contains the amount to be charged for
this garnishment.
PGR-FREQUENCY Alpha 1 PR25.2 PR46.2
Frequency Indicates when the fee will be withheld.
1 = Only When Garn Amt is Withheld
2 = Every Cyc Garn Should be Taken
PGR-FEES-LMT-TYPE Alpha 2 PR25.2 PR46.2
Fees Lmt Type Identifies which rules formula is used
in determining the fee amount.
PGR-FEES-LMT-AMT-1 Signed 7.2 PR25.2 PR46.2
Fees Lmt Amt 1 Contains a limit amount or percent.
This used in calculation based on the
limit rule.
PGR-FEES-LMT-AMT-2 Signed 7.2 PR25.2 PR46.2
Fees Lmt Amt 2 If the limit rule has two calculations,
contains the amount or percent of the
second part of the calculation.
PGR-FEES-1ST-TIME Signed 7.2 PR25.2 PR46.2
Fees 1st Time Contains a fee used for the first time
garnishment is processed for an
employee.
PGR-GL-DIST-COMP Numeric 4 PR25.2 PR46.2
Gl Dist Comp Contains the distribution company for
the accrual account on the deduction for
fees.
PGR-GL-ACCT-UNIT Alpha 15 PR25.2 PR46.2
General Ledger Contains the accounting unit used for
Accounting Unit the accrual on the deduction for fees.
PGR-GL-ACCOUNT Numeric 6 PR25.2 PR46.2
General Ledger Contains the account for the accrual
Account account on the deduction for fees.
PGR-GL-SUB-ACCT Numeric 4 PR25.2 PR46.2
General Ledger Contains the subaccount for the accrual
Subaccount account used on the fee deduction.
PGR-EXCL-PAY-CODE Alpha 4 Occurs 30 Times PR25.2 PR46.2
Excl Pay Code Excludes certain pay in calculating the
disposable income.
PGR-EXCL-DED-CODE Alpha 4 Occurs 30 Times PR25.2 PR46.2
Excl Ded Code Excludes certain deductions in
calculating the disposable income.
PGR-CHANGE-FLAG Alpha 1 PR115 PR25.2
Change Flag Indicates whether the fee amount is PR46.2
changed for the garnishment rule.
Y = Yes
PGR-USED-FLAG Alpha 1 PR25.2 PR26.1
Used This flag is updated when an employee PR46.2 PR47.1
garnishment is added for this PR514 PR925
garnishment rule in PR26.1 (Employee
Garnishment) based on the governing
taxing authority, category, and type.
Y = YEs
N = No
PGR-COUNTRY-CODE Alpha 2 PR25.2 PR46.2
Country Code The country code. Required for VAT and PR925
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PGR-NBR-DEPS Numeric 2 Occurs 20 Times PR46.2
Nbr Deps Contains the number of dependents used
in the calculation of the dependent
exempt amount.
PGR-DEP-AMOUNT Signed 7.2 Occurs 20 Times PR46.2
Dep Amount Contains the amount per dependent that
is exempt from seizure.
PGR-INCL-ADD-NET Alpha 4 Occurs 10 Times PR46.2
Incl Add Net Contains the deduction code of the add
to net deduction(s) that should be
included in calculating the wages
available for garnishment.
PGR-CURRENCY-CODE Alpha 5
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PGR-CURR-ND Numeric 1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
PRGARNRULE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGRSET1 COMPANY BN66.1 PR05.1
COUNTRY-CODE PR115 PR139
TAX-ID-CODE PR195 PR225
GARN-CAT PR246 PR25.2
TYPE PR26.1 PR46.2
PR47.1 PR514
PR89.1 PR925
PGRSET2 TYPE PR25.1 PR46.1
COMPANY
COUNTRY-CODE
TAX-ID-CODE
GARN-CAT
PGRSET3 COMPANY Subset PR115
COUNTRY-CODE Where CHANGE-FLAG = "Y"
TAX-ID-CODE And USED-FLAG = "Y"
GARN-CAT
TYPE
PRGARNRULE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Fees Ded DEDCODE Required
PGR-COMPANY -> DDC-COMPANY
PGR-FEES-DED-CODE -> DDC-DED-CODE
Incl Add Net DEDCODE Required
PGR-COMPANY -> DDC-COMPANY
PGR-INCL-ADD-NET -> DDC-DED-CODE
Prgarncat PRGARNTYPE Required
PGR-COUNTRY-CODE -> GRT-COUNTRY-CODE
PGR-GARN-CAT -> GRT-GARN-CAT
PGR-TYPE -> GRT-TYPE
Prgarntype PRGARNTYPE Required
PGR-COUNTRY-CODE -> GRT-COUNTRY-CODE
PGR-TYPE -> GRT-TYPE
Prsystem PRSYSTEM Required
PGR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Prtaxauth PRTAXAUTH Required
PGR-TAX-ID-CODE -> PRX-TAX-ID-CODE
PRGARNRULE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Prgarnrulx PRGARNRULX Delete Cascades
PGR-COMPANY -> PGX-COMPANY
PGR-COUNTRY-CODE -> PGX-COUNTRY-CODE
PGR-TAX-ID-CODE -> PGX-TAX-ID-CODE
PGR-GARN-CAT -> PGX-GARN-CAT
PGR-TYPE -> PGX-TYPE
PGX-SEQ-NBR
|
