RA_ROLEUSER_VW

(SQL View)
 Index Back

Role User View

Added " AND C.OPRALIASTYPE = 'PER' " to the WHERE clause

SELECT DISTINCT D.BO_ID , B.ROLENAME , E.DESCR FROM PS_ROLEXLATOPR A , PSROLEUSER B , PSOPRALIAS C , PS_RD_PERSON D , PSROLEDEFN E WHERE A.ROLEUSER = B.ROLEUSER AND A.OPRID = C.OPRID AND C.PERSON_ID = D.PERSON_ID AND B.ROLENAME=E.ROLENAME

  • Related Language Record: RA_ROLEUSERLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    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