Migrated question review
Summarize
Summary of Migrated question review
This content explains how to manage and adjust migrated survey questions in ServiceNow to ensure accurate result calculations. It focuses on the migration of legacy survey questions and their conversion into records within the Assessment Metric tables, which are essential for the assessment engine’s score calculation between 0 and 10.
Show less
Key details on migrated survey questions
- Each legacy question is migrated to a survey question record in the Assessment Metric [asmtmetric] table.
- For Multiple Choice and Select Box legacy questions, corresponding metric definition records are created in the Assessment Metric Definition [asmtmetricdefinition] table for each choice.
- The system uses the legacy Order of survey choices to assign numerical Value fields to metric definitions, starting at 1 for the smallest Order value.
- If no Order values exist, ServiceNow assigns metric values based on the alphanumeric order of the choice text.
- The Scale definition field on the migrated Survey Question form indicates whether higher or lower metric values correspond to better scores, defaulting to "High" (higher values are better).
Practical implications for ServiceNow customers
- After migration, review and adjust the Scale definition for each question to ensure scoring logic aligns with the meaning of responses (e.g., "Excellent" should not yield the worst score).
- Minor adjustments to metric definition values or scale settings may be required to maintain accurate result calculations, especially for advanced survey implementations.
- If you do not intend to use survey result calculation data, these adjustments can be safely ignored.
Why this matters
Proper configuration of migrated survey questions and metric definitions ensures that ServiceNow’s assessment engine calculates survey results accurately and meaningfully. Incorrect metric values or scale settings could result in misleading scores, impacting reporting and decision-making based on survey data.
Next steps
- Verify metric definition values and scale settings for each migrated survey question.
- Consult scale definition recommendations for specific question data types to guide adjustments.
- Refer to related tasks such as "Migrate a legacy survey" for detailed migration processes.
To maintain accurate result calculations, you may need to make minor adjustments to some of the migrated survey records to ensure results are calculated correctly.
For each legacy question migrated, the system creates a survey question record on the Assessment Metric [asmt_metric] table. For legacy questions of the Multiple Choice and Select Box types, the system also creates a metric definition record, on the Assessment Metric Definition [asmt_metric_definition] table, for each legacy question choice.
| Survey question choice field | Related metric definition field |
|---|---|
| Text | Display |
| Value (can be any string value) | Value (must be a numerical value) |
| Order | Value (metric definition with smallest Value is first) |
When the system migrates legacy survey question choices, it uses the legacy Order to set each metric definition Value. For the legacy question choice with the smallest Order, the corresponding metric definition Value is set to 1. For the legacy question choice with the next smallest Order, the metric definition Value is 2, and so on.
The Scale definition field on the migrated Survey Question form determines whether smaller or bigger metric definition values equate to a good score in survey result calculations. By default, the scale definition is set to High, meaning bigger values are good. When you migrate a legacy survey, check that the default scale definition makes sense for each question.
For example, the following tables depict a sample migrated question and the metric definitions automatically created for it. Recall that the system uses the order of the legacy survey question choices to set the metric definition value. Excellent has the lowest Order value, so when the system creates a metric definition for this question choice, the Value is set to 1. In this case the default scale definition value, High, does not make sense, as the system will calculate the worst scores for responses of Excellent.
| Question choice text | Question choice vlue | Question choice order |
|---|---|---|
| Excellent | A | 100 |
| Good | B | 200 |
| Fair | C | 300 |
| Poor | D | 400 |
| Metric definition display | Metric definition value |
|---|---|
| Excellent | 1 |
| Good | 2 |
| Fair | 3 |
| Poor | 4 |
If there are no Order values for the legacy survey question choices, the system sets each corresponding metric definition Value based on the alphanumeric order of the legacy Text value.
| Metric definition display | Metric definition value |
|---|---|
| Excellent | 1 |
| Good | 2 |
| Fair | 3 |
| Poor | 4 |
You may also need to change the Scale definition setting for other migrated questions. For details, see the scale definition recommendations for each survey question data type.