EPO_POSN_SCH_LV

(SQL View)
 Index Back

Position Search Results

Left Outer Join View Used to display search results in search banner grid.

SELECT POSN.POSITION_NBR , POSNL.LANGUAGE_CD , %Upper(POSNL.DESCR) , POSNL.DESCR FROM PS_POS_DATA_EF_VW POSN LEFT OUTER JOIN PS_EPO_PGHDR_EFF_V PG ON POSN.POSITION_NBR = %Substring(PG.EPO_NODE_ID,1,8) , PS_POSN_DATA_LANG POSNL WHERE POSN.POSITION_NBR = POSNL.POSITION_NBR AND POSN.EFFDT = POSNL.EFFDT

  • Related Language Record for EPO_POSN_SCH_VW

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 POSN_DESCR Character(30) VARCHAR2(30) NOT NULL Position Description