Database Table AccreditationBody

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

Table AccreditationBody defines the accreditation bodies, i.e. the bodies that take part in the survey process.

Bodies must be numbered consequetively according to workflow: first body to work on survey must have number 1, second must have number 2, etc.

Typical use of body numbers:

Surveyors / surveyor pool.
Accreditation secretariat (the institution that mediates the survey process).
Accreditation board (the authority that awards accreditation status to surveyed institutions).

By changing the contents of this table, it is possible to add or remove bodies in the accreditation process - and change the permissions for each body.

Note, however, that changing the number and/or permissions of accreditation bodies, will require corresponding changes to the "state machine" controlling the survey process. The "survey state machine" is NOT defined in the database (it is defined by an XML file on the webserver).

Fields

Field Name	Type	Note	Description
Number	INT	Primary Key	Accreditation body number - must be numbered consequetively according to workflow: first body to work on survey must have number 1, second must have number 2, etc.
Description	VARCHAR(255)		Description - displayed in user interface
RecommendationLabel	VARCHAR(255)		Label displayed for "Recommandation" field in survey properties form - NB: not used!
AllowAssessment	BIT		Whether or not users employed by org.unit belonging to this body may perform assesment. Body number 1 (surveyors) must have this field set.
AccreditationSecretariat	BIT		1 enables "secretariat" functionality. Users employed by org.unit beloging to body marked as "secretariat" get extended permissions in survey module.