PTAL_USER_LVW

(SQL View)
 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 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label