LM_OBJV_POS_VW

(SQL View)
 Index Back

Position Prompt table

Contains the valid Positions with effective date , descriptions & effective status

SELECT A.LM_POSITION_NBR , A.LM_POSN_DESCR FROM PS_LM_POSITION A , PS_LM_POSTN_OBJV B WHERE B.LM_POSITION_NBR = A.LM_POSITION_NBR

  • Related Language Record: LM_OBJV_POS_LVW

    • # 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