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
PR539 PR560 UK560 PR139 PR141 PR198
PR275 PR39.3 UK141 XR275


UPDATED BY
BN66.1 PR140 PR189 PR195 PR197 PR26.1
PR26.2 PR47.1 PR47.2 PR514 PR582 PR80.1
PR80.4 PR82.1 PR85.1 PR89.1 UK47.1 UK47.2
HR11.1 PA115 PR05.1 PR226 PR247 PR277
UK145 UK201 UK202 UK277 PR115 PR25.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEG-COMPANY
Element: Company Hr
Numeric 4
PR26.1 PR47.1
PR514 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
PEG-DESC
Element: Description
Alpha 30 (Lower Case)
Contains a detail description of the garnishment. Used in reporting.
PR26.1 PR47.1
PR514 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
PEG-DED-CODE
Element: Ded Code
Alpha 4
Defines which deduction will be used in withholding the garnishment amount.
PR26.1 PR47.1
PR514 UK47.1
PEG-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
PR26.1 PR47.1
PR514 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
PEG-ARR-SEQ-NBR
Element: Arr Seq Nbr
Numeric 4
An automatically assigned sequence number.
PR26.1 PR47.1
PR514 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
PEG-FEES-SEQ-NBR
Element: Fees Seq Nbr
Numeric 4
An automatically assigned sequence number.
PR26.1 PR47.1
PR514 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
PEG-COUNTRY-CODE
Element: Country Code
Alpha 2
Distinguishes the records by country code.
PR26.1 PR47.1
PR514 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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 UK47.1
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
PR26.1 PR47.1
PR514 PR582
PR82.1 PR85.1
UK47.1
PEG-EXEMPT-ARRS-TP
Element: Exempt Arrs Tp
Signed 7.2
BN66.1 PR140
PR189 PR195
PR197 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1
PEG-DED-FREQ
Element: Ded Freq
Alpha 1
PEG-DED-ARRS-TD
Element: Ded Arrs Td
Signed 7.2
PR195 PR197
PR26.1 PR47.1
PR514 PR582
PR82.1 PR85.1
UK47.1
PEG-DED-ARRS-TP
Element: Ded Arrs Tp
Signed 7.2
BN66.1 PR140
PR189 PR195
PR197 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.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 UK47.1
PEG-DED-FROM-GARN
Element: Ded From Garn
Alpha 1
PR26.1 PR47.1
PR514 UK47.1
PEG-CH-DED-CODE
Element: Ded Code
Alpha 4
PR26.1 PR47.1
PR514 UK47.1
PEG-CLEARHOUSE-FEE
Element: Clearhouse Fee
Signed 11.2
PR26.1 PR47.1
PR514 UK47.1
PEG-CHFEE-OVERRIDE
Element: Chfee Override
Alpha 1
PR26.1 PR47.1
PR514 UK47.1
PEG-FIPS-CODE
Element: Fips Code
Alpha 7
PR26.1 PR47.1
PR514 UK47.1
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
UK145 UK201
UK202 UK277
UK47.1 UK47.2
UK560
PEGSET2 GARN-OBJ-ID
BN66.1 PR139
PR140 PR141
PR189 PR195
PR198 PR275
PR277 PR39.3
PR80.1 PR80.4
PR89.1 UK141
UK277 XR275
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: Wed Jun 08 20:51:10 2016

Home
Contact Us



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