From Bright Pattern Documentation
< 5.3:Reporting-database-specification
Revision as of 04:09, 29 May 2024 by BpDeeplTranslateMaintenance (talk | contribs) (Updated via BpDeleteTranslateTags script)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
• 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 >