PS_PTLT_COMP_NAV

PS_PTLT_COMP_NAV – Define Components Navigation Setup record (in PT>=8.4xx). It is a very useful table especially when you are given a certain PeopleSoft link or Component and you don’t know how to identify the navigation path. The record stores the PTLT_TASK_CODE which is the component name followed by the market name “.GBL”/Global extension, the PTLT_FEATURES_LIST which represents the general features that the component/page encloses (eg: for the component -BUS_UNIT_TBL_BI.GBL – Set Up Financials/Supply Chain > Business Unit Related > Billing > Billing Definition the enclosed features are “”BI Business Unit Billing General Promotions Management General” ), the product code lists (PTLT_PROD_CD_LIST) which stores a list of relevant module/functional abreviations for the specific component (eg:AM,BI,AR,etc – Asset Management,BI – Business Intelligence, AR – Accounts Receivable), and finally the Navigation path to the current page (NAVIGATION) (eg: for USERMAINT.GBL – Navigation field is PeopleTools > Security > User Profiles > User Profiles). If the component has no corresponding Portal Navigation path the field stores “No Portal Navigation Available”.
To determine the path to a certain component in PeopleSoft one can issue the following SQL statement:
SELECT NAVIGATION FROM PS_PTLT_COMP_NAV WHERE PTLT_TASK_CODE=’COMPONENT_NAME.GBL’
To determine the type of access,components/menus and navigation paths on which a permission list grants rights one can run the following query:

[sql] view plain copy print ?

1. select DISTINCT N.NAVIGATION, 
2.                 N.PTLT_TASK_CODE COMPONENT, 
3.                 b.menuname MENU, 
4.                 a.CLASSID PERMISSION_LIST, 
5.                 DECODE(a.DISPLAYONLY, 1, 'TRUE', 0, 'FALSE') DISPLAYONLY, 
6.                 (CASE 
7.                   WHEN a.AUTHORIZEDACTIONS = 1THEN 
8.                    'ADD' 
9.                   WHEN a.AUTHORIZEDACTIONS = 2THEN 
10.                    'UPDATE,DISPLAY' 
11.                   WHEN a.AUTHORIZEDACTIONS = 3THEN 
12.                    'ADD,UPDATE,DISPLAY' 
13.                   WHEN a.AUTHORIZEDACTIONS = 4THEN 
14.                    'UPDATE/DISPLAY ONLY' 
15.                   WHEN a.AUTHORIZEDACTIONS = 5THEN 
16.                    'ADD,UPDATE/DISPLAY ALL' 
17.                   WHEN a.AUTHORIZEDACTIONS = 6THEN 
18.                    'UPDATE,DISPLAY,UPDATE/DISPLAY ALL' 
19.                   WHEN a.AUTHORIZEDACTIONS = 7THEN 
20.                    'ADD,UPDATE,DISPLAY,UPDATE/DISPLAY ALL' 
21.                   WHEN a.AUTHORIZEDACTIONS = 8THEN 
22.                    'CORRECTION' 
23.                   WHEN a.AUTHORIZEDACTIONS = 9THEN 
24.                    'ADD,CORRECTION' 
25.                   WHEN a.AUTHORIZEDACTIONS = 10THEN 
26.                    'UPDATE,DISPLAY,CORRECTION' 
27.                   WHEN a.AUTHORIZEDACTIONS = 11THEN 
28.                    'ADD, UPDATE/DISPLAY ALL, CORRECTION' 
29.                   WHEN a.AUTHORIZEDACTIONS = 12THEN 
30.                    'UPDATE/DISPLAY ALL,CORRECTION' 
31.                   WHEN a.AUTHORIZEDACTIONS = 13THEN 
32.                    'ADD, UPDATE, DISPLAY,UPDATE/DISPLAY ALL,CORRECTION' 
33.                   WHEN a.AUTHORIZEDACTIONS = 14THEN 
34.                    'UPDATE,DISPLAY,UPDATE/DISPLAY ALL,CORRECTION' 
35.                   WHEN a.AUTHORIZEDACTIONS = 15THEN 
36.                    'ADD,UPDATE,DISPLAY,UPDATE/DISPLAY ALL,CORRECTION' 
37.                   WHEN a.AUTHORIZEDACTIONS = 128THEN 
38.                    'DATA ENTRY' 
39.                   ELSE 
40.                    'UNKNOWN' 
41.                 END) AUTHORIZEDACTIONS 
42.   FROM PS_PTLT_COMP_NAV N 
43. inner join PSMENUITEM bON N.PTLT_TASK_CODE = b.PNLGRPNAME || '.GBL' 
44. inner join PSAUTHITEM aON a.menuname = b.menuname 
45.                         AND a.baritemname = b.itemname 
46. where a.CLASSID='YourPermissionList' 

select DISTINCT N.NAVIGATION,
                N.PTLT_TASK_CODE COMPONENT,
                b.menuname MENU,
                a.CLASSID PERMISSION_LIST,
                DECODE(a.DISPLAYONLY, 1, 'TRUE', 0, 'FALSE') DISPLAYONLY,
                (CASE
                  WHEN a.AUTHORIZEDACTIONS = 1 THEN
                   'ADD'
                  WHEN a.AUTHORIZEDACTIONS = 2 THEN
                   'UPDATE,DISPLAY'
                  WHEN a.AUTHORIZEDACTIONS = 3 THEN
                   'ADD,UPDATE,DISPLAY'
                  WHEN a.AUTHORIZEDACTIONS = 4 THEN
                   'UPDATE/DISPLAY ONLY'
                  WHEN a.AUTHORIZEDACTIONS = 5 THEN
                   'ADD,UPDATE/DISPLAY ALL'
                  WHEN a.AUTHORIZEDACTIONS = 6 THEN
                   'UPDATE,DISPLAY,UPDATE/DISPLAY ALL'
                  WHEN a.AUTHORIZEDACTIONS = 7 THEN
                   'ADD,UPDATE,DISPLAY,UPDATE/DISPLAY ALL'
                  WHEN a.AUTHORIZEDACTIONS = 8 THEN
                   'CORRECTION'
                  WHEN a.AUTHORIZEDACTIONS = 9 THEN
                   'ADD,CORRECTION'
                  WHEN a.AUTHORIZEDACTIONS = 10 THEN
                   'UPDATE,DISPLAY,CORRECTION'
                  WHEN a.AUTHORIZEDACTIONS = 11 THEN
                   'ADD, UPDATE/DISPLAY ALL, CORRECTION'
                  WHEN a.AUTHORIZEDACTIONS = 12 THEN
                   'UPDATE/DISPLAY ALL,CORRECTION'
                  WHEN a.AUTHORIZEDACTIONS = 13 THEN
                   'ADD, UPDATE, DISPLAY,UPDATE/DISPLAY ALL,CORRECTION'
                  WHEN a.AUTHORIZEDACTIONS = 14 THEN
                   'UPDATE,DISPLAY,UPDATE/DISPLAY ALL,CORRECTION'
                  WHEN a.AUTHORIZEDACTIONS = 15 THEN
                   'ADD,UPDATE,DISPLAY,UPDATE/DISPLAY ALL,CORRECTION'
                  WHEN a.AUTHORIZEDACTIONS = 128 THEN
                   'DATA ENTRY'
                  ELSE
                   'UNKNOWN'
                END) AUTHORIZEDACTIONS
  FROM PS_PTLT_COMP_NAV N
 inner join PSMENUITEM b ON N.PTLT_TASK_CODE = b.PNLGRPNAME || '.GBL'
 inner join PSAUTHITEM a ON a.menuname = b.menuname
                        AND a.baritemname = b.itemname
where a.CLASSID='YourPermissionList'