RE_EMP_EMAIL(SQL View) |
Index Back |
---|---|
employee's work emailEmployee work email to be sent over to CAFM. |
SELECT A.EMPLID , B.EMAIL_ADDR FROM %Table (RE_CAFM_EMP_STG) A , %Table(EMAIL_ADDRESSES) B WHERE A.EMPLID = B.EMPLID (+) |
# | 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 |