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 |