RTBL_SCENA_VW

(SQL View)
 Index Back

SELECT SCE_ID , RTBL_SCENARIO , STATUS_SCENARIO , ASOFDATE2 , SCE_COMMENT , NO_OF_ELEMENT , LAST_PROC_DTTM , LAST_DEPLOY_DTTM , LASTUPDDTTM , DESCRIPTION_RTB , ELEMENT_RTB , PREDECESSORS_RTB , VERSION_RTB , TYPE_RTB , ATTACHMENT_EXIST , DATA_CAPTURE_DTTM , SOURCE_DATA_OPTN , SCE_ID_SRC , RTBL_REF_SRC_DATA , SKIP_ALL_CHKPOINTS , OWNER_SCENARIO , SOURCE_INSTANCE , CATEGORY_SCENARIO , ACTIVE_SCENARIO , SCE_DISPLAY , SCE_LOCKED , SCE_LOCKED_DTTM , SCE_LOCKER , SCE_LAST_PROCESSOR , SCE_LAST_UPDATER , SCE_LAST_DEPLOYER FROM %Table(RTBL_SCENARIO)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID
2 RTBL_SCENARIO Character(18) VARCHAR2(18) NOT NULL Scenario Name
3 STATUS_SCENARIO Character(2) VARCHAR2(2) NOT NULL Status
CE=Complete with Errors
CS=Cancelled
CW=Complete with Warning
EE=Edit Errors
HS=On Hold
NS=No Success
NY=Not Yet Processed
PC=Paused for Checkpoint
PN=Processing Now
RA=Request Approved
RC=Request Cancelled
RD=Request Denied
RP=Request Pending
RY=Request Deployed
SC=Successfully Complete
4 ASOFDATE2 Date(10) DATE As of Date

Default Value: %Date

5 SCE_COMMENT Long Character CLOB Comments
6 NO_OF_ELEMENT Number(3,0) SMALLINT NOT NULL No. of Elements

Default Value: 0

7 LAST_PROC_DTTM DateTime(26) TIMESTAMP last processed datetime.

Default Value: %DateTime

8 LAST_DEPLOY_DTTM DateTime(26) TIMESTAMP Date Last Deployed

Default Value: %DateTime

9 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10 DESCRIPTION_RTB Character(40) VARCHAR2(40) NOT NULL Description
11 ELEMENT_RTB Character(40) VARCHAR2(40) NOT NULL Element
12 PREDECESSORS_RTB Character(20) VARCHAR2(20) NOT NULL Predecessors
13 VERSION_RTB Number(3,0) SMALLINT NOT NULL Version
14 TYPE_RTB Character(20) VARCHAR2(20) NOT NULL Type
15 ATTACHMENT_EXIST Character(1) VARCHAR2(1) NOT NULL Attachments Exist
N=N
Y=Y
16 DATA_CAPTURE_DTTM DateTime(26) TIMESTAMP last processed datetime.
17 SOURCE_DATA_OPTN Character(1) VARCHAR2(1) NOT NULL Source of Data
0=Production
1=Scenario Source
2=Scenario Result
18 SCE_ID_SRC Character(10) VARCHAR2(10) NOT NULL Source Data ID
19 RTBL_REF_SRC_DATA Character(1) VARCHAR2(1) NOT NULL Refresh Source Data
0=Refresh data from Source
1=Reset Original Source Data

Y/N Table Edit

20 SKIP_ALL_CHKPOINTS Character(1) VARCHAR2(1) NOT NULL Skip All Checkpoints

Y/N Table Edit

21 OWNER_SCENARIO Character(30) VARCHAR2(30) NOT NULL Owner

Prompt Table: PSOPRDEFN_VW

22 SOURCE_INSTANCE Number(15,4) DECIMAL(14,4) NOT NULL Identifies a Process Instance (PROCESS_INSTANCE), and is used by the PeopleSoft Process Scheduler to save this identifier.
23 CATEGORY_SCENARIO Character(50) VARCHAR2(50) NOT NULL Category
24 ACTIVE_SCENARIO Character(1) VARCHAR2(1) NOT NULL Active
N=No
Y=Yes

Default Value: Y

25 SCE_DISPLAY Character(1) VARCHAR2(1) NOT NULL Display
N=No
Y=Yes
26 SCE_LOCKED Character(1) VARCHAR2(1) NOT NULL Locked
N=No
Y=Yes
27 SCE_LOCKED_DTTM DateTime(26) TIMESTAMP SCC 09/01/04 - Locked Date Time
28 SCE_LOCKER Character(30) VARCHAR2(30) NOT NULL Locked By
29 SCE_LAST_PROCESSOR Character(30) VARCHAR2(30) NOT NULL Last Accessed By
30 SCE_LAST_UPDATER Character(30) VARCHAR2(30) NOT NULL Last Updated By
31 SCE_LAST_DEPLOYER Character(30) VARCHAR2(30) NOT NULL Last Deployed By