Table that holds the relationship between a sponsor and a sponsorship opportunity
Foreign Key Fields
| Foreign Key |
Field Type |
Null |
Notes |
Description |
|
SPONSORSHIPCOMMITMENTID
|
uniqueidentifier
|
false
|
|
The commitment of which this sponsorship is a part.
|
|
CONSTITUENTID
|
uniqueidentifier
|
false
|
|
FK to CONSTITUENT
|
|
SPONSORSHIPPROGRAMID
|
uniqueidentifier
|
false
|
|
FK to SPONSORSHIPPROGRAM
|
|
SPONSORSHIPOPPORTUNITYID
|
uniqueidentifier
|
false
|
|
FK to SPONSORSHIPOPPORTUNITY
|
|
REVENUESPLITID
|
uniqueidentifier
|
true
|
|
The recurring gift split against which payments will be applied for this sponsorship.
|
|
SPONSORSHIPLOCATIONID
|
uniqueidentifier
|
true
|
|
The location preference for this sponsorship.
|
|
SPONSORSHIPOPPORTUNITYAGERANGEID
|
uniqueidentifier
|
true
|
|
Points to a custom Sponsorship Opportunity Age Range definition in the SPONSORSHIPOPPORTUNITYAGERANGE table, for child records only.
|
|
SPROPPPROJECTCATEGORYCODEID
|
uniqueidentifier
|
true
|
|
FK to SPROPPPROJECTCATEGORYCODE
|
|
ADDEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
CHANGEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
EXPIRATIONREASONID
|
uniqueidentifier
|
true
|
|
FK to SPONSORSHIPREASON
|
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
STATUSCODE
|
tinyint
|
false
|
|
Status of this sponsorship.
|
|
STATUS
|
nvarchar(8) (Computed)
|
true
|
|
Provides a translation for the 'STATUSCODE' field.
|
|
STARTDATE
|
date
|
true
|
|
|
|
ENDDATE
|
date
|
true
|
|
|
|
PLANNEDENDDATE
|
date
|
true
|
|
|
|
CHILDGENDERCODE
|
tinyint
|
false
|
|
0=Greatest need, 1=Male, 2=Female
|
|
CHILDGENDER
|
nvarchar(13) (Computed)
|
true
|
|
Provides a translation for the 'CHILDGENDERCODE' field.
|
|
ISHIVPOSITIVECODE
|
tinyint
|
false
|
|
0=Greatest need, 1=Yes, 2=No
|
|
ISHIVPOSITIVE
|
nvarchar(13) (Computed)
|
true
|
|
Provides a translation for the 'ISHIVPOSITIVECODE' field.
|
|
HASCONDITIONCODE
|
tinyint
|
false
|
|
0=Greatest need, 1=Yes, 2=No
|
|
HASCONDITION
|
nvarchar(13) (Computed)
|
true
|
|
Provides a translation for the 'HASCONDITIONCODE' field.
|
|
ISORPHANEDCODE
|
tinyint
|
false
|
|
0=Greatest need, 1=Yes, 2=No
|
|
ISORPHANED
|
nvarchar(13) (Computed)
|
true
|
|
Provides a translation for the 'ISORPHANEDCODE' field.
|
|
ISSOLESPONSORSHIP
|
bit
|
false
|
|
Indicates that this sponsorship is the sole sponsorship for a child.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
ISMOSTRECENTFORCOMMITMENT
|
bit
|
false
|
|
Indicates the active or last sponsorship for a commitment.
|
Indexes
| Index Name |
Field(s) |
Unique |
Primary |
Clustered |
|
IX_SPONSORSHIP_CONSTITUENTID
|
|
False
|
False
|
False
|
|
IX_SPONSORSHIP_DATEADDED
|
|
False
|
False
|
True
|
|
IX_SPONSORSHIP_DATECHANGED
|
|
False
|
False
|
False
|
|
IX_SPONSORSHIP_EXPIRATIONREASONID
|
|
False
|
False
|
False
|
|
IX_SPONSORSHIP_REVENUESPLITID
|
|
False
|
False
|
False
|
|
IX_SPONSORSHIP_SPONSORSHIPCOMMITMENTID
|
|
False
|
False
|
False
|
|
IX_SPONSORSHIP_SPONSORSHIPLOCATIONID
|
|
False
|
False
|
False
|
|
IX_SPONSORSHIP_SPONSORSHIPOPPORTUNITYAGERANGEID
|
SPONSORSHIPOPPORTUNITYAGERANGEID
|
False
|
False
|
False
|
|
IX_SPONSORSHIP_SPONSORSHIPOPPORTUNITYID
|
|
False
|
False
|
False
|
|
IX_SPONSORSHIP_SPONSORSHIPPROGRAMID
|
|
False
|
False
|
False
|
|
IX_SPONSORSHIP_SPROPPPROJECTCATEGORYCODEID
|
SPROPPPROJECTCATEGORYCODEID
|
False
|
False
|
False
|
|
PK_SPONSORSHIP
|
|
True
|
True
|
False
|
