SCC_EML_NTF_VW(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID , A.SCC_EMAIL_NTF_IND , A.E_ADDR_TYPE , A.SCC_NTF_LANG , B.EMAIL_ADDR FROM PS_SCC_NTF_PREF A , PS_EMAIL_ADDRESSES B WHERE A.emplid = B.emplid AND A.E_ADDR_TYPE=B.E_ADDR_TYPE AND A.SCC_EMAIL_NTF_IND = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SCC_SMS_NTF_IND | Character(1) | VARCHAR2(1) NOT NULL | User Preference flag for SMS notifications |
| 3 | 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 |
| 4 | SCC_NTF_LANG | Character(3) | VARCHAR2(3) NOT NULL |
Notification Language Preference
CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese |
| 5 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |