PAYMENT_DELTMP (SQL Table)	Index Back
Delete Payments Temp Table A temporary table to hold the keys of Payments that are to be deleted. Its high end keys are user id and datetime. These keys are used to batch those payments that should be deleted in one session.

PAYMENT_DELTMP

(SQL Table)

Delete Payments Temp Table

A temporary table to hold the keys of Payments that are to be deleted. Its high end keys are user id and datetime. These keys are used to batch those payments that should be deleted in one session.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

3 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.

4 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.

5 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
3	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
4	DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
5	PAYMENT_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.