{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":18374,"path":"governance-risk-compliance/smart-assessment-engine/tables-installed-in-smart-assessment-engine.md","title":null,"bundle":null,"doc_type":null,"release":null,"body":"---\ntitle: Tables installed in Smart Assessment Engine\ndescription: Tables are added with activation of GRC: Smart Assessment Engine.\nlocale: en-US\ncanonical_url: https://www.servicenow.com/docs/r/australia/governance-risk-compliance/smart-assessment-engine/tables-installed-in-smart-assessment-engine.html\nrelease: australia\nproduct: Smart Assessment Engine\nclassification: smart-assessment-engine\ntopic_type: reference\nlast_updated: \"2026-04-13\"\nreading_time_minutes: 8\nbreadcrumb: [Components installed with Smart Assessment Engine, Reference, Smart Assessment Engine, Governance, Risk, and Compliance]\n---\n\n# Tables installed in Smart Assessment Engine\n\nTables are added with activation of GRC: Smart Assessment Engine.\n\n## Tables installed with Smart Assessment Core\n\n<table id=\"table_ut1_5wq_t3c\"><thead><tr><th>\n\nTable\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td>\n\nAssessment Template\\[sn\\_smart\\_asmt\\_template\\]\n\n</td><td>\n\nExtends the sys\\_metadata table and stores all assessment template definitions including name, description, publication status, versioning, and instructions.\n\n</td></tr><tr><td>\n\nAssessment Template Category\\[sn\\_smart\\_asmt\\_template\\_category\\]\n\n</td><td>\n\nExtends 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.\n\n</td></tr><tr><td>\n\nAssessment Template Contributor\\[sn\\_smart\\_asmt\\_template\\_contributor\\]\n\n</td><td>\n\nExtends 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.\n\n</td></tr><tr><td>\n\nSection\\[sn\\_smart\\_asmt\\_section\\]\n\n</td><td>\n\nExtends the sys\\_metadata table and stores sections within assessment templates. Supports hierarchical structure with subsections via parent/child relationships.\n\n</td></tr><tr><td>\n\nQuestion\\[sn\\_smart\\_asmt\\_question\\]\n\n</td><td>\n\nExtends 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.\n\n</td></tr><tr><td>\n\nQuestion Type\\[sn\\_smart\\_asmt\\_question\\_type\\]\n\n</td><td>\n\nExtends 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.\n\n</td></tr><tr><td>\n\nResponse Option\\[sn\\_smart\\_asmt\\_response\\_option\\]\n\n</td><td>\n\nExtends the sys\\_metadata table and stores answer options for choice-based questions. Supports text, currency, number, and date response labels.\n\n</td></tr><tr><td>\n\nAssessment Condition\\[sn\\_smart\\_asmt\\_condition\\]\n\n</td><td>\n\nExtends the sys\\_metadata table and stores reusable condition definitions as encoded queries. Used for visibility, preferred answer, justification, and attachment conditions on questions.\n\n</td></tr><tr><td>\n\nAssessment Predicate\\[sn\\_smart\\_asmt\\_predicate\\]\n\n</td><td>\n\nExtends the sys\\_metadata table and stores predicate definitions linking conditions to assessment templates. Base table for specialized predicates such as response automation and scoring.\n\n</td></tr><tr><td>\n\nResponse Automation Predicate\\[sn\\_smart\\_asmt\\_response\\_automation\\_predicate\\]\n\n</td><td>\n\nExtends 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.\n\n</td></tr><tr><td>\n\nQuestion to Assessment Condition\\[sn\\_smart\\_asmt\\_m2m\\_question\\_condition\\]\n\n</td><td>\n\nExtends 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.\n\n</td></tr><tr><td>\n\nAssessment Persona\\[sn\\_smart\\_asmt\\_persona\\]\n\n</td><td>\n\nExtends the sys\\_metadata table and stores persona or role definitions for assessment participation such as assessor and reviewer.\n\n</td></tr><tr><td>\n\nAssessment Workflow State\\[sn\\_smart\\_asmt\\_workflow\\_state\\]\n\n</td><td>\n\nExtends the sys\\_metadata table and stores workflow state definitions for assessment instances such as Draft, In Progress, and Completed.\n\n</td></tr><tr><td>\n\nContext Item\\[sn\\_smart\\_asmt\\_context\\_item\\]\n\n</td><td>\n\nExtends 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.\n\n</td></tr><tr><td>\n\nDescriptive Image\\[sn\\_smart\\_asmt\\_descriptive\\_image\\]\n\n</td><td>\n\nExtends the sys\\_metadata table and stores images associated with questions or sections to provide visual guidance, including alt text for accessibility.\n\n</td></tr><tr><td>\n\nAssessment Duration\\[sn\\_smart\\_asmt\\_duration\\]\n\n</td><td>\n\nStores time duration allocations for assessment templates.\n\n</td></tr><tr><td>\n\nAssessment Group\\[sn\\_smart\\_asmt\\_assessment\\_group\\]\n\n</td><td>\n\nStores assessment group records that group multiple assessment instances together. Tracks group status as open or closed.\n\n</td></tr><tr><td>\n\nSmart Assessment Instance\\[sn\\_smart\\_asmt\\_instance\\]\n\n</td><td>\n\nStores individual assessment instances created from templates. Tracks assessment state, due dates, response completion metrics, and audit trail including requestor and assigned personas.\n\n</td></tr><tr><td>\n\nAssessment Section Instance\\[sn\\_smart\\_asmt\\_section\\_instance\\]\n\n</td><td>\n\nStores 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.\n\n</td></tr><tr><td>\n\nAssessment Question Instance\\[sn\\_smart\\_asmt\\_question\\_instance\\]\n\n</td><td>\n\nStores 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.\n\n</td></tr><tr><td>\n\nResponse Option Instance\\[sn\\_smart\\_asmt\\_response\\_option\\_instance\\]\n\n</td><td>\n\nStores the selected or unselected state of each response option for a specific question instance in an assessment.\n\n</td></tr><tr><td>\n\nAssessment Predicate Instance\\[sn\\_smart\\_asmt\\_predicate\\_instance\\]\n\n</td><td>\n\nStores runtime instances of predicate evaluations during assessment execution, including condition result sets and final evaluation outcomes.\n\n</td></tr><tr><td>\n\nAssessment Condition Result Set\\[sn\\_smart\\_asmt\\_condition\\_result\\_set\\]\n\n</td><td>\n\nStores the aggregated boolean result of evaluated conditions at runtime. Referenced by question instances for visibility, preferred answer, justification, and attachment condition outcomes.\n\n</td></tr><tr><td>\n\nAssessment Condition Result\\[sn\\_smart\\_asmt\\_condition\\_result\\]\n\n</td><td>\n\nStores individual condition evaluation results within a condition result set, including the table, record, operator, and boolean outcome.\n\n</td></tr><tr><td>\n\nAssessment Scope Item\\[sn\\_smart\\_asmt\\_scope\\_item\\]\n\n</td><td>\n\nStores records from other tables that are in scope for an assessment as table and record references.\n\n</td></tr><tr><td>\n\nAssessment Instance to Scope Item\\[sn\\_smart\\_asmt\\_m2m\\_instance\\_scope\\_item\\]\n\n</td><td>\n\nMany-to-many relationship table that is used to manage the mapping between assessment instances and scope items.\n\n</td></tr><tr><td>\n\nAssessment Instance to Persona to Users\\[sn\\_smart\\_asmt\\_m2m\\_instance\\_persona\\]\n\n</td><td>\n\nMany-to-many relationship table that is used to map users to personas for specific assessment instances. Tracks persona-level ownership via primary owner.\n\n</td></tr><tr><td>\n\nSmart Assessment Combined Assessment\\[sn\\_smart\\_asmt\\_combined\\_assessment\\]\n\n</td><td>\n\nStores combined assessment records that aggregate multiple assessment instances into a unified view with aggregated metrics and auto-copy capability.\n\n</td></tr><tr><td>\n\nAssessment Instance to Combined Assessment\\[sn\\_smart\\_asmt\\_m2m\\_instance\\_combined\\_assessment\\]\n\n</td><td>\n\nMany-to-many relationship table that is used to manage the mapping between assessment instances and combined assessments, with aggregated question counts.\n\n</td></tr><tr><td>\n\nAssessment Template Transaction\\[sn\\_smart\\_asmt\\_assessment\\_template\\_transaction\\]\n\n</td><td>\n\nStores template-level transaction records for operations such as publish, move to draft, copy, and create version. Tracks transaction status and error details.\n\n</td></tr><tr><td>\n\nCombined Assessment Transaction\\[sn\\_smart\\_asmt\\_combined\\_assessment\\_transaction\\]\n\n</td><td>\n\nStores transaction records for copying responses, justifications, and attachments between combined assessment instances. Tracks transaction type and status.\n\n</td></tr></tbody>\n</table>## Tables installed with Smart Assessment Scoring\n\n<table id=\"table_nnj_cxq_t3c\"><thead><tr><th>\n\nTable\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td>\n\nMetric\\[sn\\_smart\\_scoring\\_metric\\]\n\n</td><td>\n\nExtends the sys\\_metadata table and stores scoring metric definitions for assessments, with support for normalization strategies.\n\n</td></tr><tr><td>\n\nPre Defined Metric\\[sn\\_smart\\_scoring\\_pre\\_defined\\_metric\\]\n\n</td><td>\n\nExtends 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.\n\n</td></tr><tr><td>\n\nMetric Instance\\[sn\\_smart\\_scoring\\_metric\\_instance\\]\n\n</td><td>\n\nStores runtime metric score values for a specific assessment instance, including both raw and normalized scores.\n\n</td></tr><tr><td>\n\nMetric Mapping\\[sn\\_smart\\_scoring\\_metric\\_mapping\\]\n\n</td><td>\n\nExtends the sys\\_metadata table. Many-to-many relationship table that is used to map metrics to sections within assessment templates for score aggregation.\n\n</td></tr><tr><td>\n\nQuestion Scoring Predicate\\[sn\\_smart\\_scoring\\_question\\_scoring\\_predicate\\]\n\n</td><td>\n\nExtends the Assessment Predicate \\[sn\\_smart\\_asmt\\_predicate\\] table and stores question-specific scoring rules with aggregation strategies and optional normalization.\n\n</td></tr><tr><td>\n\nScoring Normalization Strategy\\[sn\\_smart\\_scoring\\_normalization\\_strategy\\]\n\n</td><td>\n\nExtends the sys\\_metadata table and stores reusable, system-provided normalization strategies defined via scripts.\n\n</td></tr><tr><td>\n\nScoring Normalization Strategy Input\\[sn\\_smart\\_scoring\\_normalization\\_strategy\\_input\\]\n\n</td><td>\n\nExtends the sys\\_metadata table and defines input parameters of number or choice type for normalization strategies.\n\n</td></tr><tr><td>\n\nScoring Normalization Strategy Input Choice\\[sn\\_smart\\_scoring\\_normalization\\_strategy\\_input\\_choice\\]\n\n</td><td>\n\nExtends the sys\\_metadata table and stores choice values for choice-type normalization strategy inputs.\n\n</td></tr><tr><td>\n\nScoring Normalization Strategy Input Mapping\\[sn\\_smart\\_scoring\\_normalization\\_strategy\\_input\\_mapping\\]\n\n</td><td>\n\nExtends the sys\\_metadata table and maps specific values to normalization strategy inputs at the template level for questions or metrics.\n\n</td></tr></tbody>\n</table>## Tables installed with Reusable Impact Framework\n\n<table id=\"table_obg_2xq_t3c\"><thead><tr><th>\n\nTable\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td>\n\nAutomated Action\\[sn\\_impact\\_fwk\\_automated\\_action\\]\n\n</td><td>\n\nExtends the sys\\_metadata table and stores automated action definitions that reference Flow Designer subflows with input configuration.\n\n</td></tr><tr><td>\n\nAutomated Action Context\\[sn\\_impact\\_fwk\\_automated\\_action\\_context\\]\n\n</td><td>\n\nStores execution context for automated actions, including flow context, inputs, outputs, and execution status.\n\n</td></tr></tbody>\n</table>**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.\n\n## Tables installed with Smart Assessment Collaboration\n\n<table id=\"table_collab\"><thead><tr><th>\n\nTable\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td>\n\nSection Instance to Persona to Users\\[sn\\_smart\\_collab\\_m2m\\_section\\_instance\\_persona\\]\n\n</td><td>\n\nMany-to-many relationship table that maps section instances to personas and their contributing users within an assessment instance.\n\n</td></tr></tbody>\n</table>## Tables installed with Smart Assessment ServiceNow Otto\n\n<table id=\"table_now_assist\"><thead><tr><th>\n\nTable\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td>\n\nAI Response\\[sn\\_smart\\_ai\\_assist\\_ai\\_response\\]\n\n</td><td>\n\nExtends 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.\n\n</td></tr><tr><td>\n\nAI Response Source\\[sn\\_smart\\_ai\\_assist\\_ai\\_response\\_source\\]\n\n</td><td>\n\nStores source references for AI-generated responses. Base table for specialized source types such as record sources.\n\n</td></tr><tr><td>\n\nAI Response Record Source\\[sn\\_smart\\_ai\\_assist\\_ai\\_response\\_record\\_source\\]\n\n</td><td>\n\nExtends 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.\n\n</td></tr><tr><td>\n\nAI Response Transaction\\[sn\\_smart\\_ai\\_assist\\_ai\\_response\\_transaction\\]\n\n</td><td>\n\nStores transaction records for AI response generation operations on assessment instances, tracking status, source types, question counts, and auto-populate settings.\n\n</td></tr><tr><td>\n\nAI Transaction Result\\[sn\\_smart\\_ai\\_assist\\_ai\\_transaction\\_result\\]\n\n</td><td>\n\nStores individual results for each question within an AI response transaction, including source type, status, error details, and generated AI responses.\n\n</td></tr></tbody>\n</table>## Tables installed with Smart Assessment Impact Automation\n\n<table id=\"table_impact_auto\"><thead><tr><th>\n\nTable\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td>\n\nAssessment Automation Rule\\[sn\\_smart\\_imp\\_auto\\_rule\\]\n\n</td><td>\n\nExtends the sys\\_metadata table and stores automation rule definitions for assessment templates, including name, description, publication status, and enabled state.\n\n</td></tr><tr><td>\n\nAssessment Action Set\\[sn\\_smart\\_imp\\_auto\\_action\\_set\\]\n\n</td><td>\n\nExtends the Assessment Predicate \\[sn\\_smart\\_asmt\\_predicate\\] table and stores action set definitions that group assessment actions under an automation rule.\n\n</td></tr><tr><td>\n\nAssessment Action\\[sn\\_smart\\_imp\\_auto\\_assessment\\_action\\]\n\n</td><td>\n\nExtends 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.\n\n</td></tr><tr><td>\n\nAssessment Action Set Instance\\[sn\\_smart\\_imp\\_auto\\_action\\_set\\_instance\\]\n\n</td><td>\n\nExtends the Assessment Predicate Instance \\[sn\\_smart\\_asmt\\_predicate\\_instance\\] table and stores runtime instances of action set evaluations during assessment execution.\n\n</td></tr><tr><td>\n\nAssessment Automated Action Context\\[sn\\_smart\\_imp\\_auto\\_action\\_context\\]\n\n</td><td>\n\nExtends 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.\n\n</td></tr><tr><td>\n\nAssessment Rule Instance\\[sn\\_smart\\_imp\\_auto\\_rule\\_instance\\]\n\n</td><td>\n\nStores runtime instances of automation rules for specific assessment instances, linking automation rules to their execution context.\n\n</td></tr><tr><td>\n\nTemplate Category to Action Category\\[sn\\_smart\\_imp\\_auto\\_m2m\\_temp\\_cat\\_to\\_action\\_cat\\]\n\n</td><td>\n\nExtends the sys\\_metadata table. Many-to-many relationship table that maps assessment template categories to Flow Designer action categories.\n\n</td></tr></tbody>\n</table>## Tables installed with Smart Assessment Response Automation\n\n<table id=\"table_resp_auto\"><thead><tr><th>\n\nTable\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td>\n\nResponse Automation Predicate Instance\\[sn\\_smart\\_resp\\_auto\\_predicate\\_instance\\]\n\n</td><td>\n\nExtends 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.\n\n</td></tr></tbody>\n</table>## Tables installed with Smart Assessment Migration Tools\n\n<table id=\"table_mig_tools\"><thead><tr><th>\n\nTable\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td>\n\nAssessment Template Migration\\[sn\\_smart\\_asmt\\_mig\\_template\\_migration\\]\n\n</td><td>\n\nStores migration records for converting legacy assessment metric types to smart assessment templates, tracking source, target, purpose, migration status, and errors.\n\n</td></tr><tr><td>\n\nSection Migration\\[sn\\_smart\\_asmt\\_mig\\_section\\_migration\\]\n\n</td><td>\n\nStores migration records for converting legacy metric categories to smart assessment sections within a template migration.\n\n</td></tr><tr><td>\n\nQuestion Migration\\[sn\\_smart\\_asmt\\_mig\\_question\\_migration\\]\n\n</td><td>\n\nStores migration records for converting legacy metrics to smart assessment questions within a section migration.\n\n</td></tr><tr><td>\n\nResponse Option Migration\\[sn\\_smart\\_asmt\\_mig\\_response\\_option\\_migration\\]\n\n</td><td>\n\nStores migration records for converting legacy metric definitions and template definitions to smart assessment response options within a question migration.\n\n</td></tr></tbody>\n</table>"}}