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
 FORCESTARTDATE bit   Default = 0
 PDACCOUNTSYSTEMID uniqueidentifier

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_UPDATE
 TR_SPONSORSHIPFORMCMSSETTINGS_AUDIT_DELETE