Migrated question review
Summarize
Summary of Migrated Question Review
The Migrated Question Review provides guidance on ensuring accurate result calculations for migrated survey records. Minor adjustments may be necessary for effective results, particularly for advanced survey implementations. If results calculation data is not needed, this section can be disregarded.
Show less
Key Features
- The assessment engine calculates survey responses on a scale of 0 to 10.
- Legacy survey questions are migrated to the Assessment Metric [asmtmetric] table, with corresponding choices recorded in the Assessment Metric Definition [asmtmetricdefinition] table.
- Order values from legacy questions determine the metric definition values, where the smallest Order equates to a value of 1.
- The default scale definition is set to High, indicating that larger values represent better scores, but this may need adjustment based on legacy question context.
Key Outcomes
Customers should verify that the scale definition aligns with the intent of each migrated question. For example, if a question’s choices rank quality, an “Excellent” choice should logically correspond to a high score. Adjustments to the Scale definition may be required for accurate metric representation across various question types.
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.