EPO_POSN_SCH_V2

(SQL View)
 Index Back

Position Search Results

Lists all positions having BO plans.

SELECT POSN.POSITION_NBR , %Upper(POSN.DESCR) , POSN.DESCR , PG.EPO_OBJ_PLAN , PG.EPO_PAGE_ID , PG.EFFDT , PG.EPO_PAGE_OWNER_ID , PG.EPO_PAGE_OWNER_RCD , PG.NAME_DISPLAY_SRCH FROM PS_POS_DATA_EF_VW POSN , PS_EPO_PGHDR_EFFV2 PG WHERE POSN.POSITION_NBR = %Substring(PG.EPO_NODE_ID,1,8)

  • Related Language Record: EPO_POSN_SCH_L2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 POSN_DESCR Character(30) VARCHAR2(30) NOT NULL Position Description
    4 EPO_OBJ_PLAN Character(8) VARCHAR2(8) NOT NULL Objectives Management: Objective Plan ID field
    5 EPO_PAGE_ID Number(8,0) INTEGER NOT NULL Objectives Management: Objective Page ID
    6 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    7 EPO_PAGE_OWNER_ID Character(11) VARCHAR2(11) NOT NULL Objectives Management: Emplid of the person who owns the Objective Page
    8 EPO_PAGE_OWNER_RCD Number(3,0) SMALLINT NOT NULL Page Owner Record Number
    9 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.