ROLENAMEGPSC_NF_ROLE_VW(SQL View) |
Index Back |
|---|---|
Fluid Banking Notify RolesUsed to retrieve the email address for the Admin Role of the Fluid Banking Notification Roles. |
| SELECT DISTINCT(A.ROLENAME) , B.EMAILID , B.OPRID FROM PSROLEUSER A , PSUSEREMAIL B WHERE A.ROLENAME IN ( SELECT C.ROLENAME FROM PSROLEUSER C) AND A.ROLEUSER = B.OPRID AND B.PRIMARY_EMAIL = 'Y' GROUP BY A.ROLENAME , B.EMAILID , B.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 2 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |