Table: csi_iDonate_Tribute_Notification

Purpose

This table stores all of the tribute notification entries when the Multiple Tributes feature is used.

Schema

Name	Column Type (SQL)	Notes
NotificationID	`INT (PK, IDENTITY)`	An identity column / primary key for this table. Uniquely identifies a single multiple tribute record.
DonorID	`VARCHAR(10)`	The iMIS ID of the donor for the gift that was made.
ActivitySeqn	`INT`	DEPRECATED CSiDonate no longer writes to this column. Any existing values are not touched. Any records inserted after the 2.11.1 patch will always have a constant value of "-1". In a future patch, this column will be deleted.
TributeID	`VARCHAR(10)`	The iMIS ID of the tribute. (If this value is provided, TributeName and TributeEmail may be empty.)
TributeName	`NVARCHAR(200)`	The name of the tribute. (If this value is provided, TributeID may be empty.)
TributeEmail	`NVARCHAR(510)`	The e-mail address entered for the tribute. (If this value is provided, TributeID may be empty.)
IsSearchResult	`BIT`	`True/1` if this tribute was found via the Tribute Member Search feature, otherwise `False/0`.
IsMatchResult	`BIT`	`True/1` if this tribute was matched by last name and e-mail to a record in iMIS, otherwise `False/0`.
TributeMessage	`NVARCHAR(500)`	The message that was entered by the donor, addressed to this tribute.
DateEntered	`DATETIME`	The date/time that this tribute was entered.
SelectedBannerFileName	`NVARCHAR(100)`	The banner image selected by the donor.
SelectedMergeCode	`NVARCHAR(200)`	The merge code selected by the donor.
InvoiceRef	`INT`	The Invoice Reference Num of the original gift, used to join in additional information about the gift via other tables. Or, use the vcsi_iDonate_Tribute_Data view for a combined tribute view containing iMIS single tributes and CSiDonate multiple tributes.