EPO_PG_ITEM

(SQL Table)
Index Back

Objectives Page Item

Holds the Item information for the Objectives Pages

  • 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

    Prompt Table: JPM_C_LIST_VW

    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