OPRROLEUSER_VW2

(SQL View)
Index Back

Roleuser by Operator View


SELECT A.OPRID , A.ROLEUSER , A.DESCR , A.EMAILID , A.FORMID , A.WORKLIST_USER_SW , A.EMAIL_USER_SW , A.FORMS_USER_SW , A.EMPLID , A.ROLEUSER_ALT FROM PS_ROLEXLATOPR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPERATOR_VW

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

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

Y/N Table Edit

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

9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

10 ROLEUSER_ALT Character(30) VARCHAR2(30) NOT NULL Alternate Role User

Prompt Table: ROLEXLATOPR