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 NameField TypeColumn TypeDescription
ROLEUSERCharacter(30)VARCHAR2(30) NOT NULLRole User
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).
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