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.

REFERENCED BY
UK277


UPDATED BY
BN66.1 PR139 PR140 PR141 PR189 PR195
PR197 PR198 PR226 PR247 PR277 PR300
PR36.1 PR45.1 PR582 PR80.1 PR80.4 PR82.1
PR85.1 PR89.1 UK141

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GRH-COMPANY
Element: Company Hr		Numeric 4
Contains the company number.
BN66.1 PR140
PR189 PR195
PR582 PR80.1
PR80.4 PR82.1
PR89.1
GRH-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee number.
BN66.1 PR140
PR189 PR195
PR582 PR80.1
PR80.4 PR82.1
PR89.1
GRH-CHECK-ID
Element: 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
PR85.1 PR89.1
GRH-GARN-OBJ-ID
Element: 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
PR89.1
GRH-AP-COMPANY
Element: Company Ap		Numeric 4
Contains the AP company.
BN66.1 PR140
PR189 PR195
PR198 PR582
PR80.1 PR80.4
PR82.1 PR89.1
GRH-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
BN66.1 PR140
PR189 PR195
PR198 PR582
PR80.1 PR80.4
PR82.1 PR89.1
GRH-INVOICE
Element: Invoice		Alpha 22
Used to identify the invoice.
BN66.1 PR140
PR189 PR195
PR198 PR582
PR80.1 PR80.4
PR82.1 PR89.1
GRH-STATUS
Element: 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
PR82.1 PR85.1
PR89.1
GRH-DISP-INCOME
Element: 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
PR85.1 PR89.1
GRH-WAGES-EXEMPT
Element: 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
PR85.1 PR89.1
GRH-MSG-NBR
Element: Msg Nbr		Numeric 3 Occurs 10 Times
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
PR85.1 PR89.1
GRH-CREATE-DATE
Element: 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
PR89.1
GRH-CREATE-TIME
Element: Sys 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
PR89.1
GRH-COURT-FEE
Element: Court Fee		Signed 11.2
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1
GRH-COURT-ARR-FEE
Element: Court Arr Fee		Signed 11.2
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1
GRH-CURRENCY-CODE
Element: 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
PR89.1
GRH-CURR-ND
Element: Acct 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
PR89.1
GRH-REMIT-TO-CODE
Element: Remit To Code		Alpha 4
A user-defined code that represents a vendor's remittance address.
PR198
GRH-DED-FROM-GARN
Element: Ded From Garn		Alpha 1
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1
GRH-CH-DED-CODE
Element: Ded Code		Alpha 4
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1
GRH-CLEARHOUSE-FEE
Element: Clearhouse Fee		Signed 11.2
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1
GRH-CHFEE-OVERRIDE
Element: Chfee Override		Alpha 1
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1
GRH-FIPS-CODE
Element: Fips Code		Alpha 7
GRH-ARR-INVOICE
Element: Invoice		Alpha 22
Used to identify the invoice.
PR198


PRGARNHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GRHSET1 COMPANY
EMPLOYEE
CHECK-ID
GARN-OBJ-ID
BN66.1 PR139
PR140 PR141
PR189 PR195
PR197 PR198
PR277 PR300
PR36.1 PR45.1
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 UK141
GRHSET2 COMPANY
CREATE-DATE
EMPLOYEE
CHECK-ID
GARN-OBJ-ID
Subset
WhereSTATUS =9
UK277
GRHSET3 COMPANY
EMPLOYEE
GARN-OBJ-ID
CREATE-DATE
CHECK-ID
BN66.1 PR139
PR140 PR189
PR195 PR226
PR247 PR277
PR80.1 PR80.4
PR89.1 UK277


PRGARNHIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
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

File created: Thu Jun 09 11:27:14 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.