CS_QLIST_VALUES(SQL Table) |
Index Back |
|---|---|
List values for Questions |
| # | 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
Default Value: 10 |
| 4 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
| 5 | CS_STRING_30 | Character(30) | VARCHAR2(30) NOT NULL | F-AHAYT-X0ES6 new field label |
| 6 | CS_STRING_2 | Character(2) | VARCHAR2(2) NOT NULL | F-AHAYT-X0ES6 new field label |
| 7 | CS_STRING_5 | Character(5) | VARCHAR2(5) NOT NULL | F-AHAYT-X0ES6 new field label |
| 8 | CS_STRING_12 | Character(12) | VARCHAR2(12) NOT NULL | F-AHAYT-X0ES6 new field label |
| 9 | CS_STRING_254 | Character(254) | VARCHAR2(254) NOT NULL | 254 Character |
| 10 | CS_INTEGER | Number(23,0) | DECIMAL(23) NOT NULL | Integer 23 |
| 11 | CS_YESNO | Character(1) | VARCHAR2(1) NOT NULL |
Yes No Field
N=No Y=Yes |
| 12 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 13 | CS_GOTO_SEQ | Number(3,0) | SMALLINT NOT NULL |
Navigate to Sequence
Prompt Table: CS_QUESTIONSVW2 |
| 14 | CS_WIZ_NAVIGATE | Character(1) | VARCHAR2(1) NOT NULL |
Navigate
C=Specific Configurator G=Next Group N=None Q=Next Question S=Specific Sequence Default Value: Q |
| 15 | DEFAULT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Default Flag
Y/N Table Edit |
| 16 | CS_TEMPLATE_ID | Character(20) | VARCHAR2(20) NOT NULL |
SCC 09/01/04
Prompt Table: CS_TEMPLATE_DVW |