LM_POSTN_LG_VW1 (SQL View)	Index Back
Position Language view Language View for Position with effective date

LM_POSTN_LG_VW1

(SQL View)

Position Language view

Language View for Position with effective date

SELECT A.LM_POSITION_NBR , A.EFFDT , B.LANGUAGE_CD , B.LM_POSN_DESCR FROM PS_LM_POSITION A , PS_LM_POSN_LANG B WHERE A.LM_POSITION_NBR = B.LM_POSITION_NBR AND A.EFFDT = B.EFFDT AND %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT

Related Language Record for LM_HR_POSTN_VW1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_POSITION_NBR Character(15) VARCHAR2(15) NOT NULL Position Number

2 EFFDT Date(10) DATE Effective Date

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 LM_POSN_DESCR Character(50) VARCHAR2(50) NOT NULL Position Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_POSITION_NBR	Character(15)	VARCHAR2(15) NOT NULL	Position Number
2	EFFDT	Date(10)	DATE	Effective Date
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	LM_POSN_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Position Description