EM_B_USR_ROL_VW(SQL View) |
Index Back |
|---|---|
eS Roles ConfiguredReturns list of user-defined Roles, Role Users, and their email addresses. Views must be configured/mapped to eS Buyer role types (includes System Administrator in result set). |
| SELECT C.ROLEUSER , C.DESCR , C.EMAILID , A.ROLENAME , A.DESCR FROM PSROLEDEFN A , PS_EM_ROLE_CONFIG B , PS_ROLEXLATOPR C , PSROLEUSER D WHERE A.ROLENAME = B.EM_ROLENAME AND B.EM_ROLENAME = D.ROLENAME AND D.ROLEUSER=C.ROLEUSER AND B.EM_ROLETYPE IN ('05', '10', '15','20') |
| # | 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 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 4 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 5 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |