| Database Table SurveyIndicatorRecordAudit |
[This is preliminary documentation and is subject to change.]
FieldsField Name | Type | Note | Description |
|---|---|---|---|
SurveyId | INT | Primary key | Reference to Survey |
StandardCode | VARCHAR (20) | Primary key | Reference to Indicator |
VersionNumber | INT | Primary key | Reference to Indicator |
IndicatorCode | VARCHAR (20) | Primary key | Reference to Indicator |
RecordAuditId | INT | Primary key | Reference to RecordAudit |
RecordAuditDateFrom | DATETIME | Start date of record audit | |
RecordAuditDateTo | DATETIME | End date of record audit | |
CountMinimum | INT | Minimum number of records in record audit to make complete | |
CountActual | INT | Actual number of records registered in audit | |
CountAnswer | INT | Number of answers in record audit | |
CountNoAnswer | INT | Number of unanswered questions in record audit |