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
PR139 PR141 PR226 PR247


UPDATED BY
BN66.1 PR140 PR189 PR195 PR197 PR198
PR300 PR45.1 PR582 PR80.1 PR80.4 PR82.1
PR85.1 PR89.1 PRAT.1 PR277 PR36.1 PR36.4

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 PRAT.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 PRAT.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
PRAT.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 PRAT.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
PRAT.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
PRAT.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
PRAT.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 PRAT.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
PRAT.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
PRAT.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
PRAT.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 PRAT.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 PRAT.1
GRH-COURT-FEE
Element: Court Fee
Signed 11.2
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
GRH-COURT-ARR-FEE
Element: Court Arr Fee
Signed 11.2
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.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 PRAT.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 PRAT.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 PRAT.1
GRH-CH-DED-CODE
Element: Ded Code
Alpha 4
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
GRH-CLEARHOUSE-FEE
Element: Clearhouse Fee
Signed 11.2
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
GRH-CHFEE-OVERRIDE
Element: Chfee Override
Alpha 1
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.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 PR36.4
PR45.1 PR80.1
PR80.4 PR82.1
PR85.1 PR89.1
PRAT.1
GRHSET2 COMPANY
CREATE-DATE
EMPLOYEE
CHECK-ID
GARN-OBJ-ID
Subset
WhereSTATUS =9
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 PRAT.1


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 02:30:35 2016

Home
Contact Us



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