TL_PORTALLBL_VW

(SQL View)
 Index Back

Portal Label View

View against Portal definition that helps bring in the label based on menu name and object name of the portal entry.

SELECT CREF.PORTAL_URI_SEG1 , CREF.PORTAL_OBJNAME , CREF.PORTAL_LABEL , P.PORTAL_LABEL FROM PSPRSMDEFN CREF , PSPRSMDEFN P WHERE CREF.PORTAL_NAME = 'EMPLOYEE' AND CREF.PORTAL_REFTYPE = 'C' AND CREF.PORTAL_NAME = P.PORTAL_NAME AND P.PORTAL_REFTYPE = 'F' AND CREF.PORTAL_PRNTOBJNAME = P.PORTAL_OBJNAME

  • Related Language Record: TL_PORTALLBL_LV

  • Parent Record Of TL_PORTALLBL_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    3 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    4 PORTAL_LABEL2 Character(30) VARCHAR2(30) NOT NULL Label 2