EP_SRCH_PRF_DEL (SQL View)	Index Back
Perf Analytics Deletions Returns all section keys for documents being updated or deleted.

EP_SRCH_PRF_DEL

(SQL View)

Perf Analytics Deletions

Returns all section keys for documents being updated or deleted.

SELECT DOC.EP_APPRAISAL_ID ,DOC.EMPLID ,DOC.EMPL_RCD ,DOC.EP_REVIEW_STATUS ,DOC.EP_CANCEL_DTTM ,SEC.EP_ROLE ,SEC.EP_REVIEWER_ID ,SEC.EP_SECTION_TYPE ,SEC.REVIEW_RATING ,DIR.SUPERVISOR_ID ,(CASE WHEN %Coalesce(DOC.LASTUPDDTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) >= %Coalesce(DOC.EP_CREATE_DTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) AND %Coalesce(DOC.LASTUPDDTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) >= %Coalesce(APROLE.LASTUPDDTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) THEN %Coalesce(DOC.LASTUPDDTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) WHEN %Coalesce(DOC.EP_CREATE_DTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) >= %Coalesce(DOC.LASTUPDDTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) AND %Coalesce(DOC.EP_CREATE_DTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) >= %Coalesce(APROLE.LASTUPDDTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) THEN %Coalesce(DOC.EP_CREATE_DTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) WHEN %Coalesce(APROLE.LASTUPDDTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) >= %Coalesce(DOC.LASTUPDDTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) AND %Coalesce(APROLE.LASTUPDDTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) >= %Coalesce(DOC.EP_CREATE_DTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) THEN %Coalesce(APROLE.LASTUPDDTTM,%DateTimeIn('1900-01-01-00.00.00.000000')) ELSE %DateTimeIn('1900-01-01-00.00.00.000000') END) FROM (PS_EP_APPR DOC LEFT OUTER JOIN PS_EP_APPR_ROLE APROLE ON DOC.EP_APPRAISAL_ID = APROLE.EP_APPRAISAL_ID AND DOC.EP_MANAGER_ID = APROLE.EP_REVIEWER_ID AND APROLE.EP_ROLE = 'M' LEFT OUTER JOIN PS_EP_APPR_SECTION SEC ON DOC.EP_APPRAISAL_ID = SEC.EP_APPRAISAL_ID AND DOC.EP_MANAGER_ID = SEC.EP_REVIEWER_ID AND SEC.EP_ROLE = 'M' AND SEC.EP_SECTION_TYPE = 'SUMMARY') , PS_EP_DIR_RPT_VW DIR WHERE DOC.EMPLID = DIR.EMPLID AND DOC.EMPL_RCD = DIR.EMPL_RCD

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

5 EP_CANCEL_DTTM DateTime(26) TIMESTAMP Specifies the date and time a document was Canceled

6 EP_ROLE Character(8) VARCHAR2(8) NOT NULL Role unique identifier

7 EP_REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer ID

8 EP_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Section type

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

10 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

11 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	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
5	EP_CANCEL_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time a document was Canceled
6	EP_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role unique identifier
7	EP_REVIEWER_ID	Character(11)	VARCHAR2(11) NOT NULL	Reviewer ID
8	EP_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Section type
9	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating
10	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
11	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.