PROCESS_INSTANCE1=Not Yet Processed
2=Processing Now
3=Successfully Completed
4=Completed With Data Errors
5=No Success With Severe Errors
6=Skip Due To Process Dependency
AP_REALTIME_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | RTM_SOURCE_TXN | Character(10) | VARCHAR2(10) NOT NULL | Source Transaction |
| 5 | RTM_PROCESS_GROUP | Character(10) | VARCHAR2(10) NOT NULL | On-Demand Process Group |
| 6 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 7 | RTM_PROCESS_NAME | Character(12) | VARCHAR2(12) NOT NULL | On-Demand Process |
| 8 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL | Process Type |
| 9 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 10 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 11 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Exist |
| 12 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 13 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 14 | MESSAGE_PARM1 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 1 |
| 15 | MESSAGE_PARM2 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 2 |
| 16 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |
| 17 | RTM_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Real-Time processing status
1=Not Yet Processed 2=Processing Now 3=Successfully Completed 4=Completed With Data Errors 5=No Success With Severe Errors 6=Skip Due To Process Dependency |
| 18 | AE_APPSTATUS | Number(1,0) | SMALLINT NOT NULL | AE Application Warning Status |