index back

User Roles

A simple view on table psroleuser -- selects both dynamic and static role-users.
SELECT roleuser , rolename , dynamic_sw FROM PSROLEUSER

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

    Prompt Table: %EDITTABLE

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

    Y/N Table Edit

    Default: N

    index back (c)David Kurtz 2020, PeopleTools 8.58
    PTRef generated on 21-DEC-20