Build |
Definition | Identifies the version of the software that inserted/updated this row. |
TouchedBy |
Definition | The User who last updated the row. IDCode from CV3User table. |
TouchedWhenUTC |
Definition | Date and time the row was last updated. |
CreatedBy |
Definition | The User who created the row. IDCode from CV3User table. |
CreatedWhenUTC |
Definition | Date and time the row was created. |
MSRowVersion |
Definition | Optimistic lock identifier. |
MSReplrowguid |
Definition | Added in order to support Merge Replication. |
Active |
Definition | Active flag is used for soft deleting or deactivating rows from this table. |
GUID |
Definition | Primary key |
MatchingWindowSessionGUID |
Definition | Foreign key from SXAORMMedMatchingSessionsMaster |
NEHRItemID |
Definition | SCM created ID of the downloaded medication from NEHR |
SCMItemID |
Definition | FK from SXAORMMedMatchingSCMOrdersDetail |
MedMatchingTypeID |
Definition | Type of Medication match |
FinalItemID |
Definition | store new/modified order ID |
ItemGroupKey |
Definition | Group Info for the item |
ItemSDDInfo |
Definition | SDD Info for the item |
ItemMLMInfo |
Definition | MLM info for the item |
FinalFromNEHRItemID |
Definition | NEHR medication item ID |
FinalFromSCMItemID |
Definition | SCM medication item ID |