POSITION_VIEW2

(SQL View)
Index Back

Posn Descr - Employment Titles

POSITION_VIEW2 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 ,EFFDT ,DESCR ,DESCRSHORT FROM PS_POSITION_DATA

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