LM_PERS_SEL_VW

(SQL View)
 Index Back

Person Details View

Contains a Persons Detail fields for Use by Other Modules without Organization join

SELECT A.LM_PERSON_ID , B.OPRID , D.LM_ACTIVE , C.FIRST_NAME , C.LAST_NAME , C.NAME , D.LM_ORGANIZATION_ID , 0 , ' ' , ' ' , D.LM_JOB_TITLE , D.LM_JOBCODE_ID , D.LM_HIRE_DT , A.LM_HR_EMPLID , C.LAST_NAME_SRCH , C.FIRST_NAME_SRCH , C.NAME_AC , A.LM_EXT_PERSON_FLG , C.LM_NAME_DISPLAY , 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_OPRID B ,PS_LM_PERSON_NAME C ,PS_LM_CURR_JOB_VW D WHERE D.LM_PERSON_ID = A.LM_PERSON_ID AND %CurrentDateIn BETWEEN D.EFFDT AND D.LM_END_EFFDT AND D.LM_ACTIVE = 'Y' AND B.LM_PERSON_ID = A.LM_PERSON_ID AND C.LM_PERSON_ID = A.LM_PERSON_ID AND C.LM_DISPLAY_FLAG = '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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 LM_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active
N=Inactive
Y=Active
4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
6 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
8 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID
9 LM_MGR_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Manager First Name
10 LM_MGR_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Manager Last Name
11 LM_JOB_TITLE Character(30) VARCHAR2(30) NOT NULL Job Title
12 LM_JOBCODE_ID Number(15,0) DECIMAL(15) NOT NULL JobCode ID
13 LM_HIRE_DT Date(10) DATE Hire Date
14 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
15 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
16 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
17 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name
18 LM_EXT_PERSON_FLG Character(1) VARCHAR2(1) NOT NULL External Person Flag

Y/N Table Edit

19 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
20 LM_EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address