index back

Role Definition View

Another view on Role Definition table to select all Roles except 'PeopleSoft Administrator'. (Note: View: PSROLEDEFN_SRCH selects different set of columns.)
SELECT rolename , descr , %TextIn(descrlong) , rolestatus FROM PSROLEDEFN WHERE rolename <> 'PeopleSoft Administrator'

  • Related language record: PSROLEDEFN_L_VW
  • PeopleSoft Field Name Field Type Column Type Description
    ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    DESCRLONG Long Character CLOB Long Description
    ROLESTATUS Character(1) VARCHAR2(1) NOT NULL Role Status
    index back (c)David Kurtz 2020, PeopleTools 8.58
    PTRef generated on 21-DEC-20