RB_PRESENCELDFL(SQL Table) |
Index Back |
---|---|
Presence DefaultRelated language table for CRM UAD Agent presence codes |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | UAD_CHANNEL | Character(4) | VARCHAR2(4) NOT NULL |
UAD Channels
CTIV=Voice MULT=Multichannel Queue |
3 | UAD_PRESENCE_STATE | Character(4) | VARCHAR2(4) NOT NULL |
UAD Presence State
AVAL=Available BUSY=Busy NOTR=Not Ready NVAL=Unavailable READ=Ready UNAV=Assumed Unavailable WNOT=Work Not Ready WRDY=Work Ready |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | UAD_PRESENCE_TEXT | Character(30) | VARCHAR2(30) NOT NULL | UAD Presence State |