Primary Key Field Type
 ID int

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

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

Index Name Field(s) Unique Primary Clustered
 PK_GivingHistory2 ID

Entity-Relationship diagram of this table