|
|
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 PR140 PR189 PR195
PR225 PR246 PR80.1 PR89.1
UPDATED BY
PR115 PR25.2 PR26.1 PR46.2 PR47.1 PR514
PR925 UK46.2 UK47.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGR-COMPANY Numeric 4 PR25.2 PR46.2
Element: Company Contains the company number. PR925 UK46.2
PGR-TAX-ID-CODE Alpha 10 PR25.2 PR46.2
Element: Tax Id Code Defines the state, county, or province PR925 UK46.2
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
Element: Garn Cat Identifies a group of garnishments. PR925 UK46.2
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
Element: Type Defines a type of garnishment. Rules PR925 UK46.2
are then defined for this type.
PGR-EXEM-FORM Alpha 2 PR25.2 PR46.2
Element: Exem Form Defines how exempt earnings (protected PR925
income) are calculated.
PGR-RATE-X-FED-MIN Numeric 3 PR25.2 PR925
Element: Rate X Fed MinThis number is multiplied by the
federal minimum wage to determine exempt
wages.
PGR-FACTOR-1 Signed 7.2 PR25.2 PR925
Element: Factor 1 Parameter used in calculating exempt
wages.
PGR-FACTOR-2 Signed 7.2 PR25.2
Element: Factor 2 Parameter used to calculate exempt
wages.
PGR-FACTOR-3 Signed 7.2 PR25.2
Element: Factor 3 Parameter used to calculate exempt
wages.
PGR-FACTOR-4 Signed 7.2 PR25.2
Element: Factor 4 Parameter used to calculate exempt
wages.
PGR-SND-FAM-YES Signed 5.2 PR25.2 PR925
Element: 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
Element: 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
Element: 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
Element: Pct Per Dep Defines the amount or percent per
dependent used to calculate exempt
earnings.
PGR-CALC-TYPE Alpha 1 PR25.2
Element: Calculation TyDetermines 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
Element: Mult Garn RuleDefines how to distribute the amount to PR925 UK46.2
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
Element: Fees Ded Code Contains the deduction code used to UK46.2
track the fee amount withheld separately
from the order amount.
PGR-AMOUNT Currency 15.2 PR25.2 PR46.2
Element: Amount Contains the amount to be charged for UK46.2
this garnishment.
PGR-FREQUENCY Alpha 1 PR25.2 PR46.2
Element: Frequency Indicates when the fee will be withheld. UK46.2
1 = Only When Garn Amt is Withheld
2 = Every Cyc Garn Should be Taken
PGR-FEES-LMT-TYPE Alpha 2 PR25.2 PR46.2
Element: Fees Lmt Type Identifies which rules formula is used UK46.2
in determining the fee amount.
PGR-FEES-LMT-AMT-1 Signed 7.2 PR25.2 PR46.2
Element: Fees Lmt Amt 1Contains a limit amount or percent. UK46.2
This used in calculation based on the
limit rule.
PGR-FEES-LMT-AMT-2 Signed 7.2 PR25.2 PR46.2
Element: Fees Lmt Amt 2If the limit rule has two calculations, UK46.2
contains the amount or percent of the
second part of the calculation.
PGR-FEES-1ST-TIME Signed 7.2 PR25.2 PR46.2
Element: Fees 1st Time Contains a fee used for the first time UK46.2
garnishment is processed for an
employee.
PGR-GL-DIST-COMP Numeric 4 PR25.2 PR46.2
Element: Gl Dist Comp Contains the distribution company for UK46.2
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 UK46.2
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 UK46.2
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 UK46.2
Subaccount account used on the fee deduction.
PGR-EXCL-PAY-CODE Alpha 4 Occurs 30 Times PR25.2 PR46.2
Element: Excl Pay Code Excludes certain pay in calculating the UK46.2
disposable income.
PGR-EXCL-DED-CODE Alpha 4 Occurs 30 Times PR25.2 PR46.2
Element: Excl Ded Code Excludes certain deductions in UK46.2
calculating the disposable income.
PGR-CHANGE-FLAG Alpha 1 PR115 PR25.2
Element: Change Flag Indicates whether the fee amount is PR46.2 UK46.2
changed for the garnishment rule.
Y = Yes
PGR-USED-FLAG Alpha 1 PR25.2 PR26.1
Element: 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 UK46.2 UK47.1
Garnishment) based on the governing
taxing authority, category, and type.
Y = YEs
N = No
PGR-COUNTRY-CODE Alpha 2 PR25.2 PR46.2
Element: Country Code The country code. Required for VAT and PR925 UK46.2
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PGR-NBR-DEPS Numeric 2 Occurs 20 Times PR46.2
Element: 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
Element: Dep Amount Contains the amount per dependent that
is exempt from seizure.
PGR-INCL-ADD-NET Alpha 4 Occurs 10 Times PR46.2 UK46.2
Element: 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
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PGR-CURR-ND Numeric 1
Account Currency
Code
PRGARNRULE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGRSET1 COMPANY BN66.1 PR05.1
COUNTRY-CODE PR115 PR139
TAX-ID-CODE PR140 PR189
GARN-CAT PR195 PR225
TYPE PR246 PR25.2
PR26.1 PR46.2
PR47.1 PR514
PR80.1 PR89.1
PR925 UK46.2
UK47.1
PGRSET2 TYPE PR25.1 PR46.1
COMPANY UK46.1
COUNTRY-CODE
TAX-ID-CODE
GARN-CAT
PGRSET3 COMPANY Subset PR115 PR140
COUNTRY-CODE Where CHANGE-FLAG = "Y" PR189 PR80.1
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
|
