Cargo query
Showing below up to 100 results in range #101 to #200.
View (previous 100 | next 100) (20 | 50 | 100 | 250 | 500)
| Page | colName | dataType Ora | dataType MSSQL | dataType Postgre | dataType DB2 | primaryKey | mandatoryKey | foreignKey | defaultValue | colDesc | introduced | modified | discontinued | KVP | xpath | mandatoryForGIM | transformDefault |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS BOT NAME DIM | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. This ID is referenced from other tables as BGS_BOT_NAME_DIM_KEY. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION DIM | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools—that is, applications that need to identify newly added data. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION DIM | ENDED_ABNORMALLY | NUMBER(10) | int | integer | yes | 0 | Indicates whether the session ended abnormally for a technical reason (for example, a protocol or connection error resulted in disconnection of the bot from the session): 0 = No, 1 = Yes. | /session_stats/cbs_endedAbnormally | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION DIM | ENDED_BY | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | NO_VALUE | The type of participant that initiated termination of the BGS session. Possible values are:
For more information about the meaning of the values, see Integrating BGS with Genesys Historical Reporting in the Bot Gateway Server Quick Start Guide. |
/session_stats/cbs_endedBy | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION DIM | END_REASON | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | NO_VALUE | The reason the BGS session was terminated. For information about possible values, see Integrating BGS with Genesys Historical Reporting in the Bot Gateway Server Quick Start Guide. | /session_stats/cbs_endReason | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION DIM | END_RESULT | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | NO_VALUE | The business result of the session: Success or Fail. In the initial BGS implementation of support for reporting, BGS does not populate the applicable data attribute, and END_RESULT will always be populated with the default value defined in the schema. | /session_stats/cbs_endResult | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION DIM | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. This ID is referenced from other tables as BGS_SESSION_DIM_KEY. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION DIM | REJECTED_TO_START | NUMBER(10) | int | integer | yes | 0 | Indicates whether the session was rejected before it started: 0 = No, 1 = Yes. If the session was rejected (REJECTED_TO_START=1), the columns for other session statistics in this table are populated with the default values defined in the schema. |
/session_info/cbs_rejectedToStart | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | BGS_BOT_DIM_KEY | NUMBER(10) | int | integer | yes | -2 | The surrogate key that is used to join the BGS_BOT_DIM dimension to the fact table, to identify the category and function of the bot used in the session. | /chatBot_info/chatBot_category, /chatBot_info/chatBot_function | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | BGS_BOT_NAME_DIM_KEY | NUMBER(10) | int | integer | yes | -2 | The surrogate key that is used to join the BGS_BOT_NAME_DIM dimension to the fact table, to identify the name of the bot used in the session. | /chatBot_info/chatBot_name | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | BGS_SESSION_DIM_KEY | NUMBER(10) | int | integer | yes | -2 | The surrogate key that is used to join the BGS_SESSION_DIM dimension to the fact table, to describe characteristics of the session. | /session_info/cbs_rejectedToStart, /session_stats/cbs_endedAbnormally, /session_stats/cbs_endedBy, /session_stats/cbs_endReason, /session_stats/cbs_endResult | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | CBS_ID | VARCHAR2(50 CHAR) | varchar(50)/nvarchar(50) | varchar(50) | yes | yes | The ID assigned by BGS to every bot instance or process connected to the Chat Server session. In combination with START_DATE_TIME_KEY, CBS_ID forms the value of the composite primary key for this table in nonpartitioned as well as partitioned databases. | /session_info/cbs_id | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools—that is, applications that need to identify newly added data. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | DURATION | NUMBER(10) | int | integer | yes | 0 | The duration, in milliseconds, of the BGS session. | /session_stats/cbs_duration | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | END_DATE_TIME_KEY | NUMBER(10) | int | integer | yes | yes | Identifies the start of a 15-minute interval in which the BGS session ended or was rejected. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts that are related to the same interval and/or convert the END_TS timestamp to an appropriate time zone. | /cbs_endTime | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | END_TS | NUMBER(10) | int | integer | yes | The UTC-equivalent value of the date and time at which the BGS session ended or was rejected. | /cbs_endTime | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | INTERACTION_SDT_KEY | NUMBER(10) | int | integer | yes | yes | The value of the START_DATE_TIME_KEY field of the INTERACTION_FACT record that is identified by the MEDIA_SERVER_IXN_GUID field. In a partitioned database, INTERACTION_SDT_KEY in combination with MEDIA_SERVER_IXN_GUID forms the value of the composite primary key for the INTERACTION_FACT table. | /session_info/attr_itx_submitted_at | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | MEDIA_SERVER_IXN_GUID | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | The interaction GUID, as reported by Interaction Server. This value is the ID of the chat session. This GUID might not be unique. The value allows you to associate bot session details with chat session details by using the following references:
|
/session_info/attr_itx_id | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | MEDIA_TYPE_KEY | NUMBER(10) | int | integer | yes | yes | -2 | The surrogate key that is used to join the MEDIA_TYPE dimension to the fact tables. The MEDIA_TYPE_KEY references the MEDIA_TYPE dimension record where the value of the reporting data attribute matches MEDIA_TYPE.MEDIA_NAME_CODE. | /session_info/attr_itx_media_type | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | MESSAGES_RECEIVED | NUMBER(10) | int | integer | yes | 0 | The number of messages received by the bot in the BGS session. | /session_stats/cbs_messagesReceived | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | MESSAGES_SENT | NUMBER(10) | int | integer | yes | 0 | The number of messages sent by the bot in the BGS session. | /session_stats/cbs_messagesSent | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | START_DATE_TIME_KEY | NUMBER(10) | int | integer | yes | yes | yes | Identifies the start of a 15-minute interval in which the bot session was initiated in BGS, regardless of whether it was accepted or rejected. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts that are related to the same interval and/or convert the START_TS timestamp to an appropriate time zone. In combination with CBS_ID, START_DATE_TIME_KEY forms the value of the composite primary key for this table in nonpartitioned as well as partitioned databases. | /session_info/cbs_startTime | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | START_TS | NUMBER(10) | int | integer | yes | The UTC-equivalent value of the date and time at which the bot session was initiated in BGS, regardless of whether the session was accepted or rejected. | /session_info/cbs_startTime | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | TENANT_KEY | NUMBER(10) | int | integer | yes | yes | -2 | The surrogate key that is used to join the TENANT dimension to the fact tables. | /session_info/attr_itx_tenant_id | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BGS SESSION FACT | UPDATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools—that is, applications that need to identify recently modified data. | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BOT ATTRIBUTES | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify newly added data. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BOT ATTRIBUTES | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BOT ATTRIBUTES | NAME | VARCHAR2(255 CHAR) | nvarchar(255) | varchar(255) | yes | NO_VALUE | The name of the bot, as defined for the bot resource in the Bot Registry in Designer. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BOT ATTRIBUTES | OUTCOME | VARCHAR2(32 CHAR) | nvarchar(32) | varchar(32) | yes | NO_VALUE | Indicates whether the bot session succeeded or failed. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BOT ATTRIBUTES | PROVIDER | VARCHAR2(255 CHAR) | nvarchar(255) | varchar(255) | yes | NO_VALUE | The bot service provider for the specified bot type. For example: Google. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BOT ATTRIBUTES | TYPE | VARCHAR2(32 CHAR) | nvarchar(32) | varchar(32) | yes | NO_VALUE | The type of bot, as defined for the bot resource in the Bot Registry. For example: Dialogflow. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BOT INTENT | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify newly added data. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BOT INTENT | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-BOT INTENT | INTENT | VARCHAR2(255 CHAR) | nvarchar(255) | varchar(255) | yes | NO_VALUE | The customer's intent, which is a possible outcome of the bot session. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALL RESULT | CALL_RESULT | VARCHAR2(32 CHAR) | nvarchar(32) | varchar(32) | The description of the call result. This value can change with localization. The following are possible values: None |
8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALL RESULT | CALL_RESULT_CODE | VARCHAR2(32 CHAR) | nvarchar(32) | varchar(32) | The code for the call result description. This value does not change with localization. The following are possible values: NONE |
8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALL RESULT | CALL_RESULT_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join this dimension table to the fact tables. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALL RESULT | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify newly added data. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALL RESULT | UPDATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify recently modified data. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIAL RESULTS | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify newly added data. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIAL RESULTS | DIAL_1_RESULT | VARCHAR2(64 CHAR) | nvarchar(64) | varchar(64) | yes | UNKNOWN | The result of the first dialing attempt. Possible values are:
|
8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | _CB_DIAL_1_RESULT | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIAL RESULTS | DIAL_2_RESULT | VARCHAR2(64 CHAR) | nvarchar(64) | varchar(64) | yes | UNKNOWN | The result of the second dialing attempt. See DIAL_1_RESULT for the possible values. | 8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | _CB_DIAL_2_RESULT | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIAL RESULTS | DIAL_3_RESULT | VARCHAR2(64 CHAR) | nvarchar(64) | varchar(64) | yes | UNKNOWN | The result of the third dialing attempt. See DIAL_1_RESULT for the possible values. | 8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | _CB_DIAL_3_RESULT | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIAL RESULTS | DIAL_4_RESULT | VARCHAR2(64 CHAR) | nvarchar(64) | varchar(64) | yes | UNKNOWN | The result of the fourth dialing attempt. See DIAL_1_RESULT for the possible values. | 8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | _CB_DIAL_4_RESULT | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIAL RESULTS | DIAL_5_RESULT | VARCHAR2(64 CHAR) | nvarchar(64) | varchar(64) | yes | UNKNOWN | The result of the fifth dialing attempt. See DIAL_1_RESULT for the possible values. | 8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | _CB_DIAL_5_RESULT | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIAL RESULTS | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. This ID is referenced from other tables as CALLBACK_DIAL_RESULTS_KEY. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 1 | CALLBACK_OFFER_TYPE | VARCHAR2(255 CHAR) | nvarchar(170) | varchar(255) | yes | UNKNOWN | The type of callback offer that was presented to the customer. For example, after business hours, SCHEDULED is the only available option; during business hours, business rules might allow only the WAIT_FOR_AGENT option or a combination of SCHEDULED and WAIT_FOR_AGENT. This field is set to one of the following values:
|
8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) • 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | _CB_DIM_CALLBACK_OFFER_TYPE | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 1 | CALLBACK_TYPE | VARCHAR2(255 CHAR) | nvarchar(170) | varchar(255) | yes | UNKNOWN | The type of callback the customer requested. This field is set to one of the following values:
|
8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) • 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | _CB_DIM_TYPE | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 1 | CHANNEL | VARCHAR2(255 CHAR) | nvarchar(170) | varchar(255) | yes | UNKNOWN | The interaction channel from which the callback originated. This field is set to one of the following values:
|
8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) • 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | _CB_DIM_CHANNEL | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 1 | CONNECT_ORDER | VARCHAR2(255 CHAR) | nvarchar(170) | varchar(255) | yes | UNKNOWN | The order in which the final callback interaction was connected. This field is set to one of the following values:
|
8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) • 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | _CB_DIM_CONNECT_ORDER | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 1 | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify newly added data. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 1 | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. This ID is referenced from other tables as CALLBACK_DIM_1_KEY. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 2 | CALL_DIRECTION | VARCHAR2(255 CHAR) | nvarchar(170) | varchar(255) | yes | UNKNOWN | The direction of the final callback interaction. This field is set to one of the following values:
|
8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) • 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | _CB_DIM_CALL_DIRECTION | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 2 | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify newly added data. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 2 | DIAL_DIALOG_RESULT | VARCHAR2(255 CHAR) | nvarchar(170) | varchar(255) | yes | UNKNOWN | The result of the final dialog for the callback. This field is set to one of the following values:
|
8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) • 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | _CB_DIM_DIAL_DIALOG_RESULT | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 2 | FINAL_DIAL_RESULT | VARCHAR2(255 CHAR) | nvarchar(170) | varchar(255) | yes | UNKNOWN | The result of the final callback dialing attempt. This field is set to one of the following values:
Notes:
|
8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) • 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | _CB_DIM_FINAL_DIAL_RESULT | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 2 | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. This ID is referenced from other tables as CALLBACK_DIM_2_KEY. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 2 | OFFER_TIMING | VARCHAR2(255 CHAR) | nvarchar(170) | varchar(255) | yes | UNKNOWN | Specifies whether the callback offer was made during operational (business) or non-operational hours. This field is set to one of the following values:
|
8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) • 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | _CB_DIM_OFFER_TIMING | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 3 | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify newly added data. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 3 | DISPOSITION | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | UNKNOWN | The state of the callback, in the format state.substate. If the state cannot be reported, the field is set to the default value, UNKNOWN. Supported states are:
Supported substates are:
|
8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) | _CB_DISPOSITION | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 3 | FINAL_TARGET | VARCHAR2(255 CHAR) | nvarchar(170) | varchar(255) | yes | UNKNOWN | The routing target that was used to find the agent. | 8.5.014.34 (in Microsoft SQL Server, data type changed from varchar to nvarchar in single-language databases) • 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | _CB_DIM_FINAL_TARGET | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 3 | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. This ID is referenced from other tables as CALLBACK_DIM_3_KEY. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 4 | ABANDONED_DURING_CB_OFFER | NUMBER(10) | int | integer | yes | 0 | Indicates whether the caller dropped the call without explicitly accepting or rejecting the callback offer: 0 = No, 1 = Yes. | _CB_N_ABANDONED_DURING_CALLBACK_OFFER | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 4 | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify newly added data. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 4 | DIAL_IGNORING_AVAILABILITY | NUMBER(10) | int | integer | yes | 0 | Indicates whether the callback queue is being flushed, and dialing (or push notification) is being forced regardless of actual agent availability: 0 = No, 1 = Yes. A value of 1 might occur at the end of the day, when contact center personnel are trying to close the queue for the day and do not want to leave any callbacks for the next day. |
_CB_IXN_START_IGNORING_AVAILABILITY | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK DIM 4 | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. This ID is referenced from other tables as CALLBACK_DIM_4_KEY. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | ABANDONED_WAITING | NUMBER(10) | int | integer | yes | 0 | Indicates whether the customer abandoned the callback interaction while waiting to be connected to an agent: 0 = No, 1 = Yes. | _CB_N_CUSTOMER_ABANDONED_WHILE_WAITING_FOR_AGENT | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | ADDED_TS | NUMBER(10) | int | integer | yes | yes | The UTC-equivalent value of the date and time at which the event with callback data is received. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | AGENT_ADDED_TO_IXN | NUMBER(10) | int | integer | yes | 0 | Indicates whether the agent was successfully added to the callback interaction: 0 = No, 1 = Yes. | _CB_N_AGENT_ADDED_TO_IXN | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CALLBACK_ACCEPTED | NUMBER(10) | int | integer | yes | 0 | Indicates whether a callback offer was accepted: 0 = No, 1 = Yes. | _CB_N_CALLBACK_ACCEPTED | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CALLBACK_ACCEPTED_TS | NUMBER(10) | int | integer | yes | 0 | The UTC timestamp at the time the callback offer was accepted. | _CB_T_CALLBACK_ACCEPTED | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CALLBACK_ATTEMPTS | NUMBER(10) | int | integer | yes | 0 | The total number of callback attempts or notifications, both successful and unsuccessful. | _CB_N_CALLBACK_MEDIA_ATTEMPTS | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CALLBACK_DIAL_RESULTS_KEY | NUMBER(10) | int | integer | yes | The surrogate key that is used to join the CALLBACK_DIAL_RESULTS dimension to the fact table, by the record ID. | 8.5.009.20 | -2 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CALLBACK_DIM_1_KEY | NUMBER(10) | int | integer | yes | yes | -2 | The surrogate key that is used to join the CALLBACK_DIM_1 dimension to the fact table, by the record ID. | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CALLBACK_DIM_2_KEY | NUMBER(10) | int | integer | yes | yes | -2 | The surrogate key that is used to join the CALLBACK_DIM_2 dimension to the fact table, by the record ID. | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CALLBACK_DIM_3_KEY | NUMBER(10) | int | integer | yes | yes | -2 | The surrogate key that is used to join the CALLBACK_DIM_3 dimension to the fact table, by the record ID. | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CALLBACK_DIM_4_KEY | NUMBER(10) | int | integer | yes | The surrogate key that is used to join the CALLBACK_DIM_4 dimension to the fact table, by the record ID. | 8.5.009.20 | -2 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CALLBACK_OFFERED | NUMBER(10) | int | integer | yes | Indicates whether callback was offered, at least once, during the session: 0 = No, 1 = Yes. | _CB_N_CALLBACK_OFFERED | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CALLBACK_OFFERED_TS | NUMBER(10) | int | integer | yes | The UTC timestamp at the time the callback was offered. | _CB_T_CALLBACK_OFFERED | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CALLBACK_OFFERS_PER_SESSION | NUMBER(10) | int | integer | yes | 0 | The number of times a callback was offered to the customer during the current interaction. | _CB_N_CALLBACK_OFFERS_PER_SESSION | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CALLBACK_OFFER_TIME | NUMBER(10) | int | integer | yes | The duration of the callback offer, in seconds. | _CB_D_CALLBACK_OFFER | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CONN_WAITING_AGENT_TIME | NUMBER(10) | int | integer | yes | 0 | The amount of time, in seconds, the customer was waiting to be connected to the agent after the callback interaction was established. | _CB_D_CUSTOMER_CONNECTED_WAITING_FOR_AGENT | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify newly added data. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CUSTOMER_ANI | VARCHAR2(20 CHAR) | varchar(20)/nvarchar(20) | varchar(20) | The ANI of the customer for in-queue scenarios. This value might match CUSTOMER_PHONE_NUMBER if the same number is confirmed or entered, or the field might be empty if the ANI is not detected. | 8.5.009.20 | _CB_CUSTOMER_ANI | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CUSTOMER_CONNECTED_TS | NUMBER(10) | int | integer | yes | 0 | The UTC timestamp at the time the customer was reconnected to the contact center and started waiting for an agent to be connected. | _CB_T_CUSTOMER_CONNECTED | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CUSTOMER_PHONE_NUMBER | VARCHAR2(255 CHAR) | varchar(255)/nvarchar(255) | varchar(255) | The customer phone number that was used for the callback interaction, if available. | _CB_CUSTOMER_PHONE_NUMBER | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | CUSTOMER_READY_TO_START_IXN_TS | NUMBER(10) | int | integer | yes | 0 | The UTC timestamp at the time the customer is ready to start the callback interaction. This field is populated for Inbound Callback scenarios. Typically, the value is set to the time when the application sends a request for an access number to dial and an access code to match the call. In cases when no special confirmation is sent about push delivery, this value is the same as _CB_T_PUSH_DELIVERY_CONFIRMED. Note: Genesys recommends to use a separate confirmation for push delivery. |
8.5.003 | _CB_T_CUSTOMER_READY_TO_START_MEDIA_IXN | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | DESIRED_TIME | NUMBER(10) | int | integer | The UTC equivalent of the scheduled callback time that was promised to the customer. For ASAP callback requests, this time equals to the CALLBACK_ACCEPTED_TS value. | 8.5.003 (renamed to DESIRED_TIME_TS) | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | DESIRED_TIME_TS | NUMBER(10) | int | integer | yes | 0 | The UTC equivalent of the scheduled callback time that was promised to the customer. For ASAP callback requests, this time equals to the CALLBACK_ACCEPTED_TS value. | 8.5.003 (renamed from DESIRED_TIME) | _CB_T_DESIRED_TIME | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | DIAL_1_TS | NUMBER(10) | int | integer | The UTC timestamp of the first dialing attempt. | 8.5.009.20 | _CB_T_DIAL_1 | 0 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | DIAL_2_TS | NUMBER(10) | int | integer | The UTC timestamp of the second dialing attempt. | 8.5.009.20 | _CB_T_DIAL_2 | 0 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | DIAL_3_TS | NUMBER(10) | int | integer | The UTC timestamp of the third dialing attempt. | 8.5.009.20 | _CB_T_DIAL_3 | 0 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | DIAL_4_TS | NUMBER(10) | int | integer | The UTC timestamp of the fourth dialing attempt. | 8.5.009.20 | _CB_T_DIAL_4 | 0 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | DIAL_5_TS | NUMBER(10) | int | integer | The UTC timestamp of the fifth dialing attempt. | 8.5.009.20 | _CB_T_DIAL_5 | 0 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | DS_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | yes | The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The value of this field equals the audit key of the GIDB table from which the callback-related data is taken. | 8.5.008 (data type increased from 10 to 19 digits) | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | ESTABLISH_MEDIA_IXN_TIME | NUMBER(10) | int | integer | yes | 0 | The amount of time, in seconds, it took to establish the callback interaction, such as an outbound call. | _CB_D_ESTABLISH_MEDIA_IXN | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | EVENT_SEQUENCE | NUMBER(10) | int | integer | yes | yes | The number of this event relative to other events associated with the same callback service. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | EWT_READY_TO_START_IXN | NUMBER(10) | int | integer | yes | 0 | The value of Expected Wait Time (EWT), in seconds, for the service request at the time the contact center was ready to start the first callback interaction, such as an outbound dialing attempt. | _CB_EWT_WHEN_READY_TO_START_MEDIA_IXN | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | EWT_THRESHOLD_WHEN_OFFERED | NUMBER(10) | int | integer | The value of the EWT threshold the callback application used to decide whether the callback offer should be made. | 8.5.009.20 | _CB_EWT_THRESHOLD_WHEN_OFFERED | 0 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | EWT_WHEN_LAST_DIAL | NUMBER(10) | int | integer | EWT, in seconds, at the time the last callback dialing attempt was made or the last push notification sent. | 8.5.009.20 | _CB_EWT_WHEN_READY_TO_START_LAST_MEDIA_IXN | 0 |