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.

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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PEGSET1COMPANY, EMPLOYEE, CASE-NUMBER, FILE-NUMBERPrimaryHR11.1, PA115, PR05.1, PR195, PR197, PR226, PR247, PR26.1 +10 more
PEGSET2GARN-OBJ-IDBN66.1, PR139, PR140, PR141, PR189, PR195, PR198, PR275 +6 more
PEGSET4COMPANY, TAX-ID-CODE, EMPLOYEE, GARN-OBJ-IDPR115, PR25.2

Relations

One to one (11) — lookups and parents

RelationTableRulesConditionField map
Arr DedDEDCODERequiredPEG-COMPANY → DDC-COMPANY, PEG-ARR-DED-CODE → DDC-DED-CODE
Arr EmdedEMDEDMASTRRequiredPEG-COMPANY → EDM-COMPANY, PEG-EMPLOYEE → EDM-EMPLOYEE, PEG-ARR-DED-CODE → EDM-DED-CODE, PEG-ARR-SEQ-NBR → EDM-SEQ-NBR
EmployeeEMPLOYEERequiredPEG-COMPANY → EMP-COMPANY, PEG-EMPLOYEE → EMP-EMPLOYEE
Fees DedDEDCODERequiredPEG-COMPANY → DDC-COMPANY, PEG-FEES-DED-CODE → DDC-DED-CODE
Fees EmdedEMDEDMASTRRequiredPEG-COMPANY → EDM-COMPANY, PEG-EMPLOYEE → EDM-EMPLOYEE, PEG-FEES-DED-CODE → EDM-DED-CODE, PEG-FEES-SEQ-NBR → EDM-SEQ-NBR
Garn DedDEDCODERequiredPEG-COMPANY → DDC-COMPANY, PEG-DED-CODE → DDC-DED-CODE
Garn EmdedEMDEDMASTRRequiredPEG-COMPANY → EDM-COMPANY, PEG-EMPLOYEE → EDM-EMPLOYEE, PEG-DED-CODE → EDM-DED-CODE, PEG-SEQ-NBR → EDM-SEQ-NBR
Garn RulePRGARNRULERequiredPEG-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
PrgarntypePRGARNTYPERequiredPEG-COUNTRY-CODE → GRT-COUNTRY-CODE, PEG-TYPE → GRT-TYPE
PrsystemPRSYSTEMRequiredPEG-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
PrtaxauthPRTAXAUTHRequiredPEG-TAX-ID-CODE → PRX-TAX-ID-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
Emp Garn HistPRGARNHISTPEG-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)