EOFD_GRP_USR_VW

(SQL View)
Index Back

Group/User Description

Group/User Description

SELECT 'U' ,OPRID ,OPRDEFNDESC FROM PSOPRDEFN UNION SELECT 'G' ,EOFD_PARTICIPANT ,DESCR FROM PS_EOFD_DSCN_GROUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOFD_PARTCPANT_TYP Character(1) VARCHAR2(1) NOT NULL Participant Type
G=Discussion Group
U=User
2 EOFD_PARTICIPANT Character(30) VARCHAR2(30) NOT NULL Participant
3 EOFD_GRP_USR_DESCR Character(30) VARCHAR2(30) NOT NULL Group or User Description