LM_PERS_PHON_VW (SQL View)	Index Back
Person Phone View Contains a person's current, primary phone number

LM_PERS_PHON_VW

(SQL View)

Person Phone View

Contains a person's current, primary phone number

SELECT LM_PERSON_ID , LM_COUNTRY_CODE , LM_PHONE , LM_PHONE_EXT FROM PS_LM_PERSON_PHONE WHERE LM_PRIMARY = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

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

3 LM_PHONE Character(24) VARCHAR2(24) NOT NULL Phone

4 LM_PHONE_EXT Character(6) VARCHAR2(6) NOT NULL Phone extension

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
2	LM_COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
3	LM_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Phone
4	LM_PHONE_EXT	Character(6)	VARCHAR2(6) NOT NULL	Phone extension