dbo.SXAORMMedMatchingXref 
Default Table Name  SXAORMMedMatchingXref 
Definition  The purpose of this table is to save the matching SCM medications for every NEHR medication 

dbo.SXAORMMedMatchingXref 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 
MatchingWindowSessionGUID(FK)    bigint  NO  Foreign key from SXAORMMedMatchingSessionsMaster 
NEHRItemID    bigint  YES  SCM created ID of the downloaded medication from NEHR 
SCMItemID    HVCIDdt  NO  FK from SXAORMMedMatchingSCMOrdersDetail 
MedMatchingTypeID    smallint  YES  Type of Medication match 
FinalItemID    HVCIDdt  NO  store new/modified order ID 
ItemGroupKey    varchar(50)  YES  Group Info for the item 
ItemSDDInfo    varchar(50)  YES  SDD Info for the item 
ItemMLMInfo    varchar(50)  YES  MLM info for the item 
FinalFromNEHRItemID    varchar(50)  YES  NEHR medication item ID 
FinalFromSCMItemID    HVCIDdt  YES  SCM medication item ID 

dbo.SXAORMMedMatchingXref Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAORMMedMatchingXrefPK  PrimaryKey  GUID