PTAL_USER_SVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    3 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Menu Item Name
    4 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label