Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 FILTERPROGRAM bit   Default = 0 Flag for if status part filters by program for display
 SELECTEDPROGRAMS xml Programs which allow children to be displayed in the CMS
 NOTESAVAILABLILITYCODE tinyint   Default = 0 Flag for filtering of the notes
 NOTESAVAILABLILITY nvarchar(8) (Computed) CASE [NOTESAVAILABLILITYCODE] WHEN 0 THEN N'All' WHEN 1 THEN N'Filtered' WHEN 2 THEN N'None' END Provides a translation for the 'NOTESAVAILABLILITYCODE' field.
 NOTESCODESLIST xml IDs of note types to be displayed on the status part
 ATTACHMENTSAVAILABILITYCODE tinyint   Default = 0 Flag for filtering of attachments
 ATTACHMENTSAVAILABILITY nvarchar(8) (Computed) CASE [ATTACHMENTSAVAILABILITYCODE] WHEN 0 THEN N'All' WHEN 1 THEN N'Filtered' WHEN 2 THEN N'None' END Provides a translation for the 'ATTACHMENTSAVAILABILITYCODE' field.
 ATTACHMENTCODESLIST xml Ids of attachment types to be displayed on the status part
 MEDIALINKSAVAILABILITYCODE tinyint   Default = 0 Flag for filtering of media links
 MEDIALINKSAVAILABILITY nvarchar(8) (Computed) CASE [MEDIALINKSAVAILABILITYCODE] WHEN 0 THEN N'All' WHEN 1 THEN N'Filtered' WHEN 2 THEN N'None' END Provides a translation for the 'MEDIALINKSAVAILABILITYCODE' field.
 MEDIALINKCODESLIST xml Ids of media link types to be displayed on the status part
 EMAILENABLED bit   Default = 0 Flag for if emailing opportunities is allowed form this part
 EMAILCATEGORYID uniqueidentifier Email category Id
 EMAILSUBCATEGORYID uniqueidentifier Email subcategory Id
 DEFAULTEMAILCATEGORYID uniqueidentifier Default email category Id
 DEFAULTEMAILSUBCATEGORYID uniqueidentifier Default email subcategory Id
 DEFAULTEMAILADDRESS UDT_EMAILADDRESS   Default = '' Default email address for emails sent from a sponsor
 EMAILTYPECODE uniqueidentifier Typecode for sponsor emails
 EMAILFIELDLIMIT int   Default = 0 Character limit for sponsor emails
 EMAILTEMPLATESLIST xml Email template Ids specifying which templates will appear on the status part
 EMAILPROGRAMLIST xml List of Ids of programs which allow email
 OUTPUTFIELDLIST xml List of the integer mergefield Ids in the html content
 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.
 CHILDHTMLCONTENT nvarchar(max)   Default = '' HTML Content for displaying child sponsorship information on the status page
 PROJECTHTMLCONTENT nvarchar(max)   Default = '' HTML content for displaying project sponsorship information on the status page
 PAYMENTPARTPAGE int   Default = 0

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_SPONSORSHIPSTATUSCMSSETTINGS_DATEADDED DATEADDED    
 IX_SPONSORSHIPSTATUSCMSSETTINGS_DATECHANGED DATECHANGED      
 PK_SPONSORSHIPSTATUSCMSSETTINGS ID  

Trigger Name Description
 TR_SPONSORSHIPSTATUSCMSSETTINGS_AUDIT_UPDATE
 TR_SPONSORSHIPSTATUSCMSSETTINGS_AUDIT_DELETE