ROLEXLATOPR_VW

 index back

Role User View


select roleuser, descr, oprid, emailid, formid, worklist_user_sw, email_user_sw, forms_user_sw, emplid, roleuser_alt, roleuser_supr from PS_ROLEXLATOPR

  • Related language record: ROLEXLATOPR_LVW

    • PeopleSoft Field Name Field Type Column Type Description
    ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRDEFN2

    EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    FORMID Character(70) VARCHAR2(70) NOT NULL Form ID
    WORKLIST_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets a worklist generated
    EMAIL_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets workflow email generated
    FORMS_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets workflow Lotus forms generated
    EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    ROLEUSER_ALT Character(30) VARCHAR2(30) NOT NULL Alternate Role User
    ROLEUSER_SUPR Character(30) VARCHAR2(30) NOT NULL Supervisor Role User
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20