PROCESS_INSTANCEALL=Header + Children (n-levels)
CHLD=Header + Children (2-levels)
HEAD=Header (1-level)
CRIT=Delete with criteria
TUNC=Truncate Table(s)
Prompt Table: PSRECDEFN
Prompt Table: PSRECDEFN
RO_CART_PRG_AET(SQL Table) |
Index Back |
|---|---|
State Rec - Cart Purge AEThis record is used in application egine program for Cart Purge AE |
| # | 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 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 5 | LEVEL_EXISTS | Character(1) | VARCHAR2(1) NOT NULL | Level Exists |
| 6 | PURGE_LEVEL | Character(4) | VARCHAR2(4) NOT NULL |
Depth to purge tables
ALL=Header + Children (n-levels) CHLD=Header + Children (2-levels) HEAD=Header (1-level) |
| 7 | PURGE_OPTION | Character(4) | VARCHAR2(4) NOT NULL |
Purge Options
CRIT=Delete with criteria TUNC=Truncate Table(s) |
| 8 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 9 | RECNAME_KEY | Character(15) | VARCHAR2(15) NOT NULL |
Record Name
Prompt Table: PSRECDEFN |
| 10 | RECNAME_PARENT | Character(15) | VARCHAR2(15) NOT NULL |
Parent Record. If this comes from a sub-record, this column has the name of the sub-record, otherwise it has the same value as RECNAME.
Prompt Table: PSRECDEFN |
| 11 | RECORD_COUNT | Number(7,0) | INTEGER NOT NULL | Count of Records |
| 12 | WHERE_LONG | Long Character | CLOB | Where Clause |