EP_EEDOC_SRO_VW

(SQL View)
 Index Back

Current Doc Selection View

This view is used to display current documents available for selection

SELECT DISTINCT B.EP_REVIEWER_ID , B.EP_REVIEW_STATUS , CASE WHEN B.EP_REVIEW_STATUS = 'NS' THEN '0' WHEN B.EP_REVIEW_STATUS = 'EC' THEN '1' WHEN B.EP_REVIEW_STATUS = 'TP' THEN '2' WHEN B.EP_REVIEW_STATUS = 'IP' THEN '3' WHEN B.EP_REVIEW_STATUS = 'AR' THEN '4' WHEN B.EP_REVIEW_STATUS = 'RH' THEN '5' WHEN B.EP_REVIEW_STATUS = 'AK' THEN '6' WHEN B.EP_REVIEW_STATUS = 'PA' THEN '7' WHEN B.EP_REVIEW_STATUS = 'CO' THEN '8' WHEN B.EP_REVIEW_STATUS = 'CA' THEN '9' END FROM PS_EP_APPR A , PS_EP_APPR_ROLE B WHERE A.EP_APPRAISAL_ID = B.EP_APPRAISAL_ID AND (B.EP_ROLE <> 'E' AND B.EP_ROLE <> 'M')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EP_REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer 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