RC_SOL_FAV_VW

(SQL View)
Index Back

Favorite Solution View

View shows favorite solutions by agents

select setid, solution_id, count(OPRID) Favorite_count from PS_RC_SOL_USER_FAV group by setid, 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_FAV_CNT Number(5,0) INTEGER NOT NULL Solution Favorite Count