DARTS : SCC_EMAIL_QVW - Email Address Query View & EMAIL_ADDRESSES - Email Addresses

SCC_EMAIL_QVW is an exact view of EMAIL_ADDRESSES which is available in PS Query. Use this table for reporting.

EMAIL_ADDRESSES is a staging table available only to developers using other tools. These are both PeopleSoft delivered.

CS-3505 - PS_EMAIL_ADDRESSES Closed

Data Dictionary Links

Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.

SCC_EMAIL_QVW - Email Address (use this for reporting)

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

Tips

When you use SCC_EMAIL_QVW, following conditions may help you to extract one email address per person.

E_ADDR_TYPE = 'BUSN'
PREF_EMAIL_FLAG = 'Y'

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;

EMAIL_ADDRESSES - Email Addresses (developers only)

Key	Record.Fieldname	Format	XLAT	Heading Text	Notes
→	EMPLID - Empl ID	Char11		ID
→	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

DARTS : SCC_EMAIL_QVW - Email Address Query View & EMAIL_ADDRESSES - Email Addresses

SCC_EMAIL_QVW - Email Address (use this for reporting)

EMAIL_ADDRESSES - Email Addresses (developers only)

Attachments: