Project database

pAPIAccounts

This table holds user credentials for the related sAPIServer records.

Field Name	Type	Length
apia_ID	int
apia_ServerID	int
apia_UserID	int
apia_Domain	nvarchar	255
apia_Username	nvarchar	255
apia_Password	nvarchar	1024
apia_Token	nvarchar	255
apia_Extra1	nvarchar	255
apia_Extra2	nvarchar	255
apia_Extra3	nvarchar	255

pAPIServers

This table is used as a "placeholder" for pAPIAccounts records so they can be grouped i.e. SalesForce, MSCRM, SugarCRM etc.

Field Name	Type	Length	Description
apis_ID	int

pAudit

This table is used to keep an audit of configuration modifications.

Field Name	Type	Length
AU_ID	int
AU_UserID	int
AU_Date	datetime
AU_Module	nvarchar	50
AU_Key	int
AU_ParentKey	int
AU_Type	nchar	1
AU_SubType	nchar	5
AU_Comment	ntext
AU_Station	nvarchar	255

pCall

This table stores the specific call details of every call.

Field Name	Type	Length
call_id	int
call_UserID	int
call_Extension	varchar	10
call_SysID	int
call_SubSysID	int
call_Direction	varchar	10
call_Type	varchar	20
call_Source	varchar	50
call_Destination	varchar	50
call_RequestTime	datetime
call_StartTime	datetime
call_AnswerTime	datetime
call_EndTime	datetime
call_TagData	nvarchar	255
call_Result	varchar	20
call_Details	nvarchar	max

pCallBackPeriod

This table links call back time windows and periods.

Field Name	Type	Description
CBTW_ID	int	Unique ID for record
CBTW_CBW_ID	int	Link to pCallBackWeekPeriod table (CBW_ID)
CBTW_CBT_ID	int	Link to pCallBackTimePeriod table (CBT_ID)

pCallBacks

This contains the call lists for manual/ progressive dialling.

Field Name	Type	Length	Description
CallBac_ID	int		Unique ID for record
CallBac_Team	int		Link to sSkills table (ski_ID)
CallBac_User	int		Link to sUsers table (use_ID)
CallBac_Date	datetime	8	Date the task is due
CallBac_SysId	int		Link to pContacts table (Con_SysID)
CallBac_SubSysID	int		Link to pContactsSub table (consub_ID)
CallBac_TaskType	int		Link to pTaskTypes table (tt_ID)
CallBac_Type	int		Link to pResultCodes table (Res_Code)
CallBac_Priority	tinyint		The priority of the record
CallBac_ListId	int		Link to pCallBacks table (cl_ID)
CallBac_TimePeriod	int		Link to pCallBackTimePeriod table (CBT_ID)
CallBac_WeekPeriod	int		Link to pCallBackWeekPeriod table (CBW_ID)
CallBac_TaskReference	int		Link to task reference table, for example pEmail or pFulfilment
CallBac_Filter1	nvarchar	100
CallBac_Filter2	nvarchar	100
CallBac_Filter3	nvarchar	100
CallBac_Filter4	nvarchar	100
CallBac_Filter5	nvarchar	100
CallBac_Filter6	nvarchar	100

pCallBackTimePeriod

This table holds details of a time period that can be used when rescheduling an Infinity task.

Field Name	Type	Length	Description
CBT_ID	int		Unique ID for record
CBT_Name	nvarchar	100	Name of the period
CBT_StartTime	nvarchar	5	Start time as HH:MM
CBT_EndTime	nvarchar	5	End time as HH:MM
CBT_Active	bit	1	Indicate if Active

pCallBackWeekPeriod

This table holds details of a date period that can be used when rescheduling an Infinity task.

Field Name	Type	Length	Description
CBW_ID	int		Unique ID for record
CBW_Name	nvarchar	100	Name of the period
CBW_Monday	bit	1	Indicates if valid of Monday
CBW_Tuesday	bit	1	Indicates if valid of Tuesday
CBW_Wednesday	bit	1	Indicates if valid of Wednesday
CBW_Thursday	bit	1	Indicates if valid of Thursday
CBW_Friday	bit	1	Indicates if valid of Friday
CBW_Saturday	bit	1	Indicates if valid of Saturday
CBW_Sunday	bit	1	Indicates if valid on Sunday
CBW_Active	bit	1	Indicate if Active

