Build 
Definition  Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. 

TouchedBy 
Definition  Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

TouchedWhenUTC 
Definition  The date and time that the row was last updated including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 

CreatedBy 
Definition  Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

CreatedWhenUTC 
Definition  The date and time that the row was created including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 

Active 
Definition  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 

EventOccurrenceRuleID 
Definition  Auto generated unique primary key value. 

EventSeriesDefinitionID 
Definition  A foreign key to the EventSeriesDefinitionID column in the SXAHMEventSeriesDefinition table. 

PreferredAdminEventID 
Definition  A foreign key to the EventID column in the SXAHMEvent table. 

SequenceNumber 
Definition  Defines this occurrence's sequential order in the series. The sequence will be an integer from 1 to N, where N is typically no higher than 6. The absolute max value is determined by the smallint datatype. 

AbsoluteMin 
Definition  The minimum amount of time that must elapse, relative to a reference date, before this occurrence is allowed to be completed.
An alphanumeric string representing an amount of time. Accepted values will be all of, or part of, this format: ##y##m##w###d 

AbsoluteMax 
Definition  The maximum amount of time that is allowed elapse, relative to a reference date, before this occurrence is no longer allowed to be completed.
An alphanumeric string representing an amount of time. Accepted values will be all of, or part of, this format: ##y##m##w###d 

RecommendedMin 
Definition  The recommended amount of time that should elapse, relative to a reference date, before this occurrence should be completed.
An alphanumeric string representing an amount of time. Accepted values will be all of, or part of, this format: ##y##m##w###d 

RecommendedMax 
Definition  The recommended amount of time that could potentially be allowed to elapse, relative to a reference date, before this occurrence should have already been completed. This max would represent the end of the date range that this occurrence is scheduled.
An alphanumeric string representing an amount of time. Accepted values will be all of, or part of, this format: ##y##m##w###d 

PrevOccurrenceMax 
Definition  For the previous occurrence, this is the recommended amount of time that could potentially be allowed to elapse, relative to a reference date, before this occurrence should have already been completed. This max would represent the end of the date range that this occurrence is scheduled.
An alphanumeric string representing an amount of time. Accepted values will be all of, or part of, this format: ##y##m##w###d 

NextOccurrenceRecGapMin 
Definition  The recommended minimum amount of time, relative to the scheduled or completed data of this occurrence, that should elapse before the next occurrence should be scheduled or completed.
An alphanumeric string representing an amount of time. Accepted values will be all of, or part of, this format: ##y##m##w###d 

NextOccurrenceRecGapMax 
Definition  The recommended maximum amount of time, relative to the scheduled or completed data of this occurrence, that should elapse before the next occurrence should be scheduled or completed.
An alphanumeric string representing an amount of time. Accepted values will be all of, or part of, this format: ##y##m##w###d 

MSRowVersion 
Definition  Optimistic lock identifier using rowversion datatype. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.