FAFEVENTBATCH (4.0SP20)

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes
BATCHID	uniqueidentifier	false	BATCH.ID
COPYFROMEVENTID	uniqueidentifier	true	EVENT.ID
EVENTPROGRAMID	uniqueidentifier	true	FAFPROGRAM.ID
EVENTLOCATIONID	uniqueidentifier	true	EVENTLOCATION.ID
EVENTLOCATIONCONTACTID	uniqueidentifier	true	CONSTITUENT.ID
PREVIOUSYEAREVENTID	uniqueidentifier	true	EVENT.ID
EVENTCATEGORYCODEID	uniqueidentifier	true	EVENTCATEGORYCODE.ID
SITEID	uniqueidentifier	true	SITE.ID
DEFAULTCONSTITUENTSITEID	uniqueidentifier	true	SITE.ID
APPEALID	uniqueidentifier	true	APPEAL.ID
DESIGNATIONID	uniqueidentifier	true	DESIGNATION.ID
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID

Fields
Field	Field Type	Null	Notes
SEQUENCE	int	false	0
NAME	nvarchar(100)	false	''
DESCRIPTION	nvarchar(255)	false	''
STARTDATE	date	false
STARTTIME	UDT_HOURMINUTE	false	''
ENDDATE	date	false
ENDTIME	UDT_HOURMINUTE	false	''
REPORTYEAR	UDT_YEAR	false	((0))
EVENTLOCATIONNAME	nvarchar(100)	false	''
EVENTLOCATIONCONTACTLASTNAME	nvarchar(100)	false	''
EVENTLOCATIONCONTACTFIRSTNAME	nvarchar(50)	false	''
EVENTTYPECODE	tinyint	false	1
EVENTTYPE	nvarchar(43) (Computed)	true
LOOKUPEVENTID	nvarchar(100)	false	''
SUPPORTPHONE	nvarchar(100)	false	''
SUPPORTURL	UDT_WEBADDRESS	false	''
EVENTSUPPORTEMAIL	UDT_EMAILADDRESS	false	''
EVENTURL	nvarchar(200)	false	''
TOTALREVENUEGOAL	money	false	0
REGISTRATIONSREVENUEGOAL	money	false	0
PARTICIPANTSREVENUEGOAL	money	false	0
HOUSEHOLDSREVENUEGOAL	money	false	0
TEAMSREVENUEGOAL	money	false	0
COMPANIESREVENUEGOAL	money	false	0
SPONSORSREVENUEGOAL	money	false	0
DONORSRECRUITMENTGOAL	int	false	0
PARTICIPANTSRECRUITMENTGOAL	int	false	0
HOUSEHOLDSRECRUITMENTGOAL	int	false	0
TEAMSRECRUITMENTGOAL	int	false	0
COMPANIESRECRUITMENTGOAL	int	false	0
SPONSORSRECRUITMENTGOAL	int	false	0
DATEADDED	datetime	false	getdate()
DATECHANGED	datetime	false	getdate()
TS	timestamp	false
TSLONG	bigint (Computed)	true
EVENTLOCATIONCONTACTEMAILADDRESS	UDT_EMAILADDRESS	false	''

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_FAFEVENTBATCH_BATCHID	BATCHID	False	False	False
IX_FAFEVENTBATCH_DATEADDED	DATEADDED	False	False	True
IX_FAFEVENTBATCH_DATECHANGED	DATECHANGED	False	False	False
IX_FAFEVENTBATCH_EVENTLOCATIONCONTACTID	EVENTLOCATIONCONTACTID	False	False	False
PK_FAFEVENTBATCH	ID	True	True	False

Triggers
Trigger Name	Description
TR_FAFEVENTBATCH_AUDIT_UPDATE
TR_FAFEVENTBATCH_AUDIT_DELETE

Referenced by
Referenced by	Field
FAFEVENTBATCHBATCHSYSTEMMESSAGES	FAFEVENTBATCHID
FAFEVENTBATCHBATCHUSERMESSAGE	ID