EMAIL_ADDRESSES - Email Addresses & SCC_EMAIL_QVW - Email Address Query View

Body

EMAIL_ADDRESSES is a source table available in Human Resources and Campus Solutions. These are both PeopleSoft-delivered tables.
SCC_EMAIL_QVW is an exact view of EMAIL_ADDRESSES which is available in Campus Solutions PS Query. Use this table for reporting.

 Detailed Information  

EMAIL TYPES

Field Value Translate Long Name Translate Short Name
BUSN Business Business
CAMP Campus Campus
GRAD Post-graduation Post-grad
HOME Home Home
OTHR Other Other
PAR1 Parent1 Parent1
PAR2 Parent2 Parent2

EMAIL_ADDRESSES - Email Addresses

Key Record.Fieldname Format XLAT Heading Text Notes
 Key EMPLID - Empl ID Char11   ID  
Key  E_ADDR_TYPE - Email Type Char4 N Type To get all types
select * from sysadm.ps_email_type_xlvw
  EMAIL_ADDR - Email Address Char70   Email  
  PREF_EMAIL_FLAG - Preferred Char1   Preferred  

SCC_EMAIL_QVW - Email Address (use this for reporting in Campus Solutions)

Key Record.Fieldname Format XLAT Heading Text Notes
  EMAIL_ADDR - Email Address Char70   Email  
Key EMPLID - Empl ID Char11   ID  
Key E_ADDR_TYPE - Email Type Char4 N Type

  PREF_EMAIL_FLAG - Preferred Char1   Preferred  
The following criteria will help you to extract one University of Maine System email address per person.
  • E_ADDR_TYPE = 'BUSN'
SQL for SCC_EMAIL_QVW
CREATE OR REPLACE VIEW SYSADM.PS_SCC_EMAIL_QVW AS
SELECT 
A.EMPLID, 
A.E_ADDR_TYPE, 
A.EMAIL_ADDR,
A.PREF_EMAIL_FLAG 
FROM PS_EMAIL_ADDRESSES A;

Environment

PeopleSoft

Details

Details

Article ID: 158845
Created
Fri 5/10/24 4:26 AM
Modified
Tue 8/6/24 12:53 PM
Applies To
Faculty
Staff
Community

Related Services / Offerings

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)