| Database Table Assessment |
[This is preliminary documentation and is subject to change.]
The Assessment table holds assessment data. One row in the Assessment table holds data about assessment on one object - which may be of one of the following types:
Indicator
Standard
StdGroup (theme / category)
Tracer
Combined record audit
FieldsField Name | Type | Note | Description |
|---|---|---|---|
Id | INT | Primary Key | Internal unique id |
CreatedDateTime | DATETIME | Date and time for creation of assesment | |
CreatedBy | INT | Reference to Employee: id of user who created the assesment | |
UpdatedDateTime | DATETIME | Date and time for last update of assesment | |
UpdatedBy | INT | Reference to Employee: id of user who last updated the assesment | |
DeletedDateTime | DATETIME | Date and time for (logical) deletion of assesment | |
DeletedBy | INT | Reference to Employee: id of user who (logically) deleted the assesment | |
SurveyId | INT | Reference to Survey | |
StandardGroupCode | VARCHAR (20) | Reference to StandardGroup | |
StandardCode | VARCHAR (20) | Reference to StandardVersion or Indicator | |
VersionNumber | INT | Reference to StandardVersion or Indicator | |
IndicatorCode | VARCHAR (20) | Reference to Indicator | |
TracerId | INT | Reference to Tracer | |
Iteration | INT | Partial foreign key to SurveyIterationBody / AccreditationBody | |
AccreditationBody | INT | Foreign key to AccreditationBody | |
AssessmentDate | DATETIME | Date for assessment | |
AssessmentResult | INT | Reference to AssesmentResult | |
Reason | VARCHAR(MAX) | Reason / explanation for result | |
FollowUp | BIT | Whether or not to follow up on assesment | |
FollowUpText | VARCHAR(MAX) | What or how to follow up | |
Recommendation | VARCHAR(MAX) | Recommendation to initiatives to take as consequence of assesment |