Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 CHILDDISPLAYHTML nvarchar(max)   Default = '' Child Opportunity HTML
 PROJECTDISPLAYHTML nvarchar(max)   Default = '' Project Opportunity HTML
 ATTRIBUTEITEMSLIST xml Gift Attributes
 DESIGNATIONLIST xml Designations
 DEFAULTDESIGNATIONID uniqueidentifier Id for the default designation
 DEFAULTDESIGNATION int   Default = 0 Default Designation returned by CFA picker
 APPEALSLIST xml List of the appeals used for additional gifts
 REQUIREAPPEAL bit   Default = 0 Flag for requiring appeal during sponsorship
 SOLESPONSORSHIPENABLED bit   Default = 0 Flag for sole sponsorship
 GIFTSPONSORSHIPENABLED bit   Default = 0 Flag for gift sponsorships
 ECARDSENABLED bit   Default = 0 Ecards Enabled
 ADDITIONALGIFTENABLED bit   Default = 0 Flag for additional gifts
 MULTIPLEGIFTSENABLED bit   Default = 0 Flag for allowing multiple additional gifts in a sponsorship transaction
 MINIMUMGIFTAMOUNT decimal(20, 4)   Default = 0 Minimum value for additional gifts
 CONSTITUENCYID uniqueidentifier Constituency to apply to sponsorship transactions
 GENERALRECURRENCEENABLED bit   Default = 0 Flag for general recurrence schedule
 SCHEDULEDENDDATEENABLED bit   Default = 0 Flag for including recurrence end date
 RECURRENCEDATAIDLIST xml List of recurrence data ids
 ITEMEXPIRATION int   Default = 0 Sales order item expiration in minutes
 PAYMENTPARTPAGE int   Default = 0 Page Id hosting payment part control
 DIRECTDEBITENABLED bit   Default = 0 Flag for debit
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 CHECKENABLED bit   Default = 0 Flag for checks
 FORMITEMEXPIRATION int   Default = 0 Sponsorship form item expiration in minutes
 ACKNOWLEDGEMENTHTML nvarchar(max)   Default = '' HTML used for summary and acknowledgement email from payment part

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_SPONSORSHIPFORMCMSSETTINGS_DATEADDED DATEADDED    
 IX_SPONSORSHIPFORMCMSSETTINGS_DATECHANGED DATECHANGED      
 PK_SPONSORSHIPFORMCMSSETTINGS ID  

Trigger Name Description
 TR_SPONSORSHIPFORMCMSSETTINGS_AUDIT_DELETE
 TR_SPONSORSHIPFORMCMSSETTINGS_AUDIT_UPDATE