|
|
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
Company The company number represents an
established company and is entered on
all function codes.
PRU-BNK-ACCT-NBR Alpha 17 PRAU.1
Bank Account Number Contains the bank account on which the
manual payment is drawn.
PRU-CHECK-NBR Numeric 8 PRAU.1
Payment Number Contains 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
Sequence Number An automatically assigned sequence
number.
PRU-STATUS Numeric 1 PRAU.1
Status Contains the payment status.
0 = Created
1 = Changed
2 = Printed
3 = Deleted
PRU-GROSS-PAY Signed 11.2 PRAU.1
Gross Pay Contains the gross pay associated with
the manual payment.
PRU-NET-PAY-AMT Signed 11.2 PRAU.1
Net Pay Amt Contains the net amount of the manual
payment.
PRU-USER-NAME Alpha 10 (Lower Case) PRAU.1
User Name Contains the sign on name of the person
who created the manual payment.
PRU-DATE Numeric 8 (yyyymmdd) PRAU.1
Date Contains the system date the payment
was created, updated, printed or
deleted.
PRU-TIME Numeric 8 PRAU.1
Time Contains the system-assigned time the
payment was created, updated, printed,
or deleted.
PRU-EMPLOYEE Numeric 9 PRAU.1
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
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
|