RBF_AS_FLDR_LST

(SQL View)
Index Back

Search View for nav Security

Search View for nav Security

SELECT a.ROLENAME , a.PORTAL_NAME ,a.PORTAL_OBJNAME , b.PORTAL_LABEL FROM PS_RBF_NAV_SRTY a , PSPRSMDEFN b WHERE a.PORTAL_OBJNAME = b.PORTAL_OBJNAME AND b.PORTAL_REFTYPE = 'F'

  • Related Language Record: RBF_AS_FLDL_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
    2 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    3 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    4 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label