EP_SEC_ROLE_VW(SQL View) |
Index Back |
|---|---|
Average Section rating by roleUsed to calc the average section rating by role |
| SELECT A.EP_APPRAISAL_ID , A.EP_SECTION_TYPE , B.EP_ROLE , COUNT(*) , AVG(A.EP_RATING) FROM PS_EP_APPR_SECTION A , PS_EP_APPR_ROLE B 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_SEC_ROLE_RTD_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, B.EP_ROLE |
| # | 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_ROLE | Character(8) | VARCHAR2(8) NOT NULL | Role unique identifier |
| 4 | EP_COUNT | Number(2,0) | SMALLINT NOT NULL | Used as a dummy counter. |
| 5 | EP_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Rating |