CS_WIZSUMM_VW(SQL View) |
Index Back |
---|---|
Wizard Defn and DetailSELECT 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 |