EMPLIDRS_EMPL_EMAIL_V(SQL View) |
Index Back |
|---|---|
RS_EMPL_EMAIL_VView to get the Email Address for the Employee present in the system. We first look in to EMAIL_ADDRESSES with type as 'BUSN' and if no Email Address is found we access the PSOPRDEFN for Email Adddress. |
| SELECT B.EMPLID , CASE WHEN A.EMAIL_ADDR IS NULL THEN ( SELECT C.EMAILID FROM PSOPRDEFN C WHERE C.EMPLID = B.EMPLID) ELSE A.EMAIL_ADDR END "EMAIL_ADDR" FROM PS_EMAIL_ADDRESSES A RIGHT OUTER JOIN PS_PERSONAL_DATA B ON A.EMPLID = B.EMPLID AND A.E_ADDR_TYPE ='BUSN' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |