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
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. |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
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). |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
PCH-COMPANY Element: Company Hr | Numeric 4 |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
PCH-RECON-AMOUNT Element: Recon Amount | Signed 13.2 Contains the reconciled amount. |
|
||||||||||||||||||||
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). |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
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 ). |
|
||||||||||||||||||||
PCH-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||||||||||
PCH-PENS-SEQ-NBR Element: Pens Seq Nbr | Numeric 4 |
|
||||||||||||||||||||
PCH-SUB-STATUS Element: Sub Status | Numeric 2 01 = Escheated 02 = Escheated pmt filed with govt 03 = Hold 04 = Reissue payment 05 = Cashed |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PCHSET1 |
BNK-ACCT-NBR PRINT-TYPE CHECK-NBR CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||
PCHSET10 |
COMPANY EMPLOYEE PENS-SEQ-NBR CHECK-ID |
|
|||||||||||||||||||||||||||||||||||||
PCHSET11 |
COMPANY BNK-ACCT-NBR RECON-DATE CHECK-NBR CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||
PCHSET2 |
COMPANY SERIAL-NBR BNK-ACCT-NBR CHECK-TYPE CHECK-NBR CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||
PCHSET3 |
BNK-ACCT-NBR CHECK-NBR CHECK-DATE CHECK-TYPE STATUS SUB-STATUS COMPANY EMPLOYEE |
|
| ||||||||||||||||||||||||||||||||||||
PCHSET4 |
STATUS COMPANY BNK-ACCT-NBR CHECK-TYPE CHECK-NBR CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||
PCHSET5 |
COMPANY CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||
PCHSET6 |
COMPANY BNK-ACCT-NBR CHECK-DATE CHECK-NBR CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||
PCHSET7 |
BNK-ACCT-NBR CHECK-NBR* CHECK-SUF CHECK-ID CHECK-TYPE |
|
|||||||||||||||||||||||||||||||||||||
PCHSET8 |
BNK-ACCT-NBR PRINT-TYPE CHECK-NBR* CHECK-ID |
|
|||||||||||||||||||||||||||||||||||||
PCHSET9 |
STATUS COMPANY PROCESS-LEVEL EMPLOYEE CHECK-DATE CHECK-NBR CHECK-ID |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Bank Account | BANKACCT |
Required
| ||||||||||||
Company | PRSYSTEM |
Required
| ||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||
Paymastr | PAYMASTR |
Not Required
| ||||||||||||
Pr1099rhst | PR1099RHST |
Not Required
| ||||||||||||
Prpenhist | PRPENHIST |
Not Required
| ||||||||||||
Prpenpay | PRPENPAY |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Praudit | PRAUDIT |
| |||||||||||||||||||||||||||
Prpenfsrc | PRPENFSRC |
| |||||||||||||||||||||||||||
Prtime | PRTIME |
|
All trademarks and registered trademarks are the property of their
respective owners.