| Database Table SurveyIterationBody |
[This is preliminary documentation and is subject to change.]
This table holds survey data that depend on survey phase. A survey has same number of phases as the number of accreditation bodies (defined in AccreditationBody).
FieldsField Name | Type | Note | Description |
|---|---|---|---|
SurveyId | INT | Part of primary key | Reference to Survey |
Iteration | INT | Part of primary key | Iteration number - NB: currently always 1 - multiple iterations not supported! |
AccreditationBody | INT | Part of primary key | Reference to AccreditationBody |
CreatedDateTime | DATETIME | Date and time for creation of survey iteration/body | |
CreatedBy | INT | Reference to Employee: id of user who created the survey iteration/body | |
UpdatedDateTime | DATETIME | Date and time for latest update of survey iteration/body | |
UpdatedBy | INT | Reference to Employee: id of user who latest updated the survey iteration/body | |
DeletedDateTime | DATETIME | Date and time for (logical) deletion of survey iteration/body. NB: Not used - surveys are deleted physically! | |
DeletedBy | INT | Reference to Employee: id of user who (logically) deleted the survey iteration/body. NB: Not used - surveys are deleted physically! | |
ApprovedDateTime | DATETIME | Date and time for approval of survey iteration/body | |
ApprovedBy | INT | Reference to Employee: id of user who approved the survey iteration/body | |
DateFrom | DATETIME | Start date of iteration/body | |
DateTo | DATETIME | End date of iteration/body | |
RecommendedDate | DATETIME | Date for recommendation | |
RecommendedStateName | VARCHAR(50) | Recommended state name (refers to state machine) | |
Comment | VARCHAR(MAX) | Comment on the survey iteration/body |