|
|
| Line 1: |
Line 1: |
| − | = Table CALLBACK_FACT=
| |
| | | | |
| − | <onlyinclude>
| |
| − | {{PDMTable
| |
| − | |tableName = CALLBACK_FACT
| |
| − | |shortDesc = Represents a callback-related event.
| |
| − | |tableDesc = Each row in this table describes a callback-related event, such as a callback offer, callback cancellation, or successful callback. The facts are based on data passed from Callback applications. Rows are inserted at receipt of a callback-related event and are not updated. The SERVICE_ID links the CALLBACK_FACT record with the related IRF record. There are no associated MSF records.
| |
| − |
| |
| − | Note: Reporting on declined callback offers is available in Genesys Cloud deployments only.
| |
| − |
| |
| − | |subjectAreas = Facts
| |
| − | |introduced = 8.1.402. Supported for on-premises deployments starting with release 8.5.005.
| |
| − | |modified = 8.5.003 (PUSH_DELIVERY_CONFIRMED_TS and CUSTOMER_READY_TO_START_IXN_TS added; DESIRED_TIME renamed to DESIRED_TIME_TS, which has been made mandatory)
| |
| − | |discontinued =
| |
| − | |group = CB
| |
| − | |dataExport = yes
| |
| − | |partitioned = yes
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = ADDED_TS
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey = yes
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default =
| |
| − | |colDesc = The UTC-equivalent value of the date and time at which the event with callback data is received.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = DS_AUDIT_KEY
| |
| − | |dataType_Ora = NUMBER(19)
| |
| − | |dataType_MSSQL = numeric(19)
| |
| − | |dataType_Postgre = numeric(19)
| |
| − | |primaryKey = yes
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default =
| |
| − | |colDesc = 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.
| |
| − | |introduced =
| |
| − | |modified = 8.5.008 (data type increased from 10 to 19 digits)
| |
| − | |discontinued =
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = EVENT_SEQUENCE
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey = yes
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default =
| |
| − | |colDesc = The number of this event relative to other events associated with the same callback service.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = CREATE_AUDIT_KEY
| |
| − | |dataType_Ora = NUMBER(19)
| |
| − | |dataType_MSSQL = numeric(19)
| |
| − | |dataType_Postgre = numeric(19)
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = 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.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = TENANT_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default = -1
| |
| − | |colDesc = 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.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_TENANT_DBID
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = SERVICE_ID
| |
| − | |dataType_Ora = VARCHAR2(255 CHAR)
| |
| − | |dataType_MSSQL = varchar(255)
| |
| − | |dataType_Postgre = varchar(255)
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default =
| |
| − | |colDesc = 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.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_SERVICE_ID
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = FINAL_RECORD
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = Indicates whether this is a final record about this callback service: 0 = No, 1 = Yes.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_FINAL_RECORD
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = EWT_READY_TO_START_IXN
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The value of Expected Wait Time (EWT), in seconds, for the service request when the contact center was ready to start the first callback interaction, such as an outbound dialing attempt.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_EWT_WHEN_READY_TO_START_MEDIA_IXN
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = EWT_WHEN_OFFERED
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The value of EWT, in seconds, at the time the callback was offered.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_EWT_WHEN_CALLBACK_WAS_OFFERED
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = POS_READY_TO_START_IXN
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The customer position in the queue when the contact center was ready to start the first callback interaction, such as an outbound dialing attempt.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_POS_WHEN_READY_TO_START_MEDIA_IXN
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = POS_WHEN_OFFERED
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The customer position in the queue when callback was offered.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_POS_WHEN_CALLBACK_WAS_OFFERED
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = CALLBACK_OFFER_TIME
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default =
| |
| − | |colDesc = The duration of the callback offer, in seconds.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_D_CALLBACK_OFFER
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = WAIT_AGENT_OFFLINE_TIME
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The amount of time, in seconds, the customer was waiting offline for an agent to become available.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_D_WAITING_FOR_AGENT_OFFLINE
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = ESTABLISH_MEDIA_IXN_TIME
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The amount of time, in seconds, it took to establish the callback interaction, such as an outbound call.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_D_ESTABLISH_MEDIA_IXN
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = CONN_WAITING_AGENT_TIME
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The amount of time, in seconds, the customer was waiting to be connected to the agent after the callback interaction was established.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_D_CUSTOMER_CONNECTED_WAITING_FOR_AGENT
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = CALLBACK_ACCEPTED_TS
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The UTC timestamp when the callback offer was accepted.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_T_CALLBACK_ACCEPTED
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = CALLBACK_OFFERED_TS
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default =
| |
| − | |colDesc = The UTC timestamp when the callback was offered.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_T_CALLBACK_OFFERED
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = READY_START_MEDIA_IXN_TS
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The UTC timestamp when 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.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_T_READY_TO_START_MEDIA_IXN
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = CUSTOMER_CONNECTED_TS
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The UTC timestamp when the customer was reconnected to the contact center and started waiting for an agent to be connected.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_T_CUSTOMER_CONNECTED
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = AGENT_ADDED_TO_IXN
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = Indicates whether the agent was successfully added to the callback interaction: 0 = No, 1 = Yes.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_N_AGENT_ADDED_TO_IXN
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = XFER_TO_AGENT_FAILED
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = Number of times the callback interaction failed to transfer to the agent.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_N_TRANSFER_TO_AGENT_FAILED
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = ABANDONED_WAITING
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = Indicates whether the customer abandoned the callback interaction while waiting to be connected to an agent: 0 = No, 1 = Yes.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_N_CUSTOMER_ABANDONED_WHILE_WAITING_FOR_AGENT
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = TIMEOUT_WAITING
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = Indicates whether the customer was disconnected because the timeout for waiting for an agent was reached: 0 = No, 1 = Yes.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_N_TIMEOUT_WHILE_WAITING_FOR_AGENT
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = IXN_REQ_AGENT
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = For internal use.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_N_IXN_REQ_AGENT
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = CALLBACK_OFFERED
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default =
| |
| − | |colDesc = Indicates whether callback was offered, at least once, during the session: 0 = No, 1 = Yes.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_N_CALLBACK_OFFERED
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = CALLBACK_ACCEPTED
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = Indicates whether a callback offer was accepted: 0 = No, 1 = Yes.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_N_CALLBACK_ACCEPTED
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = CALLBACK_ATTEMPTS
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The total number of callback attempts or notifications, both successful and unsuccessful.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_N_CALLBACK_MEDIA_ATTEMPTS
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = SERVICE_START_TS
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default =
| |
| − | |colDesc = The UTC timestamp when 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.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_T_SERVICE_START
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = START_DATE_TIME_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey = yes
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = This is the DATE_TIME_KEY equivalent of the SERVICE_START_TS value.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_T_SERVICE_START
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = CALLBACK_OFFERS_PER_SESSION
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The number of times a callback was offered to the customer during the current interaction.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_N_CALLBACK_OFFERS_PER_SESSION
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = LAST_CALLBACK_OFFERED_TS
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The UTC timestamp of the final callback offer during the current interaction.
| |
| − | |introduced =
| |
| − | |modified = 8.5.008 (default value added)
| |
| − | |discontinued =
| |
| − | |KVP = _CB_T_LAST_CALLBACK_OFFERED
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = LAST_CALLBACK_OFFER_TIME
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The duration, in seconds, of the final callback offer.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_D_LAST_CALLBACK_OFFER
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = CUSTOMER_PHONE_NUMBER
| |
| − | |dataType_Ora = VARCHAR2(255 CHAR)
| |
| − | |dataType_MSSQL = varchar(255)/nvarchar(255)
| |
| − | |dataType_Postgre = varchar(255)
| |
| − | |primaryKey =
| |
| − | |mandatory =
| |
| − | |foreignKey =
| |
| − | |default =
| |
| − | |colDesc = The customer phone number that was used for the callback interaction, if available.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_CUSTOMER_PHONE_NUMBER
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = DESIRED_TIME
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory =
| |
| − | |foreignKey =
| |
| − | |default =
| |
| − | |colDesc = 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.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued = 8.5.003 (renamed to DESIRED_TIME_TS)
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = DESIRED_TIME_TS
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = 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.
| |
| − | |introduced = 8.5.003 (renamed from DESIRED_TIME)
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_T_DESIRED_TIME
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = PUSH_DELIVERY_CONFIRMED_TS
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The UTC timestamp when the application confirmed receipt of push notification. This field is populated for Inbound Callback scenarios.
| |
| − | |introduced = 8.5.003
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_T_PUSH_DELIVERY_CONFIRMED
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = CUSTOMER_READY_TO_START_IXN_TS
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The UTC timestamp when 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.
| |
| − | |introduced = 8.5.003
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_T_CUSTOMER_READY_TO_START_MEDIA_IXN
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = CALLBACK_DIM_1_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default = -2
| |
| − | |colDesc = The surrogate key that is used to join the CALLBACK_DIM_1 dimension to the fact table, by the record ID.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = CALLBACK_DIM_2_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default = -2
| |
| − | |colDesc = The surrogate key that is used to join the CALLBACK_DIM_2 dimension to the fact table, by the record ID.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = CALLBACK_DIM_3_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default = -2
| |
| − | |colDesc = The surrogate key that is used to join the CALLBACK_DIM_3 dimension to the fact table, by the record ID.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − |
| |
| − | {{PDMColumn
| |
| − | |colName = RESOURCE_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default = -2
| |
| − | |colDesc = 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.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | |KVP = _CB_DIM_VQ_DBID,_CB_DIM_VQ
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parentTable = CTL_AUDIT_LOG
| |
| − | |parentColumn = AUDIT_KEY
| |
| − | |foreignKey = CREATE_AUDIT_KEY
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parentTable = DATE_TIME
| |
| − | |parentColumn = DATE_TIME_KEY
| |
| − | |foreignKey = START_DATE_TIME_KEY
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parentView = TENANT
| |
| − | |parentColumn = TENANT_KEY
| |
| − | |foreignKey = TENANT_KEY
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parentTable = CALLBACK_DIM_1
| |
| − | |parentColumn = ID
| |
| − | |foreignKey = CALLBACK_DIM_1_KEY
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parentTable = CALLBACK_DIM_2
| |
| − | |parentColumn = ID
| |
| − | |foreignKey = CALLBACK_DIM_2_KEY
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parentTable = CALLBACK_DIM_3
| |
| − | |parentColumn = ID
| |
| − | |foreignKey = CALLBACK_DIM_3_KEY
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parentTable = RESOURCE_
| |
| − | |parentColumn = RESOURCE_KEY
| |
| − | |foreignKey = RESOURCE_KEY
| |
| − | }}
| |
| − |
| |
| − | </onlyinclude>
| |
| − |
| |
| − | [[Category:V:GIM:8.5DRAFT]]
| |
