EOQF_QSTRE_KEYS(SQL View) |
Index Back |
---|---|
Questionnaire ReportQuestionnaire Framework Reporting |
SELECT A.EOQF_QSTNRINSTANCE ,A.EOQF_KEY_VALUE FROM PS_EOQF_QSTNRCNTXT A WHERE A.EOQF_KEY_FIELDNAME='OPRID' UNION SELECT A.EOQF_QSTNRINSTANCE ,M.MESSAGE_TEXT FROM PS_EOQF_QUESTIONRE A , PSMSGCATDEFN M WHERE M.MESSAGE_SET_NBR=18111 AND M.MESSAGE_NBR=3221 AND NOT EXISTS ( SELECT 'X' FROM PS_EOQF_QSTNRCNTXT B WHERE B.EOQF_QSTNRINSTANCE=A.EOQF_QSTNRINSTANCE) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOQF_QSTNRINSTANCE | Number(15,0) | DECIMAL(15) NOT NULL | Questionnaire Instance |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |