Tables installed with assessments

Tables

Assessments adds the following tables.
Table 1. Tables for assessments
Table Description: Assessments Description: Surveys
Assessable Record

[asmt_assessable_record]

Stores all assessable records. For system use only.
Assessment Category Result

[asmt_category_result]

Stores all category results. For system use only.
Assessment Category User

[asmt_m2m_category_user]

Stores associations between users and metric categories they can assess. A user that is associated to a category is a category user. Stores associations between users and surveys. A user that is associated to a survey is a survey user and is automatically associated to all the survey's categories.
Assessment Group

[asmt_assessment]

Stores all assessment groups. For system use only.
Assessment Instance

[asmt_assessment_instance]

Stores all assessment instances. Stores all survey instances.
Assessment Instance Question

[asmt_assessment_instance_question]

Stores all assessment instance questions, each of which represents one question on one assessment instance. Stores all survey instance questions, each of which represents one question on one survey instance.
Assessment Metric

[asmt_metric]

Stores all metrics. Stores all survey questions.
Assessment Metric Definition

[asmt_metric_definition]

Stores all metric definitions. Stores all answer options for survey questions.
Assessment Metric Template

[asmt_template]

Stores all metric templates. Stores all question templates.
Assessment Metric Type

[asmt_metric_type]

Stores all metric types. Stores all survey definitions.
Assessment Stakeholders

[asmt_m2m_stakeholder]

Stores associations between assessable records and category users. A category user that is associated to an assessable record is a stakeholder. Not used for surveys.
Assessment Template Definition

[asmt_template_definition]

Stores all metric template definitions. Stores all question template definitions.
Assessment X Category Matrix

[asmt_m2m_xcategory_matrix]

Allows users to specify metric categories as the X axis of a decision matrix. Not used for surveys.
Assessment Y Category Matrix

[asmt_m2m_ycategory_matrix]

Allows users to specify metric categories as the Y axis of a decision matrix. Not used for surveys.
Bubble Chart

[asmt_bubble_chart]

Stores all bubble chart definitions. Not used for surveys.
Category Assessable Records

[asmt_m2m_category_assessment]

Stores associations between assessable records and metric categories. For system use only.
Decision Matrix

[asmt_decision_matrix]

Stores all decision matrixes. Not used for surveys.
Metric Category

[asmt_metric_category]

Stores all metric categories. Stores all survey categories.
Metric Result

[asmt_metric_result]

Stores all metric results. Stores all survey responses.
Signature

[asmt_signature]

Stores all signature records for assessments and [[Attestations|GRC attestations]]. Stores all signature records for surveys.
Trigger Condition

[asmt_condition]

Stores all assessment trigger conditions. Stores all survey trigger conditions.