RC_SOL_FDBK_CNT(SQL View) |
Index Back |
|---|---|
Soluton Feedback CountSoluton Feedback Count view for Solutoon Management Insight |
| select fed.setid, fed.solution_id, count(1) total_fed_cnt, sum(case when rc_fdk_category ='O' then 1 else 0 end) open_fed_cnt from PS_RC_FEEDBACK FED join PS_RC_REVIEW_TBL rev on fed.setid=rev.setid and FED.RC_REVIEW_STATUS=REV.RC_REVIEW_STATUS group by fed.setid, fed.solution_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | SOLUTION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Solution ID |
| 3 | RC_SOL_FDBK_CNT | Number(6,0) | INTEGER NOT NULL | Solution Feedback Count |
| 4 | RC_SOL_FDBKOP_CNT | Number(6,0) | INTEGER NOT NULL | Open Feedback Count |