dbo.SXACDExchangeDocumentEvent 
Default Table Name  SXACDExchangeDocumentEvent 
Definition  This table holds records that track the DocEx generation and inbound processing 

dbo.SXACDExchangeDocumentEvent Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Build    int  NO  Application build version. 
TouchedBy    varchar(50)  NO  User ID of the person who is updating the data. 
TouchedWhenUTC    datetimeoffset(3)  NO  Data and time when the data was updated / modified. 
CreatedBy    varchar(50)  NO  User ID of the person who is inserting the data. 
CreatedWhenUTC    datetimeoffset(3)  NO  Data and time when the data was inserted / added. 
MSRowVersion    timestamp  NO  Optimistic lock identifier. 
MSReplrowguid    uniqueidentifier  NO  MSReplrowguid 
ExchangeDocumentEventId(PK)    bigint  NO  Primary Key for table (used as correlation id in other status tables) 
UserGuid(FK)    HVCIDdt  YES  Primary Key for CV3User 
ClientGuid(FK)    HVCIDdt  YES  Primary Key for CV3Client 
ClientVisitGuid(FK)    HVCIDdt  YES  Primary Key for CV3ClientVisit 
PatientCareDocumentGUID(FK)    HVCIDdt  YES  Primary Key for CV3PatientCareDocument 
ClientDocumentGUID    HVCIDdt  YES  Primary Key for CV3ClientDocument 
SourceId    bigint  YES  Primary Key of the Task if initiated by the Export Job Execution Service 
DocContinuityOfCareId(FK)    bigint  YES  Primary Key of the ContinuityOfCare table 
EventType    int  NO  Type of Event (Generate, Receive, SaveExternal, SearchExternal) 
StateType    int  NO  State of event (Unknown, Pending, Success or Failure) 
ContextData    xml  YES  Additional context data 
SourceType    int  NO  Identifies the type of workflow generating an exchange document. 

dbo.SXACDExchangeDocumentEvent Primary and Unique Keys 
Key Name  Key Type  Keys 
SXACDExchangeDocumentEventPK  PrimaryKey  ExchangeDocumentEventId