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 NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
    PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Item Name
    PORTAL_LABELCharacter(30)VARCHAR2(30) NOT NULLPortal Label
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19