EP_DOC_SORTD_VW (SQL View)	Index Back
Current Doc Selection View This view is used to display current documents available for selection

EP_DOC_SORTD_VW

(SQL View)

Current Doc Selection View

This view is used to display current documents available for selection

SELECT DISTINCT B.EODL_PROXY_ID , A.EP_REVIEW_STATUS , CASE WHEN A.EP_REVIEW_STATUS = 'NS' THEN '0' WHEN A.EP_REVIEW_STATUS = 'EC' THEN '1' WHEN A.EP_REVIEW_STATUS = 'TP' THEN '2' WHEN A.EP_REVIEW_STATUS = 'IP' THEN '3' WHEN A.EP_REVIEW_STATUS = 'AR' THEN '4' WHEN A.EP_REVIEW_STATUS = 'RH' THEN '5' WHEN A.EP_REVIEW_STATUS = 'AK' THEN '6' WHEN A.EP_REVIEW_STATUS = 'PA' THEN '7' WHEN A.EP_REVIEW_STATUS = 'CO' THEN '8' WHEN A.EP_REVIEW_STATUS = 'CA' THEN '9' END FROM PS_EP_APPR A , PS_EP_REVW_TYP_TBL D , PS_EODL_MYDLGTOR B WHERE A.EP_REVIEW_TYPE = D.EP_REVIEW_TYPE AND (A.EP_REVIEW_STATUS <> 'CO' AND A.EP_REVIEW_STATUS <> 'CA') AND B.EODL_DLGT_REQ_STAT = 'A' AND B.EODL_DLGT_STATUS = 'A' AND ((B.TRANSACTION_NAME = 'Delegate_ePerformace_Doc' AND D.EP_DOC_USAGE_IND = 'P') OR (B.TRANSACTION_NAME = 'Delegate_ePerformace_Dev' AND D.EP_DOC_USAGE_IND = 'D')) AND B.EODL_DELEGATOR_ID = A.EP_MANAGER_ID AND (B.FROM_DATE <= %CurrentDateIn AND (B.TO_DATE >= %CurrentDateIn OR B.TO_DATE IS NULL))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROXY_ID Character(11) VARCHAR2(11) NOT NULL Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.

2 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

3 EP_SORT Character(1) VARCHAR2(1) NOT NULL field used to sort current documents grid in NUI MSS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROXY_ID	Character(11)	VARCHAR2(11) NOT NULL	Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
2	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
3	EP_SORT	Character(1)	VARCHAR2(1) NOT NULL	field used to sort current documents grid in NUI MSS