SCC_SMS_NTF_VW(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID , A.SCC_SMS_NTF_IND , A.PHONE_TYPE , A.SCC_NTF_LANG , B.COUNTRY_CODE , B.PHONE FROM PS_SCC_NTF_PREF A , PS_PERSONAL_PHONE B WHERE A.emplid = B.emplid AND A.PHONE_TYPE=B.PHONE_TYPE AND A.SCC_SMS_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 | PHONE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work |
| 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 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Country Code |
| 6 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |