PRCHECK

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 PR170 PR162 BN150
HR170 HR70.1 PR521 EXI2.1 EXI4.1 LP130
PR128 PR131 PR132 PR134 PR135 PR136
PR137 PR139 PR141 PR142 PR275 PR277
PR285 PR29.1 PR295 PR32.1 PR32.2 PR33.1
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR35.9 PR37.1 PR50.2
PR51.1 PR529 PR530 PR582 PR82.1 UK102
TA147


UPDATED BY
BN66.1 PR140 PR155 PR160 PR165 PR180
PR189 PR195 PR197 PR300 PR36.1 PR36.4
PR45.1 PR560 PR80.1 PR80.2 PR80.4 PR81.1
PR85.1 PR86.1 PR89.1 PRAT.1 ZP296 PR296

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCH-BNK-ACCT-NBR
Element: Bnk Acct Nbr
Alpha 17
Contains the bank account from the bank 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.
PR160 PR180
PR560 PR81.1
PR85.1
PCH-PRINT-TYPE
Element: Print Type
Alpha 1
Contains the value that identifies the 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
BN66.1 PR140
PR160 PR180
PR189 PR195
PR560 PR80.1
PR80.4 PR81.1
PR85.1 PR86.1
PR89.1 PRAT.1
PCH-CHECK-NBR
Element: Check Nbr
Numeric 8
Contains the number that prints on the payment. For system payments, the number is determined by the beginning payment number entered in PR160 (Payment Print). Manual payments use payment numbers reserved in PR81.1 (Manual Payment Reservation).
PR142 PR160
PR180 PR560
PR81.1 PR85.1
PR86.1
PCH-CHECK-ID
Element: Check Id
Numeric 12
When a payment is created, the payment 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.
PR160 PR180
PR560 PR80.1
PR80.4 PR81.1
PR85.1 PR86.1
PCH-CHECK-TYPE
Element: Check Type
Alpha 1
Contains the payment type.
A = ACH Receipt
D = Deposit
I = Interest
J = Adjustment
M = Manual Payment
P = Partial ACH
S = System Payment
W = Withdrawal
H = Manual Direct Deposit
BN66.1 PR140
PR142 PR160
PR180 PR189
PR195 PR560
PR80.1 PR80.4
PR81.1 PR85.1
PR86.1 PR89.1
PRAT.1
PCH-COMPANY
Element: Company Hr
Numeric 4
PR160 PR180
PR560 PR80.1
PR80.4 PR81.1
PCH-EMPLOYEE
Element: Employee
Numeric 9
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.
BN66.1 PR140
PR160 PR189
PR195 PR560
PR80.1 PR80.4
PR89.1 PRAT.1
PCH-CHECK-DATE
Element: Check Date
Numeric 8 (yyyymmdd)
Contains the date of the payment, with one exception. For payments with status 7 (Void Reversal), it contains the void date of the payment being reversed.
BN66.1 PR140
PR155 PR160
PR170 PR180
PR189 PR195
PR560 PR80.1
PR80.4 PR81.1
PR85.1 PR86.1
PR89.1 PRAT.1
PCH-STATUS
Element: Status
Numeric 1
Contains the payment status. There are several status flows for records in this file: 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
BN66.1 PR140
PR155 PR160
PR162 PR165
PR170 PR180
PR189 PR195
PR197 PR560
PR80.1 PR80.4
PR81.1 PR85.1
PR85.2 PR86.1
PR89.1 PRAT.1
PCH-CHECK-AMOUNT
Element: Check Amount
Signed 13.2
Contains the actual amount for which a payment is created. This amount comes from the Check Net field of the Employee Payments Master file. ACH amounts are not included.
BN66.1 PR140
PR160 PR162
PR189 PR195
PR560 PR80.1
PR80.4 PR85.1
PR86.1 PR89.1
PRAT.1
PCH-RECON-PRT-ST
Element: Recon Prt St
Numeric 1
Contains the value that indicates whether or not the payment printed when you ran PR155 (Bank Reconciliation) with Update option. Not printed = 0 Printed = 1
BN66.1 PR140
PR155 PR189
PR195 PR80.1
PR80.4 PR85.1
PR86.1 PR89.1
PRAT.1
PCH-CHECK-SUF
Element: Check Suf
Numeric 2
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.
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR85.1 PR89.1
PRAT.1
PCH-RECON-DATE
Element: Recon Date
Numeric 8 (yyyymmdd)
Contains the void or reconciliation date for any payment records that have been voided or reconciled. For status 7 (Void Reversal) records this is the payment date of the payment being reversed.
BN66.1 PR140
PR155 PR160
PR162 PR165
PR170 PR180
PR189 PR195
PR197 PR560
PR80.1 PR80.4
PR81.1 PR85.1
PR86.1 PR89.1
PRAT.1
PCH-RECON-AMOUNT
Element: Recon Amount
Signed 13.2
Contains the reconciled amount.
BN66.1 PR140
PR155 PR160
PR162 PR165
PR170 PR180
PR189 PR195
PR197 PR560
PR80.1 PR80.4
PR85.1 PR86.1
PR89.1 PRAT.1
PCH-SERIAL-NBR
Element: Serial Nbr
Numeric 6
Contains the automatically sequenced serial number that identifies records created in the same run of PR160 (Payment Print).
BN66.1 PR140
PR160 PR180
PR189 PR195
PR80.1 PR80.2
PR80.4 PR86.1
PR89.1 PRAT.1
PCH-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
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.
BN66.1 PR140
PR160 PR189
PR195 PR560
PR80.1 PR80.4
PR89.1 PRAT.1
PCH-REVERSAL-ID
Element: Reversal Id
Numeric 12
Contains the payment identification 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.
BN66.1 PR140
PR155 PR162
PR170 PR189
PR195 PR80.1
PR80.4 PR85.1
PR89.1 PRAT.1
PCH-CURRENT-FLAG
Element: Current Flag
Alpha 1
Contains the value that identifies 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
BN66.1 PR140
PR160 PR180
PR189 PR195
PR197 PR80.1
PR80.4 PR81.1
PR85.1 PR89.1
PRAT.1
PCH-VOID-IND
Element: Void Ind
Alpha 1
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
BN66.1 PR140
PR160 PR180
PR189 PR195
PR80.1 PR80.4
PR81.1 PR89.1
PRAT.1
PCH-TYPE-1
Element: Type 1
Derived
PCH-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN66.1 PR140
PR160 PR189
PR195 PR560
PR80.1 PR80.4
PR89.1 PRAT.1
PCH-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN66.1 PR140
PR160 PR189
PR195 PR560
PR80.1 PR80.4
PR89.1 PRAT.1
PCH-PENS-SEQ-NBR
Element: Pens Seq Nbr
Numeric 4
BN66.1 PR140
PR160 PR189
PR195 PR560
PR80.1 PR80.4
PR89.1 PRAT.1
PCH-SUB-STATUS
Element: Sub Status
Numeric 2

