EP_GBLKEYS_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_GBLKEYS_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 ,B.EP_ROLE ,B.EP_REVIEWER_ID FROM PS_EP_APPR A , PS_EP_APPR_ROLE 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 EP_ROLE Character(8) VARCHAR2(8) NOT NULL Role unique identifier
Prompt Table: EP_ROLE_TBL

3 EP_REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
2	EP_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role unique identifier Prompt Table: EP_ROLE_TBL
3	EP_REVIEWER_ID	Character(11)	VARCHAR2(11) NOT NULL	Reviewer ID