LM_NAME_EML_VW (SQL View)	Index Back
First Name Last Name Email VW This view returns First Name, Last Name and Email View for Learner

LM_NAME_EML_VW

(SQL View)

First Name Last Name Email VW

This view returns First Name, Last Name and Email View for Learner

SELECT N.LM_PERSON_ID , N.FIRST_NAME , N.LAST_NAME , E.LM_EMAIL_ADDR FROM PS_LM_PERS_NAME_VW N LEFT OUTER JOIN PS_LM_PERS_EML_VW E ON N.LM_PERSON_ID = E.LM_PERSON_ID

# 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 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field

3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field

4 LM_EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address

#	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	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name field
3	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name Field
4	LM_EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address