LM_LNR_MERGE_VW

(SQL View)
 Index Back

SELECT A.LM_PERSON_ID , A.LM_HR_EMPLID , D.FIRST_NAME_SRCH , D.LAST_NAME_SRCH , D.LM_NAME_DISPLAY , E.LM_EMAIL_ADDR , F.LM_PHONE FROM PS_LM_PERSON A , PS_LM_CURR_JOB_VW B , PS_LM_PERSON_NAME D , PS_LM_PERSON_EMAIL E , PS_LM_PERSON_PHONE F WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND B.LM_ACTIVE = 'Y' AND A.LM_EXT_PERSON_FLG = 'N' AND F.LM_PERSON_ID = A.LM_PERSON_ID AND F.LM_PRIMARY = 'Y' AND E.LM_PERSON_ID = A.LM_PERSON_ID AND E.LM_PRIMARY = 'Y' AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND D.LM_PERSON_ID = A.LM_PERSON_ID AND D.LM_DISPLAY_FLAG = 'Y' AND %CurrentDateIn BETWEEN D.EFFDT AND D.LM_END_EFFDT AND ((D.LM_NAME_TYPE = 'PRF') OR (D.LM_NAME_TYPE = 'PRI' AND NOT EXISTS ( SELECT LM_NAME_TYPE FROM PS_LM_PERSON_NAME WHERE LM_PERSON_ID = D.LM_PERSON_ID AND LM_NAME_TYPE = 'PRF' AND %CurrentDateIn BETWEEN EFFDT AND 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 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
3 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
5 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
6 LM_EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address
7 LM_PHONE Character(24) VARCHAR2(24) NOT NULL Phone