EOQF_CATEGORYEOQF_QSTNR_CODEEOQF_QSTN_IDEOQF_QSTGRP_VW(SQL View) |
Index Back |
|---|---|
Question Group ViewQuestion Group View |
| SELECT A.EOQF_CATEGORY ,A.EOQF_QSTNR_CODE ,A.EOQF_QSTN_ID ,A.EOQF_QUES_GRP_ID ,A.EOQF_ORD_QST ,B.EOQF_QUESTION FROM PS_EOQF_QQSTN_TBL A ,PS_EOQF_QUESTION B WHERE A.EOQF_QSTN_ID=B.EOQF_QSTN_ID |
| # | 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_QUES_GRP_ID | Number(15,0) | DECIMAL(15) NOT NULL | Question Group ID |
| 5 | EOQF_ORD_QST | Number(3,0) | SMALLINT NOT NULL | Question order |
| 6 | EOQF_QUESTION | Long Character | CLOB | Question |