From Bright Pattern Documentation
<translate>
evaluation_results
The evaluation_results table contains metrics that describe the results, scores, and data associated with evaluation forms.
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 agent_performance table.
| Column Name | Data Type | Description |
| ID | BINARY (16) | Primary key |
| FORM_ID | BINARY | Evaluation form identifier.
A new identifier is assigned to each new evaluation form. |
| FORM_NAME | VARCHAR | Name of the evaluation form |
| LAYOUT | VARCHAR | Saved layout of the evaluation form |
| LOGIN_ID | VARCHAR | Quality evaluator’s login as defined in configuration |
| FORM_SCORE | INT | The score assigned by the quality evaluator for the given form |
| EVALUATION_TIME | DATETIME | Evaluation time of the review activity.
Time is given in the Universal Coordinated Time (UTC) time zone |
| REVIEW_TIME | DATETIME | Start time of the review activity.
Time is given in the Universal Coordinated Time (UTC) time zone |
| CDR_ID | VARCHAR | Identifier of the call detail record (CDR) |
| STATUS | VARCHAR | Evaluation form status.
Possible statuses include:
|
| TYPE | VARCHAR | Type of evaluation result |
| TEAM_ID | VARCHAR | Team of the agent that is being evaluated |
| AGENT_ID | VARCHAR | Agent identifier as defined in configuration |
| CONFIRMED_ON | DATETIME | Start time for when the evaluation form was confirmed
Time is given in the Universal Coordinated Time (UTC) time zone |
| CONFIRMED_BY | VARCHAR | Identifier of the quality evaluator who confirmed the evaluation form |
| BOOKMARK | VARCHAR | Whether the evaluation form was bookmarked in QM Eval Home |
</translate>