|
|
PREMPGARN FILE
Employee Garnishment
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 PR277 PR560 BN66.1 PR139
PR140 PR141 PR150 PR195 PR199 PR275
PR39.3 PR80.1 PR82.1 PR85.1 PR89.1 PR115
UPDATED BY
PR26.1 PR26.2 PR514
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEG-COMPANY Numeric 4 PR26.1 PR514
Company The company number represents an
established company and is entered on
all function codes.
PEG-EMPLOYEE Numeric 9 PR26.1 PR514
Employee 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 Alpha 20 PR26.1 PR514
Case Number 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 Alpha 15 PR26.1 PR514
File Number Used with the case number to identfiy
the garnishment. Used to break out
different orders with same case number.
PEG-DESC Alpha 30 (Lower Case) PR26.1 PR514
Description Contains a detail description of the
garnishment. Used in reporting.
PEG-TAX-ID-CODE Alpha 10 PR26.1 PR514
Tax Id Code Contains the state, county, or province
that governs the attachment. Determines
the rules that apply to this
garnishment.
PEG-TYPE Alpha 2 PR26.1 PR514
Type Defines the garnishment and determines
which set of rules apply from the
Garnishment table.
PEG-GARN-OBJ-ID Numeric 12 PR26.1 PR514
Garn Obj Id 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 Alpha 4 PR26.1 PR514
Deduction Code Defines which deduction will be used in
withholding the garnishment amount.
PEG-SEQ-NBR Numeric 4 PR26.1 PR514
Sequence Number An automatically assigned sequence
number.
PEG-VENDOR Alpha 9 PR26.1 PR514
Vendor ID Contains the vendor for AP invoices
created for the amount to be withheld.
PEG-ORIG-BALANCE Signed 11.2 PR26.1 PR514
Orig Balance 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 Alpha 2 PR26.1 PR514
Exem Form Defines how exempt earnings (protected
income) is calculated. If entered, this
overrides the rules table.
PEG-RATE-X-FED-MIN Numeric 3 PR26.1 PR514
Rate X Fed Min This number is multiplied by the federal
minimumwage to determine exempt wages.
If entered, this number overrides the
rules table.
PEG-FACTOR-1 Signed 7.2 PR26.1 PR514
Factor 1 Parameter used to calculate exempt
wages. If entered, this number overrides
the rules table.
PEG-FACTOR-2 Signed 7.2 PR26.1 PR514
Factor 2 Parameter used to calculate the exempt
wages. If entered, this number overrides
the rules table.
PEG-FACTOR-3 Signed 7.2 PR26.1 PR514
Factor 3 Parameter used to calculate exempt
wages. If entered, this number overrides
the rules table.
PEG-FACTOR-4 Signed 7.2 PR26.1 PR514
Factor 4 Parameter used to calculate exempt
wages. If entered, this number overrides
the rules table.
PEG-SND-FAM-YES Signed 5.2 PR26.1 PR514
Snd Fam Yes Contains the percent to be deducted for
employee with a second family. If
entered, this number overrides the
rules table.
PEG-SND-FAM-NO Signed 5.2 PR26.1 PR514
Snd Fam No 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 Signed 5.2 PR26.1 PR514
Arr Add Pct 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 Signed 7.2 PR26.1 PR514
Pct Per Dep Defines the amount or percent per
dependent used to calculate exempt
earnings. If entered, this number
overrides the rules table.
PEG-CALC-TYPE Alpha 1 PR26.1 PR514
Calculation Type 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 Numeric 2 PR26.1 PR514
Num Of Dep Contains the number of dependents. This
can be used to calculate the wage
exception rule.
PEG-SND-FAMILY Alpha 1 PR26.1 PR514
Snd Family Indicates whether the employee has a
second family. This can be used to
calculate the wage exemption rule.
PEG-HEAD-OF-FAM Alpha 1 PR26.1 PR514
Head Of Fam Indicates whether employee is the head
of the family. This can be used to
calculate the wage exeption rule.
Y = Yes
N = No
PEG-ARR-DED-CODE Alpha 4 PR26.1 PR514
Arr Ded Code Contains the deduction code that will be
used to track arrears withheld for this
order.
PEG-ARR-SEQ-NBR Numeric 4 PR26.1 PR514
Arr Seq Nbr An automatically assigned sequence
number.
PEG-ARR-ORIG-BAL Signed 11.2 PR26.1 PR514
Arr Orig Bal 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 Alpha 1 PR26.1 PR514
Over 12 Weeks Indicates whether the arrears are in
arrears more than 12 weeks. If so, a
different forumula is used.
This is used in calculating the exempt
wage formula.
Y = Yes
N = No
PEG-FEES-DED-CODE Alpha 4 PR26.1 PR514
Fees Ded Code Displays the deduction description from
the DEDCODE file for the fees deduction
if entered on Garnishment Rules.
PEG-FEES-SEQ-NBR Numeric 4 PR26.1 PR514
Fees Seq Nbr An automatically assigned sequence
number.
PEG-FEES-OVERRIDE Alpha 1 PR26.1 PR514
Fees Override Indicates whether the fees in the XXX
field override the Rules table.
PEG-EXCL-PAY-CODE Alpha 4 Occurs 30 Times PR26.1 PR514
Excl Pay Code Excludes certain pay in calculating
disposable income. If anything is
entered, it will override the rules
table.
PEG-EXCL-DED-CODE Alpha 4 Occurs 30 Times PR26.1 PR514
Excl Ded Code Excludes certain deductions in
calculating disposable income. If
anything is entered, it will override
the rules table.
PREMPGARN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEGSET1 COMPANY PR05.1 PR226
EMPLOYEE PR26.1 PR26.2
CASE-NUMBER PR277 PR514
FILE-NUMBER PR560
PEGSET2 GARN-OBJ-ID BN66.1 PR139
PR140 PR141
PR150 PR195
PR199 PR275
PR277 PR39.3
PR80.1 PR82.1
PR85.1 PR89.1
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 Not Required
PEG-COMPANY -> PGR-COMPANY
PEG-TAX-ID-CODE -> PGR-TAX-ID-CODE
GRT-GARN-CAT -> PGR-GARN-CAT
PEG-TYPE -> PGR-TYPE
Prgarntype PRGARNTYPE Required
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
|