INTERACTION

Contains data about prospect interactions.

For the full definition of the INTERACTION table, see INTERACTION.

Fields

Field	Change	Field Type	Null	Notes	Description
STATUS	Changed	nvarchar(12) (Computed)	yes	CASE [STATUSCODE] WHEN 0 THEN N'Planned' WHEN 1 THEN N'Pending' WHEN 2 THEN N'Completed' WHEN 3 THEN N'Unsuccessful' WHEN 4 THEN N'Cancelled' WHEN 5 THEN N'Declined' END	Expression changed from CASE [STATUSCODE] WHEN 0 THEN N'Planned' WHEN 1 THEN N'Pending' WHEN 2 THEN N'Completed' WHEN 3 THEN N'Unsuccessful' WHEN 4 THEN N'Canceled' WHEN 5 THEN N'Declined' END to CASE [STATUSCODE] WHEN 0 THEN N'Planned' WHEN 1 THEN N'Pending' WHEN 2 THEN N'Completed' WHEN 3 THEN N'Unsuccessful' WHEN 4 THEN N'Cancelled' WHEN 5 THEN N'Declined' END