CM_EVAL_HIST_VW (SQL View)	Index Back
EE Evaluation History View This view lists employee "self" evaluations which are not current, i..e all self evaluations prior to the current self evaluation for each employee.

CM_EVAL_HIST_VW

(SQL View)

EE Evaluation History View

This view lists employee "self" evaluations which are not current, i..e all self evaluations prior to the current self evaluation for each employee.

SELECT E.EMPLID ,E.EVALUATION_ID ,E.REVIEW_DT ,E.EP_APPRAISAL_ID FROM PS_CM_EVALUATIONS E WHERE (E.EVALUATION_TYPE = 'S' OR (E.EVALUATION_TYPE = 'R' AND E.EP_APPRAISAL_ID > 0)) AND E.REVIEW_DT < ( SELECT MAX(REVIEW_DT) FROM PS_CM_EVALUATIONS WHERE EMPLID = E.EMPLID AND (E.EVALUATION_TYPE = 'S' OR (E.EVALUATION_TYPE = 'R' AND E.EP_APPRAISAL_ID > 0)))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EVALUATION_ID Character(2) VARCHAR2(2) NOT NULL Evaluation ID

3 REVIEW_DT Date(10) DATE Review Date

4 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EVALUATION_ID	Character(2)	VARCHAR2(2) NOT NULL	Evaluation ID
3	REVIEW_DT	Date(10)	DATE	Review Date
4	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID