PMT_REQUEST_LOG

(SQL Table)
Index Back

Log table for payment requests

Log table for payment requests

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PMT_MSG_ID Character(15) VARCHAR2(15) NOT NULL Payment Message ID
2 PMT_REQUEST_DATE DateTime(26) TIMESTAMP Request Date
3 PMT_REQUEST_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Request Status
A=Request Abended
C=Complete
E=Complete with Errors
4 PMT_COUNT Number(6,0) INTEGER NOT NULL Number of Payments
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
6 PMT_SOURCE Character(10) VARCHAR2(10) NOT NULL Source System Name

Prompt Table: PMT_SRC_DEFN

7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
8 PMT_REQUEST_TYPE Character(1) VARCHAR2(1) NOT NULL Request Type
C=Cancel Request
P=Payment Request
9 GRP_ID Character(30) VARCHAR2(30) NOT NULL Group id
10 GRP_MSG_NUM Number(5,0) INTEGER NOT NULL Group message number
11 GRP_MSG_TOTAL Number(5,0) INTEGER NOT NULL Group message total
12 EVENT_TRACKING_ID Number(10,0) DECIMAL(10) NOT NULL The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.