POSN_VW_LANG

(SQL View)
 Index Back

Posn Descr - Employment Titles

POSITION_VIEW is a view which retrieves only the title from the Position Data record. It is used for the Reports-To Position title on Employment, since Position Data is already brought into the panel via related-display to Job.Position_Nbr.

SELECT POSITION_NBR ,LANGUAGE_CD ,EFFDT ,DESCR ,DESCRSHORT FROM PS_POSN_DATA_LANG

  • Related Language Record for HR_VT_POS_VW POSITION_FL_VW POSITION_VIEW POSITION_VIEW2 POSITION_VW POSITION_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description