CS_QGRPQSTVL_VW(SQL View) |
Index Back |
|---|---|
List values for QuestionsSELECT A.SETID , A.CS_QUESTGRP , A.CS_QUEST_SEQ , B.SEQUENCE_NBR , A.CS_BIND_VAR , A.CS_QUESTION , A.CS_REQUIRED , A.CS_DISPLAY_SEQ , A.CS_LIST_TYPE , A.CS_CLAUSE_ID , A.DESCR60 , B.CS_STRING_30 , B.CS_STRING_2 , B.CS_STRING_5 , B.CS_STRING_12 , B.CS_STRING_254 , B.CS_INTEGER , B.CS_YESNO , B.DESCR60 , B.CS_GOTO_SEQ , B.CS_WIZ_NAVIGATE FROM PS_CS_QUESTGRP_VW3 A , PS_CS_QLIST_VALUES B WHERE A.SETID = B.SETID AND A.CS_QUESTGRP = B.CS_QUESTGRP AND A.CS_QUEST_SEQ = B.CS_QUEST_SEQ |
| SELECT A.SETID , A.CS_QUESTGRP , A.CS_QUEST_SEQ , B.SEQUENCE_NBR , A.CS_BIND_VAR , A.CS_QUESTION , A.CS_REQUIRED , A.CS_DISPLAY_SEQ , A.CS_LIST_TYPE , A.CS_CLAUSE_ID , A.DESCR60 , A.CS_INFOONLY , A.CS_URL , A.CS_LABEL , B.CS_STRING_30 , B.CS_STRING_2 , B.CS_STRING_5 , B.CS_STRING_12 , B.CS_STRING_254 , B.CS_INTEGER , B.CS_YESNO , B.DESCR60 , B.CS_GOTO_SEQ , B.CS_WIZ_NAVIGATE , B.CS_TEMPLATE_ID FROM PS_CS_QUESTGRP_VW3 A , PS_CS_QLIST_VALUES B WHERE A.SETID = B.SETID(+) AND A.CS_QUESTGRP = B.CS_QUESTGRP(+) AND A.CS_QUEST_SEQ = B.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_QUESTGRP |
Character(30) | VARCHAR2(30) NOT NULL | Question Group |
| 3 | CS_QUEST_SEQ |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 4 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
| 5 | CS_BIND_VAR | Character(30) | VARCHAR2(30) NOT NULL | Bind Variable |
| 6 | CS_QUESTION | Character(254) | VARCHAR2(254) NOT NULL | Question |
| 7 | CS_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL | F-AHAYT-X0ES6 - new label |
| 8 | CS_DISPLAY_SEQ | Number(3,0) | SMALLINT NOT NULL | Display Sequence |
| 9 | 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) |
| 10 | CS_CLAUSE_ID | Character(30) | VARCHAR2(30) NOT NULL | Clause ID |
| 11 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 12 | CS_INFOONLY | Character(1) | VARCHAR2(1) NOT NULL |
F-AHAYT-X0ES6 - new field for wizard enhancments
Y/N Table Edit Default Value: N |
| 13 | CS_URL | Character(120) | VARCHAR2(120) NOT NULL | F-AHAYT-X0ES6 - new field for wizard enhancements |
| 14 | CS_LABEL | Character(60) | VARCHAR2(60) NOT NULL | F-AHAYT-X0ES6 - new field for wizard enhancements |
| 15 | CS_STRING_30 | Character(30) | VARCHAR2(30) NOT NULL | F-AHAYT-X0ES6 new field label |
| 16 | CS_STRING_2 | Character(2) | VARCHAR2(2) NOT NULL | F-AHAYT-X0ES6 new field label |
| 17 | CS_STRING_5 | Character(5) | VARCHAR2(5) NOT NULL | F-AHAYT-X0ES6 new field label |
| 18 | CS_STRING_12 | Character(12) | VARCHAR2(12) NOT NULL | F-AHAYT-X0ES6 new field label |
| 19 | CS_STRING_254 | Character(254) | VARCHAR2(254) NOT NULL | 254 Character |
| 20 | CS_INTEGER | Number(23,0) | DECIMAL(23) NOT NULL | Integer 23 |
| 21 | CS_YESNO | Character(1) | VARCHAR2(1) NOT NULL |
Yes No Field
N=No Y=Yes |
| 22 | CS_QLISTVAL_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Valid Value Description |
| 23 | CS_GOTO_SEQ | Number(3,0) | SMALLINT NOT NULL |
Navigate to Sequence
Prompt Table: CS_QUESTIONSVW2 |
| 24 | CS_WIZ_NAVIGATE | Character(1) | VARCHAR2(1) NOT NULL |
Navigate
C=Specific Configurator G=Next Group N=None Q=Next Question S=Specific Sequence |
| 25 | CS_TEMPLATE_ID | Character(20) | VARCHAR2(20) NOT NULL | SCC 09/01/04 |