EOQF_EVNT_RPT_V

(SQL View)
 Index Back

Event Report

Questionnaire Framework Event Reporting

SELECT B.EOQF_EVENT_ID , B.EOQF_QSTNRINSTANCE , A.EOQF_CATEGORY , A.EOQF_QSTNR_CODE , B.EOQF_START_DTTM , A.EOQF_ROW_UPD_OPRID , COALESCE(D.OPRDEFNDESC ,E.MESSAGE_TEXT) , A.EOQF_ROW_UPD_DTTM , A.EOQF_QSTN_TYPE , A.EOQF_QSTN_ID , A.EOQF_DATE_ANSWER , A.EOQF_NUM_ANSWER , A.EOQF_OE_ANSWER , C.EOQF_ANS_ID , C.EOQF_RANK , C.EOQF_COMMENTS FROM ((PS_EOQF_QUESN_EVNT B LEFT OUTER JOIN PS_EOQF_QUESTIONRE A ON A.EOQF_QSTNRINSTANCE = B.EOQF_QSTNRINSTANCE LEFT OUTER JOIN PSOPRDEFN D ON A.EOQF_ROW_UPD_OPRID = D.OPRID) LEFT OUTER JOIN PS_EOQF_QUESTI_ANS C ON A.EOQF_QSTNRINSTANCE = C.EOQF_QSTNRINSTANCE AND A.EOQF_QSTN_ID = C.EOQF_QSTN_ID) , PSMSGCATDEFN E WHERE E.MESSAGE_SET_NBR = 18111 AND E.MESSAGE_NBR = 3221

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOQF_EVENT_ID Character(30) VARCHAR2(30) NOT NULL Questionnaire Event Framework
2 EOQF_QSTNRINSTANCE Number(15,0) DECIMAL(15) NOT NULL Questionnaire Instance
3 EOQF_CATEGORY Character(30) VARCHAR2(30) NOT NULL Category Field
4 EOQF_QSTNR_CODE Character(30) VARCHAR2(30) NOT NULL Questionnaire Code
5 EOQF_START_DTTM DateTime(26) TIMESTAMP timestamp
6 EOQF_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
7 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
8 EOQF_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
9 EOQF_QSTN_TYPE Character(4) VARCHAR2(4) NOT NULL Question Type
0=Select
1=Multiple Choice
2=Single Choice
3=Drop Down
4=Numeric
5=Date
6=Open Ended
7=Ranking
10 EOQF_QSTN_ID Number(15,0) DECIMAL(15) NOT NULL Question Id
11 EOQF_DATE_ANSWER Date(10) DATE Date Answer
12 EOQF_NUM_ANSWER Signed Number(17,5) DECIMAL(15,5) NOT NULL Numeric Answer
13 EOQF_OE_ANSWER Long Character(5000) CLOB Open Ended Answer
14 EOQF_ANS_ID Number(15,0) DECIMAL(15) NOT NULL Answer ID
15 EOQF_RANK Number(3,0) SMALLINT NOT NULL Rank
16 EOQF_COMMENTS Long Character(5000) CLOB Question