EPO_PGITMLST_VW

(SQL View)
 Index Back

Objectives Page Item view

Holds the Active Item information for the Objectives Pages that are published to Organisation

SELECT B.EPO_PAGE_ID , B.EFFDT , A.EPO_SECTION_TYPE , A.EPO_OBJ_ITEM_ID , A.EP_ITEM_ID , A.EPO_ITEM_SEQ , A.EP_TITLE , A.EPO_SUP_OBJITEM_ID , A.EPO_ITEM_DUE_DT , A.EPO_ITEM_STATUS , A.EPO_ITEM_SYS_STAT , A.EPO_OBJ_STATUS , A.EPO_ITEM_PCT , A.EPO_ITEM_MOD_ID , A.EPO_ITEM_MOD_DTTM , A.EPO_ITEM_PUB_DT , A.EPO_SYND_FLAG , A.EP_DESCR254 , A.EP_MEASURE FROM PS_EPO_PG_ITEM A , PS_EPO_PG_HDR B WHERE A.EPO_PAGE_ID = B.EPO_PAGE_ID AND A.EFFDT = B.EFFDT AND B.EPO_PAGE_STATUS = 'P' AND A.EPO_OBJ_STATUS <> 'I'

  • Related Language Record: EPO_PGITEM_LANG

  • 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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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

    Prompt Table: EPO_SECTN_DEFN

    4 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.
    5 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier
    6 EPO_ITEM_SEQ Number(2,0) SMALLINT NOT NULL Objectives Item sequence number
    7 EP_TITLE Character(60) VARCHAR2(60) NOT NULL Title of an item
    8 EPO_SUP_OBJITEM_ID Number(8,0) INTEGER NOT NULL Objectives Supporting Item

    Prompt Table: EPO_NO_ITEM_VW

    9 EPO_ITEM_DUE_DT Date(10) DATE Date that an item on an Objective Page is due.
    10 EPO_ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Status of an Item on an Objective Page.
    A=Not Applicable
    C=Complete
    I=In Progress
    11 EPO_ITEM_SYS_STAT Character(1) VARCHAR2(1) NOT NULL Status of an Item on an Objective Page.
    I=In Progress
    P=Published

    Default Value: I

    12 EPO_OBJ_STATUS Character(1) VARCHAR2(1) NOT NULL Objective Status
    A=Active Item
    I=Inactive Item

    Default Value: A

    13 EPO_ITEM_PCT Number(3,0) SMALLINT NOT NULL Percent completion of an Objective item.
    14 EPO_ITEM_MOD_ID Character(12) VARCHAR2(12) NOT NULL Modified By ID
    15 EPO_ITEM_MOD_DTTM DateTime(26) TIMESTAMP Datetime stamp of when an Item on an Objective Page was last modified
    16 EPO_ITEM_PUB_DT Date(10) DATE Date that the Item on an Objective Page was published
    17 EPO_SYND_FLAG Character(1) VARCHAR2(1) NOT NULL Syndication Flag

    Y/N Table Edit

    Default Value: N

    18 EP_DESCR254 Long Character CLOB 1325 character description field used in ePerformance
    19 EP_MEASURE Long Character CLOB 1325 Character Item measurement description