View: vcsi_iDonate_Tribute_Data
Introduced in CSiDonate 2.10.2.
Purpose
The vcsi_iDonate_Tribute_Data view is a combined view of CSiDonate and iMIS tribute data.
Reporting Tip
This view makes a great base for CSiDonate reporting! Import this view as a RiSE business object and you can create CSiDonate gift reports from the data available in this view.
Referenced Tables
The following tables are referenced by this view:
csi_iDonate_Tribute_NotificationNameActivityTransTrans_Notify
Tributes versus Notifications
For CSiDonate multiple tributes, only the Tribute fields will be populated. (However, for consistency with iMIS, since we are notifying these tributes via email, we write to Trans_Notify for these gifts if there are matching contacts in iMIS.)
For CSiDonate single tributes, only the Notify fields will be populated. (CSiDonate does not support linking to a Tribute ID, only the freeform honoree name/text. CSiDonate will create and/or link to a Notification ID if a notification contact was entered, however.)
For standard iMIS tributes, the Tribute and/or Notify fields will be populated, depending on the type of tribute entered into iMIS and whether or not there is a Trans_Notify record for that gift.
Schema
In keeping with iMIS best practice, all values that would otherwise be NULL are replaced with empty string ('').
| Column Name | Column Type | Can Be Empty? | Originating Tables/Columns | Notes |
|---|---|---|---|---|
| ID | VARCHAR(10) |  No | csi_iDonate_Tribute_Notification.DonorID | Donor's iMIS ID. |
| TributeID | VARCHAR(10) |  Yes |
| Tribute record's iMIS ID. |
| NotifyID | VARCHAR(10) | Yes | Trans_Notify.NOTIFY_ID | For standard iMIS tributes only, the Notify record's iMIS ID. Blank for CSiDonate multiple tributes. |
| TransNumber | INT | No | Trans.TRANS_NUMBER | Transaction number of the gift. |
| ActivitySeqn | INT | No | Trans.ACTIVITY_SEQN | Activity SEQN number of the gift. |
| InvoiceRef | INT | No | Trans.INVOICE_REFERENCE_NUM | Invoice Reference # of the gift. |
| TransactionDate | DATETIME | No | Trans.TRANSACTION_DATE | Date of the transaction. |
| EnteredDate | DATETIME | No | Trans.DATE_ENTERED | Date the gift was created / entered into the system. |
TributeName | NVARCHAR(100) | Yes | csi_iDonate_Tribute_Notification.TributeName | Tribute's full name. Either the iMIS full name, or the name the donor entered onto the donation form. |
| TributeEmail | NVARCHAR(255) | Yes | csi_iDonate_Tribute_Notification.TributeEmail | Tribute's email address. Either the iMIS email address, or the e-mail address the donor entered onto the donation form. |
NotifyName | NVARCHAR(100) | Yes | Name.FULL_NAME | For standard iMIS tributes only, the Notify record's full name. Blank for CSiDonate multiple tributes. |
| NotifyEmail | NVARCHAR(255) | Yes | Name.EMAIL | For standard iMIS tributes only, the Notify record's email address. Blank for CSiDonate multiple tributes. |
| TributeOriginalEmail | VARCHAR(100) | Yes | Name.EMAIL | In the case where a tribute is matched or selected from the search and has a known iMIS ID, but the donor overrides/changes the e-mail address of the tribute, this field will contain the tribute contact's original e-mail address from iMIS. |
| TributeMessage | NVARCHAR(250) | Yes | csi_iDonate_Tribute_Notification.TributeMessage | For CSiDonate multiple tributes, contains the donor's message to this tribute. For standard iMIS tributes, contains the Memorial/Tribute honoree text. |
| TributeMergeCode | VARCHAR(40) | Yes | Trans.MERGE_CODE | For multiple tributes, contains the donor's selected merge code, only if user-selectable merge codes are enabled. For standard iMIS tributes, contains the merge code. |
| TributeType | VARCHAR(1) | No | N/A | For multiple tributes, this field will be "M". For standard iMIS tributes, this field will be "S". |
| IsDatabaseMatch | BIT | No | csi_iDonate_Tribute_Notification.IsMatchResult | For multiple tributes only. True/1 if this tribute was successfully matched to a contact in iMIS using a last name and e-mail search. |
| IsMemberSearchResult | BIT | No | csi_iDonate_Tribute_Notification.IsSearchResult | For multiple tributes only. True/1 if this tribute was explicitly selected via the Tribute Member Search feature. |