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 | 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 |