Database Table SurveyType

[This is preliminary documentation and is subject to change.]

Table defining the possible values for the survey type (property in table Survey).

The value of the Number field has no special meaning in the system - that is: it is possible to define any number of values. However, pay attention to the values of the fields Initial and SelectAll, as the fields determine the behavior of the survey types.

Fields

Field Name

Type

Note

Description

Number

INT

Primary Key

Survey type number

Name

VARCHAR(255)

Name of survey type

Initial

BIT

Whether or not the survey type is initial - initial surveys start new accrediation cycles

SelectAll

BIT

0: only standards perviously marked as "follow up" get selected in new survey. 1: all standards get selected in new survey.