RD_ROLEUSR_VW

(SQL View)
Index Back

User Roles for Distributed

User Roles for Distributed User Maintanence to handle the Can Grant Role Security for Partners.

SELECT roleuser , rolename , dynamic_sw FROM PSROLEUSER

  • Parent record: PSOPRDEFN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
    2 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: PSROLEGRANTVW

    3 DYNAMIC_SW Character(1) VARCHAR2(1) NOT NULL Dynamic

    Y/N Table Edit

    Default Value: N