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. |