EP_APPR_SS_VW (SQL View)	Index Back
Appraisal SS Approval Details This view includes the approval chain for all appraisals that have been submitted through the 8.4 framework. This is used for the appraisal status component (EP_APPRAISAL_STS_L).

EP_APPR_SS_VW

(SQL View)

Appraisal SS Approval Details

This view includes the approval chain for all appraisals that have been submitted through the 8.4 framework. This is used for the appraisal status component (EP_APPRAISAL_STS_L).

SELECT DISTINCT A.EP_APPRAISAL_ID , C.EMPLID , C.EMPL_RCD , F.NAME , F.FIRST_NAME_SRCH , F.LAST_NAME_SRCH , D.EP_REVIEW_TYPE , D.PERIOD_BEGIN_DT , D.PERIOD_END_DT , D.EP_REVIEW_STATUS , D.EP_APPROVAL_STATUS , D.EP_MANAGER_ID , E.NAME , E.FIRST_NAME_SRCH , E.LAST_NAME_SRCH , A.TRANSACTION_NAME , B.ROLEUSER FROM PS_SS_DTL_EPM A , PS_SS_PROCESS_DTL B , PS_SS_KEYS C , PS_EP_APPR D , PS_PERSON_NAME E , PS_PERSON_NAME F WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND B.TRANSACTION_NAME = C.TRANSACTION_NAME AND A.SS_GRP_ID = B.SS_GRP_ID AND B.SS_GRP_ID = C.SS_GRP_ID AND A.SS_TRANS_ID = B.SS_TRANS_ID AND B.SS_TRANS_ID = C.SS_TRANS_ID AND A.SS_PROCESS_CYCLE = B.SS_PROCESS_CYCLE AND A.EP_APPRAISAL_ID = D.EP_APPRAISAL_ID AND D.EP_MANAGER_ID = E.EMPLID AND C.EMPLID = F.EMPLID AND D.EOAWDEFN_ID = ' ' AND (D.EP_APPROVAL_STATUS IN ('APRV', 'DENY') OR (D.EP_APPROVAL_STATUS = 'SUBM' AND D.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

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

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

4 NAME Character(50) VARCHAR2(50) NOT NULL Name

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

6 EP_EE_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Work field used to search for a evaluatee's last name..

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_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

11 EP_APPROVAL_STATUS Character(4) VARCHAR2(4) NOT NULL This field tracks the current approval status of a review. This is separate from the review's lifecycle status, which is tracked separately.
APRV=Approved
DENY=Denied
ERRO=Approval Error
NREQ=Not Required
OPEN=Not Submitted
SUBM=Submitted

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

13 EP_MANAGER_NAME Character(60) VARCHAR2(60) NOT NULL Used to display the manager/mentor's name in ePerformance.

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

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

16 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name

17 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User

#	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 Record
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	EP_EE_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Work field used to search for a evaluatee's first name..
6	EP_EE_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Work field used to search for a evaluatee's last name..
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_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
11	EP_APPROVAL_STATUS	Character(4)	VARCHAR2(4) NOT NULL	This field tracks the current approval status of a review. This is separate from the review's lifecycle status, which is tracked separately. APRV=Approved DENY=Denied ERRO=Approval Error NREQ=Not Required OPEN=Not Submitted SUBM=Submitted
12	EP_MANAGER_ID	Character(11)	VARCHAR2(11) NOT NULL	Manager/Mentor ID.
13	EP_MANAGER_NAME	Character(60)	VARCHAR2(60) NOT NULL	Used to display the manager/mentor's name in ePerformance.
14	EP_MGR_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Work field used to search for a evaluatee's first name..
15	EP_MGR_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Work field used to search for a manager's last name..
16	TRANSACTION_NAME	Character(25)	VARCHAR2(25) NOT NULL	EDI Transaction Name
17	ROLEUSER	Character(30)	VARCHAR2(30) NOT NULL	Role User