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

EP_EEDOC_SRT_VW

(SQL View)

Current Doc Selection View

This view is used to display current documents available for selection

SELECT DISTINCT A.EMPLID , 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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
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