EOFD_DTYP_ROLE

(SQL View)
 Index Back

Privileges

Discussion Type Privileges

SELECT EOFD_DSCN_TYPE_ID , EOFD_ROLENAME , EOFD_ROLE_DESCR , EOFD_ALLOW_CLOSE , EOFD_ALLOW_EDPTCPT , EOFD_ALLOW_EDSUBJ , EOFD_ALLOW_ASGNROL FROM PS_EOFD_DTYP_PRVLG WHERE eofd_rolename <>'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOFD_DSCN_TYPE_ID Character(30) VARCHAR2(30) NOT NULL Discussion Type
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
4 EOFD_ALLOW_CLOSE Character(1) VARCHAR2(1) NOT NULL All Open Close for Discussion

Y/N Table Edit

5 EOFD_ALLOW_EDPTCPT Character(1) VARCHAR2(1) NOT NULL All Edit of Participant

Y/N Table Edit

6 EOFD_ALLOW_EDSUBJ Character(1) VARCHAR2(1) NOT NULL Allow edit of discussion subject

Y/N Table Edit

7 EOFD_ALLOW_ASGNROL Character(1) VARCHAR2(1) NOT NULL Allow edit of discussion subject

Y/N Table Edit