WM_INALT_USR_VW

(SQL View)
 Index Back

Inspection Alert Msg User Vw


SELECT ROLEUSER , DESCR , OPRID , EMAILID , FORMID , WORKLIST_USER_SW , EMAIL_USER_SW , FORMS_USER_SW , EMPLID FROM PS_ROLEXLATOPR_VW WHERE EMAIL_USER_SW = 'Y'

  • Related Language Record: WM_INALT_USR_LV

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

    Prompt Table: OPRDEFN2

    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
    7 EMAIL_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets workflow email generated
    8 FORMS_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets workflow Lotus forms generated
    9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID