EVENTEXTENSION (4.0SP17)

Extended fields to EVENT Table

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

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

Fields
Field	Field Type	Null	Notes	Description
EVENTYEAR	UDT_YEAR	false	((0))	Year of the Event
SUPPORTPHONE	nvarchar(100)	false	''	constituent phone number
SUPPORTURL	UDT_WEBADDRESS	false	''	customer support URL
EVENTURL	UDT_WEBADDRESS	false	''	url of the event
LOCATIONDESCRIPTION	nvarchar(1000)	false	''	location description of event
FACEBOOKURL	UDT_WEBADDRESS	false	''	url of facebook
MYSPACEURL	UDT_WEBADDRESS	false	''	url of myspace
TWITTERID	nvarchar(100)	false	''	Id of Twitter
TWITTERPASSWORD	nvarchar(4000)	false	''	Password of Twitter
FACEBOOKID	nvarchar(100)	false	''	Id of facebook
FACEBOOKPASSWORD	nvarchar(4000)	false	''	Password of facebook
YOUTUBEID	nvarchar(100)	false	''	Id of youtube
YOUTUBEPASSWORD	nvarchar(4000)	false	''	Password of youtube
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
TWITTERURL	UDT_WEBADDRESS	false	''	url of twitter
YOUTUBEURL	UDT_WEBADDRESS	false	''	url of youtube
MYSPACEID	nvarchar(100)	false	''	Id of myspace
MYSPACEPASSWORD	nvarchar(4000)	false	''	Password of myspace
LOOKUPEVENTID	nvarchar(100)	false	''	Alternate ID for the Event
MERCHANTACCOUNTID	uniqueidentifier	true		BBPS MerchantAccount ID of the event
EVENTTYPECODE	tinyint	false	1	Type of the Event
EVENTTYPE	nvarchar(43) (Computed)	true		Provides a translation for the 'EVENTTYPECODE' field.
EVENTSUPPORTEMAIL	UDT_EMAILADDRESS	false	''	Event support email
COPYSOURCEID	uniqueidentifier	true		Original copy from ID
COPYBATCHGUID	uniqueidentifier	true		Copy batch ID
EVENTSTATUSCODE	tinyint	false	0	Status of the Event
EVENTSTATUS	nvarchar(8) (Computed)	true		Provides a translation for the 'EVENTSTATUSCODE' field.
ISNEWSOCIALNETWORK	bit	false	0
AUTOMATCHSITEMODECODE	tinyint	false	0
AUTOMATCHSITEMODE	nvarchar(40) (Computed)	true
ISZIPMATCHINGON	bit	false	0

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

Triggers
Trigger Name	Description
TR_EVENTEXTENSION_AUDIT_UPDATE
TR_EVENTEXTENSION_AUDIT_DELETE