EP_NOTIFY_SRCH (SQL View)	Index Back
Notification Target Search Vw This search view is used by the intermediate EP_NOTIFY component that is the "target" of eMail URLs. The keys to the target review document are passed in the URL as query strings: - Appraisal_Id - Reviewer_Id - Role - UserRole This extra level of security is required to handle situations where an unscrupulous user modifies one or more keys in the URL in an attempt to access a different document than the one referenced in the eMail.

EP_NOTIFY_SRCH

(SQL View)

Notification Target Search Vw

This search view is used by the intermediate EP_NOTIFY component that is the "target" of eMail URLs. The keys to the target review document are passed in the URL as query strings: - Appraisal_Id - Reviewer_Id - Role - UserRole This extra level of security is required to handle situations where an unscrupulous user modifies one or more keys in the URL in an attempt to access a different document than the one referenced in the eMail.

SELECT A.EP_APPRAISAL_ID ,R.EP_ROLE ,C.OPRID ,R.EP_REVIEWER_ID ,A.EMPLID ,R.EP_REVIEW_STATUS FROM PS_EP_APPR A , PS_EP_APPR_ROLE R , PSOPRDEFN C WHERE A.EP_APPRAISAL_ID = R.EP_APPRAISAL_ID AND ((A.EMPLID = C.EMPLID) OR C.EMPLID IN ( SELECT X.EP_REVIEWER_ID FROM PS_EP_APPR_ROLE X WHERE X.EP_APPRAISAL_ID = A.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

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

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

6 EP_REVIEW_STATUS Character(4) VARCHAR2(4) NOT NULL This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately.
AK=Acknowledged
AR=Shared with Employee
CA=Canceled
CO=Completed
EC=Define Criteria
IP=Evaluation in Progress
NS=Not Started
PA=Approval
RH=Pending Acknowledgement
TP=Track Progress

#	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
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	EP_REVIEWER_ID	Character(11)	VARCHAR2(11) NOT NULL	Reviewer ID
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	EP_REVIEW_STATUS	Character(4)	VARCHAR2(4) NOT NULL	This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately. AK=Acknowledged AR=Shared with Employee CA=Canceled CO=Completed EC=Define Criteria IP=Evaluation in Progress NS=Not Started PA=Approval RH=Pending Acknowledgement TP=Track Progress