EOSU_ROLE_VW

(SQL View)
 Index Back

SELECT A.ROLENAME ,A.DESCR FROM PSROLEDEFN A WHERE( EXISTS ( SELECT 'X' FROM ps_eosu_rvwd_role B WHERE A.ROLENAME=B.ROLENAME) OR EXISTS ( SELECT 'X' FROM PS_EOSU_ROLE_MAP C WHERE A.ROLENAME=C.eosu_rstr_role AND c.eosu_sample_role<>' '))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description