WV_USRACCESS_VW

(SQL View)
 Index Back

supplier user access view

5/1/2004 cel

SELECT DISTINCT F.PORTAL_NAME , F.PORTAL_REFTYPE , F.PORTAL_OBJNAME , A.ROLEUSER , C.MENUNAME , C.BARITEMNAME , E.PNLGRPNAME , F.PORTAL_PRNTOBJNAME , F.PORTAL_CREF_USGT , F.OBJECTOWNERID , F.PORTAL_LABEL FROM PSROLEUSER A , PSROLECLASS B , PSAUTHITEM C , PSMENUITEM D , PSPNLGRPDEFN E , PSPRSMDEFN F WHERE A.ROLENAME = B.ROLENAME AND B.CLASSID = C.CLASSID AND C.BARITEMNAME <> 'FieldFormula' AND C.MENUNAME = D.MENUNAME AND C.BARITEMNAME = D.ITEMNAME AND D.PNLGRPNAME = E.PNLGRPNAME AND F.PORTAL_URI_SEG1 = D.MENUNAME AND F.PORTAL_URI_SEG2 = E.PNLGRPNAME AND F.PORTAL_REFTYPE = 'C'

  • Related Language Record: WV_USRACCESSLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    2 PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
    C=Content
    F=Folder
    3 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    4 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
    5 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    6 BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
    7 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    8 PORTAL_PRNTOBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Parent Object Name
    9 PORTAL_CREF_USGT Character(4) VARCHAR2(4) NOT NULL Usage Type
    FRMT=Frame template
    GRPT=Fluid Homepage
    HPGC=Pagelet
    HPGT=Homepage tab
    HTMT=HTML template
    IFRM=Inline frame template
    LINK=Content Reference Link
    TARG=Target
    10 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    11 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label