PSPTTSTROLE_VW

(SQL View)
Index Back

SELECT DISTINCT A.ROLENAME , 'X' , B.DESCR FROM PSROLECLASS A , PSROLEDEFN B WHERE A.ROLENAME=B.ROLENAME AND B.ROLESTATUS='A' AND (A.CLASSID ='PTPT3400' OR A.CLASSID ='PTPT3600' OR A.CLASSID ='PTPT3700') AND NOT EXISTS ( SELECT 'X' FROM PSROLECLASS C WHERE A.ROLENAME=C.ROLENAME AND C.CLASSID='PTPT3400')

# 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 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description