View: vcsi_iDonate_Gift_Metadata_Combined
Purpose
The vcsi_iDonate_Gift_Metadata_Combined view is an aggregate view of CSiDonate gift metadata and iMIS fundraising 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_Gift_MetadataActivityTransTrans_SoftCredit
Schema
| Column Name | Column Type (SQL) | Originating Table/Column | Notes |
|---|---|---|---|
| ID | VARCHAR(10) | csi_iDonate_Gift_Metadata.ID | Donor's iMIS ID. |
| ActivitySeqn | INT | Trans.ACTIVITY_SEQN | Activity SEQN number of the gift. |
| InvoiceRef | INT | csi_iDonate_Gift_Metadata.InvoiceRef | Invoice Reference # of the gift. |
| AmbassadorId | VARCHAR(10) | csi_iDonate_Gift_Metadata.AmbassadorId | If not NULL, the iMIS ID of the ambassador this gift should be credited towards. |
| ChallengeTemplate | VARCHAR(10) | csi_iDonate_Gift_Metadata.ChallengeTemplate | If not NULL, the UID of the template that this gift should be credited towards. |
| TransactionFeeAmount | MONEY | csi_iDonate_Gift_Metadata.TransactionFeeAmount | If not 0, the amount of this gift that went to covering transaction fees. |
| TransactionBaseAmount | MONEY | csi_iDonate_Gift_Metadata.TransactionBaseAmount | If not 0, the original amount of this gift before covering transaction fees. |
| GiftMessage | NVARCHAR(MAX) | csi_iDonate_Gift_Metadata.GiftMessage | If not NULL, the gift message text that the donor entered. |
| SelectedChapter | NVARCHAR(400) | csi_iDonate_Gift_Metadata.SelectedChapter | If not NULL, the name of the chapter that was selected for this anonymous donor via the Chapter dropdown. |
| RebillingId | NVARCHAR(40) | csi_iDonate_Gift_Metadata.RebillingId | If not NULL, the BluePay Rebilling ID for this gift. |
| ListAs | NVARCHAR(510) | csi_iDonate_Gift_Metadata.ListAs | If not NULL, the donor's desired List As text, or "Anonymous" if the donor chose the anonymous donation option. |
| DonorWallEnabled | BIT | csi_iDonate_Gift_Metadata.DonorWallEnabled | True/1 if this donation should appear on the Donor Wall, otherwise False/0. |
| GiftAmount | MONEY | Activity.AMOUNT | The total recorded amount of the gift. |
| GiftDate | DATETIME | Trans.DATE_ENTERED | The date that the gift was entered into iMIS. |
| Batch | VARCHAR(15) | Trans.BATCH_NUM | The batch number for this gift. |
| Distribution | VARCHAR(31) | Activity.PRODUCT_CODE | The distribution code for this gift. |
| Fund | VARCHAR(5) | Activity.ORG_CODE | The fund code for this gift. |
| CampaignCode | VARCHAR(10) | Activity.CAMPAIGN_CODE | If not NULL, the campaign code for this gift. |
| AppealCode | VARCHAR(40) | Activity.SOURCE_CODE | If not NULL, the appeal code for this gift. |
| CashAccount | VARCHAR(10) | Trans.CHECK_NUMBER | The iMIS cash account code used for this gift. |
| CreditCardMasked | VARCHAR(25) | Trans.CC_NUMBER | The masked credit card or ACH account used for this gift. |
| CreditCardName | VARCHAR(40) | Trans.CC_NAME | The "Name on Card" value for this gift. |
| PaymentType | VARCHAR(10) | Trans.PAYMENT_TYPE | The payment type for this gift (CC for credit card transactions, ACH for ACH transactions). |
| SoftCreditId | VARCHAR(10) | Trans_SoftCredit.SOFT_CREDIT_ID | If not NULL, the iMIS ID of the user who received 100% soft credit for this gift. |
| TransNumber | INT | csi_iDonate_Gift_Metadata.TransNumber | The transaction number for the gift. |