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