EOQF_SS_ACTV_VW

(SQL View)
 Index Back

Questionnaire Event

Questionnaire Event Framework

SELECT A.EOQF_EVENT_ID , A.EOQF_EVENT_TYPE , A.EOQF_EVENT_STATUS , A.EOQF_EVENT_NAME , A.EOQF_EVENT_DESCR , B.OPRID , A.EOQF_CATEGORY , A.EOQF_QSTNR_CODE , A.EOQF_START_DATE , A.EOQF_END_DATE , A.EOQF_QUEST_EXPIRES , B.LASTUPDDTTM , %DateOut(%DateNull) FROM PS_EOQF_EVENT_TBL A LEFT OUTER JOIN PS_EOQF_NOTIF_HIST B ON A.EOQF_EVENT_ID=B.EOQF_EVENT_ID AND B.EOQF_NOTF_TYPE='20' WHERE A.EOQF_EVENT_ID NOT IN ( SELECT C.EOQF_EVENT_ID FROM PS_EOQF_QUESN_EVNT C WHERE A.EOQF_EVENT_ID = C.EOQF_EVENT_ID AND B.OPRID=C.OPRID AND C.EOQF_START_DTTM = B.LASTUPDDTTM)

# 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_EVENT_TYPE Character(1) VARCHAR2(1) NOT NULL Questionnaire Event Framework
C=Continuous
S=Single
3 EOQF_EVENT_STATUS Character(1) VARCHAR2(1) NOT NULL Questionnaire Event Framework
A=Active
C=Canceled
D=Draft
E=Expired
I=Inactive
4 EOQF_EVENT_NAME Character(50) VARCHAR2(50) NOT NULL Questionnaire Event Framework
5 EOQF_EVENT_DESCR Long Character(5000) CLOB Questionnaire Event Framework
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
7 EOQF_CATEGORY Character(30) VARCHAR2(30) NOT NULL Category Field
8 EOQF_QSTNR_CODE Character(30) VARCHAR2(30) NOT NULL Questionnaire Code
9 EOQF_START_DATE Date(10) DATE Questionnaire Event Framework
10 EOQF_END_DATE Date(10) DATE Questionnaire Event Framework
11 EOQF_QUEST_EXPIRES Number(3,0) SMALLINT NOT NULL Questionnaire Event Framework
12 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13 EOQF_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime