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 PR01.1 PR162 BN66.1 HR170
HR70.1 PR139 PR141 PR142 PR195 PR275
PR277 PR295 PR50.2 PR51.1 PR89.1
UPDATED BY
PR155 PR165 PR197 PR300 PR36.1 PR45.1
PR560 PR81.1 PR85.1 PR86.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCH-BNK-ACCT-NBR Alpha 17 PR560 PR81.1
Bank Account Number Contains the bank account from the bank PR85.1
code on which the payment is drawn. This
field along with the payment ID serves
as the link to the Employee Payments
Master file record.
PCH-PRINT-TYPE Alpha 1 PR560 PR81.1
Print Type Contains the value that identifies the PR85.1 PR86.1
kind of record in the file. All physical
payment records, Manual or System, have
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 PR560
Payment Number Contains the number that prints on the PR81.1 PR85.1
payment. For system payments, the number PR86.1
is determined by the beginning payment
number entered in PR160 (Payment Print).
Manual payments use payment numbers
reserved in PR81.1 (Manual Payment
Reservation).
PCH-CHECK-ID Numeric 12 PR560 PR81.1
Internal Check ID When a payment is created, the payment PR85.1 PR86.1
Number identification number from the Check ID
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 PR560
Payment Type Contains the payment type. PR81.1 PR85.1
A = ACH Receipt PR86.1
D = Deposit
I = Interest
J = Adjustment
M = Manual Payment
P = Partial ACH
S = System Payment
W = Withdrawal
PCH-COMPANY Numeric 4 PR560 PR81.1
Company The company number represents an
established company and is entered on
all function codes.
PCH-EMPLOYEE Numeric 9 PR560
Employee Contains the employee number. A unique
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 PR560
Payment Date Contains the date of the payment, with PR81.1 PR85.1
one exception. For payments with status PR86.1
7 (Void Reversal), it contains the void
date of the payment being reversed.
PCH-STATUS Numeric 1 PR155 PR162
Status Contains the payment status. There are PR165 PR197
several status flows for records in this PR560 PR81.1
file: PR85.1 PR85.2
PR86.1
Payment Type M (Manual Payment) records
have Status 9 (Reserved Manual) when you
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 13.2 PR162 PR560
Payment Amount Contains the actual amount for which a PR85.1 PR86.1
payment is created. This amount comes
from the Check Net field of the Employee
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) PR155 PR162
Reconciliation or Contains the void or reconciliation PR165 PR197
Void Date date for any payment records that have PR81.1 PR85.1
been voided or reconciled. PR86.1
For status 7 (Void Reversal) records
this is the payment date of the payment
being reversed.
PCH-RECON-AMOUNT Signed 13.2 PR155 PR162
Reconciled Amount Contains the reconciled amount. PR165 PR197
PR85.1 PR86.1
PCH-SERIAL-NBR Numeric 6 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
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 PR197 PR81.1
Current Flag Contains the value that identifies PR85.1
current cycle payments.
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 PR81.1
Type of Void Contains the value that identifies the
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
PCH-CURRENCY-CODE Alpha 5 PR560
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PCH-CURR-ND Numeric 1 PR560
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
PCH-PENS-SEQ-NBR Numeric 4 PR560
Pens Seq Nbr
PRCHECK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCHSET1 BNK-ACCT-NBR HR00.1 HR01.1
PRINT-TYPE PR01.1 PR155
CHECK-NBR PR165 PR197
CHECK-ID PR560 PR81.1
PR85.1 PR86.1
PCHSET10 COMPANY KeyChange, Subset
EMPLOYEE Where PENS-SEQ-NBR != Zeroes
PENS-SEQ-NBR
CHECK-ID
PCHSET2 COMPANY KeyChange
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 PR162 PR197
COMPANY PR81.1 PR86.1
BNK-ACCT-NBR
CHECK-TYPE
CHECK-NBR
CHECK-ID
PCHSET5 COMPANY KeyChange BN66.1 HR170
CHECK-ID HR70.1 PR139
PR141 PR142
PR195 PR197
PR275 PR277
PR295 PR300
PR36.1 PR45.1
PR50.2 PR51.1
PR560 PR85.1
PR89.1
PCHSET6 COMPANY KeyChange, Subset PR155 PR162
BNK-ACCT-NBR Where CHECK-TYPE = "A" PR85.2
CHECK-DATE Or CHECK-TYPE = "M"
CHECK-NBR Or CHECK-TYPE = "S"
CHECK-ID
PCHSET7 BNK-ACCT-NBR KeyChange
CHECK-NBR*
CHECK-SUF
CHECK-ID
CHECK-TYPE
PCHSET8 BNK-ACCT-NBR
PRINT-TYPE
CHECK-NBR*
CHECK-ID
PCHSET9 STATUS KeyChange
COMPANY
PROCESS-LEVEL
EMPLOYEE
CHECK-DATE
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 (BACSET1)
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
Pr1099rhst PR1099RHST Not Required
PCH-COMPANY -> PHR-COMPANY
PCH-EMPLOYEE -> PHR-EMPLOYEE
PCH-CHECK-ID -> PHR-CHECK-ID
PCH-PENS-SEQ-NBR -> PHR-PENS-SEQ-NBR
Prpenhist PRPENHIST Not Required
PCH-COMPANY -> PNH-COMPANY
PCH-EMPLOYEE -> PNH-EMPLOYEE
PCH-CHECK-ID -> PNH-CHECK-ID
PCH-PENS-SEQ-NBR -> PNH-PENS-SEQ-NBR
Prpenpay PRPENPAY Not Required
PCH-COMPANY -> PNP-COMPANY
PCH-EMPLOYEE -> PNP-EMPLOYEE
PCH-PENS-SEQ-NBR -> PNP-PENS-SEQ-NBR
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
Prpenfsrc PRPENFSRC
PCH-COMPANY -> PNF-COMPANY
PCH-EMPLOYEE -> PNF-EMPLOYEE
PCH-PENS-SEQ-NBR -> PNF-PENS-SEQ-NBR
PNF-FUNDING-SOURCE
|
