|
|
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
PR141 UK141 PR277 UK277 PR226 PR247
UPDATED BY
PR197 PR198 PR45.1 PR82.1 PR85.1 PR36.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GRH-COMPANY Numeric 4 PR82.1
Element: Company Hr Contains the company number.
GRH-EMPLOYEE Numeric 9 PR82.1
Element: 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
Element: 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
Element: Company Ap Contains the AP company.
GRH-VENDOR Alpha 9 (Right Justified) PR198 PR82.1
Element: Vendor ID The vendor's identification code.
GRH-INVOICE Alpha 22 PR198 PR82.1
Element: Invoice NumberUsed to identify the invoice.
GRH-STATUS Numeric 1 PR197 PR82.1
Element: 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
Element: Disp Income Contains the disposable income
calculated in PR140 (Earnings and
Deductions Calculations).
GRH-WAGES-EXEMPT Signed 9.2 PR82.1 PR85.1
Element: 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
Element: 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
Element: 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
Element: Sys Time Contains the time when PR140 (Earnings
and Deductions Calculations) is run and
records are created.
GRH-COURT-FEE Signed 11.2
Element: Court Fee
GRH-COURT-ARR-FEE Signed 11.2
Element: Court Arr Fee
GRH-CURRENCY-CODE Alpha 5 PR82.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
GRH-CURR-ND Numeric 1 PR82.1
Account Currency Represents the number of decimals
Code defined for the currency of the object.
GRH-REMIT-TO-CODE Alpha 4 PR198
Remit To Location A user-defined code that represents a
Code vendor's remittance address.
PRGARNHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GRHSET1 COMPANY PR141 PR197
EMPLOYEE PR198 PR36.1
CHECK-ID PR45.1 PR82.1
GARN-OBJ-ID PR85.1 UK141
GRHSET2 COMPANY Subset PR277 UK277
CREATE-DATE Where STATUS = 9
EMPLOYEE
CHECK-ID
GARN-OBJ-ID
GRHSET3 COMPANY PR226 PR247
EMPLOYEE PR277 UK277
GARN-OBJ-ID
CREATE-DATE
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
|
