dbo.SXAORMMedMatchingSessionsMaster 
Default Table Name  SXAORMMedMatchingSessionsMaster 
Definition  The purpose of this table is to save the session info of matched and unmatched medications from the downloaded PML until the process the complete 

dbo.SXAORMMedMatchingSessionsMaster Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Build    int  NO  Identifies the version of the software that inserted/updated this row. 
TouchedBy    varchar(50)  NO  The User who last updated the row. IDCode from CV3User table. 
TouchedWhenUTC    datetimeoffset(3)  NO  Date and time the row was last updated. 
CreatedBy    varchar(50)  NO  The User who created the row. IDCode from CV3User table. 
CreatedWhenUTC    datetimeoffset(3)  NO  Date and time the row was created. 
MSRowVersion    timestamp  NO  Optimistic lock identifier. 
MSReplrowguid    uniqueidentifier  NO  Added in order to support Merge Replication. 
Active    bit  NO  Active flag is used for soft deleting or deactivating rows from this table. 
GUID(PK)    bigint  NO  Primary key 
ClientVisitGUID(FK)    HVCIDdt  NO  FK from ClientVisitGUID table 
ClientGUID(FK)    HVCIDdt  NO  FK from ClientGUID table 
CompletionStatusType    int  NO  whether the PML import is complete 

dbo.SXAORMMedMatchingSessionsMaster Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAORMMedMatchingSessionsMasterPK  PrimaryKey  GUID