Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRCHECK


                              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