RTBL_ALE_FILTER(SQL Table) |
Index Back |
|---|
| # | 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 | OPR_SCE_NAME | Character(4) | VARCHAR2(4) NOT NULL |
Arithmetic Operation
BW=begins with BWN=does not begin with CO=contains CON=does not contain EW=ends with EWN=does not end with IS== ISN=<> Default Value: IS |
| 3 | OPR_SCE_DESC | Character(4) | VARCHAR2(4) NOT NULL |
Arithmetic Operation
BW=begins with BWN=does not begin with CO=contains CON=does not contain EW=ends with EWN=does not end with IS== ISN=<> Default Value: IS |
| 4 | OPR_SCE_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Arithmetic Operation
IN=in INN=not in Default Value: IN |
| 5 | OPR_SCE_OWNER | Character(4) | VARCHAR2(4) NOT NULL |
Arithmetic Operation
IS== ISN=<> Default Value: IS |
| 6 | OPR_SCE_CATEGORY | Character(4) | VARCHAR2(4) NOT NULL |
Arithmetic Operation
IS== ISN=<> Default Value: IS |
| 7 | RTBL_SCENARIO | Character(18) | VARCHAR2(18) NOT NULL |
Scenario Name
Prompt Table: RTBL_SCE_NAMDVW |
| 8 | DESCRIPTION_RTB | Character(40) | VARCHAR2(40) NOT NULL | Description |
| 9 | STATUS_RANGE | Character(50) | VARCHAR2(50) NOT NULL | Status |
| 10 | STATUS_RANGE_FULL | Long Character(500) | VARCHAR2(500) | Status |
| 11 | ASOFDATE_FROM | Date(10) | DATE | As of Date |
| 12 | ASOFDATE_TO | Date(10) | DATE | To |
| 13 | OWNER_SCENARIO | Character(30) | VARCHAR2(30) NOT NULL |
Owner
Prompt Table: PSOPRDEFN_VW |
| 14 | CATEGORY_SCENARIO | Character(50) | VARCHAR2(50) NOT NULL |
Category
Prompt Table: RTBL_CATS_VW |
| 15 | SCE_SHOW_ALL_ALERT | Character(1) | VARCHAR2(1) NOT NULL |
Show All Alerts
N=No Y=Yes Default Value: Y |