PERSON_PHONE (SQL View)	Index Back
Person Preferred Phone Person Phone Numbers - selects the Preferred Phone

PERSON_PHONE

(SQL View)

Person Preferred Phone

Person Phone Numbers - selects the Preferred Phone

SELECT EMPLID ,COUNTRY_CODE ,PHONE ,EXTENSION FROM PS_PERSONAL_PHONE WHERE PREF_PHONE_FLAG = 'Y'

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code

3 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

4 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone number extension

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
3	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
4	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone number extension