LM_PERS_DTL_VW5

(SQL View)
 Index Back

Person Details View

Contains a Persons Detail fields for Use by Other Modules

SELECT A.LM_PERSON_ID , A.LM_EXT_PERSON_FLG , C.LM_NAME_DISPLAY , C.LM_ROW_MAINT_DTTM FROM PS_LM_PERSON A ,PS_LM_PERSON_NAME C ,PS_LM_CURR_JOB_VW D WHERE D.LM_PERSON_ID = A.LM_PERSON_ID AND D.EFFDT = ( SELECT MAX(EFFDT) FROM PS_LM_CURR_JOB_VW INR WHERE INR.LM_PERSON_ID = D.LM_PERSON_ID AND INR.LM_EMPL_RCD = D.LM_EMPL_RCD) AND C.LM_PERSON_ID = A.LM_PERSON_ID AND C.LM_DISPLAY_FLAG = 'Y' AND D.LM_ACTIVE = 'Y' AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT AND ((C.LM_NAME_TYPE = 'PRF') OR (C.LM_NAME_TYPE = 'PRI' AND NOT EXISTS ( SELECT LM_NAME_TYPE FROM PS_LM_PERSON_NAME WHERE LM_PERSON_ID = c.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_EXT_PERSON_FLG Character(1) VARCHAR2(1) NOT NULL External Person Flag

Y/N Table Edit

3 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
4 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime