MOOD_IDSDB_E_MOOD_VW(SQL View) |
Index Back |
|---|---|
Email Mood ViewEmail Mood View used for Contact Center Dashboard. |
| SELECT MOOD_ID ,MOOD_NAME ,DESCR80 FROM PS_RB_MOOD_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MOOD_ID |
Number(6,0) | INTEGER NOT NULL | Mood |
| 2 | MOOD_NAME | Character(30) | VARCHAR2(30) NOT NULL | Mood Name |
| 3 | DESCR80 | Character(80) | VARCHAR2(80) NOT NULL | This generic field stores the description and used used on various tables. |