EOQF_CATEGORYEOQF_QSTNR_CODEEOQF_QUES_GRP_IDEOQF_QGROUP_VW(SQL View) |
Index Back |
|---|---|
Question Group ViewQuestion Group View |
| SELECT DISTINCT A.EOQF_CATEGORY , A.EOQF_QSTNR_CODE , A.EOQF_QUES_GRP_ID , COALESCE(B.EOQF_ORD_QST , 0) FROM %Table(EOQF_QQSTN_TBL) A LEFT OUTER JOIN %Table(EOQF_QGROUP_TBL) B ON A.EOQF_CATEGORY = B.EOQF_CATEGORY AND A.EOQF_QSTNR_CODE = B.EOQF_QSTNR_CODE AND A.EOQF_QUES_GRP_ID = B.EOQF_QUES_GRP_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_QUES_GRP_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Question Group ID |
| 4 | EOQF_ORDER | Number(6,0) | INTEGER NOT NULL | Question order |