pCallingRules

This table defines the rules for getting the next Infinity managed task.

Field Name	Type	Length	Description
cr_ID	int		Unique ID for record
cr_Code	nvarchar	3	Code to describe the order records are processed.
cr_Description	nvarchar	100	Description of Calling Rule
cr_Active	bit	1	Indicate if Active

pCallResults

This table holds the call coding options that can be selected by the agents.

Field Name	Type	Length	Description
Call_ID	int		Unique ID for record
Call_CallOutcomeCode	nvarchar	50	Short code for the call outcome
Call_CallOutcomeSystem	nvarchar	50	Match to system codes
Call_CallOutcomeDesc	nvarchar	200	Description shown to agents
Call_ResultType	int		Link to pResultCodes table (Res_Code)
Call_OrderBy	int		Display ordering field
Call_Effective	bit	1	Reporting flag
Call_Affectable	bit	1	Reporting flag
Call_Sale	bit	1	Reporting flag
Call_Recycle	int		Number of minutes to auto recycle record if this outcome is selected (also used as Reporting flag is not zero/blank)
Call_Connect	bit	1	Reporting flag
Call_Complete	bit	1	Reporting flag
Call_NoOfTimes	int		Maximum number of times this outcome can be selected
Call_Active	bit	1	Indicate if Active
Call_SalesValueDefault	float	8	Default value of sale
Call_Transfer	bit	1	Reporting flag
Call_Hidden	bit	1	Indicates the code is hidden from the agent
Call_System	bit	1	Indicates the code is a system code, and should be hidden from the agent
Call_SupplierCode	nvarchar	50	Code to be passed to CTI layer
Call_MaximumAttemptsCode	nvarchar	50	Code to be used if call is coded as Max Attempts (link to pCallResults table - Call_CallOutcomeCode)
Call_MaximumAttemptsSubCode	nvarchar	50	Sub-Code to be used if call is coded as Max Attempts (link to pSubCodes table - sub_Code)

pCallsLists

This table holds a description allowing you to group tasks records together.

Field Name	Type	Length	Description
cl_ID	int		Unique ID for record
cl_Description	nvarchar	200	Description of the List
cl_DateLoaded	datetime	8	Date the list was created
cl_LoadedBy	int		Link to sUsers table (use_ID)
cl_TaskTypeId	int		Link to pTaskTypes table (tt_ID)
cl_RecordCount	int		Number of records in the list
cl_Priority	tinyint		The priority of the list

pConfig

This table holds a number of configuration options that can be set against the project.

Field Name	Type	Length	Description
conf_ID	int		Unique ID for record
conf_Team	int		Link to sSkills table (ski_ID)
conf_Group	nvarchar	50	Grouping name for the entry
conf_Item	nvarchar	50	Item name for the entry
conf_Order	nvarchar	50	Order field
conf_Type	nvarchar	50	Type of entry
conf_Value1	nvarchar	500	Setting 1 of entry
conf_Value2	nvarchar	500	Setting 2 of entry
conf_Value3	nvarchar	500	Setting 3 of entry
conf_hide	bit		Indicates if Active

pContacts

This table contains the Customer data record joined with pContactsExtra.

Field Name	Type	Length	Description
Con_SysID	int		Unique ID for record
Con_Team	nvarchar	100
Con_User	nvarchar	100
Con_CallOutcome	nvarchar	50
Con_CallOutcomeSub	nvarchar	50
Con_RecordStatus	int
Con_CallDate	datetime	8
Con_CallTime	datetime	8
Con_DiallerID	nvarchar	50
Con_CallCount	int
Con_Phone1	nvarchar	50
Con_Phone2	nvarchar	50
Con_Phone3	nvarchar	50
Con_Title	nvarchar	10
Con_Initial	nvarchar	3
Con_FirstName	nvarchar	30
Con_Surname	nvarchar	30
Con_FullName	nvarchar	80
Con_Company_ID	int
Con_Position	nvarchar	50
Con_Department	nvarchar	50
Con_Address1	nvarchar	50
Con_Address2	nvarchar	50
Con_Address3	nvarchar	50
Con_Address4	nvarchar	50
Con_Address5	nvarchar	50
Con_City	nvarchar	50
Con_CountyRegion	nvarchar	50
Con_PostCode	nvarchar	10
Con_Country	nvarchar	30
Con_Mobile	nvarchar	25
Con_Fax	nvarchar	25
Con_Email	nvarchar	100
Con_WebAddress	nvarchar	100
Con_DateOfBirth	datetime	8
Con_ImportDate	datetime	8
Con_ImportedBy	nvarchar	50
Con_ImportID	nvarchar	50
Con_Exported	bit	1
Con_ExportedDate	datetime	8
Con_ExportedBy	nvarchar	50
Con_HierachyKey	int
Con_Barred	bit	1

pContactsExtra

This is an extended table to include definable customer data fields joined to pContacts.

Field Name	Type	Length	Description
ConExt_SysID	int		Link to pContacts table (Con_SysID)

pContactsInUse

This table tracks the records that are currently being processed.

Field Name	Type	Length	Description
ConInUse_ID	int		Unique ID for record
ConInUse_SysId	int		Link to pContacts table (Con_SysID)
ConInUse_Team	int		Link to sSkills table (ski_ID)
ConInUse_User	int		Link to sUsers table (use_ID)
ConInUse_TimeStamp	datetime	8	Date/time record added
ConInUse_TaskType	int		Link to pTaskTypes table (tt_ID)
ConInUse_TaskReference	int		Link to task reference table, for example pEmail or pFulfilment

pContactsLink

This table holds the mapping between tables pContacts and pContactsSub.

Field Name	Type	Length	Description
conlnk_ID	int
conlnk_SysID	int
conlnk_SubID	int

pContactsSub

This table associates multiple contact information against a main record

Field Name	Type	Length
consub_ID	int
consub_SysID	int
consub_CreatedDate	datetime
consub_CreatedUser	int
consub_UpdatedDate	datetime
consub_UpdatedUser	int
consub_Outcome	nvarchar	50
consub_OutcomeSub	nvarchar	50
consub_RecordStatus	int

pControl

This table is used to hold information on screen controls.

Field Name	Type	Length	Description
ctr_ID	int		Unique ID for record
ctr_ScreenID	int		Link to pScreen table (scn_ID)
ctr_Name	nvarchar	100	Name of Control
ctr_XML	ntext	8	XML data for control

pDiary

This table holds information of diary bookings.

Field Name	Type	Length	Description
dry_ID	int		Unique ID for record
dry_OwnerID	int		Link to pDiaryOwner table (dro_ID)
dry_ProjectID	int		Link to sProject table (pro_ID)
dry_SysID	int		Link to pContacts table (Con_SysID)
dry_SubSysID	int		Link to pContactsSub table (consub_SysID)
dry_StartDT	datetime	8	Start date/time of the booking
dry_EndDT	datetime	8	End date/time of the booking
dry_Duration	int		Duration of booking
dry_Type	nvarchar	15
dry_Status	nvarchar	15	Status of booking
dry_BookedDT	datetime	8	Date the booking was made
dry_BookedBy	nvarchar	100	Link to sUsers table (use_Logon)
dry_BookedByID	int		Link to sUsers table (use_ID)
dry_Information	nvarchar	max
dry_ContactInfo	nvarchar	max
dry_Location	nvarchar	max

pDiaryArea

This table allows you to define 'Areas' to restrict which Diary Owners can accept bookings.

Field Name	Type	Length	Description
dra_ID	int		Unique ID for record
dra_Code	nvarchar	50	Code for the Area
dra_Description	nvarchar	255	Description of Area

pDiaryException

This table allows you to define dates that cannot be booked, e.g. public holidays.

Field Name	Type	Length	Description
drex_ID	int		Unique ID for record
drex_Type	nvarchar	15	Link to pDiaryRule table (drr_Type)
drex_Owner	int		Link to pDiaryOwner table (dro_ID)
drex_StartDate	datetime	8	Start date/time for the exception
drex_EndDate	datetime	8	End date/time for the exception
drex_Description	nvarchar	100	Description of the exception

pDiaryOwner

This table holds information of entities that can have booking allocated to them (diary owners).

Field Name	Type	Length	Description
dro_ID	int		Unique ID for record
dro_Code	nvarchar	15	Code for owner
dro_Name	nvarchar	100	Name of owner
dro_Address	nvarchar	50	Address of owner
dro_PhoneNo	nvarchar	30	Contact Number of owner
dro_Email	nvarchar	255	Email address for owner
dro_RuleType	nvarchar	15	Link to pDiaryRule table (drr_Type)
dro_Active	bit	1	Indicate if Active

pDiaryOwnerArea

This table holds the mappings between tables pDiaryOwner and pDiaryArea.

Field Name	Type	Description
doa_ID	int	Unique ID for record
doa_AreaID	int	Link to pDiaryArea table (dra_ID)
doa_OwnerID	int	Link to pDiaryOwner table (dro_ID)

pDiaryRule

This table holds the basic information about a Diary (such as days when bookings are allowed and how much time a booking slot is for).

Field Name	Type	Length	Description
drr_ID	int		Unique ID for record
drr_Type	nvarchar	15	Type of Diary
drr_Day	nchar	3	Day of week
drr_StartTime	nchar	4	Start time for bookings
drr_EndTime	nchar	4	End time for bookings
drr_Duration	int		Duration of booking

pDocuments

This table holds information on merged documents and attachments for fulfilment templates.

Field Name	Type	Length	Description
doc_ID	int		Unique ID for record
doc_Name	nvarchar	255
doc_Format	nvarchar	15
doc_md5	char	32
doc_Content	varbinary	max

pEmail

This table stores all inbound and outbound emails.

Field Name	Type	Length	Description
ema_EmailId	int		Unique ID for record
ema_SysId	int
ema_SubSysID	int
ema_ToAddress	nvarchar	255
ema_CCAddress	nvarchar	255
ema_BCCAddress	nvarchar	255
ema_Sender	nvarchar	255
ema_FromAddress	nvarchar	255
ema_FromDisplay	nvarchar	255
ema_ReplyTo	nvarchar	255
ema_ReturnPath	nvarchar	255
ema_Subject	nvarchar	512
ema_EmailDate	datetime	8
ema_Message	nvarchar	max
ema_HTMLMessage	nvarchar	max
ema_Direction	nvarchar	50
ema_Status	nvarchar	10
ema_ErrorMessage	nvarchar	255
ema_MessageID	nvarchar	255
ema_Priority	tinyint
ema_SendAsHTML	bit	1
ema_CreatedByID	int
ema_CreatedDT	datetime	8
ema_CompletedByID	int
ema_CompletedDT	datetime	8
ema_POP3ID	int

pEmailAttachment

This table stores details of the email attachments.

Field Name	Type	Length	Description
ea_AttachmentID	int		Unique ID for record
ea_EmailID	int
ea_OriginalFilename	nvarchar	255
ea_Storedfilename	nvarchar	255
ea_CID	nvarchar	255
ea_Disposition	nvarchar	255
ea_Content	varbinary	max
ea_md5	char	32

pEmailMap

This table is used by the POP3 service to map incoming emails to a specific task type.

Field Name	Type	Length	Description
em_ID	int		Unique ID for record
em_EmailAddress	nvarchar	255
em_TaskTypeId	int
em_CallsListID	int

pExport

This table holds top level information for export definitions.

Field Name	Type	Length	Description
exp_ID	int		Unique ID for record
exp_Description	nvarchar	100
exp_Table	nvarchar	100
exp_Condition	nvarchar	1024
exp_SQLQuery	nvarchar	1024
exp_Active	bit	1
exp_FileFormat	nchar	3
exp_Delimiter	nchar	1
exp_TextQualifier	nchar	1
exp_FileMask	nvarchar	255
exp_DestinationPath	nvarchar	255
exp_CreateEmptyFile	bit	1
exp_Notification	nvarchar	512
exp_Audit	bit	1
exp_FirstRowHeader	bit	1
exp_OverwriteDestinationFile	bit	1
exp_IsAnsi	bit	1
exp_Encoding	nvarchar	15
exp_BeforeExport	nvarchar	255
exp_AfterExport	nvarchar	255

pExportAudit

This table tracks when a record was exported, if the Audit option is enabled.

Field Name	Type	Description
ExpAud_ID	int	Unique ID for record
ExpAud_ExportID	int	Link to pExport table (exp_ID)
ExpAud_RecordID	int	Link to the ID field of the exported table
ExpAud_HistoryID	int	Link to pExportHistory table (exphist_ID)

pExportHistory

This table records details about the exports performed.

