EOQF_CATEGORYEOQF_QSTNR_CODEEOQF_QSTN_IDLANGUAGE_CDEOQF_QSTGRP_LVW(SQL View) |
Index Back |
|---|---|
Question Group Language ViewQuestion Group Language View |
| SELECT A.EOQF_CATEGORY ,A.EOQF_QSTNR_CODE ,A.EOQF_QSTN_ID ,L.LANGUAGE_CD ,L.EOQF_QUESTION FROM PS_EOQF_QQSTN_TBL A ,PS_EOQF_QUESTION B ,PS_EOQF_QUES_LNG L WHERE A.EOQF_CATEGORY=B.EOQF_CATEGORY AND A.EOQF_QSTN_ID=B.EOQF_QSTN_ID AND A.EOQF_QSTN_ID=L.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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | EOQF_QUESTION | Long Character | CLOB | Question |