SECVREC_ROLE_VW

(SQL View)
 Index Back

SELECT RECNAME FROM PSRECDEFN A WHERE RECNAME LIKE 'SECV%VW' AND EXISTS ( SELECT 'X' FROM PSRECFIELDDB X WHERE A.RECNAME = X.RECNAME AND FIELDNAME = 'ROLENAME') AND EXISTS ( SELECT 'X' FROM PSRECFIELDDB X2 WHERE A.RECNAME = X2.RECNAME AND FIELDNAME = 'PRODSRCID')

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