Field Name	Type	Length	Description
exphist_ID	int		Unique ID for record
exphist_exportid	int		Link to pExport table (exp_ID)
exphist_exportby	int		Link to sUsers table (use_ID)
exphist_text	nvarchar	100
exphist_date	datetime	8
exphist_type	nvarchar	20
exphist_amount	int
exphist_filename	nvarchar	200
exphist_table	nvarchar	100
exphist_selectioncriteria	ntext	8

pExportSection

This table defines a section in the export file, i.e. header, data, footer.

Field Name	Type	Length	Description
ExpSec_ID	int		Unique ID for record
ExpSec_ExportID	int		Link to pExport table (exp_ID)
ExpSec_Description	nvarchar	100
ExpSec_XMLSectionName	nvarchar	100
ExpSec_Grouping	nvarchar	100
ExpSec_ConditionField	nvarchar	255
ExpSec_ConditionValue	nvarchar	255
ExpSec_Order	int
ExpSec_Repeat	nchar	1

pExportSectionAttribute

This table holds XML attribute information for an export section.

Field Name	Type	Length	Description
ExpSecAtt_ID	int		Unique ID for record
ExpSecAtt_SectionID	int		Link to pExportSection table (ExpSec_ID)
ExpSecAtt_Name	nvarchar	100
ExpSecAtt_Value	nvarchar	255
ExpSecAtt_Field	nvarchar	255
ExpSecAtt_Order	smallint

pExportSectionElement

This table holds information on each field/element of an export section.

Field Name	Type	Length	Description
ExpSecEle_ID	int		Unique ID for record
ExpSecEle_SectionID	int		Link to pExportSection table (ExpSec_ID)
ExpSecEle_ElementName	nvarchar	100
ExpSecEle_SectionName	nvarchar	100
ExpSecEle_TableName	nvarchar	100
ExpSecEle_FieldName	nvarchar	100
ExpSecEle_SQL	nvarchar	512
ExpSecEle_Size	smallint
ExpSecEle_Value	nvarchar	255
ExpSecEle_Formatting	nvarchar	255
ExpSecEle_Validation	nvarchar	100
ExpSecEle_Order	smallint

pExportUpdate

This table allows you to define a number of field to update after the export has run.

Field Name	Type	Length	Description
ExpUpd_ID	int		Unique ID for record
ExpUpd_ExportID	int		Link to pExport table (exp_ID)
ExpUpd_FieldName	nvarchar	100	Name of the field to update after export
ExpUpd_Value	nvarchar	255	Value with which to update the field after export

pFilters

This table holds filters that can be used to restrict the data selected by tasks.

Field Name	Type	Length	Description
fil_ID	int		Unique ID for record
fil_Name	nvarchar	100	The filter name
fil_SQLStatement	nvarchar	3000	The SQL to be used
fil_Active	bit	1	Indicate if Active
fil_XML	ntext	8

pFulfilment

This table is used to hold details of letters that need to be sent from the system. This can either be exported for printing by a 3rd party, printed locally or emailed.

Field Name	Type	Length	Description
ful_ID	int		Unique ID for record
ful_SysID	int		Link to pContacts table (Con_SysID)
ful_SubSysID	int		Link to pContactsSub table (consub_ID)
ful_AgentID	int		Link to sUsers table (use_ID)
ful_LetterID	int		Link to pFulfilmentLetter table (let_ID)
ful_RequestedDate	datetime	8
ful_PrintDate	datetime	8
ful_Status	nvarchar	10
ful_Direction	nvarchar	10
ful_OriginalFilename	nvarchar	255
ful_Storedfilename	nvarchar	255
ful_ErrorMessage	nvarchar	255

pFulfilmentLetter

This table holds the details of letters that can be sent.

Field Name	Type	Length	Description
let_ID	int		Unique ID for record
let_Description	nvarchar	100
let_Type	nvarchar	20
let_CustomSP	nvarchar	255
let_Active	bit	1
let_Removed	bit	1

pFulfilmentLetterSetting

This table holds additional settings for letters, e.g. email configuration.

Field Name	Type	Length	Description
letset_ID	int		Unique ID for record
letset_LetterID	int		Link to pFulfilmentLetter table (let_ID)
letset_Name	nvarchar	100
letset_Value	nvarchar	max

pFunction

This table holds the function definitions used within scripts.

Field Name	Type	Length	Description
fun_ID	int		Unique ID for record
fun_ScriptID	int		Link to pScripts table (scrp_ID)
fun_Name	nvarchar	100	The name of the function
fun_XML	ntext		XML holding type function commands

