PSROLEXLATOPRVW

(SQL View)
 Index Back

Role User View

Relates Roleusers and Operators.

SELECT oprid , roleuser , descr , emailid , formid , worklist_user_sw , email_user_sw , forms_user_sw , emplid , roleuser_alt , roleuser_supr , effdt_from , effdt_to FROM PS_ROLEXLATOPR

  • Related Language Record: PSROLEXLATOPRLV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    5 FORMID Character(70) VARCHAR2(70) NOT NULL Form ID
    6 WORKLIST_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets a worklist generated

    Y/N Table Edit

    Default Value: Y

    7 EMAIL_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets workflow email generated

    Y/N Table Edit

    Default Value: Y

    8 FORMS_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets workflow Lotus forms generated

    Y/N Table Edit

    Default Value: Y

    9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    10 ROLEUSER_ALT Character(30) VARCHAR2(30) NOT NULL Alternate Role User

    Prompt Table: PSOPRDEFN_ASRCH

    11 ROLEUSER_SUPR Character(30) VARCHAR2(30) NOT NULL Supervisor Role User

    Prompt Table: PSOPRDEFN_ASRCH

    12 EFFDT_FROM Date(10) DATE Effective Date From
    13 EFFDT_TO Date(10) DATE Effective Date To