|
|
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 AC541
AC542 BN150 HR170 HR70.1 PR128 PR130
PR131 PR132 PR134 PR136 PR139 PR141
PR142 PR275 PR277 PR285 PR29.1 PR295
PR32.2 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR50.2 PR51.1
PR529 PR530 PR82.1 UK102 UK141 UK277
TA147 UK120
UPDATED BY
BN66.1 PR140 PR155 PR160 PR165 PR180
PR189 PR195 PR197 PR300 PR36.1 PR45.1
PR560 PR80.1 PR81.1 PR85.1 PR86.1 PR89.1
UK560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCH-BNK-ACCT-NBR Alpha 17 PR160 PR180
Element: Bank Account NContains the bank account from the bank PR560 PR81.1
code on which the payment is drawn. This PR85.1 UK560
field along with the payment ID serves
as the link to the Employee Payments
Master file record.
PCH-PRINT-TYPE Alpha 1 BN66.1 PR140
Element: Print Type Contains the value that identifies the PR160 PR180
kind of record in the file. All physical PR189 PR195
payment records, Manual or System, have PR560 PR80.1
a print type of C (Check). All ACH PR81.1 PR85.1
receipt records have a print type of R PR86.1 PR89.1
(Pay Receipt). All other records, D UK560
(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
Element: Payment NumberContains 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 UK560
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 PR80.1
Number identification number from the Check ID PR81.1 PR85.1
field in the Employee Payments Master PR86.1 UK560
file is moved to this field to serve
as a link to the Employee Payment file
record.
PCH-CHECK-TYPE Alpha 1 BN66.1 PR140
Element: Payment Type Contains the payment type. PR142 PR160
A = ACH Receipt PR180 PR189
D = Deposit PR195 PR560
I = Interest PR80.1 PR81.1
J = Adjustment PR85.1 PR86.1
M = Manual Payment PR89.1 UK560
P = Partial ACH
S = System Payment
W = Withdrawal
PCH-COMPANY Numeric 4 PR160 PR180
Element: Company The company number represents an PR560 PR80.1
established company and is entered on PR81.1 UK560
all function codes.
PCH-EMPLOYEE Numeric 9 BN66.1 PR140
Element: Employee Contains the employee number. A unique PR160 PR189
employee number is assigned to each PR195 PR560
person employed, and is used to PR80.1 PR89.1
correlate all information related to UK560
that person.
PCH-CHECK-DATE Numeric 8 (yyyymmdd) BN66.1 PR140
Element: Date Contains the date of the payment, with PR155 PR160
one exception. For payments with status PR180 PR189
7 (Void Reversal), it contains the void PR195 PR560
date of the payment being reversed. PR80.1 PR81.1
PR85.1 PR86.1
PR89.1 UK560
PCH-STATUS Numeric 1 BN66.1 PR140
Element: Status Contains the payment status. There are PR155 PR160
several status flows for records in this PR162 PR165
file: PR180 PR189
PR195 PR197
Payment Type M (Manual Payment) records PR560 PR80.1
have Status 9 (Reserved Manual) when you PR81.1 PR85.1
reserve the payment number in PR81.1 PR85.2 PR86.1
(Manual Payment Reservation). The status PR89.1 UK560
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 BN66.1 PR140
Element: Payment AmountContains the actual amount for which a PR160 PR162
payment is created. This amount comes PR189 PR195
from the Check Net field of the Employee PR560 PR80.1
Payments Master file. PR85.1 PR86.1
PR89.1 UK560
ACH amounts are not included.
PCH-RECON-PRT-ST Numeric 1 BN66.1 PR140
Reconciliation Contains the value that indicates PR155 PR189
Print Status whether or not the payment printed when PR195 PR80.1
you ran PR155 (Bank Reconciliation) with PR85.1 PR86.1
Update option. PR89.1
Not printed = 0
Printed = 1
PCH-CHECK-SUF Numeric 2 BN66.1 PR140
Element: Payment SuffixContains the payment suffix, defined in PR189 PR195
PR85.1 (Bank Account Reconciliation). PR80.1 PR85.1
The payment suffix further identifies PR89.1
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) BN66.1 PR140
Reconciliation or Contains the void or reconciliation PR155 PR160
Void Date date for any payment records that have PR162 PR165
been voided or reconciled. PR180 PR189
PR195 PR197
For status 7 (Void Reversal) records PR560 PR80.1
this is the payment date of the payment PR81.1 PR85.1
being reversed. PR86.1 PR89.1
UK560
PCH-RECON-AMOUNT Signed 13.2 BN66.1 PR140
Element: Reconciled AmoContains the reconciled amount. PR155 PR160
PR162 PR165
PR180 PR189
PR195 PR197
PR560 PR80.1
PR85.1 PR86.1
PR89.1 UK560
PCH-SERIAL-NBR Numeric 6 BN66.1 PR140
Payment Run Serial Contains the automatically sequenced PR160 PR189
Number serial number that identifies records PR195 PR80.1
created in the same run of PR160 PR86.1 PR89.1
(Payment Print).
PCH-PROCESS-LEVEL Alpha 5 BN66.1 PR140
Element: Process Level When you create a payment, the process PR160 PR189
level from the Process Level field in PR195 PR560
the Employee Payments Master file is PR80.1 PR89.1
moved to this field. This field is then UK560
used to determine if a payment is
printed when you run PR162 (Payment
Register) by process level.
PCH-REVERSAL-ID Numeric 12 BN66.1 PR140
Element: Reversal CheckContains the payment identification PR155 PR162
number of a status 7 (Void Reversal) PR189 PR195
payment record that was created to PR80.1 PR85.1
reflect the reversing payroll PR89.1
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 BN66.1 PR140
Element: Current Flag Contains the value that identifies PR160 PR180
current cycle payments. PR189 PR195
PR197 PR80.1
When a payment record is created via PR81.1 PR85.1
PR80.1 (Manual Payment) and PR160 PR89.1
(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 BN66.1 PR140
Element: Type of Void Contains the value that identifies the PR160 PR180
payment as an alignment or void payment. PR189 PR195
PR80.1 PR81.1
PR89.1
All other records have blanks in this
field.
A = Alignment Check
V = PR81 Void
PCH-TYPE-1 Derived
Element: Type 1
PCH-CURRENCY-CODE Alpha 5 BN66.1 PR140
Element: Currency Code This field contains the company base PR160 PR189
currency code established in Company PR195 PR560
(GL10.1 ). PR80.1 PR89.1
UK560
PCH-CURR-ND Numeric 1 BN66.1 PR140
Account Currency PR160 PR189
Code PR195 PR560
PR80.1 PR89.1
UK560
PCH-PENS-SEQ-NBR Numeric 4 BN66.1 PR140
Element: Pens Seq Nbr PR160 PR189
PR195 PR560
PR80.1 PR89.1
UK560
PCH-SUB-STATUS Numeric 2
Element: Sub Status 01 = Escheated
02 = Escheated pmt filed with govt
03 = Hold
04 = Reissue payment
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
PR197 PR560
PR80.1 PR80.2
PR81.1 PR85.1
PR86.1 UK560
PCHSET10 COMPANY KeyChange, Subset
EMPLOYEE Where PENS-SEQ-NBR != Zeroes
PENS-SEQ-NBR
CHECK-ID
PCHSET11 COMPANY KeyChange PR155
BNK-ACCT-NBR
RECON-DATE
CHECK-NBR
CHECK-ID
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 PR197 PR81.1
BNK-ACCT-NBR PR86.1
CHECK-TYPE
CHECK-NBR
CHECK-ID
PCHSET5 COMPANY KeyChange AC541 AC542
CHECK-ID BN150 BN66.1
HR170 HR70.1
PR128 PR130
PR131 PR132
PR134 PR136
PR139 PR140
PR141 PR142
PR155 PR160
PR180 PR189
PR195 PR197
PR275 PR277
PR285 PR29.1
PR295 PR300
PR32.2 PR33.2
...
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 PR160
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
Prtime PRTIME
PCH-COMPANY -> PRT-COMPANY
PCH-EMPLOYEE -> PRT-EMPLOYEE
PCH-CHECK-ID -> PRT-CHECK-ID
PRT-PAY-SUM-GRP
PRT-TIME-SEQ
|
