| # |
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_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
|
| 5 |
OPR_SCE_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Arithmetic Operation
IN=in
INN=not in
Default Value: IN
|
| 6 |
OPR_SCE_OWNER |
Character(4) |
VARCHAR2(4) NOT NULL |
Arithmetic Operation
IS==
ISN=<>
Default Value: IS
|
| 7 |
OPR_SCE_CATEGORY |
Character(4) |
VARCHAR2(4) NOT NULL |
Arithmetic Operation
IS==
ISN=<>
Default Value: IS
|
| 8 |
OPR_SCE_LAST_DEPL |
Character(4) |
VARCHAR2(4) NOT NULL |
Arithmetic Operation
IS==
ISN=<>
Default Value: IS
|
| 9 |
OPR_SCE_LAST_PROC |
Character(4) |
VARCHAR2(4) NOT NULL |
Arithmetic Operation
IS==
ISN=<>
Default Value: IS
|
| 10 |
OPR_SCE_LAST_UPD |
Character(4) |
VARCHAR2(4) NOT NULL |
Arithmetic Operation
IS==
ISN=<>
Default Value: IS
|
| 11 |
RTBL_SCENARIO |
Character(18) |
VARCHAR2(18) NOT NULL |
Scenario Name
Prompt Table:
RTBL_SCE_NAMDVW
|
| 12 |
DESCRIPTION_RTB |
Character(40) |
VARCHAR2(40) NOT NULL |
Description
|
| 13 |
STATUS_RANGE |
Character(50) |
VARCHAR2(50) NOT NULL |
Status
|
| 14 |
STATUS_RANGE_FULL |
Long Character(500) |
VARCHAR2(500) |
Status
|
| 15 |
ASOFDATE_FROM |
Date(10) |
DATE |
As of Date
|
| 16 |
ASOFDATE_TO |
Date(10) |
DATE |
To
|
| 17 |
OWNER_SCENARIO |
Character(30) |
VARCHAR2(30) NOT NULL |
Owner
Prompt Table:
PSOPRDEFN_VW
|
| 18 |
CATEGORY_SCENARIO |
Character(50) |
VARCHAR2(50) NOT NULL |
Category
Prompt Table:
RTBL_CATS_VW
|
| 19 |
LAST_PROCESS_FROM |
Date(10) |
DATE |
Date Last Accessed
|
| 20 |
LAST_PROCESS_TO |
Date(10) |
DATE |
To
|
| 21 |
SCE_LAST_PROCESSOR |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Accessed By
Prompt Table:
PSOPRDEFN_VW
|
| 22 |
LAST_UPDATE_FROM |
Date(10) |
DATE |
Date Last Updated
|
| 23 |
LAST_UPDATE_TO |
Date(10) |
DATE |
To
|
| 24 |
SCE_LAST_UPDATER |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Updated By
Prompt Table:
PSOPRDEFN_VW
|
| 25 |
LAST_DEPLOY_FROM |
Date(10) |
DATE |
Date Last Deployed
|
| 26 |
LAST_DEPLOY_TO |
Date(10) |
DATE |
To
|
| 27 |
SCE_LAST_DEPLOYER |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Deployed By
Prompt Table:
PSOPRDEFN_VW
|
| 28 |
SCE_SHOW_INACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Inactive Scenarios
N=No
Y=Yes
|