PS_PTLT_COMP_NAV

最新推荐文章于 2024-10-31 22:45:47 发布

conanxun

最新推荐文章于 2024-10-31 22:45:47 发布

阅读量827

点赞数

分类专栏： SQL 文章标签： features list components extension path join

SQL 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

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:

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'