EP_RPT_DTL_VW3(SQL View) |
Index Back |
|---|---|
Rating Distribution SummaryProvides drill-down information for the Rating Distribution Summary chart. |
| SELECT A.GB_GROUP_ID , B.EP_REVIEW_TYPE , A.EP_DIST_RATING_TP , A.EP_DIST_RATING_GRP , B.EP_APPRAISAL_ID , C.EMPLID , C.EMPL_RCD , C.PERIOD_BEGIN_DT , C.PERIOD_END_DT , C.EP_REVIEW_STATUS , C.EP_APPROVAL_STATUS , C.REVIEW_RATING , C.REVIEW_POINTS , C.EP_PRE_REVW_RATING , C.EP_PRE_POINTS , C.EP_CALC_METHOD FROM PS_EP_RPT_DIST_SUM A , PS_EP_RPT_SNAP_DTL B , PS_EP_APPR C WHERE B.GB_GROUP_ID = A.GB_GROUP_ID AND B.EP_REVIEW_TYPE = A.EP_REVIEW_TYPE AND A.EP_DIST_RATING_TP = 2 AND B.EP_FINAL_GRP = A.EP_DIST_RATING_GRP AND C.EP_APPRAISAL_ID = B.EP_APPRAISAL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 2 | EP_REVIEW_TYPE |
Character(8) | VARCHAR2(8) NOT NULL | Review type |
| 3 | EP_DIST_RATING_TP |
Number(3,0) | SMALLINT NOT NULL |
Distribution Rating Type
1=Preliminary 2=Final 3=Desired |
| 4 | EP_DIST_RATING_GRP |
Number(3,0) | SMALLINT NOT NULL | Distribution Rating Group |
| 5 | EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL | Document ID |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 8 | PERIOD_BEGIN_DT | Date(10) | DATE | Period Begin Date |
| 9 | PERIOD_END_DT | Date(10) | DATE | Period End Date |
| 10 | 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=Available for Review CA=Cancelled CO=Completed IP=In Progress NS=Not Started RH=Review Held |
| 11 | EP_APPROVAL_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
This field tracks the current approval status of a review. This is separate from the review's lifecycle status, which is tracked separately.
APRV=Approved DENY=Denied ERRO=Approval Error NREQ=Not Required OPEN=Not Submitted SUBM=Submitted |
| 12 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | Review Rating |
| 13 | REVIEW_POINTS | Number(3,0) | SMALLINT NOT NULL | Review Points |
| 14 | EP_PRE_REVW_RATING | Character(1) | VARCHAR2(1) NOT NULL | Preliminary Review Rating Code (character). |
| 15 | EP_PRE_POINTS | Number(3,0) | SMALLINT NOT NULL | Preliminary Rating Points |
| 16 | EP_CALC_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Calculation method used - Summary, Average, Review Band
A=Average R=Review Band S=Summation |