| Database Table RecordAudit |
[This is preliminary documentation and is subject to change.]
Each row in this table corresponds to one record audit.
FieldsField name | Type | Note | Description |
|---|---|---|---|
Id | INT | Primary Key | Auto generated unique id |
CreatedDateTime | DATETIME | Date and time for creation of record audit | |
CreatedBy | INT | Link to employee who created the redord Audit | |
UpdatedDateTime | DATETIME | Date and time for lastest update of record audit | |
UpdatedBy | INT | Reference to Employee: id of who performed the latest update on the redord Audit | |
DeletedDateTime | DATETIME | Date and time for logical deletion of record audit. NB: NOT USED - record audits ar delted physically! | |
DeletedBy | INT | Link to employee who performed the logical delete on the redord Audit. NB: NOT USED - record audits ar deleted physically! | |
OrgUnitType | VARCHAR(20) | Link to Organizational unit that takes part in the record audit | |
OrgUnitCode | VARCHAR(20) | Link to Organizational unit that takes part in the record audit | |
DateFrom | DATETIME | Date for start of record audit | |
DateTo | DATETIME | Date for end of record audit | |
RecordCountMinimum | INT | Minimum number records that must be registered to make record audit "complete" - but record audit data is used in self evaluation and survey even if not complete! | |
Comment | VARCHAR(MAX) | Comment on record audit |
RelationsTable | Relation |
|---|---|
See fields OrgUnitType and OrgUnitCode above | |
See fields StandarCode and VersionNumber above | |
See field IndicatorCode above |