EOFD_MESSAGE_IDEOFD_ROLENAMEA=Administrator
C=Creator
P=Participant
EOFD_ROLEDESC_V(SQL View) |
Index Back |
|---|---|
Role Description |
| SELECT DISTINCT A.EOFD_MESSAGE_ID , B.EOFD_ROLENAME ,B.EOFD_ROLE_DESCR FROM PS_EOFD_DTYPMSG_VW A , PS_EOFD_DTYP_PRVLG B WHERE A.EOFD_DSCN_TYPE_ID = B.EOFD_DSCN_TYPE_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_ROLENAME |
Character(1) | VARCHAR2(1) NOT NULL |
Particpant Role
A=Administrator C=Creator P=Participant |
| 3 | EOFD_ROLE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Role Description |