|
|
PRCHECK FILE
Employee Payment
This file contains pay receipts, void payments, system payments, and manual
payments and adjustments for a bank account. PR160 (Payment Print) is the
primary program that updates this file. It creates a pay receipt or system
payment for every Employee Payment Master file record created in PR140
(Earnings and Deductions Calculation). PR160 (Payment Print) also uses this
file to determine if a consecutive range of payments is available for the
payment run.
PR81.1 (Manual Payment Reservation) reserves payment numbers for manual
payments and voids. PR80.1 (Manual Payment) changes a reserved payment into a
system payment and links it to the manual payment (Employee Payments Master
file record). The system does not use void payments.
When the system creates prenotifications for an ACH account, this file
requires a record to accommodate recreating a tape that includes
prenotifications.
REFERENCED BY
HR00.1 HR01.1 PBIP.1 PR01.1 PR162 HR170
HR70.1 PR141 PR142 PR150 PR275 PR277
PR285 PR295 PR50.2 PR51.1
UPDATED BY
PR140 PR155 PR160 PR165 PR180 PR199
PR300 PR36.1 PR45.1 PR560 PR80.1 PR81.1
PR85.1 PR86.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCH-BNK-ACCT-NBR Alpha 17 PR160 PR180
Bank Account Number Contains the bank account from the bank PR560 PR81.1
code on which the payment is drawn. This PR85.1
field along with the payment ID serves
as the link to the Employee Payments
Master file record.
PCH-PRINT-TYPE Alpha 1 PR160 PR180
Print Type Contains the value that identifies the PR560 PR80.1
kind of record in the file. All physical PR81.1 PR85.1
payment records, Manual or System, have PR86.1
a print type of C (Check). All ACH
receipt records have a print type of R
(Pay Receipt). All other records, D
(Deposit), I (Interest), W (Withdrawal)
or J (Adjustment) have a print type of O
(Other).
PR160 (Payment Print) uses this field
to determine the availability of a
consecutive range of payment and receipt
numbers for printing.
C = Check
O = Other
R = Pay Receipt
PCH-CHECK-NBR Numeric 8 PR142 PR160
Payment Number Contains the number that prints on the PR180 PR560
payment. For system payments, the number PR81.1 PR85.1
is determined by the beginning payment PR86.1
number entered in PR160 (Payment Print).
Manual payments use payment numbers
reserved in PR81.1 (Manual Payment
Reservation).
PCH-CHECK-ID Numeric 12 PR160 PR180
Internal Check ID When a payment is created, the payment PR560 PR81.1
Number identification number from the Check ID PR85.1 PR86.1
field in the Employee Payments Master
file is moved to this field to serve
as a link to the Employee Payment file
record.
PCH-CHECK-TYPE Alpha 1 PR142 PR160
Payment Type Contains the payment type. PR180 PR560
A = ACH Receipt PR81.1 PR85.1
D = Deposit PR86.1
I = Interest
J = Adjustment
M = Manual Payment
P = Prenotification
S = System Payment
W = Withdrawal
PCH-COMPANY Numeric 4 PR160 PR180
Company The company number represents an PR560 PR80.1
established company and is entered on PR81.1
all function codes.
PCH-EMPLOYEE Numeric 9 PR160 PR560
Employee Contains the employee number. A unique PR80.1
employee number is assigned to each
person employed, and is used to
correlate all information related to
that person.
PCH-CHECK-DATE Numeric 8 (yyyymmdd) PR155 PR160
Payment Date Contains the date of the payment, with PR180 PR560
one exception. For payments with status PR80.1 PR81.1
7 (Void Reversal), it contains the void PR85.1 PR86.1
date of the payment being reversed.
PCH-STATUS Numeric 1 PR140 PR155
Status Contains the payment status. There are PR160 PR162
several status flows for records in this PR165 PR180
file: PR199 PR560
PR80.1 PR81.1
Payment Type M (Manual Payment) records PR85.1 PR85.2
have Status 9 (Reserved Manual) when you PR86.1
reserve the payment number in PR81.1
(Manual Payment Reservation). The status
changes to 1 (Created) when you create
the payment via PR80.1 (Manual Payment),
and to 2 (Open) when you run PR199
(Payroll Close).
Payment Types A (ACH Receipt) and S
(System Payment) receive status 1
(Created) when you run PR160 (Payment
Print). The status changes to 2 (Open)
when you run PR199.
When payment record types, M (Manual
Payment), A (ACH Receipt), or S (System
Payment) are reconciled via PR85.1 (Bank
Account Reconciliation) or PR165 (Bank
Reconciliation Tape Processing), the
status changes to 3 (Reconciled).
When any payment record is voided after
you run PR199 (Payroll Close), the
status changes to 3 (Reconciled) and a
reversal record with status 7 (Void
Reversal) is created.
When any payment record is re-opened
using PR85.1, the status is changed back
to 2 (Open).
When any payment record is voided
prior to closing via PR160 (Payment
Print), PR140 (Earnings and Deductions
Calculation), PR36.1 (Time Record
Entry), or PR45.1 (Error Processing),
the status changes to 5 (Temporary
Void). When you run PR199, all status 5
records change to 4 (Void).
Alignment payments or payments voided
using PR81.1 are created with status 5
(Temporary Void). When you run PR199,
the status changes to 4 (Void).
PR140 changes the payment status for
payments in error, to 5 (Temporary Void)
when you run PR140 for errors only.
All non-payment records, types J
(Adjustment), W (Withdrawal), D
(Deposit), or I (Interest), are created
with status 3 (Reconciled).
Type P (Prenotification) records are
created with status 8 (Prenotification).
1 = Created
2 = Open
3 = Reconciled
4 = Void
5 = Temporary Void
7 = Void Reversal
8 = Prenotification
9 = Reserved Manual
PCH-CHECK-AMOUNT Signed 11.2 PR140 PR160
Payment Amount Contains the actual amount for which a PR162 PR560
payment is created. This amount comes PR80.1 PR85.1
from the Check Net field of the Employee PR86.1
Payments Master file.
ACH amounts are not included.
PCH-RECON-PRT-ST Numeric 1 PR155 PR85.1
Reconciliation Contains the value that indicates PR86.1
Print Status whether or not the payment printed when
you ran PR155 (Bank Reconciliation) with
Update option.
Not printed = 0
Printed = 1
PCH-CHECK-SUF Numeric 2 PR85.1
Payment Suffix Contains the payment suffix, defined in
PR85.1 (Bank Account Reconciliation).
The payment suffix further identifies
types J (Adjustment), W (Withdrawal), I
(Interest), and D (Deposit) bank account
transactions that occur outside the
payroll system.
PCH-RECON-DATE Numeric 8 (yyyymmdd) PR140 PR155
Reconciliation or Contains the void or reconciliation PR160 PR162
Void Date date for any payment records that have PR165 PR180
been voided or reconciled. PR199 PR81.1
PR85.1 PR86.1
For status 7 (Void Reversal) records
this is the payment date of the payment
being reversed.
PCH-RECON-AMOUNT Signed 11.2 PR140 PR155
Reconciled Amount Contains the reconciled amount. PR160 PR162
PR165 PR180
PR199 PR85.1
PR86.1
PCH-SERIAL-NBR Numeric 6 PR160 PR86.1
Payment Run Serial Contains the automatically sequenced
Number serial number that identifies records
created in the same run of PR160
(Payment Print).
PCH-PROCESS-LEVEL Alpha 5 PR160 PR80.1
Process Level When you create a payment, the process
level from the Process Level field in
the Employee Payments Master file is
moved to this field. This field is then
used to determine if a payment is
printed when you run PR162 (Payment
Register) by process level.
PCH-REVERSAL-ID Numeric 8 PR155 PR162
Reversal Check ID Contains the payment identification PR85.1
number of a status 7 (Void Reversal)
payment record that was created to
reflect the reversing payroll
information of a payment voided in
PR85.1 (Bank Account Reconciliation).
If this is the status 7 (Void Reversal)
record itself, this field contains the
payment identification number of the
actual payment record being reversed.
PCH-CURRENT-FLAG Alpha 1 PR160 PR180
Current Flag Contains the value that identifies PR199 PR80.1
current cycle payments. PR81.1 PR85.1
When a payment record is created via
PR80.1 (Manual Payment) and PR160
(Payment Print), or when a payment is
voided using PR85.1 (Bank Account
Reconciliation), this flag is set to Y
(Yes) to identify them as current cycle
payments.
PR162 (Payment Register) uses this flag
when printing current payments only.
When you run PR199, the Y (Yes) is
changed to spaces.
Y = Yes
N = No
PCH-VOID-IND Alpha 1 PR160 PR180
Type of Void Contains the value that identifies the PR81.1
payment as an alignment or void payment.
All other records have blanks in this
field.
A = Alignment Check
V = PR81 Void
PCH-TYPE-1 Derived
Type 1
PRCHECK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCHSET1 BNK-ACCT-NBR HR00.1 HR01.1
PRINT-TYPE PBIP.1 PR01.1
CHECK-NBR PR155 PR160
CHECK-ID PR165 PR180
PR560 PR80.1
PR80.2 PR81.1
PR85.1 PR86.1
PCHSET2 COMPANY KeyChange PR160 PR180
SERIAL-NBR
BNK-ACCT-NBR
CHECK-TYPE
CHECK-NBR
CHECK-ID
PCHSET3 BNK-ACCT-NBR KeyChange, Subset PR85.1
CHECK-NBR Where STATUS > 1
CHECK-SUF
CHECK-TYPE
CHECK-ID
PCHSET4 STATUS KeyChange PR160 PR162
COMPANY PR199 PR81.1
BNK-ACCT-NBR PR86.1
CHECK-TYPE
CHECK-NBR
CHECK-ID
PCHSET5 COMPANY KeyChange HR170 HR70.1
CHECK-ID PR140 PR141
PR142 PR150
PR160 PR180
PR199 PR275
PR277 PR285
PR295 PR300
PR36.1 PR45.1
PR50.2 PR51.1
PR560 PR80.2
PR85.1
PCHSET6 COMPANY KeyChange PR155 PR162
BNK-ACCT-NBR PR85.2
CHECK-DATE
CHECK-NBR
CHECK-ID
PCHSET7 BNK-ACCT-NBR KeyChange
CHECK-NBR*
CHECK-SUF
CHECK-ID
CHECK-TYPE
PCHSET8 BNK-ACCT-NBR PR160
PRINT-TYPE
CHECK-NBR*
CHECK-ID
PRCHECK FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bank Account BANKACCT Required
PCH-BNK-ACCT-NBR -> BAC-BNK-ACCT-NBR
Company PRSYSTEM Required
PCH-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
When PCH-EMPLOYEE != Zeroes
PCH-COMPANY -> EMP-COMPANY
PCH-EMPLOYEE -> EMP-EMPLOYEE
Paymastr PAYMASTR Not Required
PCH-COMPANY -> PYM-COMPANY
PCH-EMPLOYEE -> PYM-EMPLOYEE
PCH-CHECK-ID -> PYM-CHECK-ID
PRCHECK FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Praudit PRAUDIT
Valid When PCH-CHECK-TYPE = "M"
PCH-COMPANY -> PRU-COMPANY
PCH-BNK-ACCT-NBR -> PRU-BNK-ACCT-NBR
PCH-CHECK-NBR -> PRU-CHECK-NBR
PCH-CHECK-ID -> PRU-CHECK-ID
PRU-SEQ-NBR
|