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)
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" |