EP_RPT_SUM_VW2(SQL View) |
Index Back |
---|---|
Rating Distribution SummaryUsed to generate the labels for Rating Distribution Summary chart series. |
SELECT DISTINCT GB_GROUP_ID ,EP_REVIEW_TYPE ,EP_DIST_RATING_TP FROM PS_EP_RPT_DIST_SUM |
# | 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 |