Permission list Vs Pages access in Peoplesoft

[sampath kumar bodiga]

Below is the query I have to written to find access level that a
specific permission list has on menu and pages this may help you to
create a security matrix for your application

SELECT CLASSID,MENUNAME,BARITEMNAME,PNLITEMNAME, CASE WHEN
DISPLAYONLY=1 THEN 'YES' ELSE 'NO' END AS 'DISPLAYONLY', CASE WHEN
AUTHORIZEDACTIONS IN(1,3,5,7,9,11,13,15) THEN 'YES' ELSE 'NO' END AS
'ADD', CASE WHEN AUTHORIZEDACTIONS IN (2,3,6,7,10,11,14,15) THEN 'YES'
ELSE 'NO' END AS 'UPDATE/DISPLAY', CASE WHEN AUTHORIZEDACTIONS
IN(4,5,6,7,12,13,14,15) THEN 'YES' ELSE 'NO' END AS 'UPDATE/DISPLAY
ALL', CASE WHEN AUTHORIZEDACTIONS IN (8,9,10,11,12,13,14,15) THEN
'YES' ELSE 'NO' END AS 'CORRECTION' FROM PSAUTHITEM WHERE CLASSID
='<Permission ist>'

all the best