PSWEBLIBCREFVW

(SQL View)
Index Back

Authorized Menu Item view


SELECT DISTINCT CLASSID , MENUNAME , BARNAME , BARITEMNAME , PNLITEMNAME FROM PSAUTHITEM WHERE MENUNAME LIKE 'WEBLIB_%'

  • Parent record: PSOPRDEFN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
    2 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

    Prompt Table: PSMENUDEFN

    3 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
    4 BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
    5 PNLITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name