Cargo query
Showing below up to 250 results in range #101 to #350.
View (previous 250 | next 250) (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 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | EWT_WHEN_OFFERED | NUMBER(10) | int | integer | yes | 0 | The value of EWT, in seconds, at the time the callback was offered. | _CB_EWT_WHEN_CALLBACK_WAS_OFFERED | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | EWT_WHEN_REJECTED | NUMBER(10) | int | integer | Estimated Wait Time for the queue where rejected callbacks and calls not offered callbacks are being placed. This value is identical to EWT_WHEN_OFFERED if the same Virtual Queue is used to place accepted callbacks. | 8.5.009.20 | _CB_OFFER_EWT_INBOUND_VQ | 0 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | FINAL_RECORD | NUMBER(10) | int | integer | yes | 0 | Indicates whether this is a final record about this callback service: 0 = No, 1 = Yes. | _CB_FINAL_RECORD | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | FIRST_OUT_IXN_ID | VARCHAR2(64 CHAR) | varchar(64) | varchar(64) | The call ID of the first outbound call created by the callback module. | 8.5.009.20 | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | _CB_FIRST_OUT_IXN_ID | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | IXN_REQ_AGENT | NUMBER(10) | int | integer | yes | 0 | For internal use. | _CB_N_IXN_REQ_AGENT | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | LAST_CALLBACK_OFFERED_TS | NUMBER(10) | int | integer | yes | 0 | The UTC timestamp of the final callback offer during the current interaction. | 8.5.008 (default value added) | _CB_T_LAST_CALLBACK_OFFERED | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | LAST_CALLBACK_OFFER_TIME | NUMBER(10) | int | integer | yes | 0 | The duration, in seconds, of the final callback offer. | _CB_D_LAST_CALLBACK_OFFER | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | LAST_OUT_IXN_ID | VARCHAR2(64 CHAR) | varchar(64) | varchar(64) | The call ID of the last outbound call created by the callback module. | 8.5.009.20 | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | _CB_LAST_OUT_IXN_ID | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | ORIGINATION_IXN_ID | VARCHAR2(64 CHAR) | varchar(64) | varchar(64) | The ID of the interaction for which the callback was originally offered and accepted. For voice calls, this is the call ID of the original inbound call. For chat scenarios, this is the chat interaction ID. | 8.5.009.20 | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | _CB_ORIGINATION_IXN_ID | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | ORS_SESSION_ID | VARCHAR2(64 CHAR) | varchar(64) | varchar(64) | The Orchestration Server (ORS) session ID used to manage the callback. If multiple sessions were used (for example, because an ORS session terminated unexpectedly during the callback), the last session ID is reported. | 8.5.009.20 | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | _CB_ORS_SESSION_ID | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | POS_READY_TO_START_IXN | NUMBER(10) | int | integer | yes | 0 | The customer position in the queue at the time the contact center was ready to start the first callback interaction, such as an outbound dialing attempt. | _CB_POS_WHEN_READY_TO_START_MEDIA_IXN | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | POS_WHEN_LAST_DIAL | NUMBER(10) | int | integer | The position of the callback in the queue at the time the last dialing attempt was made or the last push notification sent. | 8.5.009.20 | _CB_POS_WHEN_READY_TO_START_LAST_MEDIA_IXN | 0 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | POS_WHEN_OFFERED | NUMBER(10) | int | integer | yes | 0 | The customer position in the queue at the time callback was offered. | _CB_POS_WHEN_CALLBACK_WAS_OFFERED | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | PRIORITY_WHEN_A_CONNECTED | NUMBER(10) | int | integer | The priority of the virtual interaction at the time the customer was connected to the agent. If the customer abandoned the call while waiting in the queue, then this value is the priority of the call at the time the customer disconnected. | 8.5.009.20 | _CB_PRIORITY_AT_THE_END_OF_ONLINE_WAIT | 0 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | PRIORITY_WHEN_CB_ACCEPTED | NUMBER(10) | int | integer | The priority of the interaction (real or virtual) at the time the callback offer was accepted. | 8.5.009.20 | _CB_PRIORITY_WHEN_CALLBACK_ACCEPTED | 0 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | PRIORITY_WHEN_C_CONNECTED | NUMBER(10) | int | integer | The priority of the virtual interaction at the time the customer was connected. | 8.5.009.20 | _CB_PRIORITY_WHEN_CUSTOMER_CONNECTED | 0 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | PRODUCER_BATCH_ID | NUMBER(19) | numeric(19) | numeric(19) | Reserved for internal use. | 8.5.015.19 | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | PUSH_DELIVERY_CONFIRMED_TS | NUMBER(10) | int | integer | yes | 0 | The UTC timestamp at the time the application confirmed receipt of push notification. This field is populated for Inbound Callback scenarios. | 8.5.003 | _CB_T_PUSH_DELIVERY_CONFIRMED | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | READY_START_MEDIA_IXN_TS | NUMBER(10) | int | integer | yes | 0 | The UTC timestamp at the time the contact center was ready to start the callback interaction. The value matches the time of either an outbound dialing attempt or a push notification prompting the customer to start a call or chat session. | _CB_T_READY_TO_START_MEDIA_IXN | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | RESOURCE_KEY | NUMBER(10) | int | integer | yes | yes | -2 | The surrogate key that is used to join the RESOURCE_ dimension to the fact tables, to identify the virtual queue where the callback request was waiting for execution. | _CB_DIM_VQ_DBID,_CB_DIM_VQ | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | SERVICE_END_TS | NUMBER(10) | int | integer | The UTC timestamp at the time the callback service was completed or terminated. | 8.5.009.20 | _CB_T_SERVICE_END | 0 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | SERVICE_ID | VARCHAR2(255 CHAR) | varchar(255) | varchar(255) | yes | The ID of the callback service request. Depending on the scenario, the value equals the ID of the GMS service instance or ID of the ORS session. The value allows you to associate interaction details with the callback details by using the following references: CALLBACK_FACT.SERVICE_ID = IRF_USER_DATA_GEN_1.SERVICE_ID From IRF_USER_DATA_GEN_1, you can then link in the usual way to IRF records. |
_CB_SERVICE_ID | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | SERVICE_START_TS | NUMBER(10) | int | integer | yes | The UTC timestamp at the time the callback service started. This value represents either the time of the callback request or the time that the callback offer was played, depending on deployment. | _CB_T_SERVICE_START | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | START_DATE_TIME_KEY | NUMBER(10) | int | integer | yes | yes | yes | This is the DATE_TIME_KEY equivalent of the SERVICE_START_TS value. | _CB_T_SERVICE_START | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | TENANT_KEY | NUMBER(10) | int | integer | yes | yes | -1 | The surrogate key that is used to join the TENANT dimension to the fact tables, to indicate the tenant of the IRF resource. The value of this field is identical to the value in the corresponding IRF record. Use this value to restrict data access. | _CB_TENANT_DBID | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | TIMEOUT_WAITING | NUMBER(10) | int | integer | yes | 0 | Indicates whether the customer was disconnected because the timeout for waiting for an agent was reached: 0 = No, 1 = Yes. | _CB_N_TIMEOUT_WHILE_WAITING_FOR_AGENT | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK 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. | 8.5.010.16 | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | WAITED_BEFORE_OFFER_TIME | NUMBER(10) | int | integer | The amount of time, in seconds, the customer waited in the queue before a callback was offered. | 8.5.009.20 | _CB_D_CUSTOMER_WAITED_BEFORE_OFFER | 0 | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | WAIT_AGENT_OFFLINE_TIME | NUMBER(10) | int | integer | yes | 0 | The amount of time, in seconds, the customer was waiting offline for an agent to become available. | _CB_D_WAITING_FOR_AGENT_OFFLINE | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLBACK FACT | XFER_TO_AGENT_FAILED | NUMBER(10) | int | integer | yes | 0 | Number of times the callback interaction failed to transfer to the agent. | _CB_N_TRANSFER_TO_AGENT_FAILED | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | ACTIVE_FLAG | NUMBER(1) | numeric(1) | numeric(1) | Indicates whether the calling list metric is currently active. Always 0. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | CALLING_LIST_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join the CALLING_LIST dimension to the fact tables. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | CALLING_LIST_METRIC_FACT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | The primary key of this table. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | CAMPAIGN_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join the CAMPAIGN dimension to the fact tables. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | CAMP_GROUP_SESSION_FACT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | The value of the primary key of the CAMPAIGN_GROUP_SESSION_FACT table. | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | CAMP_GROUP_SESS_FACT_SDT_KEY | NUMBER(10) | int | integer | yes | The value of the START_DATE_TIME_KEY field of the record in the CAMPAIGN_GROUP_ SESSION_FACT table. On a partitioned database, CAMP_GROUP_SESS_FACT_SDT_KEY in combination with CAMP_GROUP_SESSION_FACT_KEY forms a value of the composite primary key for the CAMPAIGN_GROUP_SESSION_FACT table. |
|||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC 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-CALLING LIST METRIC FACT | GMT_TS | NUMBER(10) | int | integer | The GMT-equivalent date and time at which measurement occurred, as the number of seconds that have elapsed since midnight on January 1, 1970. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | NOT_PROCESSED_CONTACTS | NUMBER(10) | int | integer | The total number of contacts in the calling list that have not been processed (where a set of chained records for the same customer is considered to be one contact). | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | NOT_PROCESSED_RECORDS | NUMBER(10) | int | integer | The total number of records in the calling list that are ready to be processed and that have never been processed as part of this calling list. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | PRODUCER_BATCH_ID | NUMBER(19) | numeric(19) | numeric(19) | Reserved for internal use. | 8.5.015.19 | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | PURGE_FLAG | NUMBER(1) | numeric(1) | numeric(1) | This field is reserved. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | START_DATE_TIME_KEY | NUMBER(10) | int | integer | yes | yes | Identifies the start of a 15-minute interval in which the fact began. Use this value as a key to join the fact tables to any configured DATE_TIME dimension. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | TENANT_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join the TENANT dimension to the fact tables. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | TOTAL_CONTACTS | NUMBER(10) | int | integer | The total number of contacts in the calling list (where a set of chained records for the same customer is considered to be one contact). | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | TOTAL_RECORDS | NUMBER(10) | int | integer | The total number of records in the calling list. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CALLING LIST METRIC FACT | 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-CAMPAIGN GROUP SESSION FACT | ACTIVE_FLAG | NUMBER(1) | numeric(1) | numeric(1) | Indicates whether the campaign group session is currently active: 0 = No, 1 = Yes. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT | CAMPAIGN_GROUP_SESSION_ID | VARCHAR2(64 CHAR) | varchar(64) | varchar(64) | The ICON source SessID for the campaign group session with which this session fact is related. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT | CAMPAIGN_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join the CAMPAIGN dimension to the fact tables. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT | CAMP_GROUP_SESSION_FACT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | The primary key of this table. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP 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-CAMPAIGN GROUP SESSION FACT | END_DATE_TIME_KEY | NUMBER(10) | int | integer | yes | yes | Identifies the start of a 15-minute interval in which the campaign group session ended. 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. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT | END_TS | NUMBER(10) | int | integer | The meaning depends on the value of ACTIVE_FLAG. For an inactive row, this field represents the UTC-equivalent value of the date and time at which the campaign group session ended. For an active row, this value represents a UTC-equivalent value of the date and time far in the future, so that applications do not have to test for null. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT | GROUP_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join the GROUP_ dimension to the fact tables. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT | PRODUCER_BATCH_ID | NUMBER(19) | numeric(19) | numeric(19) | Reserved for internal use. | 8.5.015.19 | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT | PURGE_FLAG | NUMBER(1) | numeric(1) | numeric(1) | This field is reserved. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT | START_DATE_TIME_KEY | NUMBER(10) | int | integer | yes | yes | Identifies the start of a 15-minute interval in which the campaign group session began. 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. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT | START_TS | NUMBER(10) | int | integer | The UTC-equivalent value of the date and time at which the campaign group session began. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT | TENANT_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join the TENANT dimension to the fact tables. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT | TOTAL_DURATION | NUMBER(10) | int | integer | The meaning depends on the value of ACTIVE_ FLAG. For an inactive row, the total duration, in seconds, of the campaign group session. For an active row, the duration, in seconds, that the campaign group session was active, from start time to the time that the ETL last executed. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP SESSION FACT | 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-CAMPAIGN GROUP STATE | CAMPAIGN_GROUP_STATE | VARCHAR2(32 CHAR) | nvarchar(32) | varchar(32) | The campaign group session state. This field is set to one of the following values:
This value can change with localization. |
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-CAMPAIGN GROUP STATE | CAMPAIGN_GROUP_STATE_CODE | VARCHAR2(32 CHAR) | nvarchar(32) | varchar(32) | The code for the campaign group session state. This field is set to one of the following values:
This value does not change with localization. |
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-CAMPAIGN GROUP STATE | CAMPAIGN_GROUP_STATE_KEY | NUMBER(10) | int | integer | yes | yes | The primary key of this table and the surrogate key that is used to join this dimension table to the fact tables. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE | 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-CAMPAIGN GROUP STATE | 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-CAMPAIGN GROUP STATE FACT | ACTIVE_FLAG | NUMBER(1) | numeric(1) | numeric(1) | Indicates whether the campaign group state is currently active: 0 = No, 1 = Yes. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | CAMPAIGN_GROUP_SESSION_ID | VARCHAR2(64 CHAR) | varchar(64) | varchar(64) | The ICON source SessID for the campaign group session with which this session fact is related. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | CAMPAIGN_GROUP_STATE_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join the CAMPAIGN_GROUP_STATE dimension to the fact tables. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | CAMPAIGN_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join the CAMPAIGN dimension to the fact tables. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | CAMP_GROUP_SESSION_FACT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | The value of the primary key of the CAMPAIGN_GROUP_SESSION_FACT table. This surrogate key is used to join this campaign group state fact to its campaign group session fact. In other words, this key places the campaign group state within the context of a campaign group session. | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | CAMP_GROUP_SESS_FACT_SDT_KEY | NUMBER(10) | int | integer | yes | The value of the START_DATE_TIME_KEY field of the record in the CAMPAIGN_GROUP_SESSION_FACT table. On a partitioned database, CAMP_GROUP_SESS_FACT_SDT_KEY in combination with CAMP_GROUP_SESSION_FACT_KEY forms a value of the composite primary key for the CAMPAIGN_GROUP_SESSION_FACT table. | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | CAMP_GROUP_STATE_FACT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | The primary key of this table. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE 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-CAMPAIGN GROUP STATE FACT | END_DATE_TIME_KEY | NUMBER(10) | int | integer | yes | yes | Identifies the start of a 15-minute interval in which this state for the campaign group ended. 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. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | END_TS | NUMBER(10) | int | integer | The meaning depends on the value of ACTIVE_FLAG. For an inactive row, this field represents the UTC-equivalent value of the date and time at which this state for the campaign group ended. For an active row, this value represents a UTC-equivalent value of the date and time far in the future, so that applications do not have to test for null. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | GROUP_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join the GROUP_ dimension to the fact tables. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | PRODUCER_BATCH_ID | NUMBER(19) | numeric(19) | numeric(19) | Reserved for internal use. | 8.5.015.19 | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | PURGE_FLAG | NUMBER(1) | numeric(1) | numeric(1) | This field is reserved. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | START_DATE_TIME_KEY | NUMBER(10) | int | integer | yes | yes | Identifies the start of a 15-minute interval in which this state for the campaign group began. 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. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | START_TS | NUMBER(10) | int | integer | The UTC-equivalent value of the date and time at which the campaign group entered this state. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | TENANT_KEY | NUMBER(10) | int | integer | yes | yes | The surrogate key that is used to join the TENANT dimension to the fact tables. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | TOTAL_DURATION | NUMBER(10) | int | integer | The meaning depends on the value of ACTIVE_FLAG. For an inactive row, the total duration, in seconds, of the campaign group in started state. For an active row, the amount of time, in seconds, that the campaign group has been in started state, from the time that it entered started state to the time that the ETL last executed. | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CAMPAIGN GROUP STATE FACT | 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-CDR DIM1 | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR DIM1 | DEVICE_CLASS | NUMBER(10) | int | integer | yes | 0 | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR DIM1 | DEVICE_DBID | NUMBER(10) | int | integer | yes | -1 | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR DIM1 | DEVICE_NAME | VARCHAR2(255 CHAR) | nvarchar(255) | varchar(255) | yes | UNKNOWN | 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-CDR DIM1 | DIRECTION | NUMBER(10) | int | integer | yes | -1 | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR DIM1 | ID | NUMBER(10) | int | integer | yes | yes | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | ANI | VARCHAR2(255 CHAR) | varchar(255)/nvarchar(255) | varchar(255) | |||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | CALLUUID | VARCHAR2(64 CHAR) | varchar(64) | varchar(64) | yes | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | CALL_ID | VARCHAR2(255 CHAR) | varchar(255) | varchar(255) | yes | 8.5.015.07 (size of the column increased) | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | CDR_DIM1_KEY | NUMBER(10) | int | integer | yes | -2 | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | CREATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | yes | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | DN | VARCHAR2(255 CHAR) | varchar(255)/nvarchar(255) | varchar(255) | yes | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | DNIS | VARCHAR2(255 CHAR) | varchar(255)/nvarchar(255) | varchar(255) | |||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | ESTABLISHED_TS | NUMBER(10) | int | integer | |||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | INITIATED_TS | NUMBER(10) | int | integer | yes | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | PARTYUUID | VARCHAR2(64 CHAR) | varchar(64) | varchar(64) | yes | yes | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | PRODUCER_BATCH_ID | NUMBER(19) | numeric(19) | numeric(19) | Reserved for internal use. | 8.5.015.19 | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | RELEASED_TS | NUMBER(10) | int | integer | yes | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | ROOT_CALLUUID | VARCHAR2(64 CHAR) | varchar(64) | varchar(64) | |||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | START_DATE_TIME_KEY | NUMBER(10) | int | integer | yes | yes | yes | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CDR FACT | UPDATE_AUDIT_KEY | NUMBER(19) | numeric(19) | numeric(19) | yes | ||||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION DIM | ASYNC_MODE | NUMBER(10) | int | integer | yes | 0 | Identifies whether the chat session is regular (0) or asynchronous (1). | 8.5.011.14 | csg_ChatAsyncMode | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT 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-CHAT SESSION DIM | ENDED_BY | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | unknown | The type of participant that initiated termination of the Chat Server session. Possible values are:
For more information about the meaning of the values, see the JD note: Update link Integrating with Genesys Historical Reporting page in the eServices Administrator's Guide. |
csg_SessionEndedBy | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION DIM | ENDED_REASON | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | unknown | The reason the Chat Server session was terminated. Possible values are:
For more information about the meaning of the values, and the types of participants for which they apply, see the Integrating with Genesys Historical Reporting page in the eServices Administrator's Guide. |
csg_SessionEndedReason | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION DIM | ID | NUMBER(10) | int | integer | yes | yes | The primary key of this table. This ID is referenced from other tables as CHAT_SESSION_DIM_KEY. | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION DIM | LANGUAGE_NAME | VARCHAR2(50 CHAR) | nvarchar(50) | varchar(50) | yes | unknown | The name of the language used in the chat session, as defined in the Chat Server application. | csg_LanguageName | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION DIM | MEDIA_ORIGIN | VARCHAR2(64 CHAR) | nvarchar(64) | varchar(64) | yes | unknown | Identifies where the chat session originated (web chat, social media channels, SMS, and so on). | csg_MediaOrigin | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | ACTIVE_IDLE_COUNT | NUMBER(10) | int | integer | The total number of times when an inactivity period exceeded a configured threshold while at least one agent was connected to the async chat session (that is, while the chat session was technically in an active state). | 8.5.011.14 | cse_ActiveIdleTotalCount | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | ACTIVE_IDLE_DURATION | NUMBER(10) | int | integer | The total time of inactivity, in seconds, in the async chat session while at least one agent was connected (that is, while the chat session was technically in an active state). | 8.5.011.14 | cse_ActiveIdleTotalTime | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | ADDED_TS | NUMBER(10) | int | integer | yes | The UTC-equivalent value of the date and time at which the event with chat data is received. | |||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | AGENTS_COUNT | NUMBER(10) | int | integer | yes | 0 | The number of unique parties that participated in the chat session as agents. | csg_PartiesAsAgentCount | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | AGENT_REPLY_COUNT | NUMBER(10) | int | integer | yes | 0 | The total number of agent replies to the customer. | cse_AgentReplyTotalCount | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | AGENT_REPLY_DURATION | NUMBER(10) | int | integer | yes | 0 | The total amount of time, in seconds, the agent(s) spent replying to the customer. Note: For async chat interactions, if a chat session was in a dormant state while a customer message was received, the time until the agent(s) rejoined the session is excluded. |
cse_AgentReplyTotalTime | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | AGENT_REPLY_MAX_DURATION | NUMBER(10) | int | integer | yes | 0 | The maximum amount of time, in seconds, the agent(s) spent replying to the customer (in other words, the maximum amount of time that elapsed between the customer's response and the time the first agent actually sent a reply). If the customer's response was a set of messages, the reply interval is calculated from the time the first message in the set was received. Note: For asynchronous (async) chat interactions, if a chat session was in a dormant state while a customer message was received, the time until the agent(s) rejoined the session is excluded. |
cse_AgentReplyMaxTime | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | AGENT_WAIT_COUNT | NUMBER(10) | int | integer | yes | 0 | The number of times the agent(s) waited for a reply from the customer. | cse_AgentWaitTotalCount | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | AGENT_WAIT_DURATION | NUMBER(10) | int | integer | yes | 0 | The total amount of time, in seconds, the agent(s) spent waiting for a reply from the customer. If there were multiple agents on the chat, a time interval is counted only once. Note: For async chat interactions, cumulative dormant time until a customer's reply is received is excluded. |
cse_AgentWaitTotalTime | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | AGENT_WAIT_MAX_DURATION | NUMBER(10) | int | integer | yes | 0 | The maximum amount of time, in seconds, the agent(s) spent waiting for a reply from the customer (in other words, the maximum amount of time that elapsed between the last response from any agent and the customer's reply). If the agent was waiting for a reply to a set of messages, the wait interval is calculated from the time the last message in the set was sent. Note: For async chat interactions, cumulative dormant time until a customer's reply is received is excluded. |
cse_AgentWaitMaxTime | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | ASYNC_DORMANT_COUNT | NUMBER(10) | int | integer | The total number of times that the async chat session was put in a dormant state (no agent was connected to the async chat session with the customer). | 8.5.011.14 | cse_AsyncDormantTotalCount | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | ASYNC_DORMANT_DURATION | NUMBER(10) | int | integer | The total amount of time, in seconds, that the async chat session spent in a dormant state (no agent was connected to the async chat session with the customer). Routing time is excluded from this value. | 8.5.011.14 | cse_AsyncDormantTotalTime | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | ASYNC_IDLE_COUNT | NUMBER(10) | int | integer | The total number of times when an inactivity period exceeded a configured threshold while no agent was connected to the async chat session (that is, while the chat session was in a dormant state). | 8.5.011.14 | cse_AsyncIdleTotalCount | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | ASYNC_IDLE_DURATION | NUMBER(10) | int | integer | The total time of inactivity, in seconds, in the async chat session while no agent was connected (that is, while the chat session was in a dormant state). | 8.5.011.14 | cse_AsyncIdleTotalTime | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | BOTS_COUNT | NUMBER(10) | int | integer | yes | 0 | The number of unique parties that participated in the chat session as bots. | csg_PartiesAsBotCount | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | CHAT_SESSION_DIM_KEY | NUMBER(10) | int | integer | yes | yes | -2 | The surrogate key that is used to join the CHAT_SESSION_DIM dimension to the fact table, to identify typical characteristics of the chat session. | csg_SessionEndedBy, csg_SessionEndedReason, csg_LanguageName, csg_MediaOrigin, csg_ChatAsyncMode | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT 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-CHAT SESSION FACT | CUSTOMER_REPLY_COUNT | NUMBER(10) | int | integer | yes | 0 | The number of times the customer replied to the agent(s). | cse_CustomerReplyTotalCount | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | CUSTOMER_REPLY_DURATION | NUMBER(10) | int | integer | yes | 0 | The total amount of time, in seconds, the customer spent replying to the agent(s). | cse_CustomerReplyTotalTime | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | CUSTOMER_REPLY_MAX_DURATION | NUMBER(10) | int | integer | yes | 0 | The maximum amount of time, in seconds, the customer spent replying to the agent(s). If the customer was replying to a set of messages, the reply interval is calculated from the time the first message in the set was received. | cse_CustomerReplyMaxTime | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | CUSTOMER_WAIT_COUNT | NUMBER(10) | int | integer | yes | 0 | The number of times the customer waited for a reply from an agent. | cse_CustomerWaitTotalCount | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | CUSTOMER_WAIT_DURATION | NUMBER(10) | int | integer | yes | 0 | The total amount of time, in seconds, the customer spent waiting for a reply from an agent. | cse_CustomerWaitTotalTime | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | CUSTOMER_WAIT_MAX_DURATION | NUMBER(10) | int | integer | yes | 0 | The maximum amount of time, in seconds, the customer spent waiting for a reply from an agent. If the customer was waiting for a reply to a set of messages, the wait interval is calculated from the time the last message in the set was sent. | cse_CustomerWaitMaxTime | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | END_DATE_TIME_KEY | NUMBER(10) | int | integer | yes | yes | Identifies the start of a 15-minute interval in which the chat session ended. 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 timestamp from the KVP to an appropriate time zone. | ChatServerSessionClosedAt | yes | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | HANDLE_COUNT | NUMBER(10) | int | integer | The total number of times a session was in an active state, with at least one agent connected to the chat session. | 8.5.011.14 | cse_SessionHandleTotalCount | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | HANDLE_DURATION | NUMBER(10) | int | integer | The total time (in seconds) that at least one agent was connected to a chat session. | 8.5.011.14 | cse_SessionHandleTotalTime | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | MEDIA_SERVER_IXN_GUID | VARCHAR2(64 CHAR) | varchar(64) | varchar(64) | yes | 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 interaction details with the chat session details by using the following references:
Note that in practice the size limit of column data is 50 characters, which corresponds to the data type size of the MEDIA_SERVER_IXN_GUID in the INTERACTION_FACT table. |
||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT 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 KVP matches MEDIA_TYPE.MEDIA_NAME_CODE. | csg_MediaType | ||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | MSG_FROM_AGENTS_COUNT | NUMBER(10) | int | integer | yes | 0 | The total number of all messages visible to the customer that were sent by all agents involved in the chat. A chat session might involve several agents (for example, in the case of a conference or transfer). | csg_MessagesFromAgentsCount | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | MSG_FROM_AGENTS_SIZE | NUMBER(10) | int | integer | yes | 0 | The total size of all messages visible to the customer that were sent by all agents involved in the chat. The size is expressed as number of characters, including spaces. | csg_MessagesFromAgentsSize | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | MSG_FROM_BOTS_COUNT | NUMBER(10) | int | integer | yes | 0 | The total number of messages visible to the customer that were sent by all bots that participated in the chat session. | csg_MessagesFromBotsCount | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | MSG_FROM_BOTS_SIZE | NUMBER(10) | int | integer | yes | 0 | The total size of all messages visible to the customer that were sent by all bots that participated in the chat session. The size is expressed as number of characters, including spaces. | csg_MessagesFromBotsSize | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | MSG_FROM_CUSTOMERS_COUNT | NUMBER(10) | int | integer | yes | 0 | The total number of messages sent by the customer. | csg_MessagesFromCustomersCount | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | MSG_FROM_CUSTOMERS_SIZE | NUMBER(10) | int | integer | yes | 0 | The total size of the messages sent by the customer. The size is expressed as number of characters, including spaces. | csg_MessagesFromCustomersSize | |||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | PARKING_QUEUE_COUNT | NUMBER(10) | int | integer | The total number of times that the interaction was placed in a parking queue. This column is populated only in deployments with Advanced Chat. | 8.5.014.26 | cse_ParkingQueueCount | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | PARKING_QUEUE_DURATION | NUMBER(10) | int | integer | The total amount of time that the interaction spent in the parking queue. This column is populated only in deployments with Advanced Chat. | 8.5.014.26 | cse_ParkingQueueCount | ||||||||||
| Draft:PEC-REP/Library/PDMLibraryGIM/Table-CHAT SESSION FACT | PRODUCER_BATCH_ID | NUMBER(19) | numeric(19) | numeric(19) | Reserved for internal use. | 8.5.015.19 |