|
|
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 BN150
HR170 HR70.1 PR128 PR130 PR131 PR132
PR134 PR136 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 PR35.9 PR50.2 PR51.1 PR529 PR530
PR82.1 UK102 UK141 UK277 TA147 TP135
UPDATED BY
PR155 PR160 PR165 PR180 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 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
field along with the payment ID serves
as the link to the Employee Payments
Master file record.
PCH-PRINT-TYPE Alpha 1 PR160 PR180
Element: Print Type Contains the value that identifies the PR560 PR81.1
kind of record in the file. All physical PR85.1 PR86.1
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 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
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
Element: 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 = Partial ACH
S = System Payment
W = Withdrawal
PCH-COMPANY Numeric 4 PR160 PR180
Element: Company Hr Identifies the AP company if the PR560 PR81.1
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PCH-EMPLOYEE Numeric 9 PR160 PR560
Element: 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 PR160
Element: Payment Date Contains the date of the payment, with PR180 PR560
one exception. For payments with status PR81.1 PR85.1
7 (Void Reversal), it contains the void PR86.1
date of the payment being reversed.
PCH-STATUS Numeric 1 PR155 PR160
Element: Status Contains the payment status. There are PR162 PR165
several status flows for records in this PR180 PR197
file: PR560 PR81.1
PR85.1 PR85.2
Payment Type M (Manual Payment) records PR86.1
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 PR160 PR162
Element: Payment AmountContains the actual amount for which a PR560 PR85.1
payment is created. This amount comes PR86.1
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
Element: Payment SuffixContains 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 PR160
Reconciliation or Contains the void or reconciliation PR162 PR165
Void Date date for any payment records that have PR180 PR197
been voided or reconciled. PR560 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 13.2 PR155 PR160
Element: Reconciled AmoContains the reconciled amount. PR162 PR165
PR180 PR197
PR560 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 PR560
Element: Process Lev HrWhen 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 12 PR155 PR162
Element: Reversal CheckContains 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
Element: Current Flag Contains the value that identifies PR197 PR81.1
current cycle payments. 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
Element: 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
Element: Type 1
PCH-CURRENCY-CODE Alpha 5 PR160 PR560
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PCH-CURR-ND Numeric 1 PR160 PR560
Account Currency Represents the number of decimals
Code defined for the currency of the object.
PCH-PENS-SEQ-NBR Numeric 4 PR160 PR560
Element: Pens Seq Nbr
PCH-SUB-STATUS Numeric 2 PR85.1
Element: Sub Status 01 = Escheated
02 = Escheated pmt filed with govt
03 = Hold
04 = Reissue payment
05 = Cashed
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
PR81.1 PR85.1
PR86.1
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 BN150 HR170
CHECK-ID HR70.1 PR128
PR130 PR131
PR132 PR134
PR136 PR141
PR142 PR155
PR160 PR180
PR197 PR275
PR277 PR285
PR29.1 PR295
PR300 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
...
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
PNF-RETRO-PAYMENT
Prtime PRTIME
PCH-COMPANY -> PRT-COMPANY
PCH-EMPLOYEE -> PRT-EMPLOYEE
PCH-CHECK-ID -> PRT-CHECK-ID
PRT-PAY-SUM-GRP
PRT-TIME-SEQ
|
