PTPHP_SRCHP_VW

index back

Portal User Homepage Tab data

Portal User Homepage Tab data
SELECT A.PORTAL_NAME , A.OPRID , A.PORTAL_OBJNAME , A.PORTAL_LABEL FROM PSPRUHTAB A WHERE A.PORTAL_OBJNAME IN ( SELECT B.PORTAL_OBJNAME FROM PSPRSMDEFN B WHERE B.portal_cref_usgt = 'GRPT' AND B.PORTAL_OBJNAME <> 'NAVBAR' AND A.PORTAL_NAME = B.PORTAL_NAME)

PeopleSoft Field Name Field Type Column Type Description
PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20