PRGARNHIST FILE
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
BN66.1 PR139 PR141 PR195 PR89.1 PR277
PR226 PR247
UPDATED BY
PR197 PR198 PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GRH-COMPANY Numeric 4 PR82.1
Company Contains the company number.
GRH-EMPLOYEE Numeric 9 PR82.1
Employee Contains the employee number.
GRH-CHECK-ID Numeric 12 PR82.1 PR85.1
Internal Check ID Contains the payment identification
Number number (unique payment identifier used
in tracking payment information).
GRH-GARN-OBJ-ID Numeric 12 PR82.1
Garn Obj Id 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.
GRH-AP-COMPANY Numeric 4 PR198 PR82.1
Ap Company Contains the AP company.
GRH-VENDOR Alpha 9 (Right Justified) PR198 PR82.1
Vendor ID The vendor's identification code.
GRH-INVOICE Alpha 22 PR198 PR82.1
Invoice Number Used to identify the invoice.
GRH-STATUS Numeric 1 PR197 PR82.1
Status Indicates the payment status. PR85.1
Records are created with a status of
zero and are updated to a status of "9"
by PR199 (Payroll Close).
0 = Created
9 = Closed
GRH-DISP-INCOME Signed 9.2 PR82.1 PR85.1
Disp Income Contains the disposable income
calculated in PR140 (Earnings and
Deductions Calculations).
GRH-WAGES-EXEMPT Signed 9.2 PR82.1 PR85.1
Wages Exempt Contains the exempt wages calculated in
PR140 (Earnings and Deductions
Calculations).
GRH-MSG-NBR Numeric 3 Occurs 10 Times PR82.1 PR85.1
Msg Nbr 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.
GRH-CREATE-DATE Numeric 8 (yyyymmdd) PR82.1
Creation Date Contains the date when PR140 (Earnings
and Deductions Calculations) are run and
records are created.
GRH-CREATE-TIME Numeric 6 (hhmmss) PR82.1
Creation Time Contains the time when PR140 (Earnings
and Deductions Calculations) is run and
records are created.
GRH-COURT-FEE Signed 11.2
Court Fee
GRH-COURT-ARR-FEE Signed 11.2
Court Arr Fee
GRH-CURRENCY-CODE Alpha 5 PR82.1
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
GRH-CURR-ND Numeric 1 PR82.1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
PRGARNHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GRHSET1 COMPANY BN66.1 PR139
EMPLOYEE PR141 PR195
CHECK-ID PR197 PR198
GARN-OBJ-ID PR82.1 PR85.1
PR89.1
GRHSET2 COMPANY Subset PR277
CREATE-DATE Where STATUS = 9
EMPLOYEE
CHECK-ID
GARN-OBJ-ID
GRHSET3 COMPANY BN66.1 PR139
EMPLOYEE PR195 PR226
GARN-OBJ-ID PR247 PR277
CREATE-DATE PR89.1
CHECK-ID
PRGARNHIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|
