PO_SETID_SEC_VW

(SQL View)
 Index Back

PO SETID Security for PTSF


SELECT SI.SETID , 'A:ALL' FROM PS_SETID_TBL SI UNION SELECT OPR.SETID , 'S:' %Concat OPR.SETID FROM PS_SETID_TBL OPR UNION SELECT CLS.SETID , 'P:' %Concat CLS.OPRCLASS FROM PS_SEC_SETID_CLS CLS UNION SELECT 'S:NOS' , 'N:NULL' FROM PS_INSTALLATION_FS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 SETID_SECURITY_SES Character(40) VARCHAR2(40) NOT NULL SETID Security