EPO_OBJ_DET_VW (SQL View)	Index Back
View Summary Data by Item View used to sum data by Item from EPO_OBJ_EXTRACT

EPO_OBJ_DET_VW

(SQL View)

View Summary Data by Item

View used to sum data by Item from EPO_OBJ_EXTRACT

SELECT EPO_PAGE_ID ,EPO_OBJ_PLAN ,EPO_SECTION_TYPE ,EPO_OBJ_ITEM_ID ,EP_ITEM_STATUS , COUNT(*) FROM PS_EPO_OBJ_EXTRACT GROUP BY EPO_PAGE_ID ,EPO_OBJ_PLAN ,EPO_SECTION_TYPE ,EPO_OBJ_ITEM_ID ,EP_ITEM_STATUS

# 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_OBJ_PLAN Character(8) VARCHAR2(8) NOT NULL Objectives Management: Objective Plan ID field

3 EPO_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Objectives Section type

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_STATUS Character(1) VARCHAR2(1) NOT NULL Status of an Item.
A=Not Applicable
C=Complete
I=In Progress

6 EPO_EMPLID_CNT Number(6,0) INTEGER NOT NULL Number of Employees

#	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_OBJ_PLAN	Character(8)	VARCHAR2(8) NOT NULL	Objectives Management: Objective Plan ID field
3	EPO_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Objectives Section type
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_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status of an Item. A=Not Applicable C=Complete I=In Progress
6	EPO_EMPLID_CNT	Number(6,0)	INTEGER NOT NULL	Number of Employees