|
|
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 PR141 PR198 PR275
PR39.3 UK141 PR115
UPDATED BY
PR197 PR26.1 PR26.2 PR47.1 PR47.2 PR82.1
PR85.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 Hr Identifies the AP company if the UK47.1
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PEG-EMPLOYEE Numeric 9 PR26.1 PR47.1
Element: Employee Contains the employee number. Each 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. 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 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 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 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 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 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 UK47.1
withholding the garnishment amount.
PEG-SEQ-NBR Numeric 4 PR26.1 PR47.1
Element: Sequence NumbeAn automatically assigned sequence UK47.1
number.
PEG-VENDOR Alpha 9 (Right Justified) PR26.1 PR47.1
Element: Vendor ID Contains the vendor for AP invoices 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 UK47.1
number.
PEG-ARR-ORIG-BAL Signed 13.2 PR26.1 PR47.1
Element: Arr Orig Bal Contains the beginning balance for the 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 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 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 UK47.1
number.
PEG-FEES-OVERRIDE Alpha 1 PR26.1 PR47.1
Element: Fees Override Indicates whether the fees in the XXX 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 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 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 UK47.1
code.
PEG-EFF-DATE-ORDER Numeric 8 (yyyymmdd) PR26.1 PR47.1
Element: Eff Date OrderContains the effective date of the 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Represents the number of decimals
Code defined for the currency of the object.
PEG-EXEMPT-ARRS-TD Signed 7.2 PR197 PR26.1
Element: Exempt Arrs Td PR47.1 PR82.1
PR85.1 UK47.1
PEG-EXEMPT-ARRS-TP Signed 7.2 PR197 PR82.1
Element: Exempt Arrs Tp PR85.1
PEG-DED-FREQ Alpha 1
Element: Ded Freq
PEG-DED-ARRS-TD Signed 7.2 PR197 PR26.1
Element: Ded Arrs Td PR47.1 PR82.1
PR85.1 UK47.1
PEG-DED-ARRS-TP Signed 7.2 PR197 PR82.1
Element: Ded Arrs Tp PR85.1
PEG-REMIT-TO-CODE Alpha 4 PR26.1 PR47.1
Remit To Location A user-defined code that represents a UK47.1
Code vendor's remittance address.
PREMPGARN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEGSET1 COMPANY HR11.1 PA115
EMPLOYEE PR05.1 PR197
CASE-NUMBER PR226 PR247
FILE-NUMBER PR26.1 PR26.2
PR277 PR47.1
PR47.2 PR560
PR82.1 PR85.1
UK145 UK201
UK202 UK277
UK47.1 UK47.2
PEGSET2 GARN-OBJ-ID PR141 PR198
PR275 PR277
PR39.3 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
|
