Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the parameter set.
 DESCRIPTION nvarchar(255)   Default = '' Details describing this parameter set
 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.
 SPONSORPREFERENCECODE tinyint   Default = 0 0=Clear conflicting preferences, 1=Overwrite specified preferences, 2=Overwrite all preferences
 SPONSORPREFERENCE nvarchar(31) (Computed) CASE [SPONSORPREFERENCECODE] WHEN 0 THEN N'Clear conflicting preferences' WHEN 1 THEN N'Overwrite specified preferences' WHEN 2 THEN N'Overwrite all preferences' END Provides a translation for the 'SPONSORPREFERENCECODE' field.
 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.
 MATCHINGRULECODE tinyint   Default = 0 0=Greatest need, 1=Nearest location, then greatest need
 MATCHINGRULE nvarchar(36) (Computed) CASE [MATCHINGRULECODE] WHEN 0 THEN N'Greatest need' WHEN 1 THEN N'Nearest location, then greatest need' END Provides a translation for the 'MATCHINGRULECODE' field.
 TRANSFERTYPECODE tinyint   Default = 0 0=Full transfer, 1=Pending transfer
 TRANSFERTYPE nvarchar(16) (Computed) CASE [TRANSFERTYPECODE] WHEN 0 THEN N'Full transfer' WHEN 1 THEN N'Pending transfer' END Provides a translation for the 'TRANSFERTYPECODE' field.
 CREATESOURCESPONSORSHIPSIDSET bit   Default = 0 Designates whether or not an ID set of source sponsorships should be created as a result of the transfer process.
 SOURCESELECTIONNAME nvarchar(100)   Default = '' The name of the output ID set of source sponsorships to be created by the transfer process.
 OVERWRITESOURCESELECTION bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.
 CREATETARGETSPONSORSHIPSIDSET bit   Default = 0 Designates whether or not an ID set of source sponsorships should be created as a result of the transfer process.
 TARGETSELECTIONNAME nvarchar(100)   Default = '' The name of the output ID set of source sponsorships to be created by the transfer process.
 OVERWRITETARGETSELECTION bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.
 CREATEUNSUCCESSFULSPONSORSHIPSIDSET bit   Default = 0 Designates whether or not an ID set of source sponsorships should be created as a result of the transfer process.
 UNSUCCESSFULSELECTIONNAME nvarchar(100)   Default = '' The name of the output ID set of source sponsorships to be created by the transfer process.
 OVERWRITEUNSUCCESSFULSELECTION bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.

Foreign Key Field Type Null Notes Description
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID Selection of sponsorships to be transfered.
 SPONSORSHIPPROGRAMID uniqueidentifier SPONSORSHIPPROGRAM.ID FK to SPONSORSHIPPROGRAM
 SPONSORSHIPLOCATIONID uniqueidentifier SPONSORSHIPLOCATION.ID The location preference for this sponsorship.
 SPROPPAGERANGEID uniqueidentifier SPONSORSHIPOPPORTUNITYAGERANGE.ID Points to a custom Sponsorship Opportunity Age Range definition in the SPONSORSHIPOPPORTUNITYAGERANGE table, for child records only.
 SPROPPPROJECTCATEGORYCODEID uniqueidentifier SPROPPPROJECTCATEGORYCODE.ID FK to SPROPPPROJECTCATEGORYCODE
 SPONSORSHIPREASONID uniqueidentifier   SPONSORSHIPREASON.ID The reason for transfering the sponsorships.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_SPONSORSHIPTRANSFERPROCESS_DATEADDED DATEADDED    
 IX_SPONSORSHIPTRANSFERPROCESS_DATECHANGED DATECHANGED      
 IX_SPONSORSHIPTRANSFERPROCESS_IDSETREGISTERID IDSETREGISTERID      
 IX_SPONSORSHIPTRANSFERPROCESS_SPONSORSHIPLOCATIONID SPONSORSHIPLOCATIONID      
 IX_SPONSORSHIPTRANSFERPROCESS_SPONSORSHIPPROGRAMID SPONSORSHIPPROGRAMID      
 IX_SPONSORSHIPTRANSFERPROCESS_SPONSORSHIPREASONID SPONSORSHIPREASONID      
 IX_SPONSORSHIPTRANSFERPROCESS_SPROPPAGERANGEID SPROPPAGERANGEID      
 IX_SPONSORSHIPTRANSFERPROCESS_SPROPPPROJECTCATEGORYCODEID SPROPPPROJECTCATEGORYCODEID      
 PK_SPONSORSHIPTRANSFERPROCESS ID  
 UC_SPONSORSHIPTRANSFERPROCESS_NAME NAME    

Trigger Name Description
 TR_SPONSORSHIPTRANSFERPROCESS_AUDIT_UPDATE
 TR_SPONSORSHIPTRANSFERPROCESS_AUDIT_DELETE

Referenced by Field
 SPONSORSHIPTRANSFERPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table