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 |
|
bigint |
NO |
Primary key |
MatchingWindowSessionGUID |
|
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 |