|
|
PRGARNRULE FILE
Garnishment Rules
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 PR140 PR195 PR225
PR80.1 PR89.1
UPDATED BY
PR115 PR25.2 PR26.1 PR514 PR925
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGR-COMPANY Numeric 4 PR25.2 PR925
Company Contains the company number.
PGR-TAX-ID-CODE Alpha 10 PR25.2 PR925
Tax Id Code Defines the state, county, or province
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 PR925
Garn Cat Identifies a group of garnishments.
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 PR925
Type Defines a type of garnishment. Rules are
then defined for this type.
PGR-EXEM-FORM Alpha 2 PR25.2 PR925
Exem Form Defines how exempt earnings (protected
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 PR925
Mult Garn Rule Defines how to distribute the amount to
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
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
Amount Contains the amount to be charged for
this garnishment.
PGR-FREQUENCY Alpha 1 PR25.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
Fees Lmt Type Identifies which rules formula is used
in determining the fee amount.
PGR-FEES-LMT-AMT-1 Signed 7.2 PR25.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
Fees Lmt Amt 2 If the limit rule has two calculations,
contains the amount or percent of the
second part of the caculation.
PGR-FEES-1ST-TIME Signed 7.2 PR25.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
Gl Dist Comp Contains the distribution company for
the accrual account on the deduction for
fees.
PGR-GL-ACCT-UNIT Alpha 15 PR25.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
General Ledger Contains the account for the accrual
Account account on the deduction for fees.
PGR-GL-SUB-ACCT Numeric 4 PR25.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
Excl Pay Code Excludes certain pay in calculating the
disposable income.
PGR-EXCL-DED-CODE Alpha 4 Occurs 30 Times PR25.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
changed for the garnishment rule.
Y = Yes
PGR-USED-FLAG Alpha 1 PR25.2 PR26.1
Used This flag is updated when an employee PR514 PR925
garnishment is added for this
garnishment rule in PR26.1 (Employee
Garnishment) based on the governing
taxing authority, category, and type.
Y = YEs
N = No
PRGARNRULE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGRSET1 COMPANY BN66.1 PR05.1
TAX-ID-CODE PR115 PR139
GARN-CAT PR140 PR195
TYPE PR225 PR25.2
PR26.1 PR514
PR80.1 PR89.1
PR925
PGRSET2 TYPE PR25.1
COMPANY
TAX-ID-CODE
GARN-CAT
PGRSET3 COMPANY Subset PR115 PR140
TAX-ID-CODE Where CHANGE-FLAG = "Y"
GARN-CAT And USED-FLAG = "Y"
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
Prgarncat PRGARNTYPE Required
PGR-GARN-CAT -> GRT-GARN-CAT
PGR-TYPE -> GRT-TYPE
Prgarntype PRGARNTYPE Required
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
|