SECREC_QROLE_VW

(SQL View)
 Index Back

SELECT RECNAME FROM PSRECDEFN A WHERE EXISTS ( SELECT 'X' FROM PSRECFIELDDB X WHERE A.RECNAME = X.RECNAME AND FIELDNAME = 'ROLENAME')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).