CS_WIZSUMM_VW

(SQL View)
Index Back

Wizard Defn and Detail

SELECT A.SETID , A.CS_WIZARD_ID , A.DESCR60 , B.CS_QUESTGRP , B.CS_DISPLAY_SEQ FROM PS_CS_WIZARD_DEFN A , PS_CS_WIZARD_DETL B WHERE A.SETID = B.SETID AND A.CS_WIZARD_ID = B.CS_WIZARD_ID

SELECT A.SETID , A.CS_WIZARD_ID , B.CS_QUESTGRP , C.CS_QUEST_SEQ , C.SEQUENCE_NBR , B.CS_DISPLAY_SEQ , A.DESCR60 , C.CS_BIND_VAR , C.CS_QUESTION , C.CS_REQUIRED , C.CS_DISPLAY_SEQ , C.CS_LIST_TYPE , C.CS_CLAUSE_ID , C.CS_STRING_30 , C.CS_STRING_2 , C.CS_STRING_5 , C.CS_STRING_12 , C.CS_STRING_254 , C.CS_INTEGER , C.CS_YESNO , C.CS_QLISTVAL_DESCR , C.CS_GOTO_SEQ , C.CS_WIZ_NAVIGATE , C.CS_TEMPLATE_ID , C.CS_INFOONLY , C.CS_URL , C.CS_LABEL , B.CS_SOURCE_TRANS FROM PS_CS_WIZARD_DEFN A , PS_CS_WIZARD_DETL B , PS_CS_QGRPQSTVL_VW C WHERE A.SETID = B.SETID AND A.CS_WIZARD_ID = B.CS_WIZARD_ID AND B.CS_QUESTGRP = C.CS_QUESTGRP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 CS_WIZARD_ID Character(30) VARCHAR2(30) NOT NULL Wizard ID
3 CS_QUESTGRP Character(30) VARCHAR2(30) NOT NULL Question Group

Prompt Table: CS_QUEST_GROUPS

4 CS_QUEST_SEQ Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

Default Value: 1

6 CS_DISPLAY_SEQ Number(3,0) SMALLINT NOT NULL Display Sequence
7 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
8 CS_BIND_VAR Character(30) VARCHAR2(30) NOT NULL Bind Variable
9 CS_QUESTION Character(254) VARCHAR2(254) NOT NULL Question
10 CS_REQUIRED Character(1) VARCHAR2(1) NOT NULL F-AHAYT-X0ES6 - new label
11 CS_QUESDISPLAY_SEQ Number(3,0) SMALLINT NOT NULL Question Display Sequence
12 CS_LIST_TYPE Character(1) VARCHAR2(1) NOT NULL Display Option
C=Display Value at Runtime
D=Display Description at Runtime
N=No Lists
X=Navigational Only (No Values)
13 CS_CLAUSE_ID Character(30) VARCHAR2(30) NOT NULL Clause ID
14 CS_STRING_30 Character(30) VARCHAR2(30) NOT NULL F-AHAYT-X0ES6 new field label
15 CS_STRING_2 Character(2) VARCHAR2(2) NOT NULL F-AHAYT-X0ES6 new field label
16 CS_STRING_5 Character(5) VARCHAR2(5) NOT NULL F-AHAYT-X0ES6 new field label
17 CS_STRING_12 Character(12) VARCHAR2(12) NOT NULL F-AHAYT-X0ES6 new field label
18 CS_STRING_254 Character(254) VARCHAR2(254) NOT NULL 254 Character
19 CS_INTEGER Number(23,0) DECIMAL(23) NOT NULL Integer 23
20 CS_YESNO Character(1) VARCHAR2(1) NOT NULL Yes No Field
N=No
Y=Yes
21 CS_QLISTVAL_DESCR Character(60) VARCHAR2(60) NOT NULL Valid Value Description
22 CS_GOTO_SEQ Number(3,0) SMALLINT NOT NULL Navigate to Sequence

Prompt Table: CS_QUESTIONSVW2

23 CS_WIZ_NAVIGATE Character(1) VARCHAR2(1) NOT NULL Navigate
C=Specific Configurator
G=Next Group
N=None
Q=Next Question
S=Specific Sequence
24 CS_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04
25 CS_INFOONLY Character(1) VARCHAR2(1) NOT NULL F-AHAYT-X0ES6 - new field for wizard enhancments

Y/N Table Edit

Default Value: N

26 CS_URL Character(120) VARCHAR2(120) NOT NULL F-AHAYT-X0ES6 - new field for wizard enhancements
27 CS_LABEL Character(60) VARCHAR2(60) NOT NULL F-AHAYT-X0ES6 - new field for wizard enhancements
28 CS_SOURCE_TRANS Character(2) VARCHAR2(2) NOT NULL Source Transaction 03/22/07 cel F-AHAYT-748L7: Added Purchase Order (03) as a new source transaction 01/12/11 tbg SCMT-92-MDEM-04: Added RFx (04) as new source transaction for strat sourcing (doc authoring)
01=Ad Hoc
02=Purchasing Contracts
03=Purchase Orders
04=Sourcing Events
97=All Sources
98=Multiple Sources
99=Not Transactional

Prompt Table: CS_SRC_TRAN_VW1