Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRAUDIT


                              PRAUDIT FILE

                       Payroll Payment Audit File

Contains information associated with manual payments. The information in this
file is used to create an audit record showing that a manual payment was
created, printed, changed, or deleted.

REFERENCED BY

PR281

UPDATED BY

PRAU.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PRU-COMPANY            Numeric 4                                 PRAU.1
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PRU-BNK-ACCT-NBR       Alpha 17                                  PRAU.1
Element: Bank Account NContains the bank account on which the
                       manual payment is drawn.

PRU-CHECK-NBR          Numeric 8                                 PRAU.1
Element: Payment NumberContains the payment number. This is
                       the number that appears on the printed
                       payment.

PRU-CHECK-ID           Numeric 12                                PRAU.1
Internal Check ID      Contains the payment identification
Number                 number (unique payment identifier used
                       in tracking payment information).

PRU-SEQ-NBR            Numeric 4                                 PRAU.1
Element: Sequence NumbeAn automatically assigned sequence
                       number.

PRU-STATUS             Numeric 1                                 PRAU.1
Element: Status        Contains the payment status.
                       0 = Created
                       1 = Changed
                       2 = Printed
                       3 = Deleted

PRU-GROSS-PAY          Signed 13.2                               PRAU.1
Element: Gross Pay     Contains the gross pay associated with
                       the manual payment.

PRU-NET-PAY-AMT        Signed 13.2                               PRAU.1
Element: Net Pay Amt   Contains the net amount of the manual
                       payment.

PRU-USER-NAME          Alpha 10  (Lower Case)                    PRAU.1
Element: User          Contains the sign on name of the person
                       who created the manual payment.

PRU-DATE               Numeric 8  (yyyymmdd)                     PRAU.1
Element: Date          Contains the system date the payment
                       was created, updated, printed or
                       deleted.

PRU-TIME               Numeric 8                                 PRAU.1
Element: Time          Contains the system-assigned time the
                       payment was created, updated, printed,
                       or deleted.

PRU-EMPLOYEE           Numeric 9                                 PRAU.1
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

PRU-CHECK-DATE         Numeric 8  (yyyymmdd)                     PRAU.1
Element: Payment Date  Contains the payment date of the
                       payment that was changed, printed, or
                       deleted.

                         PRAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRUSET1   COMPANY                                                PR281   PRAU.1
          BNK-ACCT-NBR
          CHECK-NBR
          CHECK-ID
          SEQ-NBR

PRUSET2   COMPANY       KeyChange                                PRAU.1
          BNK-ACCT-NBR
          CHECK-NBR
          CHECK-ID
          STATUS
          SEQ-NBR

                         PRAUDIT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bnk Acct Nbr   BANKACCT     Required

                            PRU-BNK-ACCT-NBR    -> BAC-BNK-ACCT-NBR

Company        PRSYSTEM     Required

                            PRU-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            PRU-COMPANY         -> EMP-COMPANY
                            PRU-EMPLOYEE        -> EMP-EMPLOYEE

Prcheck        PRCHECK      Not Required

                            PRU-BNK-ACCT-NBR    -> PCH-BNK-ACCT-NBR
                            "C"                 -> PCH-PRINT-TYPE
                            PRU-CHECK-NBR       -> PCH-CHECK-NBR
                            PRU-CHECK-ID        -> PCH-CHECK-ID