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 NameField TypeColumn TypeDescription
CLASSIDCharacter(30)VARCHAR2(30) NOT NULLThe name of the class (see PSCLASSDEFN).
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).

Prompt Table: PSMENUDEFN

ITEMNUMNumber(4,0)SMALLINT NOT NULLItem Number
SUBITEMNUMNumber(4,0)SMALLINT NOT NULLSub Item Number
BARNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Bar Name
BARITEMNAMECharacter(30)VARCHAR2(30) NOT NULLBar Item Name
PNLITEMNAMECharacter(30)VARCHAR2(30) NOT NULLPanel Item Name
BARLABELCharacter(10)VARCHAR2(10) NOT NULLMenu Bar Label
ITEMLABELCharacter(30)VARCHAR2(30) NOT NULLMenu Item Label
PNLNAMECharacter(30)VARCHAR2(30) NOT NULLPage Name (see PSPNLDEFN).
ACTIONSNumber(4,0)SMALLINT NOT NULLActions
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19