SSR_RS_EMAIL_H(SQL View) |
Index Back |
---|---|
Email AddressesCampus Solutions hollow view for the core EMAIL_ADDRESSES table. Data is actually sourced from the Service Oriented Architecture. |
SELECT ' ' , ' ' FROM %Table(INSTALLATION_SA) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |
2 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |