EPO_ITM_SRCH_VW (SQL View)	Index Back
Item Search View Empty view used as a work record for search purposes.

EPO_ITM_SRCH_VW

(SQL View)

Item Search View

Empty view used as a work record for search purposes.

SELECT 0 , ' ' , ' ' , 0 , ' ' , %TextIn(' ') , %TextIn(' ') FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.

2 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier

3 EP_TITLE Character(60) VARCHAR2(60) NOT NULL Title of an item

4 EPO_ITEM_SEQ Number(2,0) SMALLINT NOT NULL Objectives Item sequence number

5 EPO_ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Status of an Item on an Objective Page.
A=Not Applicable
C=Complete
I=In Progress

6 EP_DESCR254 Long Character CLOB 1325 character description field used in ePerformance

7 EP_MEASURE Long Character CLOB 1325 Character Item measurement description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	EP_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Item unique identifier
3	EP_TITLE	Character(60)	VARCHAR2(60) NOT NULL	Title of an item
4	EPO_ITEM_SEQ	Number(2,0)	SMALLINT NOT NULL	Objectives Item sequence number
5	EPO_ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status of an Item on an Objective Page. A=Not Applicable C=Complete I=In Progress
6	EP_DESCR254	Long Character	CLOB	1325 character description field used in ePerformance
7	EP_MEASURE	Long Character	CLOB	1325 Character Item measurement description