RC_BP_ROLE_VW

(SQL View)
 Index Back

Business Process Role View

This is a view of all the roles in the PSROLEDEFN table. This is used for assigning tasks to roles.

SELECT ROLENAME , DESCR , ROLETYPE FROM PSROLEDEFN WHERE ROLETYPE = 'U'

  • Related Language Record: RC_BP_ROLE_VW_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RC_ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL This is a field to store assignment information.
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 ROLETYPE Character(1) VARCHAR2(1) NOT NULL Role Type
    Q=Query
    U=User List