RB_SD_USER_PREF(SQL Table) |
Index Back |
|---|---|
Supervisor Desktop PreferencesTable containing the user preference settings for the Supervisor Desktop feature. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
| 2 | MCFUQQUEUEID | Character(32) | VARCHAR2(32) NOT NULL |
Auto-Login Queue
Prompt Table: RB_MCF_AGT_QUE |
| 3 | RB_MONITOR_DATA | Character(1) | VARCHAR2(1) NOT NULL |
Monitor Type field for Supervsor Desktop
A=Agent Statistics Q=Queue Statistics |
| 4 | RB_FILTER_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Initial Monitor filter option for supervisor desktop
A=Assigned Queues Q=Queue List T=Team |
| 5 | RB_ALERT_COLOR | Character(4) | VARCHAR2(4) NOT NULL |
Alert Color filed used for Supervisor Desktop Configuration
BLUE=Blue GREN=Green ORAG=Orange PURP=Purple RED=Red YELW=Yellow |
| 6 | RB_TIME_STATE | Signed Number(11,0) | DECIMAL(10) NOT NULL |
Number of seconds for time in state statistics
Default Value: -1 |
| 7 | RB_TIME_AVAIL | Signed Number(11,0) | DECIMAL(10) NOT NULL |
Number of seconds for time available statistics
Default Value: -1 |
| 8 | RB_TIME_UNAVAIL | Signed Number(11,0) | DECIMAL(10) NOT NULL |
Number of seconds for time unavailable statistics
Default Value: -1 |
| 9 | RB_TIME_WAIT | Signed Number(11,0) | DECIMAL(10) NOT NULL |
Number of seconds for average wait time statistics
Default Value: -1 |
| 10 | RB_TIME_DURATION | Signed Number(11,0) | DECIMAL(10) NOT NULL |
Number of seconds for average duration statistics
Default Value: -1 |
| 11 | RB_NUM_LOGGEDON | Signed Number(4,0) | DECIMAL(3) NOT NULL |
Field for the number of agents logged on statistic
Default Value: -1 |
| 12 | RB_NUM_AVAIL | Signed Number(4,0) | DECIMAL(3) NOT NULL |
Field for the number of agents available statistic
Default Value: -1 |
| 13 | RB_NUM_ABANDON | Signed Number(4,0) | DECIMAL(3) NOT NULL |
Field for the number of abandoned calls statistic
Default Value: -1 |
| 14 | RB_NUM_INQUEUE | Signed Number(4,0) | DECIMAL(3) NOT NULL |
Field for the number of tasks in queue statistic
Default Value: -1 |
| 15 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 16 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 17 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 18 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 19 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 20 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |