PTAL_USER_SVW

 index back

Personalize Search Record

Search Record for Personalize Pagelet Area Component
SELECT DISTINCT B.OPRID , A.PORTAL_NAME , A.PORTAL_OBJNAME , C.PORTAL_LABEL FROM %Table(PTAL_PAGE) A , %Table(PSOPRDEFN) B , %Table(PSPRSMDEFN) C WHERE (C.PORTAL_NAME = A.PORTAL_NAME) AND (C.PORTAL_REFTYPE = 'C') AND (C.PORTAL_OBJNAME = A.PORTAL_OBJNAME )

  • Related language record: PTAL_USER_LVW

    • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Menu Item 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