From Bright Pattern Documentation
| Line 12: | Line 12: | ||
|'''Description''' | |'''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 the Universal Coordinated Time (UTC) time zone | ||
| + | |- | ||
| + | |'''CDR_ID''' | ||
| + | |VARCHAR | ||
| + | |Identifier of the call detail record (CDR) | ||
| + | |- | ||
| + | |'''EVALUATION_TIME''' | ||
| + | |DATETIME | ||
| + | |Evaluation time of the review activity. | ||
| + | |||
| + | Time is given in the Universal Coordinated Time (UTC) time zone | ||
|- | |- | ||
|'''FORM_ID''' | |'''FORM_ID''' | ||
| Line 25: | Line 49: | ||
|VARCHAR | |VARCHAR | ||
|Name of the evaluation form | |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''' | |'''LAYOUT''' | ||
| Line 33: | Line 65: | ||
|VARCHAR | |VARCHAR | ||
|Quality evaluator’s login as defined in configuration | |Quality evaluator’s login as defined in configuration | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
|'''REVIEW_TIME''' | |'''REVIEW_TIME''' | ||
| Line 49: | Line 71: | ||
Time is given in the Universal Coordinated Time (UTC) time zone | Time is given in the Universal Coordinated Time (UTC) time zone | ||
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
|'''STATUS''' | |'''STATUS''' | ||
| Line 64: | Line 82: | ||
* Pending Calibrations | * Pending Calibrations | ||
* Pending Confirmations | * Pending Confirmations | ||
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
|'''TEAM_ID''' | |'''TEAM_ID''' | ||
| Line 73: | Line 87: | ||
|Team of the agent that is being evaluated | |Team of the agent that is being evaluated | ||
|- | |- | ||
| − | |''' | + | |'''TYPE''' |
|VARCHAR | |VARCHAR | ||
| − | | | + | |Type of evaluation result |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
|} | |} | ||
Revision as of 19:19, 12 September 2018
<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 the Universal Coordinated Time (UTC) time zone |
| CDR_ID | VARCHAR | Identifier of the call detail record (CDR) |
| EVALUATION_TIME | DATETIME | Evaluation time of the review activity.
Time is given in the Universal Coordinated Time (UTC) time zone |
| 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 the Universal Coordinated Time (UTC) time zone |
| 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>