From Bright Pattern Documentation
Jump to: navigation, search
(Created page with "<translate> = evaluation_result_details = The ''evaluation_result_details'' table contains metrics that describe the results, scores, and data associated with evaluation forms...")
 
Line 18: Line 18:
 
|'''AREA_NAME'''
 
|'''AREA_NAME'''
 
|VARCHAR
 
|VARCHAR
|255
+
|1023
 
|Name of the evaluation area on the evaluation form
 
|Name of the evaluation area on the evaluation form
 
|"Upsell/Cross-sell"
 
|"Upsell/Cross-sell"
Line 48: Line 48:
 
|'''QUESTION_NAME'''
 
|'''QUESTION_NAME'''
 
|VARCHAR
 
|VARCHAR
|255
+
|1023
 
|The name of the question on the evaluation form
 
|The name of the question on the evaluation form
 
|"The information given to the customer was correct"
 
|"The information given to the customer was correct"

Revision as of 16:26, 31 March 2020

• 5.19 • 5.3 • 5.8

evaluation_result_details

The evaluation_result_details table contains metrics that describe the results, scores, and data associated with evaluation forms.

Note that some of the metrics given are specific to Bright Pattern Omni QM and they are accessible only if your service provider has enabled Omni QM for your contact center.

Description of Data

The following table offers the name (i.e., ID), data type (e.g., BIGINT, BINARY, BIT, DATETIME, ENUM, INT, VARCHAR, etc.), and description for each metric (i.e., column) of the evaluation_result_details table.


Column Name Data Type Character Maximum Length Description Example
AREA_NAME VARCHAR 1023 Name of the evaluation area on the evaluation form "Upsell/Cross-sell"
COMMENT LONGTEXT 4,294,967,295 Text comment written by the quality evaluator on the evaluation form "Don't forget to repeat all information"
ID VARCHAR 64 Primary key "12FB3B1F4CD04e0F988269B283068AB1"
OPTION_NAME VARCHAR 255 Name of the answer option on the evaluation form "Yes"
ORDER_IN_FORM INT - The numeric order of the question/answer as it appears on the evaluation form "14"
QUESTION_NAME VARCHAR 1023 The name of the question on the evaluation form "The information given to the customer was correct"
RESULT_ID BINARY 16 The evaluation result identifier "5311E2893DDA4745985F6BB72C7F8946"
SCORE INT - The numeric score (out of 100) given on the evaluation form "100"


< Previous | Next >