LM_POSEFDT_VW (SQL View)	Index Back
POSITION EFFECTIVE DATE VIEW POSITION EFFECTIVE DATE VIEW-- Created a part of resolution 895878

LM_POSEFDT_VW

(SQL View)

POSITION EFFECTIVE DATE VIEW

POSITION EFFECTIVE DATE VIEW-- Created a part of resolution 895878

SELECT B.LM_POSITION_NBR ,A.EFFDT ,A.LM_END_EFFDT FROM PS_LM_POSITION A ,PS_LM_POSGR_VW B WHERE A.LM_POSITION_NBR=B.LM_POSITION_NBR

# 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
Default Value: %date

3 LM_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it

#	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 Default Value: %date
3	LM_END_EFFDT	Date(10)	DATE	The end effective date, automatically maintained, there's a doc on how this works, so read it