Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 STARTDATE date  
 GENDERCODE tinyint   Default = 0 0=Greatest need, 1=Male, 2=Female
 GENDER nvarchar(13) (Computed) CASE [GENDERCODE] WHEN 0 THEN N'Greatest need' WHEN 1 THEN N'Male' WHEN 2 THEN N'Female' END Provides a translation for the 'GENDERCODE' field.
 ISHIVPOSITIVECODE tinyint   Default = 0 0=Greatest need, 1=Yes, 2=No
 ISHIVPOSITIVE nvarchar(13) (Computed) CASE [ISHIVPOSITIVECODE] WHEN 0 THEN N'Greatest need' WHEN 1 THEN N'Yes' WHEN 2 THEN N'No' END Provides a translation for the 'ISHIVPOSITIVECODE' field.
 HASCONDITIONCODE tinyint   Default = 0 0=Greatest need, 1=Yes, 2=No
 HASCONDITION nvarchar(13) (Computed) CASE [HASCONDITIONCODE] WHEN 0 THEN N'Greatest need' WHEN 1 THEN N'Yes' WHEN 2 THEN N'No' END Provides a translation for the 'HASCONDITIONCODE' field.
 ISORPHANEDCODE tinyint   Default = 0 0=Greatest need, 1=Yes, 2=No
 ISORPHANED nvarchar(13) (Computed) CASE [ISORPHANEDCODE] WHEN 0 THEN N'Greatest need' WHEN 1 THEN N'Yes' WHEN 2 THEN N'No' END Provides a translation for the 'ISORPHANEDCODE' field.
 ISSOLESPONSORSHIP bit   Default = 0
 EXPIRATIONDATE date
 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.
 MASKIMAGEID int   Default = 0

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   SALESORDERITEM.ID Primary Key.
 SPONSORSHIPID uniqueidentifier SPONSORSHIP.ID The sponsorship created for this sales order.
 SPONSORSHIPPROGRAMID uniqueidentifier   SPONSORSHIPPROGRAM.ID FK to SPONSORSHIPPROGRAM
 SPONSORSHIPOPPORTUNITYID uniqueidentifier   SPONSORSHIPOPPORTUNITY.ID FK to SPONSORSHIPOPPORTUNITY
 GIFTRECIPIENTID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 SPONSORSHIPLOCATIONID uniqueidentifier SPONSORSHIPLOCATION.ID FK to SPONSORSHIPLOCATION
 SPONSORSHIPOPPORTUNITYAGERANGEID uniqueidentifier SPONSORSHIPOPPORTUNITYAGERANGE.ID FK to SPONSORSHIPOPPORTUNITYAGERANGE
 SPROPPPROJECTCATEGORYCODEID uniqueidentifier SPROPPPROJECTCATEGORYCODE.ID FK to SPROPPPROJECTCATEGORYCODE
 EXPIRATIONREASONID uniqueidentifier SPONSORSHIPREASON.ID FK to SPONSORSHIPREASON
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 PDACCOUNTSYSTEMID uniqueidentifier PDACCOUNTSYSTEM.ID

Index Name Field(s) Unique Primary Clustered
 IX_SALESORDERITEMSPONSORSHIP_DATEADDED DATEADDED    
 IX_SALESORDERITEMSPONSORSHIP_DATECHANGED DATECHANGED      
 IX_SALESORDERITEMSPONSORSHIP_EXPIRATIONREASONID EXPIRATIONREASONID      
 IX_SALESORDERITEMSPONSORSHIP_GIFTRECIPIENTID GIFTRECIPIENTID      
 IX_SALESORDERITEMSPONSORSHIP_SPONSORSHIPID SPONSORSHIPID      
 IX_SALESORDERITEMSPONSORSHIP_SPONSORSHIPLOCATIONID SPONSORSHIPLOCATIONID      
 IX_SALESORDERITEMSPONSORSHIP_SPONSORSHIPOPPORTUNITYAGERANGEID SPONSORSHIPOPPORTUNITYAGERANGEID      
 IX_SALESORDERITEMSPONSORSHIP_SPONSORSHIPOPPORTUNITYID SPONSORSHIPOPPORTUNITYID      
 IX_SALESORDERITEMSPONSORSHIP_SPONSORSHIPPROGRAMID SPONSORSHIPPROGRAMID      
 IX_SALESORDERITEMSPONSORSHIP_SPROPPPROJECTCATEGORYCODEID SPROPPPROJECTCATEGORYCODEID      
 PK_SALESORDERITEMSPONSORSHIP ID  

Trigger Name Description
 TR_SALESORDERITEMSPONSORSHIP_AUDIT_UPDATE
 TR_SALESORDERITEMSPONSORSHIP_AUDIT_DELETE

Entity-Relationship diagram of this table