Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 EVENTYEAR UDT_YEAR   Default = ((0)) Year of the Event
 SUPPORTPHONE nvarchar(100)   Default = '' constituent phone number
 SUPPORTURL UDT_WEBADDRESS   Default = '' customer support URL
 EVENTURL UDT_WEBADDRESS   Default = '' url of the event
 LOCATIONDESCRIPTION nvarchar(1000)   Default = '' location description of event
 FACEBOOKURL UDT_WEBADDRESS   Default = '' url of facebook
 MYSPACEURL UDT_WEBADDRESS   Default = '' url of myspace
 TWITTERID nvarchar(100)   Default = '' Id of Twitter
 TWITTERPASSWORD nvarchar(4000)   Default = '' Password of Twitter
 FACEBOOKID nvarchar(100)   Default = '' Id of facebook
 FACEBOOKPASSWORD nvarchar(4000)   Default = '' Password of facebook
 YOUTUBEID nvarchar(100)   Default = '' Id of youtube
 YOUTUBEPASSWORD nvarchar(4000)   Default = '' Password of youtube
 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.
 TWITTERURL UDT_WEBADDRESS   Default = '' url of twitter
 YOUTUBEURL UDT_WEBADDRESS   Default = '' url of youtube
 MYSPACEID nvarchar(100)   Default = '' Id of myspace
 MYSPACEPASSWORD nvarchar(4000)   Default = '' Password of myspace
 LOOKUPEVENTID nvarchar(100)   Default = '' Alternate ID for the Event
 MERCHANTACCOUNTID uniqueidentifier BBPS MerchantAccount ID of the event
 EVENTTYPECODE tinyint   Default = 1 Type of the Event
 EVENTTYPE nvarchar(43) (Computed) CASE [EVENTTYPECODE] WHEN 1 THEN N'Other' WHEN 2 THEN N'Athletic Challenge' WHEN 3 THEN N'Auction/Raffle/Give-a-way' WHEN 4 THEN N'Bike' WHEN 5 THEN N'Independent or 3rd Party Fundraising Events' WHEN 6 THEN N'Other Sport-a-Thon' WHEN 7 THEN N'Run/Walk' WHEN 8 THEN N'Virtual Event' END Provides a translation for the 'EVENTTYPECODE' field.
 EVENTSUPPORTEMAIL UDT_EMAILADDRESS   Default = '' Event support email
 COPYSOURCEID uniqueidentifier Original copy from ID
 COPYBATCHGUID uniqueidentifier Copy batch ID
 EVENTSTATUSCODE tinyint   Default = 0 Status of the Event
 EVENTSTATUS nvarchar(8) (Computed) CASE [EVENTSTATUSCODE] WHEN 0 THEN N'Preview' WHEN 1 THEN N'Active' WHEN 2 THEN N'Inactive' END Provides a translation for the 'EVENTSTATUSCODE' field.
 ISNEWSOCIALNETWORK bit   Default = 0
 AUTOMATCHSITEMODECODE tinyint   Default = 0
 AUTOMATCHSITEMODE nvarchar(40) (Computed) CASE [AUTOMATCHSITEMODECODE] WHEN 0 THEN N'All Records' WHEN 1 THEN N'Records with no site assigned' WHEN 2 THEN N'Records with one of these sites assigned' END
 ISZIPMATCHINGON bit   Default = 0

Foreign Key Field Type Null Notes Description
 EVENTID uniqueidentifier   EVENT.ID Foreign Key to Event table
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 PRIORYEAREVENTID uniqueidentifier EVENT.ID Previous year event, for year-over-year comparison
 CLIENTSITESID int ClientSites.ID FK to CLIENTSITES
 SITEID uniqueidentifier SITE.ID
 FAFPROGRAMID uniqueidentifier FAFPROGRAM.ID

Index Name Field(s) Unique Primary Clustered
 IX_EVENTEXTENSION_DATEADDED DATEADDED    
 IX_EVENTEXTENSION_DATECHANGED DATECHANGED      
 PK_EVENTEXTENSION ID  
 UIX_EVENTEXTENSION_EVENTID EVENTID    

Trigger Name Description
 TR_EVENTEXTENSION_AUDIT_UPDATE
 TR_EVENTEXTENSION_AUDIT_DELETE

Entity-Relationship diagram of this table