PRGARNHIST – Contains the history for a particular garnishment (case number and file number).

System: Payroll (PR)
Prefix: GRH
Primary key: COMPANY, EMPLOYEE, CHECK-ID, GARN-OBJ-ID
Fields: 24
Updated by: 18 programs
Referenced by: 4 programs

PRGARNHIST is the Contains the history for a particular garnishment (case number and file number). table in Lawson Payroll (prefix GRH). It is indexed by COMPANY, EMPLOYEE, CHECK-ID, GARN-OBJ-ID (GRHSET1); alternate indexes: GRHSET2 and GRHSET3. It is related 1:1 to APINVOICE, PRSYSTEM, EMPLOYEE and PAYMASTR. It is updated by BN66.1, PR140, PR189, PR195, PR197, PR198, PR277, PR300 and 10 more and referenced by PR139, PR141, PR226 and PR247. The table has 24 fields, 3 indexes and 5 documented relations.

About PRGARNHIST

Contains the history for a particular garnishment (case number and file number). It is used to link a garnishment to AP payment information. A new record is created every time payroll is run. Updated by PR199 (Payroll Close) and used for reporting.

Fields (24)

Column = COBOL field name without the GRH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`GRH-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	BN66.1, PR140, PR189, PR195, PR582, PR80.1, PR80.4, PR82.1 +2 more
`GRH-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number.	BN66.1, PR140, PR189, PR195, PR582, PR80.1, PR80.4, PR82.1 +2 more
`GRH-CHECK-ID` PK CHECK_ID	Numeric 12	Contains the payment identification number (unique payment identifier used in tracking payment information).	BN66.1, PR140, PR189, PR195, PR582, PR80.1, PR80.4, PR82.1 +3 more
`GRH-GARN-OBJ-ID` PK GARN_OBJ_ID	Numeric 12	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.	BN66.1, PR140, PR189, PR195, PR582, PR80.1, PR80.4, PR82.1 +2 more
`GRH-AP-COMPANY` AP_COMPANY	Numeric 4	Contains the AP company.	BN66.1, PR140, PR189, PR195, PR198, PR582, PR80.1, PR80.4 +3 more
`GRH-VENDOR` VENDOR	Alpha 9 (Right Justified)	The vendor's identification code.	BN66.1, PR140, PR189, PR195, PR198, PR582, PR80.1, PR80.4 +3 more
`GRH-INVOICE` INVOICE	Alpha 22	Used to identify the invoice.	BN66.1, PR140, PR189, PR195, PR198, PR582, PR80.1, PR80.4 +3 more
`GRH-STATUS` STATUS	Numeric 1	Indicates the payment status. Records are created with a status of zero and are updated to a status of "9" by PR199 (Payroll Close). `0` Created `9` Closed	BN66.1, PR140, PR189, PR195, PR197, PR582, PR80.1, PR80.4 +4 more
`GRH-DISP-INCOME` DISP_INCOME	Signed 9.2	Contains the disposable income calculated in PR140 (Earnings and Deductions Calculations).	BN66.1, PR140, PR189, PR195, PR582, PR80.1, PR80.4, PR82.1 +3 more
`GRH-WAGES-EXEMPT` WAGES_EXEMPT	Signed 9.2	Contains the exempt wages calculated in PR140 (Earnings and Deductions Calculations).	BN66.1, PR140, PR189, PR195, PR582, PR80.1, PR80.4, PR82.1 +3 more
`GRH-MSG-NBR` MSG_NBR	Numeric 3 Occurs 10 Times ×10	Contains a message number assigned in PR140 (Earnings and Deductions Calculations) for garnishment history. Messages are stored in Message Maintenance (msgmnt) for category PRGAR. PRGARNPD and PR140 access these messages.	BN66.1, PR140, PR189, PR195, PR582, PR80.1, PR80.4, PR82.1 +3 more
`GRH-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	Contains the date when PR140 (Earnings and Deductions Calculations) are run and records are created.	BN66.1, PR140, PR189, PR195, PR582, PR80.1, PR80.4, PR82.1 +2 more
`GRH-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	Contains the time when PR140 (Earnings and Deductions Calculations) is run and records are created.	BN66.1, PR140, PR189, PR195, PR582, PR80.1, PR80.4, PR82.1 +2 more
`GRH-COURT-FEE` COURT_FEE	Signed 11.2	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
`GRH-COURT-ARR-FEE` COURT_ARR_FEE	Signed 11.2	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
`GRH-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	BN66.1, PR140, PR189, PR195, PR582, PR80.1, PR80.4, PR82.1 +2 more
`GRH-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	BN66.1, PR140, PR189, PR195, PR582, PR80.1, PR80.4, PR82.1 +2 more
`GRH-REMIT-TO-CODE` REMIT_TO_CODE	Alpha 4	A user-defined code that represents a vendor's remittance address.	PR198
`GRH-DED-FROM-GARN` DED_FROM_GARN	Alpha 1	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
`GRH-CH-DED-CODE` CH_DED_CODE	Alpha 4	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
`GRH-CLEARHOUSE-FEE` CLEARHOUSE_FEE	Signed 11.2	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
`GRH-CHFEE-OVERRIDE` CHFEE_OVERRIDE	Alpha 1	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
`GRH-FIPS-CODE` FIPS_CODE	Alpha 7	—	—
`GRH-ARR-INVOICE` ARR_INVOICE	Alpha 22	Used to identify the invoice.	PR198

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`GRHSET1`	`COMPANY`, `EMPLOYEE`, `CHECK-ID`, `GARN-OBJ-ID`	Primary		BN66.1, PR139, PR140, PR141, PR189, PR195, PR197, PR198 +11 more
`GRHSET2`	`COMPANY`, `CREATE-DATE`, `EMPLOYEE`, `CHECK-ID`, `GARN-OBJ-ID`	Subset	Where STATUS = 9	—
`GRHSET3`	`COMPANY`, `EMPLOYEE`, `GARN-OBJ-ID`, `CREATE-DATE`, `CHECK-ID`			BN66.1, PR139, PR140, PR189, PR195, PR226, PR247, PR277 +4 more

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Condition	Field map
Arr Invoice	APINVOICE	Not Required	Valid When (GRH-ARR-INVOICE != Spaces)	`GRH-AP-COMPANY` → `API-COMPANY`, `GRH-VENDOR` → `API-VENDOR`, `GRH-ARR-INVOICE` → `API-INVOICE`, `Zeroes` → `API-SUFFIX`, `Zeroes` → `API-CANCEL-SEQ`
Company	PRSYSTEM	Required		`GRH-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee	EMPLOYEE	Required		`GRH-COMPANY` → `EMP-COMPANY`, `GRH-EMPLOYEE` → `EMP-EMPLOYEE`
Invoice	APINVOICE	Not Required	Valid When (GRH-INVOICE != Spaces)	`GRH-AP-COMPANY` → `API-COMPANY`, `GRH-VENDOR` → `API-VENDOR`, `GRH-INVOICE` → `API-INVOICE`, `Zeroes` → `API-SUFFIX`, `Zeroes` → `API-CANCEL-SEQ`
Paymastr	PAYMASTR	Required		`GRH-COMPANY` → `PYM-COMPANY`, `GRH-EMPLOYEE` → `PYM-EMPLOYEE`, `GRH-CHECK-ID` → `PYM-CHECK-ID`

Programs

Updated by (18)

BN66.1 Estimated Pay Calculation
PR140 Earnings and Deductions Calculation
PR189 Gross Up Calculation
PR195 Accrual Program
PR197 Payroll Close
PR198 General Ledger Posting
PR277 Garnishment History Report
PR300 History Purge
PR36.1 Time Record Entry
PR36.4 Manual Time Record Maintenance
PR45.1 Error Processing
PR582 Mass Adjustment Load
PR80.1 Manual Check
PR80.4 Manual Payment
PR82.1 Adjustment
PR85.1 Bank Account Reconciliation
PR89.1 Payment Modeling
PRAT.1 Alltax connection test

Referenced by (4)

PR139 Arrears Automation
PR141 Payroll Register
PR226 United States Employee Garnishment Listing
PR247 Canada Employee Garnishment Listing