RTBL_PUR_FILTER(SQL Table) |
Index Back |
|---|---|
RTBL search filter |
| # | 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 | SCE_SRCH_OPTIONS |
Character(1) | VARCHAR2(1) NOT NULL |
Options
A=Analyze S=Standard Default Value: S |
| 3 | 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 |
| 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_LAST_PROC | Character(4) | VARCHAR2(4) NOT NULL |
Arithmetic Operation
IS== ISN=<> Default Value: IS |
| 7 | OPR_SCE_LAST_UPD | Character(4) | VARCHAR2(4) NOT NULL |
Arithmetic Operation
IS== ISN=<> Default Value: IS |
| 8 | RTBL_SCENARIO | Character(18) | VARCHAR2(18) NOT NULL |
Scenario Name
Prompt Table: RTBL_SCE_NAMDVW |
| 9 | STATUS_RANGE | Character(50) | VARCHAR2(50) NOT NULL | Status |
| 10 | STATUS_RANGE_FULL | Long Character(500) | VARCHAR2(500) | Status |
| 11 | OWNER_SCENARIO | Character(30) | VARCHAR2(30) NOT NULL |
Owner
Prompt Table: PSOPRDEFN_VW |
| 12 | LAST_PROCESS_FROM | Date(10) | DATE | Date Last Accessed |
| 13 | LAST_PROCESS_TO | Date(10) | DATE | To |
| 14 | LAST_UPDATE_FROM | Date(10) | DATE | Date Last Updated |
| 15 | LAST_UPDATE_TO | Date(10) | DATE | To |
| 16 | CREATED_DT_FROM | Date(10) | DATE | Created Date and time |
| 17 | CREATED_DT_TO | Date(10) | DATE | Created Date and time |