PTAI_CHKSEC_VW

index back

SELECT Z.ROLEUSER , Z.ROLENAME , Y.CLASSID , A.MENUNAME , A.PNLGRPNAME , A.MARKET , B.PNLNAME , C.BARNAME , C.BARITEMNAME , C.PNLITEMNAME FROM PSROLEUSER Z , PSROLECLASS Y , PSMENUITEM A , PSPNLGROUP B , PSAUTHITEM C WHERE Y.ROLENAME = Z.ROLENAME AND Y.CLASSID = C.CLASSID AND A.MENUNAME = C.MENUNAME AND A.BARNAME = C.BARNAME AND A.ITEMNAME = C.BARITEMNAME AND A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND C.AUTHORIZEDACTIONS > 0

PeopleSoft Field Name Field Type Column Type Description
ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
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).
PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
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
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19