DARTS : SCC_PERS_PH_QVW- Phone Numbers Query View

SCC_PERS_PH_QVW is a view of PERSONAL_PHONE table. Since PERSONAL_PHONE is not available in PS Query, use this view to get phone numbers for reporting.

Key	Record.Fieldname	Format	XLAT	Heading Text
	COUNTRY_CODE - Country Code	Char3		Country
→	EMPLID - Empl ID	Char11		ID
	EXTENSION - Phone Extension	Char6		Ext
	PHONE - Telephone	Char24		Phone
→	PHONE_TYPE - Phone Type	Char4	N	Type
	PREF_PHONE_FLAG - Preferred	Char1		Preferred

SQL code for SCC_PERS_PH_QVW

--CREATE OR REPLACE VIEW SYSADM.PS_SCC_PERS_PH_QVW AS
SELECT A.EMPLID,
       A.PHONE_TYPE,
       A.COUNTRY_CODE,
       A.PHONE,
       A.EXTENSION,
       A.PREF_PHONE_FLAG
  FROM PS_PERSONAL_PHONE A;