EPO_NO_ITEM_VW (SQL View)	Index Back
Objectives Page Item Holds the Item information for the Objectives Pages

EPO_NO_ITEM_VW

(SQL View)

Objectives Page Item

Holds the Item information for the Objectives Pages

SELECT EPO_PAGE_ID , EFFDT , EPO_SECTION_TYPE , EPO_OBJ_ITEM_ID FROM PS_EPO_PG_ITEM WHERE 1 = 2

# 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
Prompt Table: EPO_PG_HDR

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 EPO_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Objectives Section type
Prompt Table: EPO_SECTN_DEFN

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.

#	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 Prompt Table: EPO_PG_HDR
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	EPO_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Objectives Section type Prompt Table: EPO_SECTN_DEFN
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.