LM_NAM_EML_VW

(SQL View)
 Index Back

First Name Last Name Email VW

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

SELECT A.LM_PERSON_ID, B.FIRST_NAME, B.LAST_NAME, E.LM_EMAIL_ADDR FROM PS_LM_PERSON A LEFT OUTER JOIN PS_LM_PERS_EML_VW E ON A.LM_PERSON_ID = E.LM_PERSON_ID, PS_LM_PERSON_NAME B WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND B.LM_DISPLAY_FLAG = 'Y' AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND ((B.LM_NAME_TYPE = 'PRF') OR (B.LM_NAME_TYPE = 'PRI' AND NOT EXISTS (SELECT P.LM_NAME_TYPE FROM PS_LM_PERSON_NAME P WHERE P.LM_PERSON_ID = B.LM_PERSON_ID AND P.LM_NAME_TYPE = 'PRF' AND %CurrentDateIn BETWEEN P.EFFDT AND P.LM_END_EFFDT)))

# 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