pImportDefs

This table holds the import definitions.

Field Name	Type	Length	Description
imp_ID	int		Unique ID for record
imp_name	nvarchar	50
imp_exptype	nvarchar	20
imp_filename	nvarchar	200
imp_errfileloc	nvarchar	200
imp_del_delimiter	nvarchar	20
imp_del_firstrownames	bit	1
imp_del_textqualifier	nvarchar	20
imp_fix_firstrownames	bit	1
imp_fix_colwidths	ntext
imp_isansi	bit	1
imp_renamefile	bit	1
imp_MoveTo	nvarchar	1024
imp_server	nvarchar	200
imp_database	nvarchar	50
imp_uid	nvarchar	50
imp_pwd	nvarchar	50
imp_table	nvarchar	100
imp_names	ntext
imp_importdata	ntext
imp_active	bit	1
imp_cleardest	bit	1
imp_UpdateField1	nvarchar	100
imp_UpdateValue1	nvarchar	100
imp_UpdateField2	nvarchar	100
imp_UpdateValue2	nvarchar	100
imp_UpdateField3	nvarchar	100
imp_UpdateValue3	nvarchar	100
imp_UpdateField4	nvarchar	100
imp_UpdateValue4	nvarchar	100
imp_UpdateField5	nvarchar	100
imp_UpdateValue5	nvarchar	100
imp_SP_ImportRowAdded	nvarchar	255
imp_SP_ImportCompleted	nvarchar	255
imp_BulkInsert	bit	1

pImportHistory

This table records details on the imports performed.

Field Name	Type	Length	Description
imphist_ID	int		Unique ID for record
imphist_date	datetime	8	Date the import was run
imphist_importid	int		Link to the pImportDefs table (imp_ID)
imphist_importby	int		Link to the sUsers table (use_ID)
imphist_text	nvarchar	50	Comments
imphist_loaded	int		Number of records loaded

pKPI

Field Name	Type	Length
trg_id	int
trg_Description	nvarchar	100
trg_Type	varchar	50
trg_Report	int
trg_Targets	text
trg_Active	bit

pList

This table holds details of Infinity lists that can be used within scripts.

Field Name	Type	Length	Description
lst_ID	int		Unique ID for record
lst_Name	nvarchar	100	The name of the list
lst_Active	bit	1	Indicate if Active

pListItem

This table holds the items that make up the lists.

Field Name	Type	Length	Description
lstitm_ID	int		Unique ID for record
lstitm_ListID	int		Link to the pList table (lst_ID)
lstitm_DisplayText	nvarchar	500	The text shown to the agent
lstitm_Code	nvarchar	100	Code for the item that will be stored
lstitm_Order	int		The display order of the item

pProcessStatus

This is a temporary table used by import/export processes when running long tasks such as SPs.

Field Name	Type	Length
Id	int
JobName	varchar	100
StartTime	datetime
EndTime	datetime
ProcessStatus	char	1
ErrorMessage	varchar	2000

pQueryCards

This tables holds queries that display segmented data to agents.

Field Name	Type	Length	Description
qc_ID	int		Unique ID for record
qc_Description	nvarchar	100	Description of the Query Card
qc_SQLQuery	ntext		SQL Query used to extract records
qc_DisplayFields	ntext		List of fields displayed to agent
qc_SearchFields	ntext		List of fields that can be used to search
qc_AddFields	ntext		List of fields displayed to agent when adding a new record
qc_AllowAdd	bit	1	Flag to indicate whether or not adding a new record is allowed
qc_AllowSearch	bit	1	Flag to indicate whether or not searching for a record is allowed
qc_RefreshTime	tinyint		Number of seconds before query is automatically run ro refresh the agents view
qc_TaskTypeID	int		Link to pTaskTypes table (tt_ID)
qc_ScriptID	int		Link to pScripts table (scrp_ID)
qc_ExistingTaskFlag	smallint		Flag used to indicate how system handle any existing tasks for a selected record
qc_Active	bit	1	Indicates if Active

pResultCodes

This table holds information of the type of result code that can be created (i.e. Complete, Call Back, Recycle) for call outcomes.

Field Name	Type	Length	Description
Res_Code	int		Unique ID for record
Res_Desc	nvarchar	50	Description of code
Res_System	bit	1	Indicates if reserved for system use

