PRCHECK – Employee Payment
- System
- Payroll (PR)
- Prefix
PCH- Primary key
BNK-ACCT-NBR,PRINT-TYPE,CHECK-NBR,CHECK-ID- Fields
- 24
- Updated by
- 24 programs
- Referenced by
- 49 programs
PRCHECK is the Employee Payment table in Lawson Payroll (prefix PCH). It is indexed by BNK-ACCT-NBR, PRINT-TYPE, CHECK-NBR, CHECK-ID (PCHSET1); alternate indexes: PCHSET10, PCHSET11, PCHSET2, PCHSET3, PCHSET4, PCHSET5, PCHSET6, PCHSET7 and 2 more. It is related 1:1 to BANKACCT, PRSYSTEM, EMPLOYEE, PAYMASTR, PR1099RHST, PRPENHIST and PRPENPAY and 1:M to PRAUDIT, PRPENFSRC and PRTIME. It is updated by BN66.1, PR140, PR155, PR160, PR165, PR180, PR189, PR195 and 16 more and referenced by BN150, EXI2.1, EXI4.1, HR00.1, HR01.1, HR170, HR70.1, LP130 and 41 more. The table has 24 fields, 11 indexes and 10 documented relations.
About PRCHECK
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.
Fields (24)
Column = COBOL field name without the PCH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PCH-BNK-ACCT-NBR PKBNK_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 PKPRINT_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.
| BN66.1, PR140, PR160, PR180, PR189, PR195, PR560, PR80.1 +6 more |
PCH-CHECK-NBR PKCHECK_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 PKCHECK_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-TYPECHECK_TYPE | Alpha 1 | Contains the payment type.
| BN66.1, PR140, PR142, PR160, PR180, PR189, PR195, PR560 +7 more |
PCH-COMPANYCOMPANY | Numeric 4 | — | PR160, PR180, PR560, PR80.1, PR80.4, PR81.1 |
PCH-EMPLOYEEEMPLOYEE | 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 +2 more |
PCH-CHECK-DATECHECK_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 +8 more |
PCH-STATUSSTATUS | 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).
| BN66.1, PR140, PR155, PR160, PR162, PR165, PR170, PR180 +12 more |
PCH-CHECK-AMOUNTCHECK_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 +5 more |
PCH-RECON-PRT-STRECON_PRT_ST | Numeric 1 | Contains the value that indicates whether or not the payment printed when you ran PR155 (Bank Reconciliation) with Update option.
| BN66.1, PR140, PR155, PR189, PR195, PR80.1, PR80.4, PR85.1 +3 more |
PCH-CHECK-SUFCHECK_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 +1 more |
PCH-RECON-DATERECON_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 +11 more |
PCH-RECON-AMOUNTRECON_AMOUNT | Signed 13.2 | Contains the reconciled amount. | BN66.1, PR140, PR155, PR160, PR162, PR165, PR170, PR180 +10 more |
PCH-SERIAL-NBRSERIAL_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 +4 more |
PCH-PROCESS-LEVELPROCESS_LEVEL | 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 +2 more |
PCH-REVERSAL-IDREVERSAL_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 +4 more |
PCH-CURRENT-FLAGCURRENT_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.
| BN66.1, PR140, PR160, PR180, PR189, PR195, PR197, PR80.1 +5 more |
PCH-VOID-INDVOID_IND | Alpha 1 | Contains the value that identifies the payment as an alignment or void payment. All other records have blanks in this field.
| BN66.1, PR140, PR160, PR180, PR189, PR195, PR80.1, PR80.4 +3 more |
PCH-TYPE-1TYPE_1 | Derived | — | — |
PCH-CURRENCY-CODECURRENCY_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 +2 more |
PCH-CURR-NDCURR_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 +2 more |
PCH-PENS-SEQ-NBRPENS_SEQ_NBR | Numeric 4 | — | BN66.1, PR140, PR160, PR189, PR195, PR560, PR80.1, PR80.4 +2 more |
PCH-SUB-STATUSSUB_STATUS | Numeric 2 | —
| PR160, PR85.1 |
Indexes (11)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PCHSET1 | BNK-ACCT-NBR, PRINT-TYPE, CHECK-NBR, CHECK-ID | Primary | HR00.1, HR01.1, PR01.1, PR140, PR155, PR160, PR165, PR170 +9 more | |
PCHSET10 | COMPANY, EMPLOYEE, PENS-SEQ-NBR, CHECK-ID | KeyChange, Subset | Where PENS-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 +5 more | |
PCHSET5 | COMPANY, CHECK-ID | KeyChange | BN150, BN66.1, HR170, HR70.1, PR521, EXI2.1, EXI4.1, LP130 +22 more (list truncated in source) | |
PCHSET6 | COMPANY, BNK-ACCT-NBR, CHECK-DATE, CHECK-NBR, CHECK-ID | KeyChange, Subset | Where CHECK-TYPE = "A" Or CHECK-TYPE = "M" Or CHECK-TYPE = "S" Or CHECK-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 |
Relations
One to one (7) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
One to many (3) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Praudit | PRAUDIT | Valid When PCH-CHECK-TYPE = "M" Or PCH-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 |
Programs
Updated by (24)
- BN66.1 Estimated Pay Calculation
- PR140 Earnings and Deductions Calculation
- PR155 Bank Reconciliation
- PR160 Payment Print
- PR165 Bank Reconciliation Tape Processing
- PR180 Manual Payment Print
- PR189 Gross Up Calculation
- PR195 Accrual Program
- PR197 Payroll Close
- PR296 New Hire Reporting
- PR300 History Purge
- PR36.1 Time Record Entry
- PR36.4 Manual Time Record Maintenance
- PR45.1 Error Processing
- PR560 Payroll History Load CSV
- PR80.1 Manual Check
- PR80.2 Manual Payment Print
- PR80.4 Manual Payment
- PR81.1 Manual Payment Reservation
- PR85.1 Bank Account Reconciliation
- PR86.1 Payment Replacement
- PR89.1 Payment Modeling
- PRAT.1 Alltax connection test
- ZP296 New Hire Reporting
Referenced by (49)
- BN150 Life Insurance Reportable Income
- EXI2.1 Invoke for PRTRDPD
- EXI4.1 Invoke for PRPRBPD
- HR00.1 Company
- HR01.1 Process Level
- HR170 Human Resource Writer Report Request
- HR70.1 Human Resource Writer Inquiry
- LP130 Absence Plan Payout
- PR01.1 Bank Account
- PR128 Offset Time Record Creation
- PR131 Retroactive Pay Calculation
- PR132 FLSA Overtime Calculation
- PR134 Automatic Time Records
- PR135 Time Record Edit
- PR136 Missing Time Records
- PR137 Batch Time Record Update
- PR139 Arrears Automation
- PR141 Payroll Register
- PR142 Consolidated Payroll Register
- PR162 Payment Register
- PR170 Positive Pay File Creation
- PR275 Deduction Report
- PR277 Garnishment History Report
- PR285 Payroll Activity Report
- PR29.1 Pension Payment Maintenance
- PR295 Distribution History Report
- PR32.1 Employee Daily Time Entry
- PR32.2 Employee Daily Time Entry
- PR33.1 Speed Entry Setup
- PR33.2 Speed Entry by Number
- PR33.3 Speed Entry by Name
- PR35.1 Time Entry
- PR35.2 Detail Time Entry
- PR35.3 Speed Time Entry
- PR35.4 Step and Grade, Grade Range Time Entry
- PR35.5 Attendance Time Entry
- PR35.6 Activity Time Entry
- PR35.8 Position Time Entry
- PR35.9 Reason Code Time Entry
- PR37.1 Batch Time Control
- PR50.2 United States Payment Inquiry
- PR51.1 Pay Stub Inquiry
- PR521 Nonstandard Pay and Work Period CSV Load
- PR529 Pension Payroll Conversion
- PR530 Time Record Interface CSV
- PR582 Mass Adjustment Load
- PR82.1 Adjustment
- TA147 Canada Vacation Audit
- UK102 Bonus Pay Update