How legacy metric types are migrated to sections in templates
Summarize
Summary of How Legacy Metric Types are Migrated to Sections in Templates
The migration of legacy metric types to specific sections in assessment templates is a key feature of the Smart Assessment Engine application. This process involves mapping various metric types, categories, and definitions to designated fields within the assessment templates, ensuring a seamless transition for users. Understanding this mapping is crucial for customers to effectively utilize the updated features in their assessments.
Show less
Key Features
- Metric Types Mapping: Existing metric types are mapped to corresponding fields in the Assessment Template table, including translated names and descriptions.
- Metric Categories Mapping: Legacy metric categories are transitioned to the Section table with relevant names, descriptions, and order indices.
- Metrics Mapping: Metrics are assigned to the Question table, with details such as data types, mandatory status, and order being preserved during migration.
- Field Mapping: Existing fields are mapped to the Question table, ensuring that reference tables and filter conditions are appropriately aligned.
- Template Definitions Mapping: Assessment template definitions are also migrated, focusing on display text and order values for choices.
Key Outcomes
After migration, all Question records default to a data type of Text, with specific adjustments for numeric-scale questions. This organized mapping allows customers to maintain the integrity of their assessment data while leveraging new functionalities. By understanding how legacy metrics are converted, ServiceNow customers can effectively manage their assessment templates and ensure a structured approach to evaluations.
Legacy metric types are migrated to specific sections in the assessment templates in the Smart Assessment Engine application.
How metric types are mapped
This tables shows the mapping used to move the existing metric types to the section in the assessment templates.
| Existing metric type | Mapped to |
|---|---|
| Name (Translated text) (Max length 255) | Name (Translated text) field in the Assessment Template table. |
| Description (Translated text) (Max length 1000) | Description (Translated html) field in the Assessment Template table. |
| Table (Table Name) | Table (Table Name) field in the Context Item table. |
How metric categories are mapped
This tables shows the mapping used to move the existing metric categories to the section table in the assessment templates.
| Existing metric type | Mapped to the Section table |
|---|---|
| Name (Translated text) (Max length 255) | Name (Translated text) field. |
| Description (Translated text) (Max length 1000) | Description (Translated text) field. |
| Order (Integer) | Order (Order Index) field. |
How metrics are mapped
This tables shows the mapping used to move the existing metrics to the question table in the assessment templates.
| Existing metric type | Mapped to the Question table |
|---|---|
| Allow additional information (True/False) | Enable justification (True/False) field. |
| Data type (String) (Max length 40) | Based on the Data type field value, the appropriate question type reference is added to the Question table. Data type is string. |
| Details (Translated html) (Max length 8000) | Guidance statement (Translated html) field. |
| Question (Translated text) (Max length 512) | Label (Translated text) field. |
| Mandatory (True/False) | Is mandatory (True/False) field |
| Max (Integer) | Max number (Decimal) field |
| Min (Integer) | Minimum number (Decimal) field |
| Order (Integer) | Order (Order index) |
How metric types are migrated to question types
After migration, all Question records are set as data type Text.
After migration, all Question records whose source metric is template/Numeric-scale are set with a response layout of Horizontal.
This tables shows the mapping used to move the existing metric types to the question types in the assessment templates.
| Existing metric type | Mapped to |
|---|---|
| Attachment | Attachment |
| Choice | Drop-down list |
| Date | Date |
| Date/Time | Date/Time |
| Likert scale | Radio button |
| Multiple selection | Check box |
| Numeric scale | Radio button |
| Reference | Reference |
| Yes/No | Radio button |
How fields are mapped
This tables shows the mapping used to move the existing fields to the question table in the assessment templates.
| Field in the existing table | Mapped to the Question table |
|---|---|
| Reference table | Table field. |
| Condition | Filter condition field. |
How metric definitions are mapped
This tables shows the mapping used to move the existing metric definitions to the choice table in the assessment templates.
| Metric definition in the existing table | Mapped to the Choice table |
|---|---|
| Display | Text label field in the Choice table |
| Order | Integer data type is mapped to the Order field in the Choice table that is based on the same ascending sequence of the template-definition records in the Value field that is associated with a particular template. |
How assessment metric templates are mapped
Only templates where the Allow image field is set to false are migrated. No field mapping is done for this table.
Metrics whose data type is template are migrated as questions of the type Radio button if the Allow image field is set to false at the template level.
How assessment template definitions are mapped
This tables shows the mapping used to move the existing template definitions to the choice table in the assessment templates.
| Assessment template definition in the existing table | Mapped to the Choice table |
|---|---|
| Display | Text label field. |
| Value | Integer data type is mapped to the Order field in the Choice table, based on the same ascending sequence of the template-definition records in the Value field that is associated with a particular template. |