Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 PROJECTCLOSETRANSFERRULE bit   Default = 0 Indicates if a transferred sponsorships will be full or pending when a location closes.
 INELIGIBLETRANSFERRULE bit   Default = 0 Indicates if a transferred sponsorships will be full or pending when a child is marked ineligible.
 LOCATIONCLOSEMATCHINGCODE tinyint   Default = 0 Indicates which rule to use when finding a child to transfer to when a location is closed.
 LOCATIONCLOSEMATCHING nvarchar(74) (Computed) CASE [LOCATIONCLOSEMATCHINGCODE] WHEN 0 THEN N'Standard (sponsorship preference, greatest need)' WHEN 1 THEN N'Nearest location (sponsorship preference, nearest location, greatest need)' END Provides a translation for the 'LOCATIONCLOSEMATCHINGCODE' field.
 INELIGIBLEMATCHINGCODE tinyint   Default = 1 Indicates which rule to use when finding a child to transfer to when a child is marked ineligible
 INELIGIBLEMATCHING nvarchar(74) (Computed) CASE [INELIGIBLEMATCHINGCODE] WHEN 0 THEN N'Standard (sponsorship preference, greatest need)' WHEN 1 THEN N'Nearest location (sponsorship preference, nearest location, greatest need)' END Provides a translation for the 'INELIGIBLEMATCHINGCODE' field.
 PROJECTCLOSEMATCHINGCODE tinyint   Default = 1 Indicates which rule to use when finding a project to transfer to when a project is closed.
 PROJECTCLOSEMATCHING nvarchar(74) (Computed) CASE [PROJECTCLOSEMATCHINGCODE] WHEN 0 THEN N'Standard (sponsorship preference, greatest need)' WHEN 1 THEN N'Nearest location (sponsorship preference, nearest location, greatest need)' END Provides a translation for the 'PROJECTCLOSEMATCHINGCODE' field.
 DEFAULTCHILDELIGIBILITYCODE tinyint   Default = 0 Indicates the default eligibility when creating a new child.
 DEFAULTCHILDELIGIBILITY nvarchar(8) (Computed) CASE [DEFAULTCHILDELIGIBILITYCODE] WHEN 0 THEN N'Eligible' WHEN 1 THEN N'Pending' END Provides a translation for the 'DEFAULTCHILDELIGIBILITYCODE' field.
 DEFAULTPROJECTSTATUSCODE tinyint   Default = 0 Indicates the default status when creating a new project
 DEFAULTPROJECTSTATUS nvarchar(7) (Computed) CASE [DEFAULTPROJECTSTATUSCODE] WHEN 0 THEN N'Open' WHEN 1 THEN N'Pending' END Provides a translation for the 'DEFAULTPROJECTSTATUSCODE' field.
 CHILDPENDINGREASONS xml Indicates the default reasons the child eligibility is pending.
 PROJECTPENDINGREASONS xml Indicates the default reasons the project status is pending.
 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.
 ADDSPONSORSHIPCUSTOMPROCEDURE nvarchar(500)   Default = ''

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

Index Name Field(s) Unique Primary Clustered
 IX_SPONSORSHIPINFO_AFFILIATERELATIONSHIPTYPECODEID AFFILIATERELATIONSHIPTYPECODEID      
 IX_SPONSORSHIPINFO_AFFILIATESPONSORRELATIONSHIPTYPECODEID AFFILIATESPONSORRELATIONSHIPTYPECODEID      
 IX_SPONSORSHIPINFO_DATEADDED DATEADDED    
 IX_SPONSORSHIPINFO_DATECHANGED DATECHANGED      
 PK_SPONSORSHIPINFO ID  

Trigger Name Description
 TR_SPONSORSHIPINFO_AUDIT_UPDATE
 TR_SPONSORSHIPINFO_AUDIT_DELETE

Entity-Relationship diagram of this table