|
|
PREMPGARN FILE
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 PR560 UK145
UK201 UK202 UK277 UK560 PR139 PR141
PR198 PR275 PR39.3 UK141 PR115
UPDATED BY
AC542 BN66.1 PR140 PR189 PR195 PR197
PR26.1 PR26.2 PR47.1 PR47.2 PR514 PR80.1
PR82.1 PR85.1 PR89.1 UK47.1 UK47.2 HR11.1
PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEG-COMPANY Numeric 4 PR26.1 PR47.1
Element: Company The company number represents an PR514 UK47.1
established company and is entered on
all function codes.
PEG-EMPLOYEE Numeric 9 PR26.1 PR47.1
Element: Employee Contains the employee number. Each PR514 UK47.1
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 Alpha 20 PR26.1 PR47.1
Element: Case Number Identifies the particular garnishment. PR514 UK47.1
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 Alpha 15 PR26.1 PR47.1
Element: File Number Used with the case number to identify PR514 UK47.1
the garnishment. Used to break out
different orders with same case number.
PEG-DESC Alpha 30 (Lower Case) PR26.1 PR47.1
Element: Description Contains a detail description of the PR514 UK47.1
garnishment. Used in reporting.
PEG-TAX-ID-CODE Alpha 10 PR26.1 PR47.1
Element: Tax Id Code Contains the state, county, or province PR514 UK47.1
that governs the attachment. Determines
the rules that apply to this
garnishment.
PEG-TYPE Alpha 2 PR26.1 PR47.1
Element: Type Defines the garnishment and determines PR514 UK47.1
which set of rules apply from the
Garnishment table.
PEG-GARN-OBJ-ID Numeric 12 PR26.1 PR47.1
Element: Garn Obj Id Assigned when an employee garnishment PR514 UK47.1
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 Alpha 4 PR26.1 PR47.1
Element: Deduction CodeDefines which deduction will be used in PR514 UK47.1
withholding the garnishment amount.
PEG-SEQ-NBR Numeric 4 PR26.1 PR47.1
Element: Sequence NumbeAn automatically assigned sequence PR514 UK47.1
number.
PEG-VENDOR Alpha 9 (Right Justified) PR26.1 PR47.1
Element: Vendor ID Contains the vendor for AP invoices PR514 UK47.1
created for the amount to be withheld.
PEG-ORIG-BALANCE Signed 13.2 PR26.1 PR47.1
Element: Orig Balance Contains the beginning balance for PR514 UK47.1
garnishments that are for a total amount
to be paid in installments. This is the
maximum amount that can be deducted.
PEG-EXEM-FORM Alpha 2 PR26.1 PR47.1
Element: Exem Form Defines how exempt earnings (protected PR514 UK47.1
income) is calculated. If entered, this
overrides the rules table.
PEG-RATE-X-FED-MIN Numeric 3 PR26.1 PR47.1
Element: Rate X Fed MinThis number is multiplied by the PR514 UK47.1
federal minimum wage to determine exempt
wages. If entered, this number overrides
the rules table.
PEG-FACTOR-1 Signed 7.2 PR26.1 PR47.1
Element: Factor 1 Parameter used to calculate exempt PR514 UK47.1
wages. If entered, this number overrides
the rules table.
PEG-FACTOR-2 Signed 7.2 PR26.1 PR47.1
Element: Factor 2 Parameter used to calculate the exempt PR514 UK47.1
wages. If entered, this number overrides
the rules table.
PEG-FACTOR-3 Signed 7.2 PR26.1 PR47.1
Element: Factor 3 Parameter used to calculate exempt PR514 UK47.1
wages. If entered, this number overrides
the rules table.
PEG-FACTOR-4 Signed 7.2 PR26.1 PR47.1
Element: Factor 4 Parameter used to calculate exempt PR514 UK47.1
wages. If entered, this number overrides
the rules table.
PEG-SND-FAM-YES Signed 5.2 PR26.1 PR47.1
Element: Snd Fam Yes Contains the percent to be deducted for PR514 UK47.1
employee with a second family. If
entered, this number overrides the
rules table.
PEG-SND-FAM-NO Signed 5.2 PR26.1 PR47.1
Element: Snd Fam No Contains the percent deducted if the PR514 UK47.1
employee does not have a second family.
If entered, this number overrides the
rules table.
PEG-ARR-ADD-PCT Signed 5.2 PR26.1 PR47.1
Element: Arr Add Pct Contains the additional percent if PR514 UK47.1
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 Signed 7.2 PR26.1 PR47.1
Element: Pct Per Dep Defines the amount or percent per PR514 UK47.1
dependent used to calculate exempt
earnings. If entered, this number
overrides the rules table.
PEG-CALC-TYPE Alpha 1 PR26.1 PR47.1
Element: Calculation TyDetermines if the value in the Per PR514 UK47.1
Dependent field is an amount or a
percent. If entered, this value
overrides the rules table.
A = Amount
P = Percent
PEG-NUM-OF-DEP Numeric 2 PR26.1 PR47.1
Element: Num Of Dep Contains the number of dependents. This PR514 UK47.1
can be used to calculate the wage
exception rule.
PEG-SND-FAMILY Alpha 1 PR26.1 PR47.1
Element: Snd Family Indicates whether the employee has a PR514 UK47.1
second family. This can be used to
calculate the wage exemption rule.
PEG-HEAD-OF-FAM Alpha 1 PR26.1 PR47.1
Element: Head Of Fam Indicates whether employee is the head PR514 UK47.1
of the family. This can be used to
calculate the wage exemption rule.
Y = Yes
N = No
PEG-ARR-DED-CODE Alpha 4 PR26.1 PR47.1
Element: Arr Ded Code Contains the deduction code that will PR514 UK47.1
be used to track arrears withheld for
this order.
PEG-ARR-SEQ-NBR Numeric 4 PR26.1 PR47.1
Element: Arr Seq Nbr An automatically assigned sequence PR514 UK47.1
number.
PEG-ARR-ORIG-BAL Signed 13.2 PR26.1 PR47.1
Element: Arr Orig Bal Contains the beginning balance for the PR514 UK47.1
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 Alpha 1 PR26.1 PR47.1
Element: Over 12 Weeks Indicates whether the arrears are in PR514 UK47.1
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 Alpha 4 PR26.1 PR47.1
Element: Fees Ded Code Displays the deduction description from PR514 UK47.1
the DEDCODE file for the fees deduction
if entered on Garnishment Rules.
PEG-FEES-SEQ-NBR Numeric 4 PR26.1 PR47.1
Element: Fees Seq Nbr An automatically assigned sequence PR514 UK47.1
number.
PEG-FEES-OVERRIDE Alpha 1 PR26.1 PR47.1
Element: Fees Override Indicates whether the fees in the XXX PR514 UK47.1
field override the Rules table.
PEG-EXCL-PAY-CODE Alpha 4 Occurs 30 Times PR26.1 PR47.1
Element: Excl Pay Code Excludes certain pay in calculating PR514 UK47.1
disposable income. If anything is
entered, it will override the rules
table.
PEG-EXCL-DED-CODE Alpha 4 Occurs 30 Times PR26.1 PR47.1
Element: Excl Ded Code Excludes certain deductions in PR514 UK47.1
calculating disposable income. If
anything is entered, it will override
the rules table.
PEG-COUNTRY-CODE Alpha 2 PR26.1 PR47.1
Element: Country Code Distinguishes the records by country PR514 UK47.1
code.
PEG-EFF-DATE-ORDER Numeric 8 (yyyymmdd) PR26.1 PR47.1
Element: Eff Date OrderContains the effective date of the PR514 UK47.1
order. Used as an informational field
for the user.
PEG-TAX-DED-ORDER Alpha 1 PR26.1 PR47.1
Element: Tax Ded Order Defines whether or not the order is to PR514 UK47.1
be a tax deductible order. Used to
validate tax status on deduction code.
PEG-CA-GRN-MARITAL Alpha 2 PR26.1 PR47.1
Element: Ca Grn MaritalContains the Canadian marital statuses PR514 UK47.1
for purpose of calculating wages exempt
from seizure.
PEG-BASIC-EXEMPT Signed 7.2 PR26.1 PR47.1
Element: Basic Exempt Contains the value that represents the PR514 UK47.1
basic exempt amount or percent of the
employee wages that is exempt from
seizure.
PEG-BASIC-CALC-TYP Numeric 1 PR26.1 PR47.1
Element: Basic Calc TypContains the value that determines if PR514 UK47.1
the basic exempt factor is a percent or
amount.
PEG-WAGE-LEVEL Numeric 7 PR26.1 PR47.1
Element: Wage Level Contains the starting value of a range PR514 UK47.1
of the employee wages that an
additional exempt amount is calculated
on.
PEG-ADDL-EXEMPT Signed 7.2 PR26.1 PR47.1
Element: Addl Exempt Contains the value that represents the PR514 UK47.1
additional exempt amount or percent of
the employee wages that is exempt from
seizure.
PEG-ADDL-CALC-TYPE Numeric 1 PR26.1 PR47.1
Element: Addl Calc TypeContains the value that determines if PR514 UK47.1
the additional exempt factor is a
percent or amount.
PEG-MIN-EXEMPT Signed 7.2 PR26.1 PR47.1
Element: Min Exempt Contains the value that represents the PR514 UK47.1
minimum exempt amount or percent of the
employee wages that is exempt from
seizure.
PEG-MIN-CALC-TYPE Numeric 1 PR26.1 PR47.1
Element: Min Calc Type Contains the value that determines if PR514 UK47.1
the minimum exempt factor is a percent
or amount.
PEG-MAX-EXEMPT Signed 7.2 PR26.1 PR47.1
Element: Max Exempt Contains the value that represents the PR514 UK47.1
maximum exempt amount or percent of the
employee wages that is exempt from
seizure.
PEG-MAX-CALC-TYPE Numeric 1 PR26.1 PR47.1
Element: Max Calc Type Contains the value that determines if PR514 UK47.1
the maximum exempt factor is a percent
or amount.
PEG-INCL-ADD-NET Alpha 4 Occurs 10 Times PR26.1 PR47.1
Element: Incl Add Net Contains the deduction code for the add PR514 UK47.1
to net deductions that should be
included in calculating the wages
available for garnishment.
PEG-CA-OVR-MARITAL Alpha 2 PR26.1 PR47.1
Element: Ca Ovr MaritalC1 = Single PR514 UK47.1
C2 = Married
C3 = Married w/spouse
C4 = Family
C5 = Widow
C6 = Widower
C7 = Divorced
C8 = Unmarried
PEG-DEP-CALC-TYPE Numeric 1 PR26.1 PR47.1
Element: Dep Calc Type Contains the value that determines PR514 UK47.1
whether the value in PEG-DEP-AMOUNT is
an amount or percent.
1 = Amount
2 = Percent
PEG-COURT-FEE Signed 11.2 PR26.1 PR47.1
Element: Court Fee Contains the value which determines the PR514 UK47.1
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 Numeric 1 PR26.1 PR47.1
Element: Crt Calc Type Contains the value that determines PR514 UK47.1
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 Signed 11.2 PR26.1 PR47.1
Element: Court Arr Fee Contains the value to determine the PR514 UK47.1
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 Numeric 1 PR26.1 PR47.1
Element: Arr Calc Type Contains the value that determines PR514 UK47.1
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 Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PEG-CURR-ND Numeric 1
Account Currency
Code
PEG-EXEMPT-ARRS-TD Signed 7.2 AC542 PR195
Element: Exempt Arrs Td PR197 PR26.1
PR47.1 PR514
PR82.1 PR85.1
UK47.1
PEG-EXEMPT-ARRS-TP Signed 7.2 AC542 BN66.1
Element: Exempt Arrs Tp PR140 PR189
PR195 PR197
PR80.1 PR82.1
PR85.1 PR89.1
PEG-DED-FREQ Alpha 1
Element: Ded Freq
PEG-DED-ARRS-TD Signed 7.2 AC542 PR195
Element: Ded Arrs Td PR197 PR26.1
PR47.1 PR514
PR82.1 PR85.1
UK47.1
PEG-DED-ARRS-TP Signed 7.2 AC542 BN66.1
Element: Ded Arrs Tp PR140 PR189
PR195 PR197
PR80.1 PR82.1
PR85.1 PR89.1
PEG-REMIT-TO-CODE Alpha 4 PR26.1 PR47.1
Purchase From PR514 UK47.1
Location Code
PREMPGARN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEGSET1 COMPANY AC542 HR11.1
EMPLOYEE PA115 PR05.1
CASE-NUMBER PR195 PR197
FILE-NUMBER PR226 PR247
PR26.1 PR26.2
PR277 PR47.1
PR47.2 PR514
PR560 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 PR89.1
UK141 UK277
PEGSET4 COMPANY PR115
TAX-ID-CODE
EMPLOYEE
GARN-OBJ-ID
PREMPGARN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
