SECQRY_PERM_VW

(SQL View)
 Index Back

SELECT RECNAME FROM PSRECDEFN A WHERE EXISTS ( SELECT 'X' FROM PSRECFIELDDB X WHERE A.RECNAME = X.RECNAME AND FIELDNAME IN('ROWSECCLASS','OPRCLASS'))

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