index back

Role Definition View

A view on Role Definition table to select all Roles except 'PeopleSoft Administrator'.
SELECT b.rolename , b.roletype , b.qryname , b.descr , b.rolestatus FROM PSROLEDEFN b WHERE b.rolename <> 'PeopleSoft Administrator'

  • Related language record: PSROLESRCH_LANG
  • 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).
    ROLETYPE Character(1) VARCHAR2(1) NOT NULL Role Type
    U=User List

    Default: U

    QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

    Prompt Table: PSROLEQRY_VW

    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    ROLESTATUS Character(1) VARCHAR2(1) NOT NULL Role Status

    Default: A

    index back (c)David Kurtz 2020, PeopleTools 8.58
    PTRef generated on 21-DEC-20