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 NameField TypeColumn TypeDescription
ROLEUSERCharacter(30)VARCHAR2(30) NOT NULLRole User
ROLENAMECharacter(30)VARCHAR2(30) NOT NULLThe name of a Role in the Role Definition Table (see PSROLEDEFN).
CLASSIDCharacter(30)VARCHAR2(30) NOT NULLThe name of the class (see PSCLASSDEFN).
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).
PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
PNLNAMECharacter(30)VARCHAR2(30) NOT NULLPage Name (see PSPNLDEFN).
BARNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Bar Name
BARITEMNAMECharacter(30)VARCHAR2(30) NOT NULLBar Item Name
PNLITEMNAMECharacter(30)VARCHAR2(30) NOT NULLPanel Item Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19