EP_OBJ_ITEM_SCH(SQL View) |
Index Back |
---|---|
Copy Item from Objective PageCopy 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' |
# | 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 |