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 |
MedMatchingXrefGUID |
|
bigint |
YES |
FK from SXAORMMedMatchingXref table |
itemID |
|
HVCIDdt |
YES |
the medication item ID |
IsVisible |
|
bit |
NO |
whether the item is visible or not |