Used to store information to identify a particular garnishment per employee per company. Information in this file is used to determine the priority, calculation, limits, balances, and fees for this garnishment, as well as information to be passed to AP for paying the garnishment and printing the check stub.
REFERENCED BY
PR139 | PR141 | PR198 | PR275 | PR39.3 | PR539 |
PR560 | UK141 | UK560 | PR25.2 |
BN66.1 | HR11.1 | PA115 | PR05.1 | PR115 | PR140 |
PR189 | PR195 | PR197 | PR226 | PR247 | PR26.1 |
PR26.2 | PR277 | PR47.1 | PR47.2 | PR514 | PR582 |
PR80.1 | PR80.4 | PR82.1 | PR85.1 | PR89.1 | UK145 |
UK201 | UK202 | UK277 | UK47.1 | UK47.2 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PEG-COMPANY Element: Company Hr | Numeric 4 |
|
||||||||||||
PEG-EMPLOYEE Element: Employee | Numeric 9 Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person. |
|
||||||||||||
PEG-CASE-NUMBER Element: Case Number | Alpha 20 Identifies the particular garnishment. A unique ID is required for each garnishment. (For example, case number in child support case, social security number for the IRS.) |
|
||||||||||||
PEG-FILE-NUMBER Element: File Number | Alpha 15 Used with the case number to identify the garnishment. Used to break out different orders with same case number. |
|
||||||||||||
PEG-DESC Element: Description | Alpha 30 (Lower Case) Contains a detail description of the garnishment. Used in reporting. |
|
||||||||||||
PEG-TAX-ID-CODE Element: Tax Id Code | Alpha 10 Contains the state, county, or province that governs the attachment. Determines the rules that apply to this garnishment. |
|
||||||||||||
PEG-TYPE Element: Type | Alpha 2 Defines the garnishment and determines which set of rules apply from the Garnishment table. |
|
||||||||||||
PEG-GARN-OBJ-ID Element: Garn Obj Id | Numeric 12 Assigned when an employee garnishment table (PREMPGARN) is added and deductions are created. This ID links the employee deductions to this garnishment (case number/file number). If the same deduction is created for this employee, this ID along with the sequence number keeps the record unique. |
|
||||||||||||
PEG-DED-CODE Element: Ded Code | Alpha 4 Defines which deduction will be used in withholding the garnishment amount. |
|
||||||||||||
PEG-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||||||||||
PEG-VENDOR Element: Vendor | Alpha 9 (Right Justified) Contains the vendor for AP invoices created for the amount to be withheld. |
|
||||||||||||
PEG-ORIG-BALANCE Element: Orig Balance | Signed 13.2 Contains the beginning balance for garnishments that are for a total amount to be paid in installments. This is the maximum amount that can be deducted. |
|
||||||||||||
PEG-EXEM-FORM Element: Exem Form | Alpha 2 Defines how exempt earnings (protected income) is calculated. If entered, this overrides the rules table. |
|
||||||||||||
PEG-RATE-X-FED-MIN Element: Rate X Fed Min | Numeric 3 This number is multiplied by the federal minimum wage to determine exempt wages. If entered, this number overrides the rules table. |
|
||||||||||||
PEG-FACTOR-1 Element: Factor 1 | Signed 7.2 Parameter used to calculate exempt wages. If entered, this number overrides the rules table. |
|
||||||||||||
PEG-FACTOR-2 Element: Factor 2 | Signed 7.2 Parameter used to calculate the exempt wages. If entered, this number overrides the rules table. |
|
||||||||||||
PEG-FACTOR-3 Element: Factor 3 | Signed 7.2 Parameter used to calculate exempt wages. If entered, this number overrides the rules table. |
|
||||||||||||
PEG-FACTOR-4 Element: Factor 4 | Signed 7.2 Parameter used to calculate exempt wages. If entered, this number overrides the rules table. |
|
||||||||||||
PEG-SND-FAM-YES Element: Snd Fam Yes | Signed 5.2 Contains the percent to be deducted for employee with a second family. If entered, this number overrides the rules table. |
|
||||||||||||
PEG-SND-FAM-NO Element: Snd Fam No | Signed 5.2 Contains the percent deducted if the employee does not have a second family. If entered, this number overrides the rules table. |
|
||||||||||||
PEG-ARR-ADD-PCT Element: Arr Add Pct | Signed 5.2 Contains the additional percent if outstanding arrears are more than 12 weeks old. This is used with child support or alimony garnishments. If entered, this number overrides the rules table. |
|
||||||||||||
PEG-PCT-PER-DEP Element: Pct Per Dep | Signed 7.2 Defines the amount or percent per dependent used to calculate exempt earnings. If entered, this number overrides the rules table. |
|
||||||||||||
PEG-CALC-TYPE Element: Calc Type | Alpha 1 Determines if the value in the Per Dependent field is an amount or a percent. If entered, this value overrides the rules table. A = Amount P = Percent |
|
||||||||||||
PEG-NUM-OF-DEP Element: Num Of Dep | Numeric 2 Contains the number of dependents. This can be used to calculate the wage exception rule. |
|
||||||||||||
PEG-SND-FAMILY Element: Snd Family | Alpha 1 Indicates whether the employee has a second family. This can be used to calculate the wage exemption rule. |
|
||||||||||||
PEG-HEAD-OF-FAM Element: Head Of Fam | Alpha 1 Indicates whether employee is the head of the family. This can be used to calculate the wage exemption rule. Y = Yes N = No |
|
||||||||||||
PEG-ARR-DED-CODE Element: Arr Ded Code | Alpha 4 Contains the deduction code that will be used to track arrears withheld for this order. |
|
||||||||||||
PEG-ARR-SEQ-NBR Element: Arr Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||||||||||
PEG-ARR-ORIG-BAL Element: Arr Orig Bal | Signed 13.2 Contains the beginning balance for the arrears that are for a total given amount to be paid in installments. This is the maximum amount that can be deducted. |
|
||||||||||||
PEG-OVER-12-WEEKS Element: Over 12 Weeks | Alpha 1 Indicates whether the arrears are in arrears more than 12 weeks. If so, a different formula is used. This is used in calculating the exempt wage formula. Y = Yes N = No |
|
||||||||||||
PEG-FEES-DED-CODE Element: Fees Ded Code | Alpha 4 Displays the deduction description from the DEDCODE file for the fees deduction if entered on Garnishment Rules. |
|
||||||||||||
PEG-FEES-SEQ-NBR Element: Fees Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||||||||||
PEG-FEES-OVERRIDE Element: Fees Override | Alpha 1 Indicates whether the fees in the XXX field override the Rules table. |
|
||||||||||||
PEG-EXCL-PAY-CODE Element: Excl Pay Code | Alpha 4 Occurs 30 Times Excludes certain pay in calculating disposable income. If anything is entered, it will override the rules table. |
|
||||||||||||
PEG-EXCL-DED-CODE Element: Excl Ded Code | Alpha 4 Occurs 30 Times Excludes certain deductions in calculating disposable income. If anything is entered, it will override the rules table. |
|
||||||||||||
PEG-COUNTRY-CODE Element: Country Code | Alpha 2 Distinguishes the records by country code. |
|
||||||||||||
PEG-EFF-DATE-ORDER Element: Eff Date Order | Numeric 8 (yyyymmdd) Contains the effective date of the order. Used as an informational field for the user. |
|
||||||||||||
PEG-TAX-DED-ORDER Element: Tax Ded Order | Alpha 1 Defines whether or not the order is to be a tax deductible order. Used to validate tax status on deduction code. |
|
||||||||||||
PEG-CA-GRN-MARITAL Element: Ca Grn Marital | Alpha 2 Contains the Canadian marital statuses for purpose of calculating wages exempt from seizure. |
|
||||||||||||
PEG-BASIC-EXEMPT Element: Basic Exempt | Signed 7.2 Contains the value that represents the basic exempt amount or percent of the employee wages that is exempt from seizure. |
|
||||||||||||
PEG-BASIC-CALC-TYP Element: Basic Calc Typ | Numeric 1 Contains the value that determines if the basic exempt factor is a percent or amount. |
|
||||||||||||
PEG-WAGE-LEVEL Element: Wage Level | Numeric 7 Contains the starting value of a range of the employee wages that an additional exempt amount is calculated on. |
|
||||||||||||
PEG-ADDL-EXEMPT Element: Addl Exempt | Signed 7.2 Contains the value that represents the additional exempt amount or percent of the employee wages that is exempt from seizure. |
|
||||||||||||
PEG-ADDL-CALC-TYPE Element: Addl Calc Type | Numeric 1 Contains the value that determines if the additional exempt factor is a percent or amount. |
|
||||||||||||
PEG-MIN-EXEMPT Element: Min Exempt | Signed 7.2 Contains the value that represents the minimum exempt amount or percent of the employee wages that is exempt from seizure. |
|
||||||||||||
PEG-MIN-CALC-TYPE Element: Min Calc Type | Numeric 1 Contains the value that determines if the minimum exempt factor is a percent or amount. |
|
||||||||||||
PEG-MAX-EXEMPT Element: Max Exempt | Signed 7.2 Contains the value that represents the maximum exempt amount or percent of the employee wages that is exempt from seizure. |
|
||||||||||||
PEG-MAX-CALC-TYPE Element: Max Calc Type | Numeric 1 Contains the value that determines if the maximum exempt factor is a percent or amount. |
|
||||||||||||
PEG-INCL-ADD-NET Element: Incl Add Net | Alpha 4 Occurs 10 Times Contains the deduction code for the add to net deductions that should be included in calculating the wages available for garnishment. |
|
||||||||||||
PEG-CA-OVR-MARITAL Element: Ca Ovr Marital | Alpha 2 C1 = Single C2 = Married C3 = Married w/spouse C4 = Family C5 = Widow C6 = Widower C7 = Divorced C8 = Unmarried |
|
||||||||||||
PEG-DEP-CALC-TYPE Element: Dep Calc Type | Numeric 1 Contains the value that determines whether the value in PEG-DEP-AMOUNT is an amount or percent. 1 = Amount 2 = Percent |
|
||||||||||||
PEG-COURT-FEE Element: Court Fee | Signed 11.2 Contains the value which determines the amount that should be deducted from the employee for a court ordered fee. This amount is added to the garnishment deduction amount and is remitted to the court. This fee is court ordered vs an employer fee deducted to cover the administrative costs. |
|
||||||||||||
PEG-CRT-CALC-TYPE Element: Crt Calc Type | Numeric 1 Contains the value that determines whether the value in PEG-COURT-FEE is an amount or percent and whether it is a continuous or one time fee. 1 = Continuous Flat Amount 2 = Continuous Percent of Garn Ded 3 = One Time Flat Amount 4 = One Time Percent of Garn Ded |
|
||||||||||||
PEG-COURT-ARR-FEE Element: Court Arr Fee | Signed 11.2 Contains the value to determine the amount that should be deducted from the employee for an arrears court ordered fee. This amount is added to the arrears deduction amount and is remitted to the court. This fee is court ordered vs an employer fee deducted to cover the administrative costs. |
|
||||||||||||
PEG-ARR-CALC-TYPE Element: Arr Calc Type | Numeric 1 Contains the value that determines whether the value in PEG-COURT-ARR-FEE is an amount or percent and whether it is a continuous or one time fee. 1 = Continuous Flat Amount 2 = Continuous Pct of Arr Ded 3 = One Time Flat Amount 4 = One Time Pct of Arr Deduction |
|
||||||||||||
PEG-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||||||
PEG-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||
PEG-EXEMPT-ARRS-TD Element: Exempt Arrs Td | Signed 7.2 |
|
||||||||||||
PEG-EXEMPT-ARRS-TP Element: Exempt Arrs Tp | Signed 7.2 |
|
||||||||||||
PEG-DED-FREQ Element: Ded Freq | Alpha 1 |
|
||||||||||||
PEG-DED-ARRS-TD Element: Ded Arrs Td | Signed 7.2 |
|
||||||||||||
PEG-DED-ARRS-TP Element: Ded Arrs Tp | Signed 7.2 |
|
||||||||||||
PEG-REMIT-TO-CODE Element: Remit To Code | Alpha 4 A user-defined code that represents a vendor's remittance address. |
|
||||||||||||
PEG-DED-FROM-GARN Element: Ded From Garn | Alpha 1 |
|
||||||||||||
PEG-CH-DED-CODE Element: Ded Code | Alpha 4 |
|
||||||||||||
PEG-CLEARHOUSE-FEE Element: Clearhouse Fee | Signed 11.2 |
|
||||||||||||
PEG-CHFEE-OVERRIDE Element: Chfee Override | Alpha 1 |
|
||||||||||||
PEG-FIPS-CODE Element: Fips Code | Alpha 7 |
|
||||||||||||
PEG-MED-DED-CODE Element: Ded Code | Alpha 4 |
|
||||||||||||
PEG-SUPP-PRIORITY Element: Ded Priority | Numeric 1 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PEGSET1 |
COMPANY EMPLOYEE CASE-NUMBER FILE-NUMBER |
|
| ||||||||||||||||||||||||||||||||
PEGSET2 |
GARN-OBJ-ID |
|
| ||||||||||||||||||||||||||||||||
PEGSET4 |
COMPANY TAX-ID-CODE EMPLOYEE GARN-OBJ-ID |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Arr Ded | DEDCODE |
Required
| |||||||||||||||
Arr Emded | EMDEDMASTR |
Required
| |||||||||||||||
Employee | EMPLOYEE |
Required
| |||||||||||||||
Fees Ded | DEDCODE |
Required
| |||||||||||||||
Fees Emded | EMDEDMASTR |
Required
| |||||||||||||||
Garn Ded | DEDCODE |
Required
| |||||||||||||||
Garn Emded | EMDEDMASTR |
Required
| |||||||||||||||
Garn Rule | PRGARNRULE |
Required
| |||||||||||||||
Prgarntype | PRGARNTYPE |
Required
| |||||||||||||||
Prsystem | PRSYSTEM |
Required
| |||||||||||||||
Prtaxauth | PRTAXAUTH |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Emp Garn Hist | PRGARNHIST |
|
All trademarks and registered trademarks are the property of their
respective owners.