EOQF_QSTRE_KEYS

(SQL View)
Index Back

Questionnaire Report

Questionnaire 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).