|
|
PRGARNHIST FILE
Garnishment History
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 everytime payroll is run.
Updated by PR199 (Payroll Close) and used for reporting.
REFERENCED BY
PR141 PR277 PR226
UPDATED BY
PR140 PR199 PR80.1 PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GRH-COMPANY Numeric 4 PR140 PR80.1
Company Contains the company number. PR82.1
GRH-EMPLOYEE Numeric 9 PR140 PR80.1
Employee Contains the employee number. PR82.1
GRH-CHECK-ID Numeric 12 PR140 PR80.1
Internal Check ID Contains the payment identification PR82.1 PR85.1
Number number (unique payment identifier used
in tracking payment information).
GRH-GARN-OBJ-ID Numeric 12 PR140 PR80.1
Garn Obj Id Assigned when an employee garnishment PR82.1
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 PR140 PR199
Ap Company Contains the AP company. PR80.1 PR82.1
GRH-VENDOR Alpha 9 PR140 PR199
Vendor ID The vendor's identification code. PR80.1 PR82.1
GRH-INVOICE Alpha 22 PR140 PR199
Invoice Number Used to identify the invoice. PR80.1 PR82.1
GRH-STATUS Numeric 1 PR140 PR199
Status Indicates the payment status. PR80.1 PR82.1
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 PR140 PR80.1
Disp Income Contains the disposable income PR82.1 PR85.1
calculated in PR140 (Earnings and
Deductions Calculations).
GRH-WAGES-EXEMPT Signed 9.2 PR140 PR80.1
Wages Exempt Contains the exempt wages calculated in PR82.1 PR85.1
PR140 (Earnings and Deductions
Calculations).
GRH-MSG-NBR Numeric 3 Occurs 10 Times PR140 PR80.1
Msg Nbr Contains a message number assigned in PR82.1 PR85.1
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) PR140 PR80.1
Creation Date Contains the date when PR140 (Earnings PR82.1
and Deductions Calculations) are run and
records are created.
GRH-CREATE-TIME Numeric 6 (hhmmss) PR140 PR80.1
Creation Time Contains the time when PR140 (Earnings PR82.1
and Deductions Calculations) is run and
records are created.
PRGARNHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GRHSET1 COMPANY PR140 PR141
EMPLOYEE PR199 PR80.1
CHECK-ID PR82.1 PR85.1
GARN-OBJ-ID
GRHSET2 COMPANY Subset PR277
CREATE-DATE Where STATUS = 9
EMPLOYEE
CHECK-ID
GARN-OBJ-ID
GRHSET3 COMPANY PR226 PR277
EMPLOYEE
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
Paymastr PAYMASTR Required
GRH-COMPANY -> PYM-COMPANY
GRH-EMPLOYEE -> PYM-EMPLOYEE
GRH-CHECK-ID -> PYM-CHECK-ID
|