PMT_REQUEST_LOG(SQL Table) |
Index Back |
---|---|
Log table for payment requestsLog 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. |