PSROLEDEFN_SRCH

Return to Index

A view on Role Definition table to select all Roles except 'PeopleSoft Administrator'.

PlatformView Text
DefaultSELECT 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 NameDescription
    ROLENAMEThe name of a Role in the Role Definition Table
    ROLETYPERole Type
    Q=Query
    U=User List (default)
    QRYNAMEQuery Name

    Prompt Table: PSROLEQRY_VW

    DESCRDescription
    ROLESTATUSRole Status
    A=Active (default)
    I=Inactive

    Author: PeopleTools

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 24 July 2010