LM_EXT_LRN_VW

(SQL View)
 Index Back

External learner list


SELECT A.LM_PERSON_ID , D.FIRST_NAME , D.LAST_NAME , D.LM_NAME_DISPLAY , E.LM_ORG_DESCR , D.MIDDLE_NAME , A.LM_BIRTHDATE ,F.LM_SEX FROM PS_LM_PERSON A , PS_LM_CURR_JOB_VW B , PS_LM_PERSON_NAME D , PS_LM_ORGANIZATION E ,PS_LM_PERSON_EFFDT F WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND F.LM_PERSON_ID = A.LM_PERSON_ID AND A.LM_EXT_PERSON_FLG = '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 %CurrentDateIn BETWEEN F.EFFDT AND F.LM_END_EFFDT AND E.LM_ORGANIZATION_ID = B.LM_ORGANIZATION_ID AND B.EFFDT BETWEEN E.EFFDT AND E.LM_END_EFFDT AND E.EFF_STATUS = 'A' 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 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_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
5 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description
6 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
7 LM_BIRTHDATE Date(10) DATE Birthdate
8 LM_SEX Character(1) VARCHAR2(1) NOT NULL Sex
F=Female
M=Male
U=Unknown