PRGARNRULE

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 PR80.4 PR89.1 PRAT.1


UPDATED BY
PR115 PR25.2 PR26.1 PR46.2 PR47.1 PR514
PR925

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGR-COMPANY
Element: Company Hr
Numeric 4
Contains the company number.
PR25.2 PR46.2
PR925
PGR-TAX-ID-CODE
Element: Tax Id Code
Alpha 10
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.
PR25.2 PR46.2
PR925
PGR-GARN-CAT
Element: Garn Cat
Alpha 1
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
PR25.2 PR46.2
PR925
PGR-TYPE
Element: Type
Alpha 2
Defines a type of garnishment. Rules are then defined for this type.
PR25.2 PR46.2
PR925
PGR-EXEM-FORM
Element: Exem Form
Alpha 2
Defines how exempt earnings (protected income) are calculated.
PR25.2 PR46.2
PR925
PGR-RATE-X-FED-MIN
Element: Rate X Fed Min
Numeric 3
This number is multiplied by the federal minimum wage to determine exempt wages.
PR25.2 PR925
PGR-FACTOR-1
Element: Factor 1
Signed 7.2
Parameter used in calculating exempt wages.
PR25.2 PR925
PGR-FACTOR-2
Element: Factor 2
Signed 7.2
Parameter used to calculate exempt wages.
PR25.2
PGR-FACTOR-3
Element: Factor 3
Signed 7.2
Parameter used to calculate exempt wages.
PR25.2
PGR-FACTOR-4
Element: Factor 4
Signed 7.2
Parameter used to calculate exempt wages.
PR25.2
PGR-SND-FAM-YES
Element: Snd Fam Yes
Signed 5.2
Contains the percent to withhold for an employee with a second family.
PR25.2 PR925
PGR-SND-FAM-NO
Element: Snd Fam No
Signed 5.2
Contains the percent to withhold for an employee without a second family.
PR25.2 PR925
PGR-ARR-ADD-PCT
Element: Arr Add Pct
Signed 5.2
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.
PR25.2 PR925
PGR-PCT-PER-DEP
Element: Pct Per Dep
Signed 7.2
Defines the amount or percent per dependent used to calculate exempt earnings.
PR25.2
PGR-CALC-TYPE
Element: Calc Type
Alpha 1
Determines if the value in the Per Dependent field is an amount or a percent.
A = Amount
P = Percent
PR25.2
PGR-MULT-GARN-RULE
Element: Mult Garn Rule
Alpha 1
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
PR25.2 PR46.2
PR925
PGR-FEES-DED-CODE
Element: Fees Ded Code
Alpha 4
Contains the deduction code used to track the fee amount withheld separately from the order amount.
PR25.2 PR46.2
PGR-AMOUNT
Element: Amount
Currency 15.2
Contains the amount to be charged for this garnishment.
PR25.2 PR46.2
PGR-FREQUENCY
Element: Frequency
Alpha 1
Indicates when the fee will be withheld.
1 = Only When Garn Amt is Withheld
2 = Every Cyc Garn Should be Taken
PR25.2 PR46.2
PGR-FEES-LMT-TYPE
Element: Fees Lmt Type
Alpha 2
Identifies which rules formula is used in determining the fee amount.
PR25.2 PR46.2
PGR-FEES-LMT-AMT-1
Element: Fees Lmt Amt 1
Signed 7.2
Contains a limit amount or percent. This used in calculation based on the limit rule.
PR25.2 PR46.2
PGR-FEES-LMT-AMT-2
Element: Fees Lmt Amt 2
Signed 7.2
If the limit rule has two calculations, contains the amount or percent of the second part of the calculation.
PR25.2 PR46.2
PGR-FEES-1ST-TIME
Element: Fees 1st Time
Signed 7.2
Contains a fee used for the first time garnishment is processed for an employee.
PR25.2 PR46.2
PGR-GL-DIST-COMP
Element: Company
Numeric 4
Contains the distribution company for the accrual account on the deduction for fees.
PR25.2 PR46.2
PGR-GL-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the accounting unit used for the accrual on the deduction for fees.
PR25.2 PR46.2
PGR-GL-ACCOUNT
Element: Account
Numeric 6
Contains the account for the accrual account on the deduction for fees.
PR25.2 PR46.2
PGR-GL-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the subaccount for the accrual account used on the fee deduction.
PR25.2 PR46.2
PGR-EXCL-PAY-CODE
Element: Excl Pay Code
Alpha 4 Occurs 30 Times
Excludes certain pay in calculating the disposable income.
PR25.2 PR46.2
PGR-EXCL-DED-CODE
Element: Excl Ded Code
Alpha 4 Occurs 30 Times
Excludes certain deductions in calculating the disposable income.
PR25.2 PR46.2
PGR-CHANGE-FLAG
Element: Change Flag
Alpha 1
Indicates whether the fee amount is changed for the garnishment rule.
Y = Yes
PR115 PR25.2
PR46.2
PGR-USED-FLAG
Element: Used Flag
Alpha 1
This flag is updated when an employee 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
PR25.2 PR26.1
PR46.2 PR47.1
PR514 PR925
PGR-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
PR25.2 PR46.2
PR925
PGR-NBR-DEPS
Element: Nbr Deps
Numeric 2 Occurs 20 Times
Contains the number of dependents used in the calculation of the dependent exempt amount.
PR46.2
PGR-DEP-AMOUNT
Element: Dep Amount
Signed 7.2 Occurs 20 Times
Contains the amount per dependent that is exempt from seizure.
PR46.2
PGR-INCL-ADD-NET
Element: Incl Add Net
Alpha 4 Occurs 10 Times
Contains the deduction code of the add to net deduction(s) that should be included in calculating the wages available for garnishment.
PR46.2
PGR-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
PGR-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PGR-DED-FROM-GARN
Element: Ded From Garn
Alpha 1
PR25.2
PGR-CH-DED-CODE
Element: Ded Code
Alpha 4
PR25.2
PGR-CLEARHOUSE-FEE
Element: Clearhouse Fee
Signed 11.2
PR25.2


PRGARNRULE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGRSET1 COMPANY
COUNTRY-CODE
TAX-ID-CODE
GARN-CAT
TYPE
BN66.1 PR05.1
PR115 PR139
PR140 PR189
PR195 PR225
PR246 PR25.2
PR26.1 PR46.2
PR47.1 PR514
PR80.1 PR80.4
PR89.1 PR925
PRAT.1
PGRSET2 TYPE
COMPANY
COUNTRY-CODE
TAX-ID-CODE
GARN-CAT
PR25.1 PR46.1
PGRSET3 COMPANY
COUNTRY-CODE
TAX-ID-CODE
GARN-CAT
TYPE
Subset
WhereCHANGE-FLAG ="Y"
AndUSED-FLAG ="Y"
PR115 PR140
PR189 PR80.1
PR80.4


PRGARNRULE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:30:35 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.