ACL_WEBLIB_VW2

(SQL View)
 Index Back

Authorized Menu Item

Made AUTHORIZEDACTIONS an alternate key field. This is now required by the tool when making a field a related display field.

SELECT DISTINCT A.CLASSID , A.MENUNAME , A.BARNAME , A.BARITEMNAME , A.PNLITEMNAME , A.DISPLAYONLY , A.AUTHORIZEDACTIONS FROM PSAUTHITEM A 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
    6 DISPLAYONLY Number(1,0) SMALLINT NOT NULL Display Only
    7 AUTHORIZEDACTIONS Number(10,0) DECIMAL(10) NOT NULL Authorized Actions for Panels