Program control table used by Support Automation.
|
Field |
Data Type |
Reference |
Remarks |
|---|---|---|---|
|
id |
INTEGER |
|
KEY |
|
notif_type |
INTEGER |
|
Specifies one of the following notification types: 1—Queue Entry Notification - end user joins Assistance Session Queue 2—Queue Entry Notification - Assistance Session is transferred to an Assistance Session Queue 3—reserved 4—Invite End User to Assistance Session - Incident 5—Invite End User to Assistance Session - Issue 6—Session Ended Notification |
|
queue_id |
INTEGER |
sa_queue |
REQUIRED |
|
queued_user_id |
INTEGER |
sa_queued_user |
|
|
queued_group_id |
INTEGER |
sa_queued_group |
|
|
end_user_uuid |
UUID |
cnt |
Specifies the UUID of the end user. |
|
analyst_uuid |
UUID |
cnt |
Specifies the UUID of the analyst. |
|
sd_obj_type |
STRING 5 |
|
Defines if the assistance session is integrated with iss, cr, or in. |
|
sd_obj_id |
INTEGER |
|
Defines the cr/iss related record. |
|
cr_persid_rel |
STRING 30 |
Call_Req |
Specifies the persid of the cr. |
|
iss_persid_rel |
STRING 30 |
Issue |
Specifies the persid of the iss. |
|
analyst_message |
nvarchar(1024) |
|
Specifies the text of the message sent by the analyst. |
|
session_url |
Long nvarchar |
|
Specifies the URL of the assistance session. |
|
msg_title |
nvarchar(255) |
|
Specifies the title of the nofitication. |
|
msg_body |
Long nvarchar |
|
Specifies the description of the notification. |
|
survey_id |
INTEGER |
|
Specifies the ID of the survey. |
|
survey_persid_rel |
STRING 30 |
|
|
|
last_mod_by |
UUID |
ca_contact |
Specifies the UUID of the contact who last modified this record. |
|
last_mod_dt |
LOCAL_TIME |
|
Specifies the timestamp of when this record was last modified. |
|
tenant |
UUID |
ca_tenant |
Specifies the UUID of the tenant. |
|
Copyright © 2013 CA.
All rights reserved.
|
|