PRAUDIT

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 PR80.1 PR80.4


UPDATED BY
PR300 PRAU.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRU-COMPANY
Element: Company Hr		Numeric 4
PRAU.1
PRU-BNK-ACCT-NBR
Element: Bnk Acct Nbr		Alpha 17
Contains the bank account on which the manual payment is drawn.
PRAU.1
PRU-CHECK-NBR
Element: Check Nbr		Numeric 8
Contains the payment number. This is the number that appears on the printed payment.
PRAU.1
PRU-CHECK-ID
Element: Check Id		Numeric 12
Contains the payment identification number (unique payment identifier used in tracking payment information).
PRAU.1
PRU-SEQ-NBR
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
PRAU.1
PRU-STATUS
Element: Status		Numeric 1
Contains the payment status.
0 = Created
1 = Changed
2 = Printed
3 = Deleted
PRAU.1
PRU-GROSS-PAY
Element: Gross Pay		Signed 13.2
Contains the gross pay associated with the manual payment.
PRAU.1
PRU-NET-PAY-AMT
Element: Net Pay Amt		Signed 13.2
Contains the net amount of the manual payment.
PRAU.1
PRU-USER-NAME
Element: User		Alpha 10 (Lower Case)
Contains the sign on name of the person who created the manual payment.
PRAU.1
PRU-DATE
Element: Date		Numeric 8 (yyyymmdd)
Contains the system date the payment was created, updated, printed or deleted.
PRAU.1
PRU-TIME
Element: Time		Numeric 8
Contains the system-assigned time the payment was created, updated, printed, or deleted.
PRAU.1
PRU-EMPLOYEE
Element: Employee		Numeric 9
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.
PRAU.1
PRU-CHECK-DATE
Element: Check Date		Numeric 8 (yyyymmdd)
Contains the payment date of the payment that was changed, printed, or deleted.
PRAU.1


PRAUDIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRUSET1 COMPANY
BNK-ACCT-NBR
CHECK-NBR
CHECK-ID
SEQ-NBR
PR281 PR300
PRAU.1
PRUSET2 COMPANY
BNK-ACCT-NBR
CHECK-NBR
CHECK-ID
STATUS
SEQ-NBR
KeyChange
PR80.1 PR80.4
PRAU.1
PRUSET3 COMPANY
DATE*
CHECK-DATE*
BNK-ACCT-NBR
CHECK-NBR
CHECK-ID
SEQ-NBR
KeyChange


PRAUDIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Bnk Acct Nbr BANKACCT Required
PRU-BNK-ACCT-NBR->BAC-BNK-ACCT-NBR (BACSET1)
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

File created: Thu Jun 09 02:30:30 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.