FSFB_ROLEUSER2

(SQL View)
 Index Back

Role User


SELECT B.ROLENAME , A.OPRID , A.OPRDEFNDESC FROM PSOPRDEFN A , PSROLEUSER B WHERE A.OPRID = B.ROLEUSER

  • Parent record: PSROLEDEFN

    • # 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user