SystemData Table Data Dictionary

Introduction 

This article gives an overview of all the fields in the ‘SystemData’ table. The system data table is used by the dialling system to store statics of each record in the data table.

This table is a system internal object. It is subject to changes without prior announcement

SystemData Table 

Name	Data Type	Max Length (Bytes)	Description
Internal__Id__	Char (32)		The internal id of a record generated by the Nixxis Contact Suite
CurrentActivity	Char (32)	Null	System current Activity ID if affected to a particular activity. Can also contains system values (_AGT or _DNR, meaning handled by agent or “do not recall”)
PreviousActivity	Char (32)	Null	Previous value of field CurrentActivity
LastHandlerActivity	Char (32)	Null	Id of the last activity that has handled the record
LastActivityChange	DateTime	Null	date of last change of activity
LastHandler	Char (32)	Null	ID of the last handling agent
LastHandlingTime	DateTime	Null	Time when the record was last handled
LastHandlingDuration	Int	0	The duration of the last handling on this record
TotalHandlingDuration	Int	0	The total time of all the handlings on this record
TotalHandlers	Int	0	Total number of agents handling this record
State	Int	0	The current state of the record see appendix ‘ContactStates’ on page 5 for the possible values
PreviousState	Int	0	The previous state of the record see appendix ‘ContactStates’ on page 5 for the possible values
SortInfo	Int	0	Internal dialer sort order
DialingModeOverride	Int	Null	Allows for an override of dialing type for this record (look at table Admin.dbo.EnumDialingModes for details)
DialStartDate	DateTime	Null	Start date of dial; dialling cannot start before this date
DialEndDate	DateTime	Null	End date of dialling
CreationTime	DateTime	Today	The date and time when the record was inserted.
TargetHandler	Char (32)	Null	Used in personal callback to set destination agent
TargetDestination	VarChar (100)	Null	Destination to be reached
TargetMedia	Int	Null	Media associated to the destination
DialedCurrentActivity	Int	0	Total number of times record has been dialed within the current activity
TotalDialed	Int	0	Total number of times record has been dialed
MaxDialAttempts	Int	-1	The maximum number of dial attempts on this record.
ExpectedProfit	Int	1	The record expected proffit
LastDialStatus	Int	Null	Status of the last dial (record see appendix ‘ContactStates’ on page 5 for the possible values)
LastQualification	Char (32)	Null	The id of the last qualification set on this record
AppointmentId			Not used, kept for retro compatibility
AreaId			Not used, kept for retro compatibility
CustomSortInfo			Custom sort info
Excluded			Record is excluded and will not be dialed
ExportSequence			Export Sequence
ExportTime			Time of export
GDPROptinDate			GDPROptinDate
GDPROptoutDate			GDPROptoutDate
ImportSequence			Import Sequence
ImportTag			Tag specified at import
LastContactId			Last contact id
LastDialedDestination			Last Dialed Destination
LastDialStatusCount			Count of Last Dial Status
LastOriginator			Last Originator number
LastQualificationArgued			Last Qualification Argued(admin settings)
LastQualificationExportable			Last Qualification Exportable(admin settings)
LastQualificationPositive			Last Qualification Positive(admin settings)
LastRecycle			LastRecycle timestamp
OriginatorStrategy			Originator Strategy
PreferredAgent			Preferred Agent if set
Priority			Priority(calculated field)
RecycleCount			Number of recyling
UUI			Universally Unique Identifier used for integrations
VMFlagged			Voice mail settings
Voicemail			Voice mail settings
VoicemailResource			Voice mail settings
WorkflowStep			Workflow step used for integrations

ContactStates 

Id	Description	Info
0	None
1	Fax
2	Disturbed
3	No answer
4	Answering machine
5	Busy
6	Abandoned
7	Validity elapsed
8	Normal clearing
9	Agent
10	Agent unavailable
11	Congestion
12	Negative plus
13	Negative minus
14	Locked
15	Callback
16	Preview
17	Max. dial attempts reached
18	Blacklisted

Nom d'utilisateur : nixxisdb
Lien : https://ncsdatadictionary.nixxis.com

Pour toute question relative au mot de passe, veuillez contacter le support à l'adresse suivante : support@nixxis.com

• Related Articles

• Administration - Activity - Data filters

  Introduction In NCS (Nixxis Contact Suite), data filters are used to define specific criteria for selecting and filtering data within the system. They allow you to retrieve and manipulate data based on certain conditions, helping you to focus on the ...

• Administration - Campaign - Data File Creation

  Introduction This article intends to outline the process of creating an Excel file and integrating it into an outbound campaign. Create an Excel File Create an Excel file containing all the fields that you will need (result of the import- and result ...

• Nixxis Contact Suite - Quotas (EN)

  1. Introduction This article explains how quotas can be used in NCS. The first section provides a technical overview of the concepts related to quotas. The second section shows how it appears in the NCS administration tool while the last section ...

• Nixxis Contact Suite - First steps guideline V2.4

  1. Introduction The purpose of this article is to provide the information you need to connect and configure a basic NCS environment via Nixxis Clients Desktop. 2. Download Nixxis Client Desktop Nixxis Client Desktop is available from : ...

• Technical Parameters - Answering Machine Detection

  Introduction This article provides an overview of the AMD (Answering Machine Detection) settings in Nixxis Contact Suite. It explores the technical parameters and customisation options available for optimising AMD settings based on specific ...