V_QUERY_RE7_GIFT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| GIFTSPLITID | int | ||
| GIFTID | int | ||
| APPEALSYSTEMID | int | yes | |
| NAME | nvarchar(100) | yes | |
| DESCRIPTION | nvarchar(255) | yes | |
| AMOUNT | money | ||
| SPLITAMOUNT | money | ||
| CONSTITUENT_SYSTEMID | int | ||
| DATE | datetime | ||
| SOURCECODE | nvarchar(255) | yes | |
| MAILINGID | int | yes | |
| FINDERNUMBER | bigint | yes | |
| FUND_LOCALID | int | yes | |
| REVENUETYPE | nvarchar(30) | yes | |
| REVENUESUBTYPE | nvarchar(100) | yes | |
| ISANONYMOUS | bit | ||
| DATE_DATEID | int | ||
| POSTDATE_DATEID | int | yes | |
| GIFT_LOCALID | int | ||
| DATEADDED | datetime | yes | |
| DONOTACKNOWLEDGE | bit | yes | |
| ACKNOWLEDGE | varchar(18) | ||
| DONOTRECEIPT | bit | yes | |
| RECEIPT | varchar(14) | ||
| CONSTITUENCY | nvarchar(100) | yes | |
| LETTER | nvarchar(100) | yes | |
| GIFTCODE | nvarchar(100) | yes | |
| ACKNOWLEDGEDATE | UDT_FUZZYDATE | ||
| RECEIPTDATE | UDT_FUZZYDATE | ||
| RECEIPTAMOUNT | money | yes | |
| RECEIPTNUMBER | nvarchar(255) | yes | |
| DATELASTCHANGED | datetime | yes | |
| PACKAGE_LOCALID | int | yes | |
| CAMPAIGN_LOCALID | int | yes | |
| PAYMENTTYPE | nvarchar(16) | yes | |
| CONSTITUENTBANK_LOCALID | int | yes | |
| STATUS | varchar(10) | yes | |
| STATUSDATE | UDT_FUZZYDATE | ||
| POSTSTATUS | varchar(11) | yes | |
| ONLINEGIFT | bit | ||
| ISRECEIVED | bit | ||
| TYPECODE_LOCALID | tinyint | ||
| REFERENCE | nvarchar(255) | yes | |
| IMPORTID | nvarchar(20) | yes | |
| REFERENCE_NUMBER | nvarchar(20) | yes | |
| REFERENCE_DATE | UDT_FUZZYDATE | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/6/2025 8:50:22 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RE7_GIFT AS
select
[RS].[LOCALID] as [GIFTSPLITID],
[R].[LOCALID] as [GIFTID],
[A].[LOCALID] as [APPEALSYSTEMID],
[A].[NAME],
[A].[DESCRIPTION],
[R].[AMOUNT],
[RS].[AMOUNT] as [SPLITAMOUNT],
[R].[CONSTITUENT_LOCALID] [CONSTITUENT_SYSTEMID],
[R].[DATE],
[R].[SOURCECODE],
[R].[MKTSEGMENTATION_IDINTEGER] as [MAILINGID],
[R].[FINDERNUMBER],
[RS].[FUND_LOCALID],
[RTC].[DESCRIPTION] as [REVENUETYPE],
[PST].[NAME] as [REVENUESUBTYPE],
[R].[GIVENANONYMOUSLY] [ISANONYMOUS],
[R].[DATE_DATEID],
[R].[POSTDATE_DATEID],
[R].[LOCALID] [GIFT_LOCALID],
[R].[DATEADDED],
cast((case [R].[ACKNOWLEDGE_FLAG] when 2 then 0 else 1 end) as bit) [DONOTACKNOWLEDGE],
case [R].[ACKNOWLEDGE_FLAG] when 1 then 'Acknowledged' when 2 then 'Not Acknowledged' when 3 then 'Do Not Acknowledge' else '' end [ACKNOWLEDGE],
cast((case [R].[RECEIPT_FLAG] when 2 then 0 else 1 end) as bit) [DONOTRECEIPT],
case [R].[RECEIPT_FLAG] when 1 then 'Receipted' when 2 then 'Not Receipted' when 3 then 'Do Not Receipt' else '' end [RECEIPT],
[CC].[DESCRIPTION] as [CONSTITUENCY],
[LC].[DESCRIPTION] as [LETTER],
[GC].[DESCRIPTION] as [GIFTCODE],
[R].[ACKNOWLEDGEDATE],
[R].[RECEIPTDATE],
[R].[RECEIPTAMOUNT],
[R].[RECEIPTNUMBER],
[R].[DATELASTCHANGED],
[RS].[PACKAGE_LOCALID],
[RS].[CAMPAIGN_LOCALID],
[PTC].[DESCRIPTION] [PAYMENTTYPE],
[R].[CONSTITUENTBANK_LOCALID],
case [R].[STATUS_LOCALID] when 1 then 'Active' when 2 then 'Held' when 3 then 'Terminated' when 4 then 'Completed' when 5 then 'Cancelled' end [STATUS],
[R].[STATUSDATE],
case [R].[POSTSTATUSCODE_LOCALID] when 1 then 'Posted' when 2 then 'Not posted' when 3 then 'Do not post' end [POSTSTATUS],
[R].[ONLINEGIFT],
[R].[ISRECEIVED],
[R].[TYPECODE_LOCALID],
[R].[REFERENCE],
[R].[IMPORTID],
[R].[REFERENCE_NUMBER],
[R].[REFERENCE_DATE]
from
dbo.[RE7_REVENUE] [R]
inner join dbo.[RE7_REVENUESPLIT] [RS] on [R].[LOCALID] = [RS].[REVENUE_LOCALID]
left outer join dbo.[RE7_APPEAL] [A] on [RS].[APPEAL_LOCALID] = [A].[LOCALID]
left outer join dbo.[RE7_REVENUETYPECODE] [RTC] on [R].[TYPECODE_LOCALID] = [RTC].[LOCALID]
left outer join dbo.[RE7_PLEDGESUBTYPE] [PST] on [R].[SUBTYPECODE_LOCALID] = [PST].[LOCALID]
left outer join dbo.[RE7_CONSTITUENCYCODE] [CC] on [R].[CONSTITUENTCODE_LOCALID] = [CC].[LOCALID]
left outer join dbo.[RE7_LETTERCODE] [LC] on [R].[LETTERCODE_LOCALID] = [LC].[LOCALID]
left outer join dbo.[RE7_GIFTCODE] [GC] on [R].[GIFTCODE_LOCALID] = [GC].[LOCALID]
left outer join dbo.[RE7_PAYMENTTYPECODE] [PTC] on [R].[PAYMENTTYPECODE_LOCALID] = [PTC].[LOCALID];