PSPTTSTROLE_VW

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 Field Type Column Type Description
ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
DESCR Character(30) VARCHAR2(30) NOT NULL Description
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20