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