| Database Table RecordAuditRecord |
[This is preliminary documentation and is subject to change.]
"Header" data for one record in a record audit (typically one patient / procedure)
FieldsField Name | Type | Note | Description |
|---|---|---|---|
Id | INT | Primary Key | Internal unique id |
CreatedDateTime | DATETIME | Date and time for creation of record | |
CreatedBy | INT | Employee if of user who created the record | |
UpdatedDateTime | DATETIME | Date and time for latest update of record | |
UpdatedBy | INT | Employee id of user who last updated the record | |
DeletedDateTime | DATETIME | Date and time for (logical) deletion of record | |
DeletedBy | INT | Employee id of user who (logically) deleted the record | |
RecordAuditId | INT | Reference to RecordAudit | |
RecordNumber | INT | Number of record in audit (automatically numbered consequetively from 1) | |
RecordIdentification | VARCHAR(255) | Optional idenfication of record (may be used as reference to one patient's record) | |
RecordDate | DATETIME | Date for registering the record | |
Comment | VARCHAR(MAX) | Comment for record |