LM_PERS_DTL_VW3

(SQL View)
 Index Back

Person Details View

Contains a Persons Detail fields for Use by Other Modules

SELECT A.LM_PERSON_ID , A.LM_HR_EMPLID , D.FIRST_NAME , D.LAST_NAME , D.LM_NAME_DISPLAY , B.LM_ORGANIZATION_ID , 0 , B.LM_JOB_TITLE , B.LM_JOBCODE_ID , B.LM_POSITION_NBR , B.BUSINESS_UNIT , B.LM_HIRE_DT , B.LM_ACTIVE FROM PS_LM_PERSON A , PS_LM_CURR_JOB_VW B , PS_LM_PERSON_NAME D WHERE B.LM_PERSON_ID = A.LM_PERSON_ID 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

Prompt Table: LM_PERS_NAME_VW

2 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
5 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
6 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
7 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID
8 LM_JOB_TITLE Character(30) VARCHAR2(30) NOT NULL Job Title
9 LM_JOBCODE_ID Number(15,0) DECIMAL(15) NOT NULL JobCode ID
10 LM_POSITION_NBR Character(15) VARCHAR2(15) NOT NULL Position Number
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
12 LM_HIRE_DT Date(10) DATE Hire Date
13 LM_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active
N=Inactive
Y=Active