LM_HR_POSTN_VW

(SQL View)
 Index Back

Positions

Contains all Active Positions

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

  • Related Language Record: LM_POSTN_LG_VW

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