01 = Escheated
02 = Escheated pmt filed with govt
03 = Hold
04 = Reissue payment
05 = Cashed
PR160 PR85.1


PRCHECK FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCHSET1 BNK-ACCT-NBR
PRINT-TYPE
CHECK-NBR
CHECK-ID
HR00.1 HR01.1
PR01.1 PR140
PR155 PR160
PR165 PR170
PR180 PR197
PR560 PR80.1
PR80.2 PR80.4
PR81.1 PR85.1
PR86.1
PCHSET10 COMPANY
EMPLOYEE
PENS-SEQ-NBR
CHECK-ID
KeyChange, Subset
WherePENS-SEQ-NBR !=Zeroes
PCHSET11 COMPANY
BNK-ACCT-NBR
RECON-DATE
CHECK-NBR
CHECK-ID
KeyChange
PR155 PR170
PCHSET2 COMPANY
SERIAL-NBR
BNK-ACCT-NBR
CHECK-TYPE
CHECK-NBR
CHECK-ID
KeyChange
PR160 PR180
PCHSET3 BNK-ACCT-NBR
CHECK-NBR
CHECK-DATE
CHECK-TYPE
STATUS
SUB-STATUS
COMPANY
EMPLOYEE
KeyChange, Subset
Where(STATUS >=2)
And(STATUS <=4)
PR85.1
PCHSET4 STATUS
COMPANY
BNK-ACCT-NBR
CHECK-TYPE
CHECK-NBR
CHECK-ID
KeyChange
BN66.1 PR140
PR160 PR162
PR189 PR195
PR197 PR80.1
PR80.4 PR81.1
PR86.1 PR89.1
PRAT.1
PCHSET5 COMPANY
CHECK-ID
KeyChange
...
BN150 BN66.1
HR170 HR70.1
PR521 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR139
PR140 PR141
PR142 PR155
PR160 PR180
PR189 PR195
PR197 PR275
PR277 PR285
PR29.1 PR295
PCHSET6 COMPANY
BNK-ACCT-NBR
CHECK-DATE
CHECK-NBR
CHECK-ID
KeyChange, Subset
WhereCHECK-TYPE ="A"
OrCHECK-TYPE ="M"
OrCHECK-TYPE ="S"
OrCHECK-TYPE ="H"
PR155 PR162
PR170 PR85.2
PCHSET7 BNK-ACCT-NBR
CHECK-NBR*
CHECK-SUF
CHECK-ID
CHECK-TYPE
KeyChange
PCHSET8 BNK-ACCT-NBR
PRINT-TYPE
CHECK-NBR*
CHECK-ID
PCHSET9 STATUS
COMPANY
PROCESS-LEVEL
EMPLOYEE
CHECK-DATE
CHECK-NBR
CHECK-ID
KeyChange
PR296 PR300
ZP296


PRCHECK FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Praudit PRAUDIT
Valid When PCH-CHECK-TYPE ="M"
OrPCH-CHECK-TYPE ="H"
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


File created: Thu Jun 09 02:30:31 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.