LM_MULTIJOBS_VW (SQL View)	Index Back
Person Job Data Contains Job Data

LM_MULTIJOBS_VW

(SQL View)

Person Job Data

Contains Job Data

SELECT A.LM_PERSON_ID , A.LM_EMPL_RCD , A.EFFDT , A.LM_EFFSEQ , A.LM_ACTIVE , A.LM_JOB_TITLE FROM PS_LM_PERSON_JOB A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_LM_PERSON_JOB B WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND B.LM_EMPL_RCD = A.LM_EMPL_RCD AND B.EFFDT <= %CurrentDateIn ) AND A.LM_EFFSEQ = ( SELECT MAX(C.LM_EFFSEQ) FROM PS_LM_PERSON_JOB C WHERE C.LM_PERSON_ID = A.LM_PERSON_ID AND C.EFFDT = A.EFFDT AND C.LM_EMPL_RCD = A.LM_EMPL_RCD)

# 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_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber

3 EFFDT Date(10) DATE NOT NULL Effective Date

4 LM_EFFSEQ Number(3,0) SMALLINT NOT NULL ELM Effective Sequence

5 LM_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active
N=Inactive
Y=Active
Default Value: Y

6 LM_JOB_TITLE Character(30) VARCHAR2(30) NOT NULL Job Title

#	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_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record umber
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	LM_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	ELM Effective Sequence
5	LM_ACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Active N=Inactive Y=Active Default Value: Y
6	LM_JOB_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Job Title