EOFD_MESSAGE_IDEOFD_DSCN_ATTVW(SQL View) |
Index Back |
|---|---|
Discussion Attachements View |
| SELECT EOFD_MSG_PRNT_ID , URL_ID , ATTACHSYSFILENAME , ATTACHUSERFILE , OPRID , LASTUPDDTTM AS EOFD_LAST_UPD_DTTM , EOFD_CONTENT FROM PS_EOFD_DSCN_MSG WHERE (URL_ID <> ' ' AND ATTACHSYSFILENAME <> ' ' AND ATTACHUSERFILE <> ' ') OR (ATTACHSYSFILENAME = 'URL') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOFD_MESSAGE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Discussion Message ID |
| 2 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL | URL Identifier (see PSURLDEFN). |
| 3 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 4 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | EOFD_LAST_UPD_DTTM | DateTime(26) | TIMESTAMP | Uploaded Date-Time |
| 7 | EOFD_CONTENT | Long Character | CLOB | Discussion message content |