LM_RTG_FLG_IDLM_RTG_FLGCNTVW(SQL View) |
Index Back |
|---|---|
Flagged Reviews CountUse this view to get the total flagged reviews by how many times by user. |
| SELECT LM_RTG_FLG_ID , COUNT(LM_RTG_FLG_ID) , COUNT(DISTINCT LM_PERSON_ID) FROM PS_LM_RTG_FLG_TBL GROUP BY LM_RTG_FLG_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_RTG_FLG_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Ratings and Reviews Flag ID |
| 2 | LM_RTG_FLAG_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Flag(s) |
| 3 | LM_RTG_FLAG_USER | Number(10,0) | DECIMAL(10) NOT NULL | Flagged by User |