Table: csi_iDonate_Tribute_Notification
Purpose
This table stores all of the tribute notification entries when the Multiple Tributes feature is used.
Schema
| Column 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 Donate Now - Premium 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 Donate Now - Premium multiple tributes. |
Updated 25 days ago
Did this page help you?