EOQF_QQSTN_TBL(SQL Table) |
Index Back |
|---|---|
Questionnaire QuestionsQuestionnaire Questions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EOQF_CATEGORY |
Character(30) | VARCHAR2(30) NOT NULL | Category Field |
| 2 | EOQF_QSTNR_CODE |
Character(30) | VARCHAR2(30) NOT NULL | Questionnaire Code |
| 3 | EOQF_QSTN_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Question Id |
| 4 | EOQF_SMART_ANS_ID | Number(15,0) | DECIMAL(15) NOT NULL | Smart Answer Id |
| 5 | EOQF_QSTN_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Question Type
0=Select 1=Multiple Choice 2=Single Choice 3=Drop Down 4=Numeric 5=Date 6=Open Ended 7=Ranking Default Value: 0 |
| 6 | EOQF_QSTN_RQD | Character(4) | VARCHAR2(4) NOT NULL |
Required Question
N=No Y=Yes Default Value: N |
| 7 | DTTM_CREATED | DateTime(26) | TIMESTAMP |
Datetime Created
Default Value: %datetime |
| 8 | EOQF_QUES_GRP_ID | Number(15,0) | DECIMAL(15) NOT NULL | Question Group ID |
| 9 | EOQF_ORD_QST | Number(3,0) | SMALLINT NOT NULL | Question order |
| 10 | EOQF_INPOOL | Character(1) | VARCHAR2(1) NOT NULL |
Question/Answer Present in Pool
N=No Y=Yes Default Value: N |
| 11 | EOQF_IS_NEW | Character(1) | VARCHAR2(1) NOT NULL |
Is New
N=No Y=Yes Default Value: N |
| 12 | EOQF_DEFAULT_POINT | Signed Number(4,0) | DECIMAL(3) NOT NULL | Default Points |