SAD_SL_EMAIL_VW(SQL View) |
Index Back |
---|---|
E-Mail AddressesUse EMAIL_ADDRESSES to record E-Mail addresses for people. A person may have as many different E-Mail addresses as there are types. |
SELECT A.EMPLID , C.E_ADDR_TYPE , A.EMAIL_ADDR FROM PS_EMAIL_ADDRESSES A , PS_ADDR_ORDER_TBL C , PS_SAD_SL_EM_USAGE D WHERE A.E_ADDR_TYPE = C.E_ADDR_TYPE AND C.ADDR_USAGE = D.ADDR_USAGE AND C.ADDR_USAGE_ORDER = ( SELECT MIN(C1.ADDR_USAGE_ORDER) FROM PS_ADDR_ORDER_TBL C1 WHERE C1.ADDR_USAGE = D.ADDR_USAGE AND C1.E_ADDR_TYPE IN ( SELECT A1.E_ADDR_TYPE FROM PS_EMAIL_ADDRESSES A1 WHERE A1.EMPLID = A.EMPLID)) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
2 | E_ADDR_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Email Address Type.
Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other |
3 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |