dbo.SXAORMMedMatchingNEHROrdersDetail 
Default Table Name  SXAORMMedMatchingNEHROrdersDetail 
Definition  The purpose of this table is to save the info on NEHR orders for the patient during med matching porcess 

dbo.SXAORMMedMatchingNEHROrdersDetail 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    varchar(50)  NO  NEHR item ID for the medication 

dbo.SXAORMMedMatchingNEHROrdersDetail Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAORMMedMatchingNEHROrdersDetailPK  PrimaryKey  GUID