PSROLEDEFN_SRCH

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
    Q=Query
    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
    A=Active
    I=Inactive

    Default: A

    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19