PeopleSoft Wiki

Thanks Praj, That's really helpful. I'm now going to push my luck even further on this !

Do you know if there is a way to link the Bar Item Names and Page Names back to the labels they are given within the portal?

So for example on this report it pulls back Menu Name as Administer_Workforce_(GBL)

On the portal Menu it show's as Administer Workforce. Same thing applies for Bar Items and page names. Bar Item on the report is DEPARTMENT_TBL_GBL on the Menu it's Departments.

It would be realy good if I could link it back to the user friendly names if possible.

Thanks
Steve

No problems. Yes there is a way to get that information from the database - everything is stored in the database after all :)

The linkage between pages/components/menus and the portal isn't as simple. The table you'll need is PSPRSMDEFN which is the portal registry structure definition table. It stores the hierarchical structure of the portal as a table, making it a bit more complicated to understand. This table doesn't follow the conventions of the menu structure beyond the menu name. So things like the bar item aren't relevant. In PeopleTools 8+ menus are used purely for security, and navigation is replaced by the portal which causes some confusion!

As the portal is a tree structure, each entry in the table has a parent (except for the portals themselves), and the top most nodes (e.g. PeopleTools - PT_PEOPLETOOLS) have PORTAL_ROOT_OBJECT as their parents. The portals themselves are things like EMPLOYEE, CUSTOMER, MOBILE) etc.

HRMS uses the EMPLOYEE portal which you can see at the start of all your URLs as http://server:port/psp/ps/EMPLOYEE etc. Also, each portal entry can either be a folder or a content reference. This is termed as the content type. To simplify, think of folders as containers and content references as links to things.

To get a better idea of the structure of the portal, go to:
PeopleTools > Portal > Structure and Content

This is the adminstration interface to the portal structure.

Any way, that's just a bit of background. Getting back to your question, to get the portal label you'll need to know the menu name (e.g. ADMINISTER_WORKFORCE_(GBL) and the component name). For example, if you wanted to get the portal label for the Job Data component you need to know the menu name (ADMINISTER_WORKFORCE_(GBL)) and the component name (JOB_DATA) which you can get using CTRL + J.

In the earlier post about getting the item label, note that the PSPNLGROUP table includes the component name as the field PNLGRPNAME. So you should be able to get the menu and component in your query which you can then use to link to the PSPRSMDEFN table.

So here's a quick example of a query to get all the portal labels for content references under the ADMINISTER_WORKFORCE_(GBL) menu:

select
    PORTAL_OBJNAME,
    PORTAL_LABEL,
    PORTAL_URI_SEG1 as MENUNAME,
    PORTAL_URI_SEG2 as COMPONENT
from 
    PSPRSMDEFN
where
    PORTAL_NAME = 'EMPLOYEE'
    and PORTAL_REFTYPE = 'C'
    and PORTAL_URI_SEG1 = 'ADMINISTER_WORKFORCE_(GBL)'    
    and PORTAL_LABEL <> ' '
order by PORTAL_LABEL;

You'll notice that to link to menu name you use the field PORTAL_URI_SEG1 and to link to component you use the field PORTAL_URI_SEG2 which I've aliased in the query as MENUNAME and COMPONENT to make it clear.

Since you are working in the EMPLOYEE portal and you want content references (actual links to components) as opposed to folders which are just containers (e.g. Job Information), you need to specify the content type as C. You also want to exclude any items with a blank portal label.

I know this is a lot of information, but hopefully it makes some sense and answers your question. Good luck.

Hi,

That's worked a treat. I'd already found the Portal definition table whilst playing around. What I hadn't managed to crack was the correct keys to join the tables. Your reply has cured that problem.

Thanks very much for your help.

Steve

Hello,

currently i am creating a CROSS-REFERENCE-(SCRIPT) of the whole PeopleSoft Application!
I need to explain where PORTAL is linked (short-cutted) to the PANEL

Can any one help me ?!

Hi,

I'm presuming you want to know how to determine the page that a particular content reference in the portal refers to? For instance, what page is behind the portal navigation PeopleTools > Security > User Profiles > User Profiles?. I might have this wrong so please advise if this isn't what you want :)

To start with if you look in PeopleTools > Portal > Structure and Content and edit the User Profiles PT_USERMAINT_GBL content reference (under PeopleTools > Security User Profiles), you will find it only points to the component USERMAINT. The page that is displayed is normally the first visible page in this component. You can get the first visible page from the PSPNLGROUP record. So in essence if you join this with the portal record PSPRSMDEFN you can get the page.

Here's some example SQL for the PT_USERMAINT_GBL content reference that would do this for you:

select
    PORTAL_OBJNAME,
    PORTAL_LABEL,
    C.PNLGRPNAME as COMPONENT,
    C.MARKET,
    C.PNLNAME as PAGE,
    C.ITEMLABEL as PAGE_DESCRIPTION    
from 
    PSPRSMDEFN P inner join PSPNLGROUP C
    on  P.PORTAL_NAME = 'EMPLOYEE'
    and P.PORTAL_REFTYPE = 'C'
    and P.PORTAL_URI_SEG2 = C.PNLGRPNAME    
    and P.PORTAL_URI_SEG3 = C.MARKET
where 
    P.PORTAL_OBJNAME = 'PT_USERMAINT_GBL'
    and C.SUBITEMNUM = (
        select  min(SUBITEMNUM)
        from    PSPNLGROUP
        where   PNLGRPNAME = C.PNLGRPNAME
        and     C.HIDDEN = 0
    )
;

Yeah Praj!
This is what i need!

But now, i know where the Portal refers to the page, i gotta know where it will be checked for the Security (Permissionlists)

So where do PeopleSoft check if i am allowed to visit or see this page or not!

In this case i say a lot of THANKS Praj, u doin really WELL !

best regards
juZtroCkwiTiT

Thanks - glad that helped you out.

As you know, portal security is controlled by permission lists and this information is stored in the record PSPRSMPERM (portal registry permissions).

This record tells you the permission lists associated with each and every portal folder and content reference (the permission list is stored in the PORTAL_PERMNAME field). Simply join to this record using the PORTAL_OBJNAME field if you want to use it with the previous SQL I posted.

You might also be interested in this forum post if you want to find out what access a particular user has.

Hi Praj

Thanks a lot for answering - however - I am only working in my HR 88 DEMO environment - which is why I am so confused. It is not the cache - as we have recreated it etc. The HC_WAGE_PROGRESSION Folder is found via the PIA - I can open it, edit it, drill down to the child records etc when looking at the Portal definition. I can change a flag - SAVE it, Open it - change the Flag back, SAVE it etc etc. I can also access the Pages in that Folder when using the system online - all in DEMO. I can also understand why the App Desigenr does not find it - as I cannot find it in PSPRSMDEFN. However - The only difference I found with this Folder, as compared to the other I do find is the Flag : Is Folder Navigation Disabled. has been ticked. I have un-ticked it, SAVED it - but nothing changes. Where else can this Folder definition live ? If you have access to a HR 88 DEMO environment - you might have a look ad see if
select * from PSPRSMDEFN
where PORTAL_REFTYPE = 'F'
AND PORTAL_OBJNAME IN ( 'HC_WAGE_PROGRESSION','HC_LABOR_RELATIONS');

returns more than 1 row?

Thanks !

Hi Praj - I found the problem! My trusty DBA made a typo in the web config file - I was looking at a HR91 Database, when it should have been a HR88 Database. No wonder I was missing some rows from the PSPRSMDEFN table !!

Thanks a lot for your help - I learnt a lot re Portals….

Ah yes, that will get you every time :)

Glad you worked it out.