EP_OBJ_ITEM_SCH

(SQL View)
Index Back

Copy Item from Objective Page

Copy Item from Objective Page

SELECT ITM.EPO_OBJ_ITEM_ID , 'O' , ITM.EP_TITLE , PG.EFFDT , ITM.EPO_ITEM_SEQ , PG.SETID , SECT.EPO_SECTION_TYPE , SECT.EP_J_ITEM_CAT_TYPE , ITM.EP_ITEM_ID , ITM.EP_DESCR254 , ITM.EP_MEASURE , ITM.EPO_ITEM_PCT , ITM.EPO_ITEM_DUE_DT , ITM.EPO_ITEM_STATUS , ITM.EPO_ITEM_MOD_ID , ITM.EPO_ITEM_MOD_DTTM , ITM.EPO_ITEM_PUB_DT , PG.EPO_PAGE_ID FROM PS_EPO_OBJ_PLAN PLN , PS_EPO_PG_HDR PG , PS_EPO_PG_SECTION SECT , PS_EPO_PG_ITEM ITM WHERE PG.EPO_PAGE_STATUS = 'P' AND PLN.EPO_OBJ_PLAN = PG.EPO_OBJ_PLAN AND SECT.EPO_PAGE_ID = PG.EPO_PAGE_ID AND SECT.EFFDT = PG.EFFDT AND ITM.EPO_PAGE_ID = SECT.EPO_PAGE_ID AND ITM.EFFDT = SECT.EFFDT AND ITM.EPO_SECTION_TYPE = SECT.EPO_SECTION_TYPE AND ITM.EPO_OBJ_STATUS = 'A'

  • Related Language Record: EP_OBJ_ITEM_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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.
    2 EP_STATUS_IND Character(1) VARCHAR2(1) NOT NULL work field to specify whether the document is in Establish Criteria or Evaluation stage.
    B=Estab Criteria: from other doc
    C=Establish Criteria
    E=Evaluation
    F=Eval: from other docs
    3 EP_TITLE Character(60) VARCHAR2(60) NOT NULL Title of an item
    4 EPO_PAGE_EFFDT Date(10) DATE Page Effective Date
    5 EPO_ITEM_SEQ Number(2,0) SMALLINT NOT NULL Objectives Item sequence number
    6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    7 EPO_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Objectives Section type
    8 EP_J_ITEM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL ePerformance specific version of the JPM Catalog Type field.
    9 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier
    10 EP_DESCR254 Long Character CLOB 1325 character description field used in ePerformance
    11 EP_MEASURE Long Character CLOB 1325 Character Item measurement description
    12 EPO_ITEM_PCT Number(3,0) SMALLINT NOT NULL Percent completion of an Objective item.
    13 EPO_ITEM_DUE_DT Date(10) DATE Date that an item on an Objective Page is due.
    14 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
    15 EPO_ITEM_MOD_ID Character(12) VARCHAR2(12) NOT NULL Modified By ID
    16 EPO_ITEM_MOD_DTTM DateTime(26) TIMESTAMP Datetime stamp of when an Item on an Objective Page was last modified
    17 EPO_ITEM_PUB_DT Date(10) DATE Date that the Item on an Objective Page was published
    18 EPO_PAGE_ID Number(8,0) INTEGER NOT NULL Objectives Management: Objective Page ID