EOFD_SRCH_VW2 (SQL View)	Index Back
Discussion Message Discussion Message

EOFD_SRCH_VW2

(SQL View)

Discussion Message

SELECT A.EOFD_MESSAGE_ID , A.EOFD_MSG_PRNT_ID , A.OPRID , A.EOFD_CONTENT , A.CREATEDTTM , 'EOFD_FILE_ATTACH' , A.ATTACHSYSFILENAME , A.ATTACHUSERFILE , A.EOFD_STATUS , A.LASTUPDDTTM FROM PS_EOFD_DSCN_MSG A

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