EPO_SYND_TAO1(SQL Table) |
Index Back |
---|---|
Sydicate Temporary recordTemp record used by the Objectives Syndicate AE program, EPO_SYNDICATE. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(8,0) | INTEGER NOT NULL | Objectives Management: Objective Page ID | |
2 | Character(8) | VARCHAR2(8) NOT NULL | Objectives Section type | |
3 | 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. | |
4 | EP_ITEM_ID | Character(12) | VARCHAR2(12) NOT NULL | Item unique identifier |
5 | EP_TITLE | Character(60) | VARCHAR2(60) NOT NULL | Title of an item |
6 | EPO_SUP_OBJITEM_ID | Number(8,0) | INTEGER NOT NULL | Objectives Supporting Item |
7 | EPO_ITEM_DUE_DT | Date(10) | DATE | Date that an item on an Objective Page is due. |
8 | EPO_OBJ_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Objective Status
A=Active Item I=Inactive Item |
9 | EPO_ITEM_PCT | Number(3,0) | SMALLINT NOT NULL | Percent completion of an Objective item. |
10 | EP_DESCR254 | Long Character | CLOB | 1325 character description field used in ePerformance |
11 | EP_MEASURE | Long Character | CLOB | 1325 Character Item measurement description |