PREMPGARN – Used to store information to identify a particular garnishment per employee per company.

System
Payroll (PR)
Prefix
PEG
Primary key
COMPANY, EMPLOYEE, CASE-NUMBER, FILE-NUMBER
Fields
70
Updated by
12 programs
Referenced by
20 programs

PREMPGARN is the Used to store information to identify a particular garnishment per employee per company. table in Lawson Payroll (prefix PEG). It is indexed by COMPANY, EMPLOYEE, CASE-NUMBER, FILE-NUMBER (PEGSET1); alternate indexes: PEGSET2 and PEGSET4. It is related 1:1 to DEDCODE, EMDEDMASTR, EMPLOYEE, PRGARNRULE, PRGARNTYPE, PRSYSTEM and PRTAXAUTH and 1:M to PRGARNHIST. It is updated by HR11.1, PA115, PR195, PR197, PR26.1, PR26.2, PR47.1, PR47.2 and 4 more and referenced by BN66.1, PR05.1, PR115, PR139, PR140, PR141, PR189, PR198 and 12 more. The table has 70 fields, 3 indexes and 12 documented relations.

About 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.

Fields (70)

Column = COBOL field name without the PEG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PEG-COMPANY PK
COMPANY		Numeric 4—PR26.1, PR47.1, PR514
#PEG-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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 PK
CASE_NUMBER		Alpha 20Identifies 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 PK
FILE_NUMBER		Alpha 15Used 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
DESC		Alpha 30 (Lower Case)Contains a detail description of the garnishment. Used in reporting.PR26.1, PR47.1, PR514
#PEG-TAX-ID-CODE SET4
TAX_ID_CODE		Alpha 10Contains the state, county, or province that governs the attachment. Determines the rules that apply to this garnishment.PR26.1, PR47.1, PR514
#PEG-TYPE
TYPE		Alpha 2Defines the garnishment and determines which set of rules apply from the Garnishment table.PR26.1, PR47.1, PR514
#PEG-GARN-OBJ-ID SET2 SET4
GARN_OBJ_ID		Numeric 12Assigned 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
DED_CODE		Alpha 4Defines which deduction will be used in withholding the garnishment amount.PR26.1, PR47.1, PR514
#PEG-SEQ-NBR
SEQ_NBR		Numeric 4An automatically assigned sequence number.PR26.1, PR47.1, PR514
#PEG-VENDOR
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
ORIG_BALANCE		Signed 13.2Contains 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
EXEM_FORM		Alpha 2Defines how exempt earnings (protected income) is calculated. If entered, this overrides the rules table.PR26.1, PR47.1, PR514
#PEG-RATE-X-FED-MIN
RATE_X_FED_MIN		Numeric 3This 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
FACTOR_1		Signed 7.2Parameter used to calculate exempt wages. If entered, this number overrides the rules table.PR26.1, PR47.1, PR514
#PEG-FACTOR-2
FACTOR_2		Signed 7.2Parameter used to calculate the exempt wages. If entered, this number overrides the rules table.PR26.1, PR47.1, PR514
#PEG-FACTOR-3
FACTOR_3		Signed 7.2Parameter used to calculate exempt wages. If entered, this number overrides the rules table.PR26.1, PR47.1, PR514
#PEG-FACTOR-4
FACTOR_4		Signed 7.2Parameter used to calculate exempt wages. If entered, this number overrides the rules table.PR26.1, PR47.1, PR514
#PEG-SND-FAM-YES
SND_FAM_YES		Signed 5.2Contains 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
SND_FAM_NO		Signed 5.2Contains 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
ARR_ADD_PCT		Signed 5.2Contains 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
PCT_PER_DEP		Signed 7.2Defines 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
CALC_TYPE		Alpha 1Determines 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
NUM_OF_DEP		Numeric 2Contains the number of dependents. This can be used to calculate the wage exception rule.PR26.1, PR47.1, PR514
#PEG-SND-FAMILY
SND_FAMILY		Alpha 1Indicates 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
HEAD_OF_FAM		Alpha 1Indicates 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
ARR_DED_CODE		Alpha 4Contains the deduction code that will be used to track arrears withheld for this order.PR26.1, PR47.1, PR514
#PEG-ARR-SEQ-NBR
ARR_SEQ_NBR		Numeric 4An automatically assigned sequence number.PR26.1, PR47.1, PR514
#PEG-ARR-ORIG-BAL
ARR_ORIG_BAL		Signed 13.2Contains 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
OVER_12_WEEKS		Alpha 1Indicates 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
FEES_DED_CODE		Alpha 4Displays 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
FEES_SEQ_NBR		Numeric 4An automatically assigned sequence number.PR26.1, PR47.1, PR514
#PEG-FEES-OVERRIDE
FEES_OVERRIDE		Alpha 1Indicates whether the fees in the XXX field override the Rules table.PR26.1, PR47.1, PR514
#PEG-EXCL-PAY-CODE
EXCL_PAY_CODE		Alpha 4 Occurs 30 Times ×30Excludes 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
EXCL_DED_CODE		Alpha 4 Occurs 30 Times ×30Excludes certain deductions in calculating disposable income. If anything is entered, it will override the rules table.PR26.1, PR47.1, PR514
#PEG-COUNTRY-CODE
COUNTRY_CODE		Alpha 2Distinguishes the records by country code.PR26.1, PR47.1, PR514
#PEG-EFF-DATE-ORDER
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
TAX_DED_ORDER		Alpha 1Defines 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
CA_GRN_MARITAL		Alpha 2Contains the Canadian marital statuses for purpose of calculating wages exempt from seizure.PR26.1, PR47.1, PR514
#PEG-BASIC-EXEMPT
BASIC_EXEMPT		Signed 7.2Contains 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
BASIC_CALC_TYP		Numeric 1Contains the value that determines if the basic exempt factor is a percent or amount.PR26.1, PR47.1, PR514
#PEG-WAGE-LEVEL
WAGE_LEVEL		Numeric 7Contains 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
ADDL_EXEMPT		Signed 7.2Contains 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
ADDL_CALC_TYPE		Numeric 1Contains the value that determines if the additional exempt factor is a percent or amount.PR26.1, PR47.1, PR514
#PEG-MIN-EXEMPT
MIN_EXEMPT		Signed 7.2Contains 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
MIN_CALC_TYPE		Numeric 1Contains the value that determines if the minimum exempt factor is a percent or amount.PR26.1, PR47.1, PR514
#PEG-MAX-EXEMPT
MAX_EXEMPT		Signed 7.2Contains 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
MAX_CALC_TYPE		Numeric 1Contains the value that determines if the maximum exempt factor is a percent or amount.PR26.1, PR47.1, PR514
#PEG-INCL-ADD-NET
INCL_ADD_NET		Alpha 4 Occurs 10 Times ×10Contains 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
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
DEP_CALC_TYPE		Numeric 1Contains 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
COURT_FEE		Signed 11.2Contains 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
CRT_CALC_TYPE		Numeric 1Contains 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
COURT_ARR_FEE		Signed 11.2Contains 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
ARR_CALC_TYPE		Numeric 1Contains 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
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).—
#PEG-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.—
#PEG-EXEMPT-ARRS-TD
EXEMPT_ARRS_TD		Signed 7.2—PR195, PR197, PR582, PR82.1, PR85.1
#PEG-EXEMPT-ARRS-TP
EXEMPT_ARRS_TP		Signed 7.2—PR195, PR197, PR582, PR82.1, PR85.1
#PEG-DED-FREQ
DED_FREQ		Alpha 1——
#PEG-DED-ARRS-TD
DED_ARRS_TD		Signed 7.2—PR195, PR197, PR582, PR82.1, PR85.1
#PEG-DED-ARRS-TP
DED_ARRS_TP		Signed 7.2—PR195, PR197, PR582, PR82.1, PR85.1
#PEG-REMIT-TO-CODE
REMIT_TO_CODE		Alpha 4A user-defined code that represents a vendor's remittance address.PR26.1, PR47.1, PR514
#PEG-DED-FROM-GARN
DED_FROM_GARN		Alpha 1—PR26.1, PR47.1, PR514
#PEG-CH-DED-CODE
CH_DED_CODE		Alpha 4—PR26.1, PR47.1, PR514
#PEG-CLEARHOUSE-FEE
CLEARHOUSE_FEE		Signed 11.2—PR26.1, PR47.1, PR514
#PEG-CHFEE-OVERRIDE
CHFEE_OVERRIDE		Alpha 1—PR26.1, PR47.1, PR514
#PEG-FIPS-CODE
FIPS_CODE		Alpha 7—PR26.1, PR47.1, PR514
#PEG-MED-DED-CODE
MED_DED_CODE		Alpha 4——
#PEG-SUPP-PRIORITY
SUPP_PRIORITY		Numeric 1——

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PEGSET1
  1. COMPANY
  2. EMPLOYEE
  3. CASE-NUMBER
  4. FILE-NUMBER
