Contents

Contacts

Table Name	Column Name	CX Insights Name	CX Insights Type	Data Type	Description	Folder
Contacts	Access	Access	attribute	int	User access to CIC features.	IC
Contacts	Assistant	Assistant	attribute	nvarchar	Assistant name of Contact table.	IC
Contacts	AssistantPhone	Assistant Phone	attribute	nvarchar	This displays assistant's phone from IndivConnection table	IC
Contacts	BusinessAddress	Business Address	attribute	nvarchar	Business address of Contacts table.	IC
Contacts	BusinessCity	Business City	attribute	nvarchar	Business city of Contacts table.	IC
Contacts	BusinessCountry	Business Country	attribute	nvarchar	Business country of Contacts table.	IC
Contacts	BusinessPhone	Business Phone First	attribute	nvarchar	Business phone of the location. This comes from LocConnection table.	IC
Contacts	BusinessPhone2	Business Phone Second	attribute	nvarchar	Location's second business phone from LocConnection table.	IC
Contacts	BusinessState	Business State	attribute	nvarchar	Business state of the location. This comes from LocAddress table.	IC
Contacts	BusinessZip	Business Zip	attribute	nvarchar	Business zip of business overriden.	IC
Contacts	Company	Company	attribute	nvarchar	This column stores the company name for an individual.	IC
Contacts	Department	Department	attribute	nvarchar	This column stores the department for an individual.	IC
Contacts	Fax	Fax	attribute	nvarchar	Fax of Contacts table.	IC
Contacts	FirstName	First Name	attribute	nvarchar	This column stores the first name for an individual.	IC
Contacts	HomeAddress	Home Address	attribute	nvarchar	Home address of Contacts table.	IC
Contacts	HomeCity	Home City	attribute	nvarchar	This displays home city address from IndivAddress table.	IC
Contacts	HomeCountry	Home Country	attribute	nvarchar	This displays home country address from IndivAddress table.	IC
Contacts	HomePhone	Home Phone First	attribute	nvarchar	This displays home phone from IndivConnection table.	IC
Contacts	HomePhone2	Home Phone Second	attribute	nvarchar	This displays second home phone from IndivConnection table.	IC
Contacts	HomeState	Home State	attribute	nvarchar	This displays home state address from IndivAddress table.	IC
Contacts	HomeZip	Home Zip	attribute	nvarchar	This displays home zip address from IndivAddress table.	IC
Contacts	ID	ID	attribute	nvarchar	ID of vcssSurveyUserAvgScores table.	IC
Contacts	LastName	Last Name	attribute	nvarchar	This column stores the last name for an individual.	IC
Contacts	Mobile	Mobile	attribute	nvarchar	Mobile of Contacts table.	IC
Contacts	Name	Name	attribute	nvarchar	The name of an address type. This will be shown wherever address types are displayed. The address types are configured in Interaction Administrator under the Interaction Tracker node.	IC
Contacts	Notes	Notes	attribute	nvarchar	Notes of IR_Event table.	IC
Contacts	Owner	Owner	attribute	nvarchar	Owner of Contacts table.	IC
Contacts	Pager	Pager	attribute	nvarchar	Pager of Contacts table.	IC
Contacts	PrimaryNumber	Primary Number	attribute	nvarchar	Primary number of contacts table.	IC
Contacts	Title	Title	attribute	nvarchar	This table stores the details of Titles. Titles can be created and edited in Interaction Administrator under the Interaction Tracker node.	IC
Contacts	URL	URL	attribute	nvarchar	UR of Contacts table.	IC