Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = ''
 DESCRIPTION nvarchar(250)   Default = ''
 LASTRUNON datetime
 APPLYTOCODE tinyint   Default = 0 0=All users, 1=Selected users, 2=Specific user
 CREATEITEMOPTIONCODE tinyint   Default = 0 0=Create calendar items with an expected date no later than, 1=Create calendar items for these step and interaction owners
 EXPECTEDDATEINTERVALCODE tinyint   Default = 0 0=One month from the current date, 1=Two months from the current date, 2=Three months from the current date, 3=Four months from the current date, 4=Five months from the current date, 5=Six months from the current date
 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.
 CREATEDEFAULTREMINDER bit   Default = 1
 DEFAULTREMINDERAMOUNT int   Default = 0 The default reminder amount in minutes.
 INCLUDEPENDINGINTERACTIONS bit   Default = 1
 INCLUDEPROSPECTPLANSTEPS bit   Default = 0
 INCLUDEPENDINGSTEWARDSHIPSTEPS bit   Default = 0
 APPLYTO nvarchar(14) (Computed) CASE [APPLYTOCODE] WHEN 0 THEN N'All users' WHEN 1 THEN N'Selected users' WHEN 2 THEN N'Specific user' END Provides a translation for the 'APPLYTOCODE' field.
 CREATEITEMOPTION nvarchar(59) (Computed) CASE [CREATEITEMOPTIONCODE] WHEN 0 THEN N'Create calendar items with an expected date no later than' WHEN 1 THEN N'Create calendar items for these step and interaction owners' END Provides a translation for the 'CREATEITEMOPTIONCODE' field.
 EXPECTEDDATEINTERVAL nvarchar(34) (Computed) CASE [EXPECTEDDATEINTERVALCODE] WHEN 0 THEN N'One month from the current date' WHEN 1 THEN N'Two months from the current date' WHEN 2 THEN N'Three months from the current date' WHEN 3 THEN N'Four months from the current date' WHEN 4 THEN N'Five months from the current date' WHEN 5 THEN N'Six months from the current date' END Provides a translation for the 'EXPECTEDDATEINTERVALCODE' field.

Foreign Key Field Type Null Notes Description
 APPUSERIDSETREGISTERID uniqueidentifier IDSETREGISTER.ID A foreign key to the ID set used to filter the app users that will receive a calendar item in the synchronization process.
 SPECIFICAPPUSERID uniqueidentifier APPUSER.ID FK to APPUSER
 PAGEDEFINITIONCATALOGID uniqueidentifier PAGEDEFINITIONCATALOG.ID FK to PAGEDEFINITIONCATALOG
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_EXCHANGECALENDARSYNC_APPUSERIDSETREGISTERID APPUSERIDSETREGISTERID      
 IX_EXCHANGECALENDARSYNC_DATEADDED DATEADDED    
 IX_EXCHANGECALENDARSYNC_DATECHANGED DATECHANGED      
 IX_EXCHANGECALENDARSYNC_PAGEDEFINITIONCATALOGID PAGEDEFINITIONCATALOGID      
 IX_EXCHANGECALENDARSYNC_SPECIFICAPPUSERID SPECIFICAPPUSERID      
 PK_EXCHANGECALENDARSYNC ID  
 UC_EXCHANGECALENDARSYNC_NAME NAME    

Trigger Name Description
 TR_EXCHANGECALENDARSYNC_UPDATED
 TR_EXCHANGECALENDARSYNC_AUDIT_UPDATE
 TR_EXCHANGECALENDARSYNC_AUDIT_DELETE

Referenced by Field
 EXCHANGECALENDARSYNCSTATUS PARAMETERSETID

Entity-Relationship diagram of this table