EOQF_QSTRE_KEY1(SQL View) |
Index Back |
|---|---|
Questionnaire ReportingQuestionnaire Framework Reporting |
| select A.EOQF_QSTNRINSTANCE,A.EOQF_KEY_VALUE,B.EOQF_KEY_VALUE,C.EOQF_KEY_VALUE,D.EOQF_KEY_VALUE,E.EOQF_KEY_VALUE from PS_EOQF_QSTNRCNTXT A, PS_EOQF_QSTNRCNTXT B, PS_EOQF_QSTNRCNTXT C, PS_EOQF_QSTNRCNTXT D, PS_EOQF_QSTNRCNTXT E where A.EOQF_QSTNRINSTANCE=B.EOQF_QSTNRINSTANCE and B.EOQF_QSTNRINSTANCE=C.EOQF_QSTNRINSTANCE and C.EOQF_QSTNRINSTANCE=D.EOQF_QSTNRINSTANCE and D.EOQF_QSTNRINSTANCE=E.EOQF_QSTNRINSTANCE and A.EOQF_KEY_FIELDNAME='PTAI_LIST_ID' and B.EOQF_KEY_FIELDNAME='PTAI_ITEM_ID' and C.EOQF_KEY_FIELDNAME='EMPLID' and D.EOQF_KEY_FIELDNAME='EMPL_RCD' 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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | field used in HD_360_RESPONSE_SYNC message. |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |