dbo.SXASHAutoReplyConfig 
Default Table Name  SXASHAutoReplyConfig 
Definition  Table contains SHM user Auto Reply configuration information 

dbo.SXASHAutoReplyConfig Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Build    int  NO  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    varchar(50)  NO  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    datetimeoffset(3)  NO  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    varchar(50)  NO  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    datetimeoffset(3)  NO  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. 
SHMUserID(PK)(FK)    bigint  NO  A foreign key to the UserID column in the SXASHUser table. 
IsAutoReplyOn    bit  NO  Identifies whether User should send Autoreply or not 
IsTimeRangeOn    bit  NO  Identifies whether User should send Autoreply for Specific time range or not 
StartDateTimeUTC    datetimeoffset(3)  NO  Enterprise TimeZone - Autoreply activation start Date and Time 
EndDateTimeUTC    datetimeoffset(3)  NO  Enterprise TimeZone - Autoreply activation end Date and Time 
ProviderMessageText    varchar(8000)  YES  PHI: Autoreply message text for provider. 
IsSendToPatient    bit  NO  Identifies whether User should send Autoreply to patient or not. 
PatientMessageText    varchar(8000)  YES  PHI: Autoreply message text for patient 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXASHAutoReplyConfig Primary and Unique Keys 
Key Name  Key Type  Keys 
SXASHAutoReplyConfigPK  PrimaryKey  SHMUserID