EPO_PG_ITM_LANG

(SQL View)
 Index Back

Objectives Page Item

Holds the Item information of the Objectives Pages to display for alignment on documents

SELECT A.EPO_PAGE_ID , A.EPO_SECTION_TYPE , A.EPO_OBJ_ITEM_ID , D.LANGUAGE_CD , A.EP_ITEM_ID , D.JPM_DESCR90 , B.EP_J_ITEM_CAT_TYPE FROM PS_EPO_PG_ITEM A , PS_EPO_PG_SECTION B , PS_EPO_PG_HDR C , PS_JPM_CAT_ITM_LNG D WHERE A.EPO_PAGE_ID = C.EPO_PAGE_ID AND B.EPO_PAGE_ID = C.EPO_PAGE_ID AND A.EPO_SECTION_TYPE = B.EPO_SECTION_TYPE AND %EffdtCheck(EPO_PG_SECTION EFFS, B, C.EFFDT) AND %EffdtCheck(EPO_PG_ITEM EFFI, A, C.EFFDT) AND D.JPM_CAT_TYPE = B.EP_J_ITEM_CAT_TYPE AND D.JPM_CAT_ITEM_ID = A.EP_ITEM_ID AND %EffdtCheck(JPM_CAT_ITM_LNG EFF, D, C.EFFDT) AND A.EPO_OBJ_STATUS = 'A' AND C.EPO_PAGE_STATUS = 'P' AND A.EP_ITEM_ID <> ' ' UNION SELECT A.EPO_PAGE_ID , A.EPO_SECTION_TYPE , A.EPO_OBJ_ITEM_ID , A.LANGUAGE_CD , D.EP_ITEM_ID , A.EP_TITLE , B.EP_J_ITEM_CAT_TYPE FROM PS_EPO_PGITEM_LANG A , PS_EPO_PG_SECTION B , PS_EPO_PG_HDR C , PS_EPO_PG_ITEM D WHERE A.EPO_PAGE_ID = C.EPO_PAGE_ID AND B.EPO_PAGE_ID = C.EPO_PAGE_ID AND D.EPO_PAGE_ID = C.EPO_PAGE_ID AND A.EPO_SECTION_TYPE = D.EPO_SECTION_TYPE AND B.EPO_SECTION_TYPE = D.EPO_SECTION_TYPE AND A.EFFDT = C.EFFDT AND B.EFFDT = C.EFFDT AND D.EFFDT = C.EFFDT AND D.EPO_OBJ_STATUS = 'A' AND D.EP_ITEM_ID = ' ' AND C.EPO_PAGE_STATUS = 'P'

  • Related Language Record for EPO_PG_ITEM_VW

  • Parent record: EPO_PG_SECTION

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EPO_PAGE_ID Number(8,0) INTEGER NOT NULL Objectives Management: Objective Page ID

    Prompt Table: EPO_PG_HDR

    2 EPO_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Objectives Section type

    Prompt Table: EPO_SECTN_DEFN

    3 EPO_OBJ_ITEM_ID Number(8,0) INTEGER NOT NULL Objectives Management: Objective Item ID. Used as a key to hold unique values as Item ID is not a key in Objective Management. It will uniquely define an item on ePerformance document when cascaded or copied over.
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier
    6 EP_TITLE Character(60) VARCHAR2(60) NOT NULL Title of an item
    7 EP_J_ITEM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL ePerformance specific version of the JPM Catalog Type field.