EPO_OBJ_EXTRACT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID Prompt Table: EP_APPR
3	EP_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role unique identifier
4	EP_REVIEWER_ID	Character(11)	VARCHAR2(11) NOT NULL	Reviewer ID
5	EP_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Section type Prompt Table: EP_SECTION_DEFN
6	EP_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Item unique identifier Prompt Table: %EDITTABLE
7	EP_ITEM_SEQ	Number(2,0)	SMALLINT NOT NULL	Item sequence number Default Value: 1
8	EPO_PAGE_ID	Number(8,0)	INTEGER NOT NULL	Objectives Management: Objective Page ID
9	EPO_OBJ_PLAN	Character(8)	VARCHAR2(8) NOT NULL	Objectives Management: Objective Plan ID field
10	EPO_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Objectives Section type
11	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.
12	EP_ITEM_PCT	Number(3,0)	SMALLINT NOT NULL	Percentage complete an item is.
13	EP_ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status of an Item. A=Not Applicable C=Complete I=In Progress
14	EP_ITEM_DUE_DT	Date(10)	DATE	Date that an item is due.