dbo.SXAEISRequestExecution 
Default Table Name  SXAEISRequestExecution 
Definition  Archive for SXAESMCExceptionDefinitionAvailabilityLocationXREFARC 

dbo.SXAEISRequestExecution 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. 
RequestExecutionID(PK)    bigint  NO  Auto generated unique primary key value. 
RequestID    bigint  NO  ID of the request made to an EIS Service 
RequestType    varchar(50)  NO  Type of request made to an EIS Service 
ClientAppName    varchar(100)  NO  Name of the Application making the request 
Correlator1    varchar(100)  YES  First Parameter (usually the username of the person using EIS services) 
Correlator2    varchar(100)  YES  Second Parameter (usually the machine name of the machine using EIS services) 
ConnectionID    varchar(100)  YES  ID of the connection to the EIS database 
OriginatingComponent    varchar(255)  NO  Component where the request originated 
OriginatingMethod    varchar(255)  NO  Method where the request originated 
HandlingComponent    varchar(255)  YES  Component handling the request if applicable 
HandlingMethod    varchar(255)  YES  Method handling the request if applicable 
ExceptionType    varchar(255)  YES  Type of exception thrown if applicable 
EventType    varchar(50)  NO  Type of event logged. 'INFO','ERROR','SECURITY','RQST','RQEND','RQABT','RQALL' 
OccurredWhen    datetime  NO  Enterprise TimeZone - Date when the diagnostic record was inserted 
RecordText    varchar(6000)  NO  Explanation of what occurred during the event 
ElapsedTime    int  YES  The amount of time taken to perform the request 
MSrepl_tran_version    uniqueidentifier  NO  Optimistic lock identifier. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXAEISRequestExecution Primary and Unique Keys 
Key Name  Key Type  Keys 
RequestExecutionPK  PrimaryKey  RequestExecutionID