EOQF_QSTRE_KEY2(SQL View) |
Index Back |
|---|---|
Questionnaire ReportingQuestionnaire Framework Reporting |
| SELECT A.EOQF_QSTNRINSTANCE ,A.EOQF_KEY_VALUE ,B.EOQF_KEY_VALUE ,E.EOQF_KEY_VALUE FROM PS_EOQF_QSTNRCNTXT A , PS_EOQF_QSTNRCNTXT B , PS_EOQF_QSTNRCNTXT E WHERE A.EOQF_QSTNRINSTANCE=B.EOQF_QSTNRINSTANCE AND B.EOQF_QSTNRINSTANCE=E.EOQF_QSTNRINSTANCE AND A.EOQF_KEY_FIELDNAME='PTAI_LIST_ID' AND B.EOQF_KEY_FIELDNAME='PTAI_ITEM_ID' AND E.EOQF_KEY_FIELDNAME='OPRID' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOQF_QSTNRINSTANCE | Number(15,0) | DECIMAL(15) NOT NULL | Questionnaire Instance |
| 2 | PTAI_LIST_ID | Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item List ID |
| 3 | PTAI_ITEM_ID | Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item ID |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |