GivingHistory2

Primary Key

Primary Key Field Type
ID int

Fields

Field Field Type Null Notes Description
GiftTypes nvarchar(max)
Campaigns nvarchar(max)
Funds nvarchar(max)
Appeals nvarchar(max)
GiftQueryID int Default = 0
IncludeSoftCredit bit Default = 0
ResultsPerPage int
UseCustomFilter bit Default = 0
UseCustomColumn bit Default = 0
IncludePending bit Default = 1
IncludeSummary bit
IncludeGiftTotal bit
IncludeGiftAidTotal bit
IncludePendingTotal bit
IncludePledgeTotal bit
IncludeBalanceTotal bit
IncludeTotalsCurrency bit
PledgePaymentPageID int Default = 0
RecGiftEditAllowAmtUpdate bit Default = 0
RecGiftEditAllowFreqUpdates bit Default = 0
RecGiftEditAllowPmntTypeUpdate bit Default = 0
RecGiftEditMinUpdateAmt money Default = 0
RecGiftEditFilterFunds nvarchar(max) Default = '<?xml version="1.0" encoding="utf-8"?> <ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" />'
RecGiftEditFilterAppeals nvarchar(max) Default = '<?xml version="1.0" encoding="utf-8"?> <ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" />'
RecGiftEditFilterQueryID int Default = 0
RecGiftEditFilterUseCustomFilter bit Default = 0
RecGiftEditFreqUseGeneralRecurrence bit Default = 0
RecGiftEditFreqAllowEndDateUpdates bit Default = 0
RecGiftEditFreqSpecifics nvarchar(max) Default = '<?xml version="1.0" encoding="utf-8"?> <ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" />'
RecGiftEditFreqAllowStartDateUpdates bit Default = 0
RecGiftAdditionalDonationPageID int Default = 0
IncludeSoftCreditsTotal bit Default = 0
IncludeHardCreditsTotal bit Default = 0
RecurringGiftPaymentPageID int Default = 0
IncludeUnpaidEvents bit Default = 0
UnpaidEventsPaymentPageID int Default = 0
MerchantAccountID int Default = 0
CHECKOUTTHEMEUSESITEDEFAULT bit Default = 0
CHECKOUTTHEMEPRIMARYCOLOR nvarchar(100) yes Default = NULL
CHECKOUTTHEMESECONDARYCOLOR nvarchar(100) yes Default = NULL
CHECKOUTTHEMEFONTTYPE nvarchar(100) yes Default = NULL

Foreign Keys

Foreign Key Field Type Null Notes Description
SiteContentID int SiteContent.ID

Indexes

Index Name Fields Unique Primary Clustered
PK_GivingHistory2 ID yes yes yes