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 NameField TypeColumn TypeDescription
    ROLENAMECharacter(30)VARCHAR2(30) NOT NULLThe name of a Role in the Role Definition Table (see PSROLEDEFN).
    ROLETYPECharacter(1)VARCHAR2(1) NOT NULLRole Type
    U=User List

    Default: U

    QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name

    Prompt Table: PSROLEQRY_VW

    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    ROLESTATUSCharacter(1)VARCHAR2(1) NOT NULLRole Status

    Default: A

    index back(c)David Kurtz 2019, 8.54
    PTRef generated on 09-JUN-19