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) FROM PSROLEDEFN WHERE rolename <> 'PeopleSoft Administrator' AND rolestatus = 'A'

  • Related language record: PTCDBRLDFNVWLNG
  • 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
    index back (c)David Kurtz 2020, PeopleTools 8.58
    PTRef generated on 21-DEC-20