View: vcsi_iDonate_Tribute_Data
NoteIntroduced in Donate Now - Premium 2.10.2.
The vcsi_iDonate_Tribute_Data view is a combined view of Donate Now - Premium and iMIS tribute data.
TipThis view makes a great base for Donate Now - Premium reporting! Import this view as a RiSE business object and you can create Donate Now - Premium gift reports from the data available in this view.
Referenced tables
The following tables are referenced by this view:
- csi_iDonate_Tribute_Notification
- Name
- Activity
- Trans
- Trans_Notify
Tributes versus notifications
For Donate Now - Premium 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 Donate Now - Premium single tributes, only the Notify fields will be populated. (Donate Now - Premium does not support linking to a Tribute ID, only the freeform honoree name/text. Donate Now - Premium 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 Trans.BT_ID | Donor's iMIS ID. |
| TributeID | VARCHAR(10) | Yes | csi_iDonate_Tribute_Notification.TributeID Trans.MEM_TRIB_ID | 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 Donate Now - Premium 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 Name.FULL_NAME | 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 Name.EMAIL | 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 Donate Now - Premium multiple tributes. |
| NotifyEmail | NVARCHAR(255) | Yes | Name.EMAIL | For standard iMIS tributes only, the Notify record's email address. Blank for Donate Now - Premium 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 Trans.MEM_TRIB_NAME_TEXT | For Donate Now - Premium 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. |
Updated 25 days ago