PREMPGARN

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
PR05.1 PR226 PR247 PR277 PR539 PR560
BN66.1 PR139 PR140 PR141 PR189 PR198
PR275 PR39.3 PR80.1 PR80.4 PR89.1 PRAT.1
PR115 PR25.2


UPDATED BY
PR195 PR197 PR26.1 PR26.2 PR47.1 PR47.2
PR514 PR582 PR82.1 PR85.1 HR11.1 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEG-COMPANY
Element: Company Hr
Numeric 4
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.)
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
PEG-DESC
Element: Description
Alpha 30 (Lower Case)
Contains a detail description of the garnishment. Used in reporting.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
PEG-TYPE
Element: Type
Alpha 2
Defines the garnishment and determines which set of rules apply from the Garnishment table.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
PEG-DED-CODE
Element: Ded Code
Alpha 4
Defines which deduction will be used in withholding the garnishment amount.
PR26.1 PR47.1
PR514
PEG-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
PR26.1 PR47.1
PR514
PEG-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
Contains the vendor for AP invoices created for the amount to be withheld.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
PEG-EXEM-FORM
Element: Exem Form
Alpha 2
Defines how exempt earnings (protected income) is calculated. If entered, this overrides the rules table.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
PEG-FACTOR-1
Element: Factor 1
Signed 7.2
Parameter used to calculate exempt wages. If entered, this number overrides the rules table.
PR26.1 PR47.1
PR514
PEG-FACTOR-2
Element: Factor 2
Signed 7.2
Parameter used to calculate the exempt wages. If entered, this number overrides the rules table.
PR26.1 PR47.1
PR514
PEG-FACTOR-3
Element: Factor 3
Signed 7.2
Parameter used to calculate exempt wages. If entered, this number overrides the rules table.
PR26.1 PR47.1
PR514
PEG-FACTOR-4
Element: Factor 4
Signed 7.2
Parameter used to calculate exempt wages. If entered, this number overrides the rules table.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
PEG-ARR-SEQ-NBR
Element: Arr Seq Nbr
Numeric 4
An automatically assigned sequence number.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
PEG-FEES-SEQ-NBR
Element: Fees Seq Nbr
Numeric 4
An automatically assigned sequence number.
PR26.1 PR47.1
PR514
PEG-FEES-OVERRIDE
Element: Fees Override
Alpha 1
Indicates whether the fees in the XXX field override the Rules table.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
PEG-COUNTRY-CODE
Element: Country Code
Alpha 2
Distinguishes the records by country code.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
PEG-CA-GRN-MARITAL
Element: Ca Grn Marital
Alpha 2
Contains the Canadian marital statuses for purpose of calculating wages exempt from seizure.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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
PR26.1 PR47.1
PR514
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
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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
PR26.1 PR47.1
PR514
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.
PR26.1 PR47.1
PR514
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
PR26.1 PR47.1
PR514
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
PR195 PR197
PR582 PR82.1
PR85.1
PEG-EXEMPT-ARRS-TP
Element: Exempt Arrs Tp
Signed 7.2
PR195 PR197
PR582 PR82.1
PR85.1
PEG-DED-FREQ
Element: Ded Freq
Alpha 1
PEG-DED-ARRS-TD
Element: Ded Arrs Td
Signed 7.2
PR195 PR197
PR582 PR82.1
PR85.1
PEG-DED-ARRS-TP
Element: Ded Arrs Tp
Signed 7.2
PR195 PR197
PR582 PR82.1
PR85.1
PEG-REMIT-TO-CODE
Element: Remit To Code
Alpha 4
A user-defined code that represents a vendor's remittance address.
PR26.1 PR47.1
PR514
PEG-DED-FROM-GARN
Element: Ded From Garn
Alpha 1
PR26.1 PR47.1
PR514
PEG-CH-DED-CODE
Element: Ded Code
Alpha 4
PR26.1 PR47.1
PR514
PEG-CLEARHOUSE-FEE
Element: Clearhouse Fee
Signed 11.2
PR26.1 PR47.1
PR514
PEG-CHFEE-OVERRIDE
Element: Chfee Override
Alpha 1
PR26.1 PR47.1
PR514
PEG-FIPS-CODE
Element: Fips Code
Alpha 7
PR26.1 PR47.1
PR514
PEG-MED-DED-CODE
Element: Ded Code
Alpha 4
PEG-SUPP-PRIORITY
Element: Ded Priority
Numeric 1


PREMPGARN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEGSET1 COMPANY
EMPLOYEE
CASE-NUMBER
FILE-NUMBER
HR11.1 PA115
PR05.1 PR195
PR197 PR226
PR247 PR26.1
PR26.2 PR277
PR47.1 PR47.2
PR514 PR539
PR560 PR582
PR82.1 PR85.1
PEGSET2 GARN-OBJ-ID
BN66.1 PR139
PR140 PR141
PR189 PR195
PR198 PR275
PR277 PR39.3
PR80.1 PR80.4
PR89.1 PRAT.1
PEGSET4 COMPANY
TAX-ID-CODE
EMPLOYEE
GARN-OBJ-ID
PR115 PR25.2


PREMPGARN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arr Ded DEDCODE Required
PEG-COMPANY->DDC-COMPANY
PEG-ARR-DED-CODE->DDC-DED-CODE
Arr Emded EMDEDMASTR Required
PEG-COMPANY->EDM-COMPANY
PEG-EMPLOYEE->EDM-EMPLOYEE
PEG-ARR-DED-CODE->EDM-DED-CODE
PEG-ARR-SEQ-NBR->EDM-SEQ-NBR
Employee EMPLOYEE Required
PEG-COMPANY->EMP-COMPANY
PEG-EMPLOYEE->EMP-EMPLOYEE
Fees Ded DEDCODE Required
PEG-COMPANY->DDC-COMPANY
PEG-FEES-DED-CODE->DDC-DED-CODE
Fees Emded EMDEDMASTR Required
PEG-COMPANY->EDM-COMPANY
PEG-EMPLOYEE->EDM-EMPLOYEE
PEG-FEES-DED-CODE->EDM-DED-CODE
PEG-FEES-SEQ-NBR->EDM-SEQ-NBR
Garn Ded DEDCODE Required
PEG-COMPANY->DDC-COMPANY
PEG-DED-CODE->DDC-DED-CODE
Garn Emded EMDEDMASTR Required
PEG-COMPANY->EDM-COMPANY
PEG-EMPLOYEE->EDM-EMPLOYEE
PEG-DED-CODE->EDM-DED-CODE
PEG-SEQ-NBR->EDM-SEQ-NBR
Garn Rule PRGARNRULE Required
PEG-COMPANY->PGR-COMPANY
PEG-COUNTRY-CODE->PGR-COUNTRY-CODE
PEG-TAX-ID-CODE->PGR-TAX-ID-CODE
GRT-GARN-CAT->PGR-GARN-CAT
PEG-TYPE->PGR-TYPE
Prgarntype PRGARNTYPE Required
PEG-COUNTRY-CODE->GRT-COUNTRY-CODE
PEG-TYPE->GRT-TYPE
Prsystem PRSYSTEM Required
PEG-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Prtaxauth PRTAXAUTH Required
PEG-TAX-ID-CODE->PRX-TAX-ID-CODE


PREMPGARN FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Emp Garn Hist PRGARNHIST
PEG-COMPANY->GRH-COMPANY
PEG-EMPLOYEE->GRH-EMPLOYEE
PEG-GARN-OBJ-ID->GRH-GARN-OBJ-ID
  GRH-CREATE-DATE
  GRH-CHECK-ID


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

Home
Contact Us



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