pResultsSkills

This table holds the link restricting a call result code to a skill.

Field Name	Type	Description
rsk_ID	int	Unique ID for record
rsk_CallId	int	Link to pCallResults table (Call_ID)
rsk_SkillId	int	Link to sSkills table (ski_ID)

pScreen

This table holds details on screens that make up a script.

Field Name	Type	Length	Description
scn_ID	int		Unique ID for record
scn_ScriptID	int		Link to pScripts table (scrp_ID)
scn_Date	datetime	8	The date the screen was last saved
scn_Name	nvarchar	100	The name of the screen
scn_Version	int		Not currently used
scn_XML	ntext		The screen XML data

pScriptFeedback

This table is used to record any comments recorded against a script during the testing phase.

Field Name	Type	Length	Description
scfd_ID	int		Unique ID for record
scfd_ScriptID	int		Link to pScripts table (scrp_ID)
scfd_ScreenID	int		Link to pScreen table (scn_ID)
scfd_AgentID	int		Link to sUsers table (use_ID)
scfd_Date	datetime	8	The date the feedback was added
scfd_Feedback	ntext		The feedback text
scfd_Completed	bit	1	Flag to indicate feedback has been completed
scfd_CompletedDate	datetime	8	Date feedback was flagged as completed
scfd_CompletedBy	int		Link to sUsers table (use_ID)

pScriptStyle

This table holds styling information about screens and controls that can be used to "theme" a script quickly.

Field Name	Type	Length
sty_ID	int
sty_Name	nvarchar	50
sty_Type	nvarchar	50
sty_XML	nvarchar	max
sty_Active	bit
sty_Default	bit

pScripts

This table holds top level information about a script.

Field Name	Type	Length	Description
scrp_ID	int		Unique ID for record
scrp_Name	nvarchar	100
scrp_Description	nvarchar	1000
scrp_Active	bit	1
scrp_StartScreenID	int
scrp_ScriptType	int
scrp_Engine	int
scrp_DateCreated	nvarchar	50
scrp_CreatedBy	nvarchar	50
scrp_ImagePath	nvarchar	200
scrp_DefaultFont	nvarchar	50
scrp_WaterMarkBlob	image	16
scrp_BackgroundColour	int
scrp_ScreenSize	nvarchar	20
scrp_BackgroundImageID	int
scrp_Version	int
scrp_AuditFlag	smallint
scrp_ScriptMode	smallint
scrp_LockedBy	int
scrp_CreatedDate	datetime	8
scrp_CreatedByID	int
scrp_LastModifiedDate	datetime	8
scrp_LastModifiedByID	int
scrp_ForceImageRefresh	bit	1
scrp_Revision	int
scrp_XML	nvarchar	max

pSkillsQCards

This table holds the link restricting a Query Card to a Skill.

Field Name	Type	Length	Description
sqc_SkillId	int		Link to sSkills table (ski_ID)
sqc_QcId	int		Link to pQueryCards table (qc_ID)

pSubCodes

This table holds sub-code details for call outcome result codes.

Field Name	Type	Length	Description
sub_ID	int		Unique ID for record
sub_CallResultId	int		Link to pCallResults table (Call_ID)
sub_Code	nvarchar	20	Code of the sub-code
sub_Desc	nvarchar	100	Description of the sub-code
sub_Active	bit	1	Indicates if Active

pTaskScript

This table holds the link between a Task Type and the Script that will be used to handle it.

Field Name	Type	Length	Description
ts_ID	int		Unique ID for record
ts_SkillId	int		Link to sSkills table (ski_ID)
ts_ScriptId	int		Link to pScripts table (scrp_ID)
ts_TaskTypeId	int		Link to pTaskTypes table (tt_ID)
ts_FilterId	int		Link to pFilters table (fil_ID)
ts_Priority	tinyint		Number to indicate priority (1 - highest)
ts_Active	bit	1	Indicates if Active
ts_CallingRule	int		Link to pCallingRules table (cr_ID)

pTaskTypes

This table holds details of task types.

Field Name	Type	Length	Description
tt_ID	int		Unique ID for record
tt_Description	nvarchar	200	Description of the Task Type
tt_Category	int		Link to sTaskTypes table (tt_ID)
tt_IsAgentTask	bit	1	Indicates whether Task Type can be assigned to agents
tt_IsDefault	bit	1	Indicates whether or not this is the default Task Type
tt_AltProc	nvarchar	128	Name of alternative procedure to be used to get the next task
tt_Active	bit	1	Indicates if Active

pURN

This table holds definition data for generating URNs within the script.

Field Name	Type	Length	Description
urn_ID	int		Unique ID for record
urn_Type	nvarchar	10
urn_Prefix	nvarchar	10
urn_Suffix	nvarchar	10
urn_Length	int
urn_NextID	int

pVariable

This table holds details of script global variables.

Field Name	Type	Length	Description
var_ID	int		Unique ID for record
var_ScriptID	int		Link to pScripts table (scrp_ID)
var_Name	nvarchar	100	Variable name
var_Value	nvarchar	255	Default value

pWorkflowEvent

This table holds the events for the various workflow processes.

Field Name	Type	Length
wfle_ID	int
wfle_ProcessID	int
wfle_Query	nvarchar	max
wfle_Status	char	1

pWorkflowProcess

This table holds the workflow process definitions.

Field Name	Type	Length
wflp_ID	int
wflp_Name	nvarchar	50
wflp_Description	nvarchar	max
wflp_Type	nvarchar	10
wflp_BaseTable	nvarchar	255
wflp_Query	nvarchar	max
wflp_Active	bit

pWorkflowProcessStep

This table is used to allocate Steps to a Process.

Field Name	Type	Length
wflps_ID	int
wflps_ProcessID	int
wflps_StepID	int
wflps_InputMappings	nvarchar	max
wflps_OutputMappings	nvarchar	max
wflps_Routing	nvarchar	max
wflps_Order	int
wflps_StopOnError	bit

pWorkflowStep

This table holds the definitions of individual workflow steps.

Field Name	Type	Length
wfls_ID	int
wfls_Name	nvarchar	50
wfls_Description	nvarchar	max
wfls_Input	nvarchar	max
wfls_Output	nvarchar	max
wfls_Controls	nvarchar	max
wfls_Function	nvarchar	max
wfls_Active	bit

Core

Stored Procedure	Description
inf40_CALLBACK_Add	This procedure is used to add a new task, or update an existing task onto the system
inf40_CALLBACK_GetNext	This procedure is called when the Infinity system is checking to see if there are any tasks that need to be processed by the agent - depending on the calling rules specified this procedure will call inf40_CALLBACK_GetNext_CR or inf40_CALLBACK_GetNext_N.
inf40_CALLBACK_GetNext_CR	This procedure is used to find any call back/recycle tasks that are due to be processed
inf40_CALLBACK_GetNext_N	This procedure is used to find any new tasks that are due to be processed

Diary

Stored Procedure	Description
inf40_DIARY_GetDiaryOwnerList
inf40_DIARY_MakeBooking

KPI

Stored Procedure	Description
kpi_AVG_SALES_TALKTIME
kpi_COMPLETE
kpi_CONVERSION
kpi_CONVERSION_PER_COMPLETE
kpi_DMC
kpi_SALES
kpi_SALES_COUNT

Reporting (rdlc)

Stored Procedure	Report
inf40_REPORTING_CallbackView	Hour Summary.rdlc

Script

Stored Procedure	Description
inf40_SD_CopyScript	This procedure is called by Script Designer when copying a script
inf40_SD_GetAuditLogBlock	This procedure is called by Script Designer when requesting Audit information
inf40_SD_GetAvailableFields	This procedure is called by Script Designer when requesting details of the available tables and fields that are to be accessed from the scripts
inf40_SD_GetCompleteScript	This procedure is used by Script Designer, and Engine, to retrieve the script information including all the screens, controls, functions and variables
inf40_SD_GetFieldNames	This procedure is used by Script Designer, and Engine, to retrieve the definition of a table, it will return the table fields and their types, along with the Primary Key field
inf40_SD_LockScript	This procedure is used by Script Designer to try and mark the script as locked, when it is opened for editing

Others

Stored Procedure	Description
inf40_REPORTING_ProjectView
inf40_SCRIPT_GenerateURN
inf40_TABLE_RebuildSPs	This procedure is used to rebuild the tables and stored procedures that are used when Infinity database encryption is enabled
inf_AGENT_CreateJob
inf_AGENT_UpdateStatus

Project database

Tables

Stored Procedures