LM_POS_EFFDT_VW

(SQL View)
Index Back

Position Effdt View

Returns valid effective dates for a postion.

SELECT LM_POSITION_NBR , EFFDT FROM PS_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

Default Value: %date