CS_WIZVALUES_VW(SQL View) |
Index Back |
|---|---|
Join btwn WizDetl & QuestionsSELECT A.SETID , A.CS_WIZARD_ID , B.CS_QUESTGRP , B.CS_QUEST_SEQ , B.CS_DISPLAY_SEQ , B.CS_BIND_VAR , B.CS_QUESTION , B.CS_REQUIRED , B.CS_YESBIND , B.CS_YESNAV , B.CS_NOBIND , B.CS_NONAV , B.CS_DEFAULT FROM PS_CS_WIZARD_DETL A , PS_CS_QUESTIONS B WHERE A.SETID = B.SETID AND A.CS_QUESTGRP = B.CS_QUESTGRP |
| SELECT A.SETID , A.CS_WIZARD_ID , B.CS_QUESTGRP , B.CS_QUEST_SEQ , C.SEQUENCE_NBR , B.CS_BIND_VAR , B.CS_LIST_TYPE , C.CS_STRING_30 , C.CS_STRING_2 , C.CS_STRING_5 , C.CS_STRING_12 , C.CS_INTEGER , C.CS_YESNO , C.DESCR60 , C.CS_GOTO_SEQ , C.CS_WIZ_NAVIGATE , C.DEFAULT_FLG , C.CS_TEMPLATE_ID FROM PS_CS_WIZARD_DETL A , PS_CS_QUESTIONS B , PS_CS_QLIST_VALUES C WHERE A.SETID = B.SETID AND A.CS_QUESTGRP = B.CS_QUESTGRP AND B.SETID = C.SETID AND B.CS_QUESTGRP = C.CS_QUESTGRP AND B.CS_QUEST_SEQ = C.CS_QUEST_SEQ |
| # | 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 |
| 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_BIND_VAR | Character(30) | VARCHAR2(30) NOT NULL | Bind Variable |
| 7 | 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) |
| 8 | CS_STRING_30 | Character(30) | VARCHAR2(30) NOT NULL | F-AHAYT-X0ES6 new field label |
| 9 | CS_STRING_2 | Character(2) | VARCHAR2(2) NOT NULL | F-AHAYT-X0ES6 new field label |
| 10 | CS_STRING_5 | Character(5) | VARCHAR2(5) NOT NULL | F-AHAYT-X0ES6 new field label |
| 11 | CS_STRING_12 | Character(12) | VARCHAR2(12) NOT NULL | F-AHAYT-X0ES6 new field label |
| 12 | CS_INTEGER | Number(23,0) | DECIMAL(23) NOT NULL | Integer 23 |
| 13 | CS_YESNO | Character(1) | VARCHAR2(1) NOT NULL |
Yes No Field
N=No Y=Yes |
| 14 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 15 | CS_GOTO_SEQ | Number(3,0) | SMALLINT NOT NULL |
Navigate to Sequence
Prompt Table: CS_QUESTIONSVW2 |
| 16 | CS_WIZ_NAVIGATE | Character(1) | VARCHAR2(1) NOT NULL |
Navigate
C=Specific Configurator G=Next Group N=None Q=Next Question S=Specific Sequence |
| 17 | DEFAULT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Default Flag
Y/N Table Edit |
| 18 | CS_TEMPLATE_ID | Character(20) | VARCHAR2(20) NOT NULL | SCC 09/01/04 |