dbo.SXAHomeMedicationCollectionStatus 
Default Table Name  SXAHomeMedicationCollectionStatus 
Definition  The purpose of this table is to store the patient's information when SCM will export Patient Madication List (PML) to NEHR system. 

dbo.SXAHomeMedicationCollectionStatus Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Build    int  NO  DBTeam application build version. 
TouchedBy    varchar(50)  NO  User ID of the person who is updating the data. 
TouchedWhenUTC    datetimeoffset(3)  NO  Data and time when the data was updated / modified. 
CreatedBy    varchar(50)  NO  User ID of the person who is inserting the data. 
CreatedWhenUTC    datetimeoffset(3)  NO  Data and time when the data was inserted / added. 
MSRowVersion    timestamp  NO  Optimistic lock identifier 
MSReplrowguid    uniqueidentifier  NO  Unique identifier in order to support Merge replication 
Active    bit  NO  Indicator whether selected row is currently active. 
HomeMedicationCollectionStatusID(PK)    bigint  NO  Primary key 
ClientGUID(FK)    HVCIDdt  NO  The GUID to identify the patient associated with this home medication collection 
VisitGUID    HVCIDdt  NO  The GUID to identify the visit in which the home medication collection was performed. 
CollectionStatusType    int  NO  Indicates if the medication review has been completed 
UpdatedByUserGUID    HVCIDdt  NO  The GUID of the user performing the medication collection 
UpdatedUTC    datetimeoffset(3)  NO  The date when the home medication status was saved
 
NEHRPMLCollectionStatusType    int  NO  whether the PML collection is complete 

dbo.SXAHomeMedicationCollectionStatus Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAHomeMedicationCollectionStatusPK  PrimaryKey  HomeMedicationCollectionStatusID