PTAL_USER_LVW

index back

Personalize Search Record Lang

Language record of search record for Personalize Pagelet Area Component
SELECT DISTINCT B.OPRID , A.PORTAL_NAME , A.PORTAL_OBJNAME , C.LANGUAGE_CD , C.PORTAL_LABEL FROM %Table(PTAL_PAGE) A , %Table(PSOPRDEFN) B , %Table(PSPRSMDEFNLANG) C WHERE (C.PORTAL_NAME = A.PORTAL_NAME) AND (C.PORTAL_REFTYPE = 'C') AND (C.PORTAL_OBJNAME = A.PORTAL_OBJNAME )

  • Related language record for PTAL_USER_SVW
  • 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
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19