index back

Role Definition View (RL)

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

  • Related language record for PSROLEDEFN_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).
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    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