PT_IQREGROLE

(SQL View)
 Index Back

Roles per CREF


SELECT DISTINCT C.PORTAL_NAME , C.PORTAL_OBJNAME , B.ROLENAME , E.DESCR FROM PSROLECLASS B , PSPRSMPERM C , PSPRSMDEFN D , PSROLEDEFN E WHERE C.PORTAL_OBJNAME = D.PORTAL_OBJNAME AND B.CLASSID = C.PORTAL_PERMNAME AND B.ROLENAME = E.ROLENAME

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