SP_BOOK_CLSVW

(SQL View)
Index Back

Sec Vw - Asset Books


SELECT DISTINCT S.OPRCLASS , A.SETID , A.BOOK , A.DESCR FROM PS_BOOK_DEFN_TBL A , PS_SEC_BUBOOK_CLS S WHERE A.BOOK = S.BOOK

  • Related Language Record: SP_BOOK_CLSLNVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    3 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

    Prompt Table: SP_BOOK_NONVW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description