Primary Key Field Type
 ID uniqueidentifier

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) 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 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.

Index Name Field(s) Unique Primary Clustered
 IX_EVENTMANAGEMENTLEVELINSTANCE_DATEADDED DATEADDED    
 IX_EVENTMANAGEMENTLEVELINSTANCE_DATECHANGED DATECHANGED      
 PK_EVENTMANAGEMENTLEVELINSTANCE ID  

Trigger Name Description
 TR_EVENTMANAGEMENTLEVELINSTANCE_AUDIT_UPDATE
 TR_EVENTMANAGEMENTLEVELINSTANCE_AUDIT_DELETE

Referenced by Field
 EVENTMANAGEMENTOPTIONS EVENTMANAGEMENTLEVELINSTANCEID

Entity-Relationship diagram of this table