EP_BKEYS_SRCH (SQL View)	Index Back
Review Document Search View This search view is used by components that display a Review document. The view contains SearchInit PeopleCode that pre-loads the keys (Appraisal_Id and Role) with the corresponding values from the ePerformance global record, so that the search dialog can be bypassed.

EP_BKEYS_SRCH

(SQL View)

Review Document Search View

This search view is used by components that display a Review document. The view contains SearchInit PeopleCode that pre-loads the keys (Appraisal_Id and Role) with the corresponding values from the ePerformance global record, so that the search dialog can be bypassed.

SELECT A.EP_APPRAISAL_ID ,A.EMPLID ,A.EP_REVIEW_TYPE ,A.PERIOD_END_DT FROM PS_EP_APPR A , PS_EP_APPR_B_SEC B WHERE A.EP_APPRAISAL_ID = B.EP_APPRAISAL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type

4 PERIOD_END_DT Date(10) DATE Period End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EP_REVIEW_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Review type
4	PERIOD_END_DT	Date(10)	DATE	Period End Date