AM_BOOK_SES_VW

(SQL View)
Index Back

Book Security for PTSF


SELECT BK.BOOK , 'A:ALL' FROM PS_BOOK_DEFN_TBL BK UNION SELECT OPR.BOOK , 'B:' %Concat OPR.BOOK FROM PS_BOOK_DEFN_TBL OPR UNION SELECT CLS.BOOK , 'P:' %Concat CLS.OPRCLASS FROM PS_SEC_BOOK_CLS CLS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
2 BOOK_SECURITY_SES Character(40) VARCHAR2(40) NOT NULL Book Security