EOFD_SEARCH_VW (SQL View)	Index Back
Dissussion Search Dissussion Search

EOFD_SEARCH_VW

(SQL View)

Dissussion Search

( SELECT A2.EOFD_MESSAGE_ID , A2.EOFD_MSG_PRNT_ID , A2.OPRID , A2.EOFD_CONTENT , A2.CREATEDTTM , A2.URL_ID , A2.ATTACHSYSFILENAME , A2.ATTACHUSERFILE , A2.EOFD_STATUS , %Substring(CMP.DESCR ,1 ,30) ,A2.LASTUPDDTTM FROM PS_EOFD_DSCN_MSG A2 , PS_EOFD_DSCN_CNTXT CT2 , PSPNLGRPDEFN CMP WHERE A2.EOFD_MSG_PRNT_ID = ' ' AND A2.EOFD_MESSAGE_ID = CT2.EOFD_MESSAGE_ID AND CT2.EOFD_KEY = 'COMPONENT' AND CT2.EOFD_VALUE = CMP.PNLGRPNAME AND CMP.MARKET = 'GBL' AND EXISTS( SELECT 'X' FROM PS_EOFD_DSCN_CNTXT CT3 WHERE CT3.EOFD_KEY = 'DSCN_TYPE_ID' AND CT3.EOFD_VALUE IN(' ' ,'DEFAULT') AND A2.EOFD_MESSAGE_ID = CT3.EOFD_MESSAGE_ID)) UNION ALL( SELECT A.EOFD_MESSAGE_ID , A.EOFD_MSG_PRNT_ID , A.OPRID , A.EOFD_CONTENT , A.CREATEDTTM , A.URL_ID , A.ATTACHSYSFILENAME , A.ATTACHUSERFILE , A.EOFD_STATUS , %Substring(DT.DESCR100 ,1 ,30) ,A.LASTUPDDTTM FROM PS_EOFD_DSCN_MSG A , PS_EOFD_DSCN_CNTXT CT , PS_EOFD_DSCN_TYPE DT WHERE A.EOFD_MSG_PRNT_ID = ' ' AND A.EOFD_MESSAGE_ID = CT.EOFD_MESSAGE_ID AND CT.EOFD_KEY = 'DSCN_TYPE_ID' AND CT.EOFD_VALUE NOT IN(' ' ,'DEFAULT') AND CT.EOFD_VALUE = EOFD_DSCN_TYPE_ID ) UNION ALL ( SELECT A3.EOFD_MESSAGE_ID , A3.EOFD_MSG_PRNT_ID , A3.OPRID , A3.EOFD_CONTENT , A3.CREATEDTTM , A3.URL_ID , A3.ATTACHSYSFILENAME , A3.ATTACHUSERFILE , A3.EOFD_STATUS , 'Default' ,A3.LASTUPDDTTM FROM PS_EOFD_DSCN_MSG A3 WHERE A3.EOFD_MSG_PRNT_ID = ' ' AND EXISTS( SELECT 'X' FROM PS_EOFD_DSCN_CNTXT CT4 WHERE CT4.EOFD_KEY = 'DSCN_TYPE_ID' AND CT4.EOFD_VALUE IN(' ' ,'DEFAULT') AND A3.EOFD_MESSAGE_ID = CT4.EOFD_MESSAGE_ID) AND NOT EXISTS( SELECT 'X' FROM PS_EOFD_DSCN_CNTXT CT5 WHERE CT5.EOFD_KEY = 'COMPONENT' AND A3.EOFD_MESSAGE_ID = CT5.EOFD_MESSAGE_ID))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOFD_MESSAGE_ID Character(30) VARCHAR2(30) NOT NULL Discussion Message ID

2 EOFD_MSG_PRNT_ID Character(30) VARCHAR2(30) NOT NULL Discussion Message Parent ID

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 EOFD_CONTENT Long Character CLOB Discussion message content

5 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

6 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).

7 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

8 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

9 EOFD_STATUS Character(1) VARCHAR2(1) NOT NULL Discussion Status
C=Closed
O=Open

10 EOFD_DSCNTYPE_DSCR Long Character CLOB Discussion Type Descr

11 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOFD_MESSAGE_ID	Character(30)	VARCHAR2(30) NOT NULL	Discussion Message ID
2	EOFD_MSG_PRNT_ID	Character(30)	VARCHAR2(30) NOT NULL	Discussion Message Parent ID
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	EOFD_CONTENT	Long Character	CLOB	Discussion message content
5	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
6	URL_ID	Character(30)	VARCHAR2(30) NOT NULL	URL Identifier (see PSURLDEFN).
7	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
8	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
9	EOFD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Discussion Status C=Closed O=Open
10	EOFD_DSCNTYPE_DSCR	Long Character	CLOB	Discussion Type Descr
11	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.