ACL_PAGES_VW1

index back

Classid / Menu Items

This SQL view joins a selected classid to all menu items in a selected menu. It is used in SavePostChange Peoplecode to populate PSAUTHITEM with all available selections for a menu, when a user select "SELECT ALL" from the component page of the ACL Maintenance component.
SELECT D.CLASSID ,A.MENUNAME , A.ITEMNUM , B.SUBITEMNUM , A.BARNAME , A.ITEMNAME , B.ITEMNAME , A.BARLABEL , A.ITEMLABEL , B.ITEMLABEL ,c.actions FROM PSMENUITEM A , PSPNLGROUP B , PSPNLGRPDEFN C , PSCLASSDEFN D WHERE A.ITEMNAME NOT LIKE 'MENUITEM%' AND B.PNLGRPNAME = A.PNLGRPNAME AND A.MARKET = B.MARKET AND B.MARKET = C.MARKET AND B.PNLGRPNAME = C.PNLGRPNAME

PeopleSoft Field Name Field Type Column Type Description
CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

Prompt Table: PSMENUDEFN

ITEMNUM Number(4,0) SMALLINT NOT NULL Item Number
SUBITEMNUM Number(4,0) SMALLINT NOT NULL Sub Item Number
BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
PNLITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name
BARLABEL Character(10) VARCHAR2(10) NOT NULL Menu Bar Label
ITEMLABEL Character(30) VARCHAR2(30) NOT NULL Menu Item Label
PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
ACTIONS Number(4,0) SMALLINT NOT NULL Actions
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20