PROCESS_INSTANCEEE_EVENTGN3_AET(SQL Table) |
Index Back |
|---|---|
Entry Event Generator AET 3 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SQL_WHERE_001 | Character(254) | VARCHAR2(254) NOT NULL | |
| 3 | SQL_WHERE_002 | Character(254) | VARCHAR2(254) NOT NULL | |
| 4 | SQL_SELECT_001 | Character(254) | VARCHAR2(254) NOT NULL | |
| 5 | SQL_SELECT_002 | Character(254) | VARCHAR2(254) NOT NULL | |
| 6 | SQL_SELECT_003 | Character(254) | VARCHAR2(254) NOT NULL | |
| 7 | RECNAME_SOURCE | Character(15) | VARCHAR2(15) NOT NULL | Source Recname |
| 8 | RECNAME_UPDATE | Character(15) | VARCHAR2(15) NOT NULL | Record to Update |
| 9 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 10 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 11 | SELECTED_ROW | Number(5,0) | INTEGER NOT NULL | Selected Row |
| 12 | ADJUSTMENT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Upward/Downward Adjustment |
| 13 | EE_PO_STEP_SQL | Character(100) | VARCHAR2(100) NOT NULL | Entry Event PO SQL |
| 14 | SQL_STMT_254 | Character(254) | VARCHAR2(254) NOT NULL | An internal work field that contains SQL text that is to be utilized in treasury application p |
| 15 | WHERE_CLAUSE2 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 16 | WHERE_TXT_LONG2 | Long Character(4000) | CLOB | Where clause |