OPRIDRUN_CNTL_IDCRIT=Delete with criteria
TUNC=Truncate Table(s)
Default Value: TUNC
ALL=Header + Children (n-levels)
CHLD=Header + Children (2-levels)
HEAD=Header (1-level)
Default Value: ALL
Prompt Table: PSRECDEFN
Prompt Table: PSRECDEFN
RB_PURGE_RUN(SQL Table) |
Index Back |
|---|---|
Cart Purge Run Control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PURGE_OPTION | Character(4) | VARCHAR2(4) NOT NULL |
Purge Options
CRIT=Delete with criteria TUNC=Truncate Table(s) Default Value: TUNC |
| 4 | 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) Default Value: ALL |
| 5 | RECNAME_KEY | Character(15) | VARCHAR2(15) NOT NULL |
Record Name
Prompt Table: PSRECDEFN |
| 6 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 7 | WHERE_LONG | Long Character | CLOB | Where Clause |