EP_ITEM_AVG_VW

(SQL View)
 Index Back

Item average rating

Used to calc the average rating for an item

SELECT A.EP_APPRAISAL_ID , A.EP_SECTION_TYPE , A.EP_ITEM_ID , A.EP_ITEM_SEQ , AVG(A.EP_RATING) FROM PS_EP_APPR_ITEM A , PS_EP_APPR_ROLE B , PS_EP_APPR_SECTION C WHERE A.EP_APPRAISAL_ID = B.EP_APPRAISAL_ID AND A.EP_ROLE = B.EP_ROLE AND A.EP_REVIEWER_ID = B.EP_REVIEWER_ID AND A.EP_APPRAISAL_ID = C.EP_APPRAISAL_ID AND A.EP_ROLE = C.EP_ROLE AND A.EP_REVIEWER_ID = C.EP_REVIEWER_ID AND A.EP_SECTION_TYPE = C.EP_SECTION_TYPE AND C.EP_ITEM_ROLE_RT_SW = 'Y' AND A.REVIEW_RATING <> ' ' AND B.EP_REVIEW_STATUS <> 'CA' AND B.EP_REVIEW_STATUS <> 'IP' GROUP BY A.EP_APPRAISAL_ID, A.EP_SECTION_TYPE, A.EP_ITEM_ID, A.EP_ITEM_SEQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID
2 EP_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Section type
3 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier
4 EP_ITEM_SEQ Number(2,0) SMALLINT NOT NULL Item sequence number
5 EP_RATING Number(6,2) DECIMAL(5,2) NOT NULL Rating