EP_APPR_RHIS_VW (SQL View)	Index Back
Historical Role Eval View This view is used to create a list of historical Evaluations by role for selection.

EP_APPR_RHIS_VW

(SQL View)

Historical Role Eval View

This view is used to create a list of historical Evaluations by role for selection.

SELECT A.EP_APPRAISAL_ID , A.EP_ROLE , A.EP_REVIEWER_ID , A.EP_DUE_DT , A.EP_REVIEW_STATUS , B.EMPLID , B.EP_REVIEW_TYPE , B.PERIOD_BEGIN_DT , B.PERIOD_END_DT , C.EP_DOC_USAGE_IND FROM PS_EP_APPR_ROLE A , PS_EP_APPR B , PS_EP_REVW_TYP_TBL C WHERE A.EP_APPRAISAL_ID = B.EP_APPRAISAL_ID AND B.EP_REVIEW_TYPE = C.EP_REVIEW_TYPE AND C.EFFDT=( SELECT MAX(EFFDT) FROM PS_EP_REVW_TYP_TBL C1 WHERE C1.EP_REVIEW_TYPE = C.EP_REVIEW_TYPE AND C1.EFFDT <= %CurrentDateIn) AND (A.EP_ROLE <> 'E' AND A.EP_ROLE <> 'M') AND (A.EP_REVIEW_STATUS = 'CO' OR A.EP_REVIEW_STATUS ='CA')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID
Prompt Table: EP_APPR

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
Prompt Table: EP_REVWR_ID_VW

4 EP_DUE_DT Date(10) DATE Date a review is due

5 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

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

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

8 PERIOD_BEGIN_DT Date(10) DATE Period Begin Date

9 PERIOD_END_DT Date(10) DATE Period End Date

10 EP_DOC_USAGE_IND Character(1) VARCHAR2(1) NOT NULL Indicator used to determine what document types are available for performance assessments and which are available for development assessments.
D=Development
P=Performance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID Prompt Table: EP_APPR
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 Prompt Table: EP_REVWR_ID_VW
4	EP_DUE_DT	Date(10)	DATE	Date a review is due
5	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
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	EP_REVIEW_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Review type
8	PERIOD_BEGIN_DT	Date(10)	DATE	Period Begin Date
9	PERIOD_END_DT	Date(10)	DATE	Period End Date
10	EP_DOC_USAGE_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicator used to determine what document types are available for performance assessments and which are available for development assessments. D=Development P=Performance