EM_S_ROLE_VW

(SQL View)
Index Back

eS Roles Configured

Returns list of user-defined Roles that are configured/mapped to eS Supplier role types (excludes System Administrator in result set. Add a Supplier Role to System Administrators User Profile to include).

SELECT DISTINCT A.ROLEUSER , D.GRANTROLENAME , B.DESCR FROM PSROLEUSER A , PSROLEDEFN B , PS_EM_ROLE_CONFIG C , PSROLECANGRANT D WHERE A.ROLENAME = D.ROLENAME AND D.GRANTROLENAME = C.EM_ROLENAME AND B.ROLENAME = C.EM_ROLENAME AND C.EM_ROLETYPE IN ('25', '30')

  • Related Language Record: EM_S_ROLE_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description