EPO_SYND_TAO1

(SQL Table)
Index Back

Sydicate Temporary record

Temp record used by the Objectives Syndicate AE program, EPO_SYNDICATE.

# 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
2 EPO_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Objectives Section type
3 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.
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