EP_EEDOC_OTH_VW (SQL View)	Index Back
Current evaluations of others This view is used to display current evaluations of others selections

EP_EEDOC_OTH_VW

(SQL View)

Current evaluations of others

This view is used to display current evaluations of others selections

SELECT DISTINCT A.EMPLID , A.EP_APPRAISAL_ID , A.EMPL_RCD , A.PERIOD_BEGIN_DT , A.PERIOD_END_DT , A.EP_REVIEW_TYPE , B.EP_REVIEW_STATUS , A.REVIEW_RATING , C.EP_DOC_USAGE_IND , D.NAME_DISPLAY , D.NAME_DISPLAY_SRCH , B.EP_ROLE , B.EP_REVIEWER_ID , B.EP_DUE_DT FROM PS_EP_APPR A , PS_EP_APPR_ROLE B , PS_EP_REVW_TYP_TBL C , PS_PERSON_NAME D WHERE A.EP_APPRAISAL_ID = B.EP_APPRAISAL_ID AND A.EMPLID = D.EMPLID AND A.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 (B.EP_ROLE <> 'E' AND B.EP_ROLE <> 'M')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

4 PERIOD_BEGIN_DT Date(10) DATE Period Begin Date

5 PERIOD_END_DT Date(10) DATE Period End Date

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

7 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

8 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

9 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

10 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

11 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.

12 EP_ROLE Character(8) VARCHAR2(8) NOT NULL Role unique identifier
Prompt Table: EP_ROLE_TBL

13 EP_REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer ID
Prompt Table: EP_REVWR_ID_VW

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID Prompt Table: EP_APPR
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	PERIOD_BEGIN_DT	Date(10)	DATE	Period Begin Date
5	PERIOD_END_DT	Date(10)	DATE	Period End Date
6	EP_REVIEW_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Review type
7	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
8	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating
9	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
10	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
11	NAME_DISPLAY_SRCH	Character(50)	VARCHAR2(50) NOT NULL	Uppercase version of Name to improve performance on searches.
12	EP_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role unique identifier Prompt Table: EP_ROLE_TBL
13	EP_REVIEWER_ID	Character(11)	VARCHAR2(11) NOT NULL	Reviewer ID Prompt Table: EP_REVWR_ID_VW
14	EP_DUE_DT	Date(10)	DATE	Date a review is due