Migrated question review
Summarize
Summary of Migrated Question Review
The Migrated Question Review process in ServiceNow focuses on ensuring accurate result calculations for migrated survey records. It is essential for users who need reliable survey data analysis after migrating from legacy systems. Adjustments may be necessary to align migrated survey questions and choices with the correct scoring system.
Show less
Key Features
- The assessment engine automatically calculates survey response scores on a scale of 0 to 10.
- Migrated legacy questions create corresponding records in the Assessment Metric and Metric Definition tables.
- For Multiple Choice and Select Box types, metric definitions are established based on legacy question choices and their order.
- The Scale definition determines the scoring interpretation; by default, higher values indicate better scores.
- Legacy questions without Order values are assigned metric definition Values in alphanumeric order.
Key Outcomes
Customers can expect to maintain accurate survey result calculations by reviewing and adjusting migrated questions as needed. Understanding the relationship between legacy question choices and their migrated metric definitions is crucial for effective survey analysis. Additionally, verifying and potentially modifying the Scale definition settings ensures that survey scores reflect the intended meanings.
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.