PrimaryHR11.1, PA115, PR05.1, PR195, PR197, PR226, PR247, PR26.1 +10 more
PEGSET2
  1. GARN-OBJ-ID
BN66.1, PR139, PR140, PR141, PR189, PR195, PR198, PR275 +6 more
PEGSET4
  1. COMPANY
  2. TAX-ID-CODE
  3. EMPLOYEE
  4. GARN-OBJ-ID
PR115, PR25.2

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
DEDCODEEMDEDMASTREMPLOYEEPRGARNRULEPRGARNTYPEPRSYSTEMPRTAXAUTHPRGARNHISTPREMPGARN

One to one (11) — lookups and parents

RelationTableRulesConditionField map
Arr DedDEDCODERequired
PEG-COMPANY→DDC-COMPANY
PEG-ARR-DED-CODE→DDC-DED-CODE
Arr EmdedEMDEDMASTRRequired
PEG-COMPANY→EDM-COMPANY
PEG-EMPLOYEE→EDM-EMPLOYEE
PEG-ARR-DED-CODE→EDM-DED-CODE
PEG-ARR-SEQ-NBR→EDM-SEQ-NBR
EmployeeEMPLOYEERequired
PEG-COMPANY→EMP-COMPANY
PEG-EMPLOYEE→EMP-EMPLOYEE
Fees DedDEDCODERequired
PEG-COMPANY→DDC-COMPANY
PEG-FEES-DED-CODE→DDC-DED-CODE
Fees EmdedEMDEDMASTRRequired
PEG-COMPANY→EDM-COMPANY
PEG-EMPLOYEE→EDM-EMPLOYEE
PEG-FEES-DED-CODE→EDM-DED-CODE
PEG-FEES-SEQ-NBR→EDM-SEQ-NBR
Garn DedDEDCODERequired
PEG-COMPANY→DDC-COMPANY
PEG-DED-CODE→DDC-DED-CODE
Garn EmdedEMDEDMASTRRequired
PEG-COMPANY→EDM-COMPANY
PEG-EMPLOYEE→EDM-EMPLOYEE
PEG-DED-CODE→EDM-DED-CODE
PEG-SEQ-NBR→EDM-SEQ-NBR
Garn RulePRGARNRULERequired
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
PrgarntypePRGARNTYPERequired
PEG-COUNTRY-CODE→GRT-COUNTRY-CODE
PEG-TYPE→GRT-TYPE
PrsystemPRSYSTEMRequired
PEG-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
PrtaxauthPRTAXAUTHRequired
PEG-TAX-ID-CODE→PRX-TAX-ID-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
Emp Garn HistPRGARNHIST
PEG-COMPANY→GRH-COMPANY
PEG-EMPLOYEE→GRH-EMPLOYEE
PEG-GARN-OBJ-ID→GRH-GARN-OBJ-ID
—→GRH-CREATE-DATE
—→GRH-CHECK-ID

Programs

Updated by (12)

Referenced by (20)