DFW_ADM_SEC_PL

index back

SELECT DISTINCT RU.ROLEUSER , PC.MENUNAME , PC.BARNAME , PC.BARITEMNAME , PC.PNLITEMNAME FROM PSROLEUSER RU , PSROLECLASS RC , PSAUTHITEM PC WHERE RU.ROLENAME = RC.ROLENAME AND RC.CLASSID = PC.CLASSID

PeopleSoft Field Name Field Type Column Type Description
ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
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