From Bright Pattern Documentation
(Created page with "<translate> = evaluation_results = QQQ The ''evaluation_results'' table contains QQQ == Description of Data == The following table offers the name (i.e., ID), data type (e.g...") |
|||
| Line 1: | Line 1: | ||
<translate> | <translate> | ||
= evaluation_results = | = evaluation_results = | ||
| − | + | The ''evaluation_results'' table contains metrics that describe the results, scores, and data associated with evaluation forms. | |
| − | The ''evaluation_results'' table contains | ||
| − | |||
== Description of Data == | == Description of Data == | ||
| Line 14: | Line 12: | ||
|- | |- | ||
|'''ID''' | |'''ID''' | ||
| − | | | + | |BINARY (16) |
| − | | | + | |Primary key |
|- | |- | ||
|'''FORM_ID''' | |'''FORM_ID''' | ||
| − | | | + | |BINARY |
| − | | | + | |Evaluation form identifier. |
| + | |||
| + | A new identifier is assigned to each new evaluation form. | ||
|- | |- | ||
|'''FORM_NAME''' | |'''FORM_NAME''' | ||
| − | | | + | |VARCHAR |
| − | | | + | |Name of the evaluation form |
|- | |- | ||
|'''LAYOUT''' | |'''LAYOUT''' | ||
| − | | | + | |VARCHAR |
| − | | | + | |Saved layout of the evaluation form |
|- | |- | ||
|'''LOGIN_ID''' | |'''LOGIN_ID''' | ||
| − | | | + | |VARCHAR |
| − | | | + | |Quality evaluator’s login as defined in configuration |
|- | |- | ||
|'''FORM_SCORE''' | |'''FORM_SCORE''' | ||
| − | | | + | |INT |
| − | | | + | |The score assigned by the quality evaluator for the given form |
|- | |- | ||
|'''EVALUATION_TIME''' | |'''EVALUATION_TIME''' | ||
| − | | | + | |DATETIME |
| − | | | + | |Evaluation time of the review activity. |
| + | |||
| + | Time is given in the Universal Coordinated Time (UTC) time zone | ||
|- | |- | ||
|'''REVIEW_TIME''' | |'''REVIEW_TIME''' | ||
| − | | | + | |DATETIME |
| − | | | + | |Start time of the review activity. |
| + | |||
| + | Time is given in the Universal Coordinated Time (UTC) time zone | ||
|- | |- | ||
|'''CDR_ID''' | |'''CDR_ID''' | ||
| − | | | + | |VARCHAR |
| − | | | + | |Identifier of the call detail record (CDR) |
|- | |- | ||
|'''STATUS''' | |'''STATUS''' | ||
| − | | | + | |VARCHAR |
| − | | | + | |Evaluation form status. |
| + | |||
| + | Possible statuses include: | ||
| + | * Accepted | ||
| + | * Completed | ||
| + | * Disputed | ||
| + | * Pending Calibrations | ||
| + | * Pending Confirmations | ||
|- | |- | ||
|'''TYPE''' | |'''TYPE''' | ||
| − | | | + | |VARCHAR |
| − | | | + | |Type of evaluation result |
|- | |- | ||
|'''TEAM_ID''' | |'''TEAM_ID''' | ||
| − | | | + | |VARCHAR |
| − | | | + | |Team of the agent that is being evaluated |
|- | |- | ||
|'''AGENT_ID''' | |'''AGENT_ID''' | ||
| − | | | + | |VARCHAR |
| − | | | + | |Agent identifier as defined in configuration |
|- | |- | ||
|'''CONFIRMED_ON''' | |'''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''' | |'''CONFIRMED_BY''' | ||
| − | | | + | |VARCHAR |
| − | | | + | |Identifier of the quality evaluator who confirmed the evaluation form |
|- | |- | ||
|'''BOOKMARK''' | |'''BOOKMARK''' | ||
| − | | | + | |VARCHAR |
| − | | | + | |Whether the evaluation form was bookmarked in QM Eval Home |
|- | |- | ||
|} | |} | ||
Revision as of 18:55, 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 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>