EPO_PG_ITEM(SQL Table) |
Index Back |
|---|---|
Objectives Page ItemHolds the Item information for the Objectives Pages |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(8,0) | INTEGER NOT NULL |
Objectives Management: Objective Page ID
Prompt Table: EPO_PG_HDR |
|
| 2 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
| 3 | Character(8) | VARCHAR2(8) NOT NULL |
Objectives Section type
Prompt Table: EPO_SECTN_DEFN |
|
| 4 | 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 |