Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of this location.
 STATUSCODE tinyint   Default = 0 The status of this location in regards to sponsorship.
 STATUS nvarchar(8) (Computed) CASE [STATUSCODE] WHEN 0 THEN N'Active' WHEN 1 THEN N'Inactive' WHEN 2 THEN N'Closed' END Provides a translation for the 'STATUSCODE' field.
 HIERARCHYPATH hierarchyid  
 COMMENT nvarchar(255)   Default = '' Comments for adding/editing a location.
 CUSTOMIDENTIFIER nvarchar(100)   Default = '' User-definable custom identifier.
 SEQUENCEID int   Identity column used to increment the default lookupid.
 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.
 LOOKUPID nvarchar(100) (Computed) (CASE LEN(CUSTOMIDENTIFIER) WHEN 0 THEN '8-' + CAST(SEQUENCEID AS nvarchar(20)) ELSE CUSTOMIDENTIFIER END) Unique identifer that supports user defined values as well as system generated values.
 DISPLAYONLINE bit   Default = 1 Specifies that a particular node should or should not be displayed online.

Foreign Key Field Type Null Notes Description
 SPONSORSHIPLOCATIONTYPECODEID uniqueidentifier   SPONSORSHIPLOCATIONTYPECODE.ID The type of this location (region, country, community, etc.).
 SPONSORSHIPREASONID uniqueidentifier SPONSORSHIPREASON.ID The reason why the location is not active.
 DESIGNATIONID uniqueidentifier DESIGNATION.ID A designation which corresponds one-to-one with this location.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 FIELDOFFICEID uniqueidentifier CONSTITUENT.LOCALID A organization constituent that represents the field office for this location.

Index Name Field(s) Unique Primary Clustered
 IX_SPONSORSHIPLOCATION_DATEADDED DATEADDED    
 IX_SPONSORSHIPLOCATION_DATECHANGED DATECHANGED      
 IX_SPONSORSHIPLOCATION_FIELDOFFICEID FIELDOFFICEID      
 IX_SPONSORSHIPLOCATION_SPONSORSHIPLOCATIONTYPECODEID SPONSORSHIPLOCATIONTYPECODEID      
 IX_SPONSORSHIPLOCATION_SPONSORSHIPREASONID SPONSORSHIPREASONID      
 PK_SPONSORSHIPLOCATION ID  
 UC_SPONSORSHIPLOCATION_HIERARCHYPATH HIERARCHYPATH    
 UC_SPONSORSHIPLOCATION_LOOKUPID LOOKUPID    
 UIX_SPONSORSHIPLOCATION_DESIGNATIONID DESIGNATIONID    

Trigger Name Description
 TR_SPONSORSHIPLOCATION_AUDIT_UPDATE
 TR_SPONSORSHIPLOCATION_AUDIT_DELETE

Referenced by Field
 BATCHSPONSORSHIP SPONSORSHIPLOCATIONID
 SALESORDERITEMSPONSORSHIP SPONSORSHIPLOCATIONID
 SPONSORSHIP SPONSORSHIPLOCATIONID
 SPONSORSHIPGREATESTNEEDRULESETREF SPONSORSHIPLOCATIONID
 SPONSORSHIPLOCATIONCLOSEPROCESS ID
 SPONSORSHIPOPPORTUNITY SPONSORSHIPLOCATIONID
 SPONSORSHIPOPPORTUNITYGROUP SPONSORSHIPLOCATIONID
 SPONSORSHIPTRANSFERPROCESS SPONSORSHIPLOCATIONID

Entity-Relationship diagram of this table