LM_POSTN_LG_VW

(SQL View)
 Index Back

Language View for Position

Language View for Position without effective date

SELECT A.LM_POSITION_NBR , B.LANGUAGE_CD , A.LM_POSN_DESCR , A.LM_POSN_SDESCR 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_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