PROCESS_INSTANCEPC_WHERE_AET(SQL Table) |
Index Back |
|---|---|
Projects Where Clause StorageStores where clauses built dynamically and used in Application Engine programs. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | WHERE_CLAUSE_LONG | Long Character(4000) | CLOB | Where Clause |
| 3 | WHERE_CLAUSE5 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 4 | WHERE_CLAUSE4 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 5 | WHERE_CLAUSE3 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 6 | WHERE_CLAUSE2 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 7 | WHERE_CLAUSE1 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 8 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 9 | WHERE_CLAUSE6 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 10 | WHERE_CLAUSE7 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 11 | WHERE_CLAUSE8 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 12 | WHERE_CLAUSE9 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |