OI_RTBL_SCN_VW

(SQL View)
 Index Back

Scenario


SELECT A.SCE_ID , A.RTBL_SCENARIO , XLI1.DESCR STATUS_SCE_DESC , A.ASOFDATE2 , A.NO_OF_ELEMENT , A.LAST_PROC_DTTM , A.LAST_DEPLOY_DTTM , A.LASTUPDDTTM , A.DESCRIPTION_RTB , A.ELEMENT_RTB , A.PREDECESSORS_RTB , A.VERSION_RTB , XLI2.DESCR ATTACH_EX_DESC , A.DATA_CAPTURE_DTTM , XLI3.DESCR SRC_DATA_OPTN_DESC , A.SCE_ID_SRC , XLI4.DESCR RTBL_REF_SRC_DESC , A.SKIP_ALL_CHKPOINTS , A.OWNER_SCENARIO , A.SOURCE_INSTANCE , A.CATEGORY_SCENARIO , XLI5.DESCR ACTV_SCE_DESC , A.SCE_DISPLAY , XLI6.DESCR SCE_LOC_DESC , A.SCE_LOCKED_DTTM , A.SCE_LOCKER , A.SCE_LAST_PROCESSOR , A.SCE_LAST_UPDATER , A.SCE_LAST_DEPLOYER , A.RTBL_COMBO_FLAG , XLI7.DESCR CALC_LOG_OPTN_DESC , A.SCE_CREATE_DTTM , A.CONFIG_CHANGED FROM PS_RTBL_SCENARIO A LEFT OUTER JOIN PS_OI_COMMON_VW XLI1 ON XLI1.CODESETNAME = A.STATUS_SCENARIO AND XLI1.CODESETGROUPNAME ='STATUS_SCENARIO' LEFT OUTER JOIN PS_OI_COMMON_VW XLI2 ON XLI2.CODESETNAME = A.ATTACHMENT_EXIST AND XLI2.CODESETGROUPNAME ='ATTACHMENT_EXIST' LEFT OUTER JOIN PS_OI_COMMON_VW XLI3 ON XLI3.CODESETNAME = A.SOURCE_DATA_OPTN AND XLI3.CODESETGROUPNAME ='SOURCE_DATA_OPTN' LEFT OUTER JOIN PS_OI_COMMON_VW XLI4 ON XLI4.CODESETNAME = A.RTBL_REF_SRC_DATA AND XLI4.CODESETGROUPNAME ='RTBL_REF_SRC_DATA' LEFT OUTER JOIN PS_OI_COMMON_VW XLI5 ON XLI5.CODESETNAME = A.ACTIVE_SCENARIO AND XLI5.CODESETGROUPNAME ='ACTIVE_SCENARIO' LEFT OUTER JOIN PS_OI_COMMON_VW XLI6 ON XLI6.CODESETNAME = A.SCE_LOCKED AND XLI6.CODESETGROUPNAME ='SCE_LOCKED' LEFT OUTER JOIN PS_OI_COMMON_VW XLI7 ON XLI7.CODESETNAME = A.CALC_LOG_OPTION AND XLI7.CODESETGROUPNAME ='CALC_LOG_OPTION' UNION SELECT ' ' ,' ' ,' ' , %DateIn('1900-01-01') ,0 , %DateTimeIn('1900-01-01 00.00.00.000000') , %DateTimeIn('1900-01-01 00.00.00.000000') , %DateTimeIn('1900-01-01 00.00.00.000000') ,' ' ,' ' ,' ' ,0 ,' ' , %DateTimeIn('1900-01-01 00.00.00.000000') ,' ' ,' ' ,' ' ,' ' ,' ' ,0 ,' ' ,' ' ,' ' ,' ' , %DateTimeIn('1900-01-01 00.00.00.000000') ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' , %DateTimeIn('1900-01-01 00.00.00.000000') ,' ' FROM PS_INSTALLATION B

# 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_SCE_DESC Character(30) VARCHAR2(30) NOT NULL Scenario Status Description
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
5 NO_OF_ELEMENT Number(3,0) SMALLINT NOT NULL No. of Elements
6 LAST_PROC_DTTM DateTime(26) TIMESTAMP last processed datetime.
7 LAST_DEPLOY_DTTM DateTime(26) TIMESTAMP Date Last Deployed
8 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.
9 DESCRIPTION_RTB Character(40) VARCHAR2(40) NOT NULL Description
10 ELEMENT_RTB Character(40) VARCHAR2(40) NOT NULL Element
11 PREDECESSORS_RTB Character(20) VARCHAR2(20) NOT NULL Predecessors
12 VERSION_RTB Number(3,0) SMALLINT NOT NULL Version
13 ATTACH_EX_DESC Character(30) VARCHAR2(30) NOT NULL Attachments Exist
N=N
Y=Y
14 DATA_CAPTURE_DTTM DateTime(26) TIMESTAMP last processed datetime.
15 SRC_DATA_OPTN_DESC Character(30) VARCHAR2(30) NOT NULL Source Data Description
0=Production
1=Scenario Source
2=Scenario Result
16 SCE_ID_SRC Character(10) VARCHAR2(10) NOT NULL Source Data ID
17 RTBL_REF_SRC_DESC Character(30) VARCHAR2(30) NOT NULL Refresh Source Data Desc
0=Refresh data from Source
1=Reset Original Source Data
18 SKIP_ALL_CHKPOINTS Character(1) VARCHAR2(1) NOT NULL Skip All Checkpoints
19 OWNER_SCENARIO Character(30) VARCHAR2(30) NOT NULL Owner
20 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.
21 CATEGORY_SCENARIO Character(50) VARCHAR2(50) NOT NULL Category
22 ACTV_SCE_DESC Character(30) VARCHAR2(30) NOT NULL Active Scenario Description
N=No
Y=Yes
23 SCE_DISPLAY Character(1) VARCHAR2(1) NOT NULL Display
N=No
Y=Yes
24 SCE_LOC_DESC Character(30) VARCHAR2(30) NOT NULL Scenario Locked Description
N=No
Y=Yes
25 SCE_LOCKED_DTTM DateTime(26) TIMESTAMP SCC 09/01/04 - Locked Date Time
26 SCE_LOCKER Character(30) VARCHAR2(30) NOT NULL Locked By
27 SCE_LAST_PROCESSOR Character(30) VARCHAR2(30) NOT NULL Last Accessed By
28 SCE_LAST_UPDATER Character(30) VARCHAR2(30) NOT NULL Last Updated By
29 SCE_LAST_DEPLOYER Character(30) VARCHAR2(30) NOT NULL Last Deployed By
30 RTBL_COMBO_FLAG Character(1) VARCHAR2(1) NOT NULL RTBL Combination Edit Flag
31 CALC_LOG_OPTN_DESC Character(30) VARCHAR2(30) NOT NULL Calculation Log Description
C=Create Calc Log and Output
N=No Calc Log - Create Output
O=Create Calc Log - No Output
32 SCE_CREATE_DTTM DateTime(26) TIMESTAMP Create Datetime
33 CONFIG_CHANGED Character(1) VARCHAR2(1) NOT NULL Configuration Changed