Tables installed in Smart Assessment Engine

  • Release version: Australia
  • Updated April 13, 2026
  • 7 minutes to read

    • Tables are added with activation of GRC: Smart Assessment Engine.

    Tables installed with Smart Assessment Core

    Table 1. Tables installed with Smart Assessment Core (com.sn_smart_asmt)
    Table Description
    Assessment Template

    [sn_smart_asmt_template]

    		 Extends the sys_metadata table and stores all assessment template definitions including name, description, publication status, versioning, and instructions.
    Assessment Template Category

    [sn_smart_asmt_template_category]

    		 Extends the sys_metadata table and stores categories that classify assessment templates by purpose. Controls access via associated roles and defines assessment handling on version retirement.
    Assessment Template Contributor

    [sn_smart_asmt_template_contributor]

    		 Extends the sys_metadata table. Many-to-many relationship table that is used to manage the relationships between assessment templates and user criteria for contributor access.
    Section

    [sn_smart_asmt_section]

    		 Extends the sys_metadata table and stores sections within assessment templates. Supports hierarchical structure with subsections via parent/child relationships.
    Question

    [sn_smart_asmt_question]

    		 Extends the sys_metadata table and stores question definitions within sections. Includes label, guidance, question type, data type, response layout, validation rules, and conditional configuration settings for visibility, justification, attachment, preferred answer, and response automation.
    Question Type

    [sn_smart_asmt_question_type]

    		 Extends the sys_metadata table and stores the available question types such as Textbox, Dropdown, Radio, Checkbox, Number, Calendar, Attachment, Reference, and Barcode with their category, icons, and guidance.
    Response Option

    [sn_smart_asmt_response_option]

    		 Extends the sys_metadata table and stores answer options for choice-based questions. Supports text, currency, number, and date response labels.
    Assessment Condition

    [sn_smart_asmt_condition]

    		 Extends the sys_metadata table and stores reusable condition definitions as encoded queries. Used for visibility, preferred answer, justification, and attachment conditions on questions.
    Assessment Predicate

    [sn_smart_asmt_predicate]

    		 Extends the sys_metadata table and stores predicate definitions linking conditions to assessment templates. Base table for specialized predicates such as response automation and scoring.
    Response Automation Predicate

    [sn_smart_asmt_response_automation_predicate]

    		 Extends the Assessment Predicate [sn_smart_asmt_predicate] table and stores automated response generation rules with support for scripted responses across various response types including text, number, date, and selected options.
    Question to Assessment Condition

    [sn_smart_asmt_m2m_question_condition]

    		 Extends the sys_metadata table. Many-to-many relationship table that is used to manage the mapping between questions and conditions, with condition types: visibility, preferred_answer, attachment, and justification.
    Assessment Persona

    [sn_smart_asmt_persona]

    		 Extends the sys_metadata table and stores persona or role definitions for assessment participation such as assessor and reviewer.
    Assessment Workflow State

    [sn_smart_asmt_workflow_state]

    		 Extends the sys_metadata table and stores workflow state definitions for assessment instances such as Draft, In Progress, and Completed.
    Context Item

    [sn_smart_asmt_context_item]

    		 Extends the sys_metadata table and defines which external table records can be shown as context or references during assessment completion. Includes reference card field configuration.
    Descriptive Image

    [sn_smart_asmt_descriptive_image]

    		 Extends the sys_metadata table and stores images associated with questions or sections to provide visual guidance, including alt text for accessibility.
    Assessment Duration

    [sn_smart_asmt_duration]

    		 Stores time duration allocations for assessment templates.
    Assessment Group

    [sn_smart_asmt_assessment_group]

    		 Stores assessment group records that group multiple assessment instances together. Tracks group status as open or closed.
    Smart Assessment Instance

    [sn_smart_asmt_instance]

    		 Stores individual assessment instances created from templates. Tracks assessment state, due dates, response completion metrics, and audit trail including requestor and assigned personas.
    Assessment Section Instance

    [sn_smart_asmt_section_instance]

    		 Stores runtime instances of sections for a specific assessment. Tracks section-level question counts, unanswered required questions, unanswered required justifications, unanswered required attachments, and user comments.
    Assessment Question Instance

    [sn_smart_asmt_question_instance]

    		 Stores runtime instances of questions for a specific assessment. Captures user responses for text, number, date, currency, reference, and selected options. Also stores condition evaluation results for visibility, preferred answer, justification, and attachment along with response metadata.
    Response Option Instance

    [sn_smart_asmt_response_option_instance]

    		 Stores the selected or unselected state of each response option for a specific question instance in an assessment.
    Assessment Predicate Instance

    [sn_smart_asmt_predicate_instance]

    		 Stores runtime instances of predicate evaluations during assessment execution, including condition result sets and final evaluation outcomes.
    Assessment Condition Result Set

    [sn_smart_asmt_condition_result_set]

    		 Stores the aggregated boolean result of evaluated conditions at runtime. Referenced by question instances for visibility, preferred answer, justification, and attachment condition outcomes.
    Assessment Condition Result

    [sn_smart_asmt_condition_result]

    		 Stores individual condition evaluation results within a condition result set, including the table, record, operator, and boolean outcome.
    Assessment Scope Item

    [sn_smart_asmt_scope_item]

    		 Stores records from other tables that are in scope for an assessment as table and record references.
    Assessment Instance to Scope Item

    [sn_smart_asmt_m2m_instance_scope_item]

    		 Many-to-many relationship table that is used to manage the mapping between assessment instances and scope items.
    Assessment Instance to Persona to Users

    [sn_smart_asmt_m2m_instance_persona]

    		 Many-to-many relationship table that is used to map users to personas for specific assessment instances. Tracks persona-level ownership via primary owner.
    Smart Assessment Combined Assessment

    [sn_smart_asmt_combined_assessment]

    		 Stores combined assessment records that aggregate multiple assessment instances into a unified view with aggregated metrics and auto-copy capability.
    Assessment Instance to Combined Assessment

    [sn_smart_asmt_m2m_instance_combined_assessment]

    		 Many-to-many relationship table that is used to manage the mapping between assessment instances and combined assessments, with aggregated question counts.
    Assessment Template Transaction

    [sn_smart_asmt_assessment_template_transaction]

    		 Stores template-level transaction records for operations such as publish, move to draft, copy, and create version. Tracks transaction status and error details.
    Combined Assessment Transaction

    [sn_smart_asmt_combined_assessment_transaction]

    		 Stores transaction records for copying responses, justifications, and attachments between combined assessment instances. Tracks transaction type and status.

    Tables installed with Smart Assessment Scoring

    Table 2. Tables installed with Smart Assessment Scoring (com.sn_smart_scoring)
    Table Description
    Metric

    [sn_smart_scoring_metric]

    		 Extends the sys_metadata table and stores scoring metric definitions for assessments, with support for normalization strategies.
    Pre Defined Metric

    [sn_smart_scoring_pre_defined_metric]

    		 Extends the Metric [sn_smart_scoring_metric] table and stores pre-built metrics based on questions, sections, or subsections with aggregation strategies including average, maximum, minimum, sum, and weighted average.
    Metric Instance

    [sn_smart_scoring_metric_instance]

    		 Stores runtime metric score values for a specific assessment instance, including both raw and normalized scores.
    Metric Mapping

    [sn_smart_scoring_metric_mapping]

    		 Extends the sys_metadata table. Many-to-many relationship table that is used to map metrics to sections within assessment templates for score aggregation.
    Question Scoring Predicate

    [sn_smart_scoring_question_scoring_predicate]

    		 Extends the Assessment Predicate [sn_smart_asmt_predicate] table and stores question-specific scoring rules with aggregation strategies and optional normalization.
    Scoring Normalization Strategy

    [sn_smart_scoring_normalization_strategy]

    		 Extends the sys_metadata table and stores reusable, system-provided normalization strategies defined via scripts. Read-only.
    Scoring Normalization Strategy Input

    [sn_smart_scoring_normalization_strategy_input]

    		 Extends the sys_metadata table and defines input parameters of number or choice type for normalization strategies. Read-only.
    Scoring Normalization Strategy Input Choice

    [sn_smart_scoring_normalization_strategy_input_choice]

    		 Extends the sys_metadata table and stores choice values for choice-type normalization strategy inputs. Read-only.
    Scoring Normalization Strategy Input Mapping

    [sn_smart_scoring_normalization_strategy_input_mapping]

    		 Extends the sys_metadata table and maps specific values to normalization strategy inputs at the template level for questions or metrics.

    Tables installed with Reusable Impact Framework

    Table 3. Tables installed with Reusable Impact Framework (com.sn_impact_fwk)
    Table Description
    Automated Action

    [sn_impact_fwk_automated_action]

    		 Extends the sys_metadata table and stores automated action definitions that reference Flow Designer subflows with input configuration.
    Automated Action Context

    [sn_impact_fwk_automated_action_context]

    		 Stores execution context for automated actions, including flow context, inputs, outputs, and execution status.
    Note:
    All additional tables installed by the dependent plugins are also needed for Smart Assessment Engine. The Scoring plugin also adds scoring-related fields such as enable_scoring, weight, default_score, score, and normalized_score to core tables such as sn_smart_asmt_question, sn_smart_asmt_template, sn_smart_asmt_section, sn_smart_asmt_question_instance, and sn_smart_asmt_section_instance.

    Tables installed with Smart Assessment Collaboration

    Table 4. Tables installed with Smart Assessment Collaboration (com.sn_smart_collab)
    Table Description
    Section Instance to Persona to Users

    [sn_smart_collab_m2m_section_instance_persona]

    		 Many-to-many relationship table that maps section instances to personas and their contributing users within an assessment instance.

    Tables installed with Smart Assessment Now Assist

    Table 5. Tables installed with Smart Assessment Now Assist (com.sn_smart_ai_assist)
    Table Description
    AI Response

    [sn_smart_ai_assist_ai_response]

    		 Extends the Assessment Question Instance [sn_smart_asmt_question_instance] table and stores AI-generated response suggestions for assessment questions, including the generation trigger, target question instance, and acceptance state.
    AI Response Source

    [sn_smart_ai_assist_ai_response_source]

    		 Stores source references for AI-generated responses. Base table for specialized source types such as record sources.
    AI Response Record Source

    [sn_smart_ai_assist_ai_response_record_source]

    		 Extends the AI Response Source [sn_smart_ai_assist_ai_response_source] table and stores specific record references used as sources for AI response generation, including table, record, and reason.
    AI Response Transaction

    [sn_smart_ai_assist_ai_response_transaction]

    		 Stores transaction records for AI response generation operations on assessment instances, tracking status, source types, question counts, and auto-populate settings.
    AI Transaction Result

    [sn_smart_ai_assist_ai_transaction_result]

    		 Stores individual results for each question within an AI response transaction, including source type, status, error details, and generated AI responses.

    Tables installed with Smart Assessment Impact Automation

    Table 6. Tables installed with Smart Assessment Impact Automation (com.sn_smart_imp_auto)
    Table Description
    Assessment Automation Rule

    [sn_smart_imp_auto_rule]

    		 Extends the sys_metadata table and stores automation rule definitions for assessment templates, including name, description, publication status, and enabled state.
    Assessment Action Set

    [sn_smart_imp_auto_action_set]

    		 Extends the Assessment Predicate [sn_smart_asmt_predicate] table and stores action set definitions that group assessment actions under an automation rule.
    Assessment Action

    [sn_smart_imp_auto_assessment_action]

    		 Extends the Automated Action [sn_impact_fwk_automated_action] table and stores assessment-specific automated actions linked to action sets and assessment templates, with active state and base record tracking.
    Assessment Action Set Instance

    [sn_smart_imp_auto_action_set_instance]

    		 Extends the Assessment Predicate Instance [sn_smart_asmt_predicate_instance] table and stores runtime instances of action set evaluations during assessment execution.
    Assessment Automated Action Context

    [sn_smart_imp_auto_action_context]

    		 Extends the Automated Action Context [sn_impact_fwk_automated_action_context] table and stores execution context for assessment-specific automated actions, linking rule instances to assessment instances.
    Assessment Rule Instance

    [sn_smart_imp_auto_rule_instance]

    		 Stores runtime instances of automation rules for specific assessment instances, linking automation rules to their execution context.
    Template Category to Action Category

    [sn_smart_imp_auto_m2m_temp_cat_to_action_cat]

    		 Extends the sys_metadata table. Many-to-many relationship table that maps assessment template categories to Flow Designer action categories.

    Tables installed with Smart Assessment Response Automation

    Table 7. Tables installed with Smart Assessment Response Automation (com.sn_smart_resp_auto)
    Table Description
    Response Automation Predicate Instance

    [sn_smart_resp_auto_predicate_instance]

    		 Extends the Assessment Predicate Instance [sn_smart_asmt_predicate_instance] table and stores runtime instances of response automation predicate evaluations, including question instance reference and error details.

    Tables installed with Smart Assessment Migration Tools

    Table 8. Tables installed with Smart Assessment Migration Tools (com.sn_smart_asmt_mig)
    Table Description
    Assessment Template Migration

    [sn_smart_asmt_mig_template_migration]

    		 Stores migration records for converting legacy assessment metric types to smart assessment templates, tracking source, target, purpose, migration status, and errors.
    Section Migration

    [sn_smart_asmt_mig_section_migration]

    		 Stores migration records for converting legacy metric categories to smart assessment sections within a template migration.
    Question Migration

    [sn_smart_asmt_mig_question_migration]

    		 Stores migration records for converting legacy metrics to smart assessment questions within a section migration.
    Response Option Migration

    [sn_smart_asmt_mig_response_option_migration]

    		 Stores migration records for converting legacy metric definitions and template definitions to smart assessment response options within a question migration.