EP_APPR_COPY_VW

(SQL View)

SELECT A.EP_APPRAISAL_ID , A.EMPLID , A.EMPL_RCD , A.PERIOD_BEGIN_DT , A.PERIOD_END_DT , A.EP_REVIEW_TYPE , A.EP_TEMPLATE_ID ,A.EP_TMPL_EFFDT , A.EP_REVIEW_STATUS , A.EP_MANAGER_ID , B.FIRST_NAME_SRCH , B.LAST_NAME_SRCH , B.NAME_DISPLAY , D.EP_DOC_USAGE_IND ,D.EP_CLONE_MGR_SW ,D.EP_CLONE_EE_SW ,E.DESCR FROM PS_EP_APPR A , PS_PERSON_NAME B , PS_EP_REVW_TYP_TBL D ,PS_EP_TMPL_DEFN E WHERE A.EMPLID = B.EMPLID AND A.EP_REVIEW_TYPE=E.EP_REVIEW_TYPE AND A.EP_TEMPLATE_ID=E.EP_TEMPLATE_ID AND A.EP_TMPL_EFFDT=E.EFFDT AND A.EP_REVIEW_TYPE = D.EP_REVIEW_TYPE AND D.EFFDT = ( SELECT MAX(EFFDT) FROM PS_EP_REVW_TYP_TBL F WHERE F.EP_REVIEW_TYPE = D.EP_REVIEW_TYPE AND EFFDT <=%CurrentDateIn)

# 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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

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_TEMPLATE_ID Character(8) VARCHAR2(8) NOT NULL Template unique identifier

8 EP_TMPL_EFFDT Date(10) DATE Review Template Effective Date

9 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=Available for Review
CA=Cancelled
CO=Completed
IP=In Progress
NS=Not Started
RH=Review Held

10 EP_MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager/Mentor ID.

11 EP_FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Work field used to search for a evaluatee's first name..

12 EP_LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Work field used to search for a manager's last name..

13 EP_EVALUATEE_NAME Character(60) VARCHAR2(60) NOT NULL Used to display the evaluatee's name in ePerformance.

14 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

15 EP_CLONE_MGR_SW Character(1) VARCHAR2(1) NOT NULL Manager can Clone

16 EP_CLONE_EE_SW Character(1) VARCHAR2(1) NOT NULL Clone process - Employee

17 EP_DESCR Character(30) VARCHAR2(30) NOT NULL Description field used in ePerformance.

#	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	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
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_TEMPLATE_ID	Character(8)	VARCHAR2(8) NOT NULL	Template unique identifier
8	EP_TMPL_EFFDT	Date(10)	DATE	Review Template Effective Date
9	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=Available for Review CA=Cancelled CO=Completed IP=In Progress NS=Not Started RH=Review Held
10	EP_MANAGER_ID	Character(11)	VARCHAR2(11) NOT NULL	Manager/Mentor ID.
11	EP_FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Work field used to search for a evaluatee's first name..
12	EP_LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Work field used to search for a manager's last name..
13	EP_EVALUATEE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Used to display the evaluatee's name in ePerformance.
14	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
15	EP_CLONE_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	Manager can Clone
16	EP_CLONE_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	Clone process - Employee
17	EP_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description field used in ePerformance.