EPO_REACTIVE_VW (SQL View)	Index Back
Empty view used as a work rec Empty view used as a work record for reactivating Inactive Items on the business objectives page.

EPO_REACTIVE_VW

(SQL View)

Empty view used as a work rec

Empty view used as a work record for reactivating Inactive Items on the business objectives page.

SELECT 0 , ' ' , 0 , ' ' FROM PS_INSTALLATION

# 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_TITLE Character(60) VARCHAR2(60) NOT NULL Title of an item

#	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_TITLE	Character(60)	VARCHAR2(60) NOT NULL	Title of an item