System database

This document describes the tables and procedures of the Infinity System Database.

Tables

Field Name Type Length Description
aex_ID int    
aex_Area nvarchar 50  
aex_UserID int    
aex_AccessLevelID int    
aex_RoleID int    
Field Name Type Length Description
aec_ID int    
aec_Category nvarchar 50  
aec_Code nvarchar 50  
aec_Description nvarchar 50  
aec_MinAccessLevel int    
Field Name Type Length Description
al_ID int    
al_Description nvarchar 100  
al_Value tinyint    
al_Active bit    
Field Name Type Length Description
add_ID int    
add_Description nvarchar 50  
add_Address1 nvarchar 50  
add_Address2 nvarchar 50  
add_Address3 nvarchar 50  
add_Address4 nvarchar 50  
add_City nvarchar 50  
add_County nvarchar 50  
add_Postcode nvarchar 20  
add_Fax nvarchar 20  
add_Phone nvarchar 20  
Field Name Type Length Description
alt_ID int    
alt_ProjectID int    
alt_From int    
alt_AgentID int    
alt_AlertType int    
alt_Reference int    
alt_AlertDate datetime    
alt_Description varchar 1024  
alt_Active bit    
Field Name Type Length Description
qaalt_ID int    
qaalt_Category varchar 20  
qaalt_Type varchar 50  
qaalt_Description nvarchar 100  
qaalt_Image nvarchar 100  
qaalt_Ordering int    
qaalt_MinAccessLevel nvarchar 255  
Field Name Type Length Description
arc_ID int    
arc_Description nvarchar 50  
arc_Database nvarchar 10  
arc_Tables ntext    
arc_Active bit    
Field Name Type Length Description
arcpro_ID int    
arcpro_Project int    
arcpro_Archive int    
Field Name Type Length Description
archis_ID int    
archis_Project int    
archis_User int    
archis_Archive int    
archis_Datetime datetime    
archis_RowsAffected int    
archis_Details nvarchar max  
Field Name Type Length Description
AU_ID int    
AU_UserID int    
AU_Date datetime    
AU_Module nvarchar 50  
AU_Key int    
AU_Type nchar 1  
AU_SubType nchar 5  
AU_Station nvarchar 255  
AU_Comment ntext    
AU_ParentKey int    
Field Name Type Length Description
ac_ID int    
ac_AuxCodes nvarchar 100  
ac_Active bit    
Field Name Type Length Description
acv_ID int    
acv_ParentId int    
acv_Code int    
acv_Description nvarchar 50  
Field Name Type Length Description
bhi_ID int    
bhi_timestamp datetime    
bhi_userid int    
bhi_listid int    
bhi_projectid int    
bhi_matched int    
Field Name Type Length Description
blp_ListID int    
blp_ProjectID int    
blp_Settings nvarchar max  
Field Name Type Length Description
bli_ID int    
bli_name nvarchar 50  
Field Name Type Length Description
bar_ID int    
bar_number nvarchar 30  
bar_listid int    
Field Name Type Length Description
cli_ID int    
cli_Name nvarchar 50  
cli_Since datetime    
cli_Description nvarchar 1000  
cli_Phone nvarchar 25  
cli_Image int    
cli_Active bit    
cli_Address int    
Field Name Type Length Description
scom_ProgID nvarchar 200  
scom_Path nvarchar 300  
scom_Title nvarchar 100  
scom_Description nvarchar 500  
scom_Input ntext    
scom_Output ntext    
scom_Height int    
scom_Width int    
Field Name Type Length Description
ctmp_ID int    
ctmp_Name nvarchar 100  
ctmp_XML ntext    
Field Name Type Length Description
cti_ID int    
cti_Description nvarchar 100  
cti_Active bit    
cti_IpAddress nvarchar 50  
cti_PortNumber int    
cti_cti bit    
cti_Vendor nvarchar 100  
cti_Object nvarchar 100  
cti_LookupLogon bit    
cti_IsRecorder bit    
Field Name Type Length Description
ctiset_ID int    
ctiset_CTIID int    
ctiset_Command nvarchar 50  
ctiset_Parameter1 nvarchar 100  
ctiset_Parameter2 nvarchar 100  
ctiset_Order smallint    
ctiset_Active bit    
Field Name Type Length Description
dp_ID smallint    
dp_Prefix nvarchar 20  
dp_Description nvarchar 100  
dp_Active bit    
Field Name Type Length Description
dtn_ID int    
dtn_Name nvarchar 100  
dtn_DialledNumber nvarchar 50  
dtn_Dtn nvarchar 50  
dtn_Active bit    
Field Name Type Length Description
chat_ID int    
chat_SourceUser int    
chat_DestinationUser int    
chat_Date datetime    
chat_Message ntext    
Field Name Type Length Description
msg_ID int    
msg_Active bit    
msg_ActiveUntil datetime    
msg_SourceUser int    
msg_Client int    
msg_Project int    
msg_Skill int    
msg_ReportingTeam int    
msg_User int    
msg_Message ntext    
Field Name Type Length Description
imcat_ID int    
imcat_Description nvarchar 50  
Field Name Type Length Description
image_ID int    
image_description nvarchar 50  
image_categoryid int    
image_blob image    
image_size int    
image_revision int    
image_md5 char 32  
image_type varchar 15  
Field Name Type Length Description
kat_id int    
kat_description nvarchar 100  
kat_Active bit    
Field Name Type Length Description
katans_id int    
katans_AssessmentID int    
katans_QuestionID int    
katans_Answer nvarchar 2000  
katans_AnswerDate datetime    
katans_Status varchar 25  
Field Name Type Length Description
katass_id int    
katass_KATID int    
katass_AgentID int    
katass_Status varchar 25  
katass_CreatedDate datetime    
katass_StartDate datetime    
katass_AllowPause int    
katass_PausePeriod int    
katass_QuestionInterval int    
katass_Section int    
katass_Question int    
katass_BeginDate datetime    
katass_CompletedDate datetime    
Field Name Type Length Description
KATlst_ID int    
KATlst_Name nvarchar 100  
KATlst_Active bit    
Field Name Type Length Description
KATlstitm_ID int    
KATlstitm_ListID int    
KATlstitm_DisplayText nvarchar 500  
KATlstitm_Code nvarchar 100  
KATlstitm_Order int    
Field Name Type Length Description
katqu_id int    
katqu_SectionID int    
katqu_Title nvarchar 100  
katqu_QuestionText ntext    
katqu_AnswerType varchar 25  
katqu_ListID int    
katqu_ScoringMode varchar 25  
katqu_Answer nvarchar 255  
katqu_Order int    
katqu_RoutingMode varchar 25  
katqu_AutoPop int    
Field Name Type Length Description
katqui_ID int    
katqui_QuestionID int    
katqui_ImageID int    
Field Name Type Length Description
katrul_id int    
katrul_QuestionID int    
katrul_Answer nvarchar 255  
katrul_Section int    
katrul_Question int    
Field Name Type Length Description
katsec_id int    
katsec_KATID int    
katsec_Description nvarchar 100  
katsec_Order int    
Field Name Type Length Description
kb_ID int    
kb_Name nvarchar 100  
kb_Desc text    
kb_ConnectionString nvarchar 200  
kb_ImageID int    
kb_Active bit    
Field Name Type Length Description
kbact_ID int    
kbact_Code nvarchar 10  
kbact_Text nvarchar 50  
Field Name Type Length Description
kbart_ID int    
kbart_KBID int    
kbart_Title nvarchar 50  
kbart_Description nvarchar 200  
kbart_Text text    
kbart_StartDate datetime    
kbart_Expires bit    
kbart_ExpiryDate datetime    
kbart_Keywords nvarchar 100  
kbart_CategoryID int    
kbart_SubCategoryID int    
kbart_ImpressionCount int    
kbart_HitCount int    
kbart_UsefulCount int    
kbart_NotUsefulCount int    
kbart_AddedByUserID int    
kbart_AddedDate datetime    
kbart_LastModifiedUserID int    
kbart_LastModifiedDate datetime    
kbart_RequiresApproval bit    
kbart_ApprovedByUserID int    
kbart_ApprovedDate datetime    
kbart_Active bit    
Field Name Type Length Description
kbcat_ID int    
kbcat_KBID int    
kbcat_Text nvarchar 50  
kbcat_Active bit    
Field Name Type Length Description
kbcr_ID int    
kbcr_Timestamp datetime    
kbcr_UserID int    
kbcr_ArticleID int    
kbcr_Detail text    
kbcr_Status int    
kbcr_Complete bit    
kbcr_CompleteDate datetime    
kbcr_CompleteUserID int    
Field Name Type Length Description
kbcom_ID int    
kbcom_ArticleID int    
kbcom_UserID int    
kbcom_Timestamp datetime    
kbcom_Comment text    
kbcom_LastModifiedDate datetime    
kbcom_LastModifiedByUserID int    
kbcom_Deleted bit    
kbcom_DeletedDate datetime    
kbcom_DeletedByUserID int    
Field Name Type Length Description
kblnk_ID int    
kblnk_ArticleID int    
kblnk_LinkedArticleID int    
Field Name Type Length Description
kpl_ID int    
kpl_KBID int    
kpl_ProjectID int    
Field Name Type Length Description
kbsub_ID int    
kbsub_CategoryID int    
kbsub_Text nvarchar 50  
kbsub_Active bit    
Field Name Type Length Description
kbtrk_ID int    
kbtrk_Timestamp datetime    
kbtrk_ActionTypeID int    
kbtrk_UserID int    
kbtrk_ArticleID int    
kbtrk_CommentID int    
Field Name Type Length Description
loc_ID int    
loc_name nvarchar 50  
loc_description ntext    
loc_addressid int    
Field Name Type Length Description
lID int    
lUser int    
lProjectID int    
lLocation nvarchar 500  
lFlag nvarchar 25  
lActive bit    
lMaxDate int    
Field Name Type Length Description
mnugrp_ID int    
mnugrp_Text nvarchar 100  
mnugrp_Tag nvarchar 50  
mnugrp_Image nvarchar 30  
mnugrp_Tab nvarchar 50  
mnugrp_Order int    
mnugrp_ShowRegularProjects bit    
mnugrp_ShowTimesheetProjects bit    
mnugrp_ShowExternalProjects bit    
Field Name Type Length Description
mnugrpopt_ID int    
mnugrpopt_GroupID int    
mnugrpopt_OptionID int    
mnugrpopt_IsProjectItem bit    
mnugrpopt_ProjectID int    
mnugrpopt_Order int    
Field Name Type Length Description
homitm_ID int    
homitm_MenuGroupID int    
homitm_MenuItemID int    
homitm_UserID int    
homitm_ProjectID int    
homitm_Order int    
Field Name Type Length Description
mnulst_ID int    
mnulst_Name nvarchar 50  
mnulst_SQL ntext    
Field Name Type Length Description
mnuitm_ID int    
mnuitm_Text nvarchar 100  
mnuitm_MenuListID int    
mnuitm_Image nvarchar 30  
mnuitm_DLLFilename nvarchar 255  
mnuitm_ListObject nvarchar 255  
mnuitm_ManageObject nvarchar 255  
mnuitm_WebServiceURL nvarchar 255  
mnuitm_AccessCategory nvarchar 50  
mnuitm_Secure bit    
mnuitm_Audit bit    
mnuitm_Active bit    
Field Name Type Length Description
offf_ID int    
offf_Name nvarchar 50  
offf_BackgroundImageID int    
offf_BackgroundImageLayout int    
offf_Width int    
offf_Height int    
offf_BackColor int    
offf_Version int    
offf_Updated datetime    
offf_UpdatedBy int    
Field Name Type Length Description
offfo_ID int    
offfo_FloorID int    
offfo_Type int    
offfo_TypeID int    
offfo_X int    
offfo_Y int    
offfo_ExtNumber nvarchar 50  
offfo_FillColour int    
offfo_BorderColour int    
offfo_BorderThickness int    
offfo_Order int    
offfo_Misc ntext    
Field Name Type Length Description
offp_ID int    
offp_Name nvarchar 50  
offp_Width int    
offp_Height int    
offp_Version int    
offp_Updated datetime    
offp_UpdatedBy int    
Field Name Type Length Description
offpo_ID int    
offpo_Name nvarchar 50  
offpo_PlanID int    
offpo_Type int    
offpo_TypeID int    
offpo_X int    
offpo_Y int    
offpo_Width int    
offpo_Height int    
offpo_Order int    
offpo_Misc ntext    
Field Name Type Length Description
plc_ID int    
plc_QuestionID int    
plc_Text nvarchar 100  
plc_Order int    
plc_Active bit    
Field Name Type Length Description
qst_ID int    
qst_Name nvarchar 50  
qst_Type nvarchar 10  
qst_Question ntext    
qst_Active bit    
qst_OwnerID int    
qst_OpenDate datetime    
qst_ExpiryDate datetime    
qst_RandomChoices bit    
qst_RespondedText nvarchar 100  
Field Name Type Length Description
plr_ID int    
plr_QuestionID int    
plr_ChoiceID int    
plr_UserID int    
plr_Timestamp datetime    
Field Name Type Length Description
pos_ID int    
pos_Name nvarchar 50  
pos_Description nvarchar 255  
pos_IsLineManager bit    
Field Name Type Length Description
pro_ID int    
pro_Title nvarchar 100  
pro_Description nvarchar 100  
pro_ConnectionString nvarchar 300  
pro_ReportConnection nvarchar 300  
pro_Active bit    
pro_TimeSheetOnly bit    
pro_ImageId int    
pro_ClientId int    
pro_ProjectGroupId int    
pro_ProSplitId int    
pro_DbVersion nvarchar 10  
pro_ProjectFilterId int    
pro_Start datetime    
pro_End datetime    
pro_QAEnabled bit    
Field Name Type Length Description
prjdb_ID int    
prjdb_ProjectID int    
prjdb_Type nvarchar 50  
prjdb_Connection nvarchar 300  
Field Name Type Length Description
pf_ID int    
pf_Desc nvarchar 100  
pf_Filter1Name nvarchar 100  
pf_Filter1 nvarchar 257  
pf_Filter2Name nvarchar 100  
pf_Filter2 nvarchar 257  
pf_Filter3Name nvarchar 100  
pf_Filter3 nvarchar 257  
pf_Filter4Name nvarchar 100  
pf_Filter4 nvarchar 257  
pf_Filter5Name nvarchar 100  
pf_Filter5 nvarchar 257  
pf_Filter6Name nvarchar 100  
pf_Filter6 nvarchar 257  
pf_Active int    
Field Name Type Length Description
pg_ID int    
pg_GroupName nvarchar 100  
pg_GroupDesc nvarchar 100  
Field Name Type Length Description
ps_ID int    
ps_Desc nvarchar 100  
ps_Split1Name nvarchar 100  
ps_Split1 nvarchar 257  
ps_Split1System bit    
ps_Split2Name nvarchar 100  
ps_Split2 nvarchar 257  
ps_Split2System bit    
ps_Split3Name nvarchar 100  
ps_Split3 nvarchar 257  
ps_Split3System bit    
ps_Split4Name nvarchar 100  
ps_Split4 nvarchar 257  
ps_Split4System bit    
ps_Split5Name nvarchar 100  
ps_Split5 nvarchar 257  
ps_Split5System bit    
ps_Split6Name nvarchar 100  
ps_Split6 nvarchar 257  
ps_Split6System bit    
ps_Active bit    
Field Name Type Length Description
ptn_ProjectId int    
ptn_TransferNumberId int    
Field Name Type Length Description
pu_ProjectID int    
pu_UserID int    
Field Name Type Length Description
Rec_ID int    
Rec_Description nvarchar 100  
Rec_Path nvarchar 255  
Rec_Object nvarchar 100  
Rec_Active bit    
Field Name Type Length Description
RecSet_ID int    
RecSet_RecID int    
RecSet_Command nvarchar 50  
RecSet_Parameter1 nvarchar 100  
RecSet_Parameter2 nvarchar 100  
RecSet_Order smallint    
RecSet_Active bit    
Field Name Type Length Description
RE_ID int    
RE_Name nvarchar 255  
RE_Expression nvarchar 1024  
Field Name Type Length Description
repdash_ID int    
repdash_Name nvarchar 50  
repdash_ImageID int    
repdash_BackColour nvarchar 15  
repdash_ForeColour nvarchar 15  
repdash_ChartColour1 nvarchar 15  
repdash_ChartColour2 nvarchar 15  
repdash_Q1DLLName nvarchar 100  
repdash_Q2DLLName nvarchar 100  
repdash_Q3DLLName nvarchar 100  
repdash_Q4DLLName nvarchar 100  
repdash_Q1control nvarchar 50  
repdash_Q2control nvarchar 50  
repdash_Q3control nvarchar 50  
repdash_Q4control nvarchar 50  
repdash_Type nvarchar 10  
repdash_Active bit    
Field Name Type Length Description
repdashacc_ID int    
repdashacc_DashboardID int    
repdashacc_AccessLevelID int    
repdashacc_UserID int    
Field Name Type Length Description
rptf_ID int    
rptf_name nvarchar 50  
rptf_tableid int    
rptf_sql ntext    
rptf_xml ntext    
rptf_public bit    
rptf_allprojects bit    
rptf_locked bit    
rptf_owner int    
Field Name Type Length Description
rptfa_ID int    
rptfa_Filter int    
rptfa_Project int    
rptfa_UserID int    
rptfa_AccessLevelID int    
Field Name Type Length Description
rptr_ID int    
rptr_engine int    
rptr_database nvarchar 10  
rptr_category nvarchar 10  
rptr_folder nvarchar 100  
rptr_name nvarchar 100  
rptr_xml ntext    
rptr_public bit    
rptr_allprojects bit    
rptr_locked bit    
rptr_owner int    
Field Name Type Length Description
rptra_ID int    
rptra_Report int    
rptra_Project int    
rptra_UserID int    
rptra_AccessLevelID int    
Field Name Type Length Description
rptrh_ID int    
rptrh_ReportID int    
rptrh_UserID int    
rptrh_ProjectID int    
rptrh_Query ntext    
rptrh_ResultSize int    
rptrh_QueryDuration int    
rptrh_RunDate datetime    
Field Name Type Length Description
rptt_ID int    
rptt_category nvarchar 10  
rptt_type nvarchar 10  
rptt_database nvarchar 10  
rptt_name nvarchar 100  
rptt_query nvarchar 512  
rptt_archivequery nvarchar 512  
rptt_fieldmappings ntext    
rptt_public bit    
rptt_allprojects bit    
rptt_locked bit    
rptt_owner int    
Field Name Type Length Description
rptta_ID int    
rptta_Table int    
rptta_Project int    
rptta_UserID int    
rptta_AccessLevelID int    
Field Name Type Length Description
rptf_ID int    
rptf_TableID int    
rptf_Group nvarchar 100  
rptf_Name nvarchar 255  
rptf_Query nvarchar 2048  
rptf_Join nvarchar 1024  
rptf_GroupBy nvarchar 1024  
rptf_Filter nvarchar 50  
rptf_IsLayerGroup bit    
rptf_IsDataItem bit    
rptf_IsGroupByItem bit    
rptf_IsTableFieldItem bit    
Field Name Type Length Description
team_ID int    
team_Title nvarchar 100  
team_Description nvarchar 255  
team_Active bit    
Field Name Type Length Description
rol_ID int    
rol_Name nvarchar 100  
rol_Deleted bit    
Field Name Type Length Description
mem_ID int    
mem_RoleID int    
mem_UserID int    
mem_AccessLevelID int    
Field Name Type Length Description
sched_ID int    
sched_ProcessCode nvarchar 10  
sched_ProcessKey int    
sched_FrequencyPeriod nchar 5  
sched_FrequencyDelay int    
sched_StartTime nchar 4  
sched_EndTime nchar 4  
sched_Status nchar 1  
sched_NextRunDate datetime    
sched_LastUpdated datetime    
sched_Active nchar 1  
Field Name Type Length Description
schdata_ID int    
schdata_Description nvarchar 50  
schdata_Engine int    
schdata_Type nvarchar 10  
schdata_ProjectID int    
schdata_SkillID int    
schdata_Tag nvarchar max  
schdata_AlertLevel int    
schdata_Recipients nvarchar 1024  
schdata_Subject nvarchar 255  
schdata_Message nvarchar 1024  
schdata_ErrorNotification nvarchar 1024  
Field Name Type Length Description
exp_ID int    
exp_Description nvarchar 50  
exp_ProjectID int    
exp_ExportID int    
exp_ZipFile nchar 1  
exp_ZipPassword nvarchar 50  
exp_Subject nvarchar 255  
exp_EmailTo nvarchar 1024  
exp_EmailNotification nvarchar 512  
exp_ExportEngine int    
exp_ErrorNotification nvarchar 1024  
exp_UploadToFTP bit    
exp_FTPServer int    
Field Name Type Length Description
expset_ID int    
expset_ExportID int    
expset_Setting nvarchar 50  
expset_Value nvarchar 255  
Field Name Type Length Description
ftp_ID int    
ftp_Description nvarchar 50  
ftp_ProjectID int    
ftp_Server nvarchar 100  
ftp_Port int    
ftp_User nvarchar 100  
ftp_Password nvarchar 100  
ftp_Path nvarchar 255  
ftp_LocalPath nvarchar 255  
ftp_FileMask nvarchar 100  
ftp_DeleteFiles nchar 1  
ftp_Direction nchar 1  
ftp_NotificationContact nvarchar 1024  
ftp_OverwriteMode nvarchar 10  
ftp_InsertIntoDatabase bit    
ftp_CustomSP nvarchar 255  
ftp_TaskType int    
ftp_CallsList int    
ftp_UseSFTP bit    
ftp_PrivateKeyFile nvarchar 255  
ftp_PrivateKeyPhrase nvarchar 100  
Field Name Type Length Description
ful_ID int    
ful_Description nvarchar 50  
ful_ProjectID int    
ful_Direction nvarchar 10  
ful_LocalFolder nvarchar 1024  
ful_RemoteFolder nvarchar 1024  
ful_FileMask nvarchar 50  
ful_DeleteFile bit    
ful_TaskTypeID int    
ful_ListID int    
ful_CustomSP nvarchar 100  
ful_ProcessLimit int    
ful_ErrorNotification nvarchar 1024  
Field Name Type Length Description
imp_ID int    
imp_Description nvarchar 50  
imp_ProjectID int    
imp_ImportID int    
imp_EmailNotification nvarchar 1024  
imp_FileLocation nvarchar 1024  
imp_FileMask nvarchar 50  
imp_DownloadFromFTP bit    
imp_FTPServer int    
imp_ErrorNotification nvarchar 1024  
imp_StopOnError bit    
Field Name Type Length Description
pop3_ID int    
pop3_Description nvarchar 50  
pop3_ProjectID int    
pop3_Server nvarchar 50  
pop3_PortNumber int    
pop3_Mailbox nvarchar 50  
pop3_Username nvarchar 50  
pop3_Password nvarchar 50  
pop3_ProcessLimit int    
pop3_AutoReply nchar 1  
pop3_AttachmentDirectory nvarchar 255  
pop3_StoreEML bit    
pop3_EMLDirectory nvarchar 255  
pop3_JunkCustomFlag nchar 1  
pop3_CustomSP nvarchar 1024  
pop3_SizeThreshold int    
pop3_ErrorNotification nvarchar 1024  
pop3_Type nvarchar 10  
pop3_MoveToFolder nvarchar 255  
pop3_TaskTypeId int    
pop3_CallsListId int    
pop3_StoreInDatabase bit    
Field Name Type Length Description
pop3ar_ID int    
pop3ar_POP3ID int    
pop3ar_FromAddress nvarchar 255  
pop3ar_FromName nvarchar 255  
pop3ar_Subject nvarchar 255  
pop3ar_Message ntext    
pop3ar_HTMLFlag nchar 1  
pop3ar_MailServer nvarchar 50  
pop3ar_PortNumber int    
pop3ar_UserName nvarchar 50  
pop3ar_Password nvarchar 50  
pop3ar_HTMLMessage ntext    
pop3ar_Attachments ntext    
Field Name Type Length Description
pop3f_ID int    
pop3f_POP3ID int    
pop3f_CheckFrom nchar 1  
pop3f_CheckSubject nchar 1  
pop3f_CheckMessage nchar 1  
pop3f_FilterText nvarchar 255  
Field Name Type Length Description
prn_ID int    
prn_Description nvarchar 50  
prn_ProjectID int    
prn_PrinterName nvarchar 100  
prn_NotificationEmail nvarchar 1024  
Field Name Type Length Description
proc_ID int    
proc_Code nvarchar 10  
proc_Description nvarchar 100  
proc_IPAddress nvarchar 30  
proc_Port int    
Field Name Type Length Description
schrpt_ID int    
schrpt_Description nvarchar 50  
schrpt_ProjectID int    
schrpt_ReportID int    
schrpt_Format nvarchar 10  
schrpt_Filename nvarchar 255  
schrpt_ZipFile bit    
schrpt_ZipPassword nvarchar 50  
schrpt_Recipients nvarchar 1024  
schrpt_Subject nvarchar 255  
schrpt_Message nvarchar 1024  
schrpt_Parameters ntext    
schrpt_ErrorNotification nvarchar 1024  
Field Name Type Length Description
smtp_ID int    
smtp_Description nvarchar 50  
smtp_ProjectID int    
smtp_ErrorNotification nvarchar 1024  
smtp_SMTPServer nvarchar 50  
smtp_SMTPPort int    
smtp_Username nvarchar 50  
smtp_Password nvarchar 50  
smtp_ReplyName nvarchar 255  
smtp_ReplyAddress nvarchar 255  
smtp_ProcessLimit int    
smtp_AttachmentDirectory nvarchar 255  
smtp_CustomSP nvarchar 100  
Field Name Type Length Description
swfl_ID int    
swfl_Description nvarchar 50  
swfl_ProjectID int    
swfl_ProcessID int    
swfl_QueryType int    
swfl_Query nvarchar max  
swfl_ProcessLimit int    
swfl_ErrorNotification nvarchar 1024  
Field Name Type Length Description
ski_ID int    
ski_Description nvarchar 100  
ski_Project int    
ski_Mode nvarchar 10  
ski_CtiComplex bit    
ski_CtiResId int    
ski_SkillsDetailsId int    
ski_Priority tinyint    
ski_DialPrefixId smallint    
ski_ShowAux bit    
ski_AuxCodesId smallint    
ski_AutoAns bit    
ski_Search int    
ski_History int    
ski_Recorder int    
ski_SkillType nvarchar 10  
ski_Active bit    
Field Name Type Length Description
sd_ID int    
sd_Description nvarchar 100  
sd_PreviewTime int    
sd_DiallingTime int    
sd_StatusAfterTimeout nvarchar 50  
sd_WaitTime int    
sd_Active bit    
Field Name Type Length Description
sdt_SkillID int    
sdt_DtnID int    
sdt_ScriptID int    
sdt_TaskID int    
Field Name Type Length Description
sg_ID int    
sg_Title nvarchar 100  
sg_Description nvarchar 100  
sg_Active bit    
Field Name Type Length Description
sgs_SkillId int    
sgs_SkillsGroupId int    
Field Name Type Length Description
shi_ID int    
shi_Description nvarchar 50  
shi_Path nvarchar 300  
shi_Object nvarchar 50  
shi_Active bit    
Field Name Type Length Description
ssh_ID int    
ssh_Description nvarchar 50  
ssh_Path nvarchar 300  
ssh_Object nvarchar 50  
ssh_Active bit    
Field Name Type Length Description
su_UserID int    
su_SkillID int    
Field Name Type Length Description
tt_ID tinyint    
tt_Desc nvarchar 50  
Field Name Type Length Description
tlm_ID int    
tlm_TeamLeaderID int    
tlm_UserID int    
tlm_UserLogon nvarchar 100  
tlm_EmployeeID int    
Field Name Type Length Description
tile_ID int    
tile_description nvarchar 100  
tile_Page int    
tile_project int    
tile_locked bit    
tile_owner int    
tile_allaccesslevels bit    
tile_allclients bit    
tile_allprojects bit    
tile_allskills bit    
tile_allusers bit    
tile_active bit    
tile_createdate datetime    
tile_modifydate datetime    
tile_expiry bit    
tile_expirydate datetime    
tile_xml ntext    
tile_order int    
Field Name Type Length Description
tilea_ID int    
tilea_Tile int    
tilea_AccessLevel int    
tilea_Client int    
tilea_Project int    
tilea_Skill int    
tilea_User int    
Field Name Type Length Description
tilep_ID int    
tilep_name nvarchar 100  
tilep_orientation int    
tilep_order int    
Field Name Type Length Description
tn_ID int    
tn_Number nvarchar 20  
tn_Description nvarchar 100  
tn_Active bit    

This table holds license usage log.

Field Name Type Length Description
USL_ID int    
USL_ServerID nvarchar 50  
USL_DateTime datetime    
USL_Module nvarchar 50  
USL_Usage int    
USL_Total int    

This table holds toolbar usage log.

Field Name Type Length Description
UST_ID int    
UST_ServerID nvarchar 50  
UST_DateTime datetime    
UST_Toolbar nvarchar 50  
UST_Complex nvarchar 50  
UST_Direction nvarchar 50  
UST_Usage int    

This table holds the information users' login activity to Console.

Field Name Type Length Description
UA_ID int 4 Unique ID for record
UA_UserID int 4 Link to sUsers table (use_ID)
UA_Station nvarchar 100 Network name of workstation
UA_Login datetime 8 Log in date/time
UA_Logoff datetime 8 Log off date/time
UA_LastCompletedCall datetime 8 Date/Time of last completed call

This table holds summary data for each user activity.

Field Name Type Length Description
UAR_ID int 4 Unique ID for record
UAR_UAS_ID int 4 Link to sUserActivitySkill table (UAS_ID)
UAR_User int 4 Link to sUsers table (use_ID)
UAR_Client int 4 Link to sClients table (cli_ID)
UAR_Project int 4 Link to sProject table (pro_ID)
UAR_Skill int 4 Link to sSkills table (ski_ID)
UAR_ReportingTeam int 4 Link to sReportingTeam table (team_ID)
UAR_Date datetime 8 Date event occurred
UAR_Hour int 4 Hour event started
UAR_Sub1 nvarchar 50 Reporting information from event
UAR_Sub2 nvarchar 50 Reporting information from event
UAR_Sub3 nvarchar 50 Reporting information from event
UAR_Sub4 nvarchar 50 Reporting information from event
UAR_Sub5 nvarchar 50 Reporting information from event
UAR_Sub6 nvarchar 50 Reporting information from event
UAR_BreakTime float 8 Time spent in break (in secs.)
UAR_WaitTime float 8 Time spent in wait (in secs.)
UAR_PreviewTime float 8 Time spent in preview (in secs.)
UAR_DialTime float 8 Time spent in dial (in secs.)
UAR_TalkTime float 8 Time spent in talk (in secs.)
UAR_WrapTime float 8 Time spent in wrap (in secs.)
UAR_Dials int 4 Sum of dial flags
UAR_Connects int 4 Sum of connected flags
UAR_Completes int 4 Sum of complete flags
UAR_Effectives int 4 Sum of effective flags
UAR_Affectables int 4 Sum of affectable flags
UAR_Recycles int 4 Sum of recycle flags
UAR_Abandonds int 4 Sum of abandoned flags
UAR_Sales int 4 Sum of sale flags
UAR_SalesValue float 8 Sum of sale values

This table holds details of the skill changes throughout the logged in session.

Field Name Type Length Description
UAS_ID int 4 Unique ID for record
UAS_UA_ID int 4 Link to sUserActivity table (UA_ID)
UAS_Extension nvarchar 20 Extension number
UAS_Login datetime 8 Log in date/time
UAS_Logoff datetime 8 Log off date/time
UAS_LastCompletedCall datetime 8 Date/time of last completed call
UAS_ProjectID int 4 Link to sProject table (pro_ID)
UAS_Skill int 4 Link to sSkills table (ski_ID)

This table holds summarised information for users' activity state history.

Field Name Type Length Description
UAST_ID int 4 Unique ID for record
UAST_UAS_ID int 4 Link to sUserActivitySkill table (UAS_ID)
UAST_Project int 4 Link to sProject table (pro_ID)
UAST_Skill int 4 Link to sSkills table (ski_ID)
UAST_ReportingTeam int 4 Link to sReportingTeam table (rep_ID)
UAST_User int 4 Link to sUsers table (use_ID)
UAST_Client int 4 Link to sClients table (cli_ID)
UAST_Date datetime 8 Date event occurred
UAST_Hour int 4 Hour event started
UAST_Sub1 nvarchar 50 Reporting information from event
UAST_Sub2 nvarchar 50 Reporting information from event
UAST_Sub3 nvarchar 50 Reporting information from event
UAST_Sub4 nvarchar 50 Reporting information from event
UAST_Sub5 nvarchar 50 Reporting information from event
UAST_Sub6 nvarchar 50 Reporting information from event
UAST_State nvarchar 50 Activity state
UAST_SubState nvarchar 100 Activity Sub state
UAST_Time float 8 Time spent in state (in secs.)

This table stores CTI server logons.

Field Name Type Length Description
ul_UserID int    
ul_CTIID int    
ul_ComplexUsername nvarchar 50  
ul_ComplexPassword nvarchar 50  
ul_SimpleUsername nvarchar 50  
ul_SimplePassword nvarchar 50  
Field Name Type Length Description
uph_ID int    
uph_UserID int    
uph_Date datetime    
uph_Password nvarchar 100  
Field Name Type Length Description
use_ID int    
use_Logon nvarchar 100  
use_Password nvarchar 100  
use_MinAccessLevel int    
use_Active bit    
use_FirstName nvarchar 40  
use_Initial nvarchar 5  
use_Surname nvarchar 40  
use_Phone nvarchar 25  
use_Email nvarchar 255  
use_Mobile nvarchar 25  
use_PayrollCode nvarchar 10  
use_EPRID int    
use_Cost float    
use_StartDate datetime    
use_FinishedDate datetime    
use_Finished bit    
use_DefaultPRFID int    
use_Overtime bit    
use_Contracthrs float    
use_PositionID int    
use_LocationID int    
use_EmployerLevel int    
use_ImageId int    
use_SkillsGroupId int    
use_ReportingTeam int    
use_Address int    
use_LoginAttempts smallint    
use_Locked bit    
use_LockedDate datetime    
use_PasswordChangeDate datetime    
use_ForcePasswordChange bit    
use_LDAPDomain nvarchar 50  
use_LDAPUsername nvarchar 50  
use_Removed bit    
Field Name Type Length Description
ext_ExtNo nvarchar 20  
ext_StationName nvarchar 50  
ext_Active bit    
ext_ExitWindows bit    
Field Name Type Length Description
vb_ScriptID int    
vb_Version nvarchar 50  
vb_Title nvarchar 200  
vb_Description nvarchar 1000  
vb_Active bit    
vb_Script ntext    
Field Name Type Length Description
ss_Option nvarchar 100  
ss_Parameter nvarchar 255  
ss_Allowed bit    
ss_Type nchar 1  

Stored Procedures

Stored Procedure Description
inf40_AUDIT_Log  
inf40_MANAGER_UpdateProcessStatus  
inf40_REPORTING_InsertSystemStateSummary Used for generating an entry into sUserActivityState table
inf40_REPORTING_InsertSystemSummary Used for generating an entry into sUserActivityReporting table
inf40_USER_ChangePassword  
inf40_USER_Login  
inf40_USER_LoginLDAP  
Stored Procedure Report
inf40_REPORTING_AgentPerformanceSummary Agent Performance Summary.rdlc
inf40_REPORTING_AgentPerformanceSummarySplit1 Agent Performance Summary By Data Split 1.rdlc
inf40_REPORTING_AgentPerformanceSummarySplit2 Agent Performance Summary By Data Split 2.rdlc
inf40_REPORTING_AgentProductivity Agent productivity.rdlc
inf40_REPORTING_AgentSummaryAccumulative Agent Summary Accumulative.rdlc
inf40_REPORTING_HourSummary Hour Summary.rdlc
inf40_REPORTING_MonthSummary Month Summary.rdlc
inf40_REPORTING_Split1Conversion Split 1 Conversion.rdlc
inf40_REPORTING_Split2Conversion Split 2 Conversion.rdlc