Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the event management level template.
 LEVEL int   Default = 0 The level's position in the event management property group 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
 EVENTMANAGEMENTTEMPLATEID uniqueidentifier   EVENTMANAGEMENTTEMPLATE.ID The event management property group template 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_EVENTMANAGEMENTLEVELTEMPLATE_DATEADDED DATEADDED    
 IX_EVENTMANAGEMENTLEVELTEMPLATE_DATECHANGED DATECHANGED      
 PK_EVENTMANAGEMENTLEVELTEMPLATE ID  
 UIX_EVENTMANAGEMENTLEVELTEMPLATE_EVENTMANAGEMENTTEMPLATEID_LEVEL EVENTMANAGEMENTTEMPLATEID, LEVEL    
 UIX_EVENTMANAGEMENTLEVELTEMPLATE_EVENTMANAGEMENTTEMPLATEID_NAME EVENTMANAGEMENTTEMPLATEID, NAME    

Trigger Name Description
 TR_EVENTMANAGEMENTLEVELTEMPLATE_AUDIT_UPDATE
 TR_EVENTMANAGEMENTLEVELTEMPLATE_AUDIT_DELETE

Entity-Relationship diagram of this table