dbo.SXAAMBeRXMessageError 
Default Table Name  SXAAMBeRXMessageError 
Definition  Ambulatory Sure Scripts table used to store prescription message errors. 

dbo.SXAAMBeRXMessageError Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SiteID    smallint  NO  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 
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. 
TouchedWhen    datetime  NO  The date and time that the row was last updated and will be 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. 
CreatedWhen    datetime  NO  The date and time that the row was created and will be based on the Enterprise time zone. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
MessageErrorID(PK)    bigint  NO  Auto generated unique primary key value. 
PrescriptionID(FK)    bigint  NO  A foreign key to the PrescriptionID column in the SXAAMBClientPrescription table. 
MessageTo    varchar(80)  NO  PHI: The identification of the individual receiving the message. 
MessageFrom    varchar(80)  NO  PHI: The identification of the individual sending the message. 
SentTime    datetime  NO  Enterprise TimeZone - The date and time the message was sent. 
MessageNum    varchar(50)  NO  A unique identifier set by the sender of the message. 
RelatesToMessageNum    varchar(50)  NO  Used in response messages to echo back the original request message's MessageNum. 
ErrorStatus    bit  NO  Status of the error acknowledgement. 
Code    char(3)  NO  A communication code indication the receipt status of the message. 
DescriptionCode    varchar(3)  NO  The rejection code that is defined in the error dictionary table. 
FreeTextDescription    varchar(70)  YES  PHI: A free text description of an error message for those cases in which the error is user entered. 
MSrepl_tran_version    uniqueidentifier  NO  Optimistic lock identifier. 
MessageType    varchar(20)  YES  Used to Identify the type of transaction (REFREQ/RXCHG/CANRES) 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
Exception    varchar(2000)  YES  Exception occurred while communicating to eRxService or received from eRxService 

dbo.SXAAMBeRXMessageError Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAAMBeRXMessageErrorPK  PrimaryKey  MessageErrorID