EM_ROLEMULTI_VW

(SQL View)
 Index Back

Role User View


SELECT C.ROLENAME , A.BUSINESS_UNIT , B.ROLEUSER , B.DESCR , A.OPRID , B.EMAILID FROM PS_SEC_BU_OPR A , PS_ROLEXLATOPR B , PSROLEUSER C , PS_EM_ROLE_CONFIG R WHERE B.ROLEUSER=C.ROLEUSER AND A.OPRID=B.OPRID AND R.EM_ROLENAME=C.ROLENAME

  • Related Language Record: EM_ROLMULT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRDEFN2

    6 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address