Previous Topic: sa_named_user_license TableNext Topic: sa_patch_history Table


sa_notif Table

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.