EMPLIDE_ADDR_TYPEBUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
SAE_LDAP_EMALVW(SQL View) |
Index Back |
|---|---|
SAIP LDAP EMAIL ADDRESSESSAIP LDAP EMAIL ADDRESSES |
| SELECT EML.EMPLID ,EML.E_ADDR_TYPE ,XLAT.XLATLONGNAME ,EML.EMAIL_ADDR ,EML.PREF_EMAIL_FLAG FROM %Table(HCR_PER_EMAIL_I) EML , %Table(PSXLATITEM) XLAT WHERE XLAT.FIELDNAME = 'E_ADDR_TYPE' AND XLAT.FIELDVALUE = EML.E_ADDR_TYPE AND %EffdtCheck(PSXLATITEM XLAT2, XLAT, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 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 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 4 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 5 | PREF_EMAIL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Preferred |