Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Unique ObjectId generated by Architecture. |
InstanceHFCID | smallint | NOT NULL | Instance HFCID generated by Architecture |
RecordId | int | NULL | Not used. |
Description | varchar(255) | NULL | Not used. |
IsVersioned | bit | NOT NULL | Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified |
CreatedUserId | int | NULL | UserId of the user who created the row |
CreationTime | smalldatetime | NULL | Date and Time when row was created. |
UserName | varchar(255) | NULL | User name of the user who started the merge. |
MergeDate | datetime | NULL | Date and time of the merge. |
SourcePatientID | varchar(20) | NULL | ObjectId of the source patient(data moved from this patient). Must be in HPatient Table. |
TargetPatientID | varchar(20) | NULL | ObjectId of the target patient(data moved to this patient). Must be in HPatient Table. |
StatusValue | tinyint | NULL | Merge status. Allowable Values: 0 - Completed 1 - In Progress |
Comments | varchar(255) | NULL | Comment put by the process at the end of the merge. |
|