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

EP_ITEM_SRCH_V2

(SQL View)

Item Search View

Empty view used as a work record for search purposes.

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 EP_ADD_ITEM_VIEW Character(1) VARCHAR2(1) NOT NULL Add items for ePerformance documents
B=Business Objectives
C=Custom
M=My Document
P=Pre-defined
T=Team Document

4 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model

5 EP_ITEM_DUE_DT Date(10) DATE Date that an item is due.

6 EP_ITEM_REMIND_DT Date(10) DATE Date to remind an item is due.

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

8 EP_MEASURE Long Character CLOB 1325 Character Item measurement description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Item unique identifier
2	EP_TITLE	Character(60)	VARCHAR2(60) NOT NULL	Title of an item
3	EP_ADD_ITEM_VIEW	Character(1)	VARCHAR2(1) NOT NULL	Add items for ePerformance documents B=Business Objectives C=Custom M=My Document P=Pre-defined T=Team Document
4	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model
5	EP_ITEM_DUE_DT	Date(10)	DATE	Date that an item is due.
6	EP_ITEM_REMIND_DT	Date(10)	DATE	Date to remind an item is due.
7	EP_DESCR254	Long Character	CLOB	1325 character description field used in ePerformance
8	EP_MEASURE	Long Character	CLOB	1325 Character Item measurement description