LM_POSITION_LVW

(SQL View)
 Index Back

Positions

Contains all Active Positions

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

  • Related Language Record for LM_POSITION_VW

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