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. |
Active |
|
bit |
NO |
Indicator whether selected row is currently active. |
MSReplrowguid |
|
uniqueidentifier |
NO |
Store auto generated unique primary value. |
DigitalSignatureID |
|
bigint |
NO |
Store ObservationDocumentGUID. |
ObservationDocumentGUID |
|
HVCIDdt |
NO |
Store hexadecimal ASCII string representation of signature |
SignatureString |
|
varchar(max) |
NO |
Store the signee details. |
PrintedName |
|
varchar(100) |
YES |
Added in order to support Merge Replication |