EVENTMANAGEMENTLEVELINSTANCE

Stores information for an instance of an event management level.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
NAME	nvarchar(100)		Default = ''	The name of the event management level instance.
LEVEL	int		Default = 0	The level's position in the event management template.
HASREGISTRANTSANDOPTIONS	bit		Default = 1	Indicates if this level tracks registrants.
HASSPEAKERS	bit		Default = 1	Indicates if this level tracks speakers.
HASEXPENSES	bit		Default = 1	Indicates if this level tracks expenses.
HASINVITATIONS	bit		Default = 1	Indicates if this level tracks invitations.
HASDOCUMENTATION	bit		Default = 1	Indicates if this level tracks documentation.
HASLODGINGOPTIONS	bit		Default = 1	Indicates if this level tracks lodging options.
HASJOBOCCURRENCES	bit		Default = 1	Indicates if this level tracks job occurrences.
HASAPPEALS	bit		Default = 1	Indicates if this level tracks appeals.
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)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.
HASTASKSANDCOORDINATORS	bit		Default = 1	Indicates if this level tracks tasks.
HASCAMPAIGNS	bit		Default = 1	Indicates if this level tracks campaigns.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
EVENTMANAGEMENTINSTANCEID	uniqueidentifier		EVENTMANAGEMENTINSTANCE.ID	The event management instance containing the level.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_EVENTMANAGEMENTLEVELINSTANCE_DATEADDED	DATEADDED			yes
IX_EVENTMANAGEMENTLEVELINSTANCE_DATECHANGED	DATECHANGED
PK_EVENTMANAGEMENTLEVELINSTANCE	ID	yes	yes

Triggers

Trigger Name	Description
TR_EVENTMANAGEMENTLEVELINSTANCE_AUDIT_UPDATE
TR_EVENTMANAGEMENTLEVELINSTANCE_AUDIT_DELETE

Referenced by

Referenced by	Field
EVENTMANAGEMENTOPTIONS	EVENTMANAGEMENTLEVELINSTANCEID