From Bright Pattern Documentation
(Created page with "<translate> = custom_field_names = QQQ The ''custom_field_names'' 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> | ||
= custom_field_names = | = custom_field_names = | ||
− | + | The ''custom_field_names'' table contains QQQ | |
− | The ''custom_field_names'' table contains | ||
− | QQQ | ||
== Description of Data == | == Description of Data == | ||
Line 14: | Line 12: | ||
|- | |- | ||
|'''category''' | |'''category''' | ||
− | | | + | |VARCHAR |
− | | | + | | The custom fields category as defined in configuration. |
+ | |||
+ | Possible categories are: | ||
+ | * Activity History | ||
+ | * Case | ||
+ | * Company | ||
+ | * Contact | ||
+ | * Knowledge Base | ||
+ | |- | ||
+ | |'''custom_field''' | ||
+ | |INT (11) | ||
+ | |The custom field as defined by the customer in configuration | ||
|- | |- | ||
|'''name''' | |'''name''' | ||
− | | | + | |VARCHAR |
− | | | + | |The name of the custom field as defined in configuration |
|- | |- | ||
|'''start_time''' | |'''start_time''' | ||
|DATETIME | |DATETIME | ||
|Start time of the aggregation interval | |Start time of the aggregation interval | ||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
|} | |} |
Revision as of 18:54, 11 September 2018
<translate>
custom_field_names
The custom_field_names table contains QQQ
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 |
category | VARCHAR | The custom fields category as defined in configuration.
Possible categories are:
|
custom_field | INT (11) | The custom field as defined by the customer in configuration |
name | VARCHAR | The name of the custom field as defined in configuration |
start_time | DATETIME | Start time of the aggregation interval |
</translate>