SP_BK_ALL_OPRVW

(SQL View)
 Index Back

View of All Books w/Descr


SELECT DISTINCT D.OPRID , A.BOOK , A.DESCR FROM PS_BOOK_DEFN_TBL A , PS_SEC_BUBOOK_OPR D WHERE D.BOOK = A.BOOK

  • Related Language Record: BK_DEFN_LN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description