SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[PS_PERSON_PHONE] (EMPLID, COUNTRY_CODE, PHONE, EXTENSION)
 AS SELECT EMPLID ,COUNTRY_CODE ,PHONE ,EXTENSION FROM
 PS_PERSONAL_PHONE WHERE PREF_PHONE_FLAG = 'Y'