ECS Dimension Tables | ||
ECSBreakCategoryTypeDimension | ||
| Column Name | Snowflake Type | Description |
|---|---|---|
| bct_id | NUMBER(15,0) | Primary key |
| bct_breakCategoryTypeName | VARCHAR(100) | The break category type name |
| bct_exceedSeconds | NUMBER(38,0) | Allowed count of exceeded seconds |
| bct_paid | BOOLEAN | Is Paid |
| bct_accountId | VARCHAR(16) | The account identifier |
| bct_parentEipId | VARCHAR(16) | The parent account identifier |
ECSBusinessProcessDimension | ||
| Column Name | Snowflake Type | Description |
| bpd_id | NUMBER(15,0) | Primary key |
| bpd_businessProcessName | VARCHAR(100) | Business process name |
| bpd_contactCenterName | VARCHAR(100) | Contact center name |
| bpd_accountId | VARCHAR(16) | The account identifier |
| bpd_parentEipId | VARCHAR(16) | The parent account identifier |
ECSCampaignDimension | ||
| Column Name | Snowflake Type | Description |
| ecd_id | NUMBER(15,0) | Primary key |
| ecd_campaignName | VARCHAR(100) | Campaign name |
| ecd_businessProcessId | NUMBER(15,0) | Business process identifier |
| ecd_businessProcessName | VARCHAR(100) | Business process name |
| ecd_dialerTypeId | NUMBER(15,0) | Dialer type identifier |
| ecd_dialerTypeName | VARCHAR(100) | Dialer type name |
| ecd_accountId | VARCHAR(16) | The account identifier |
| ecd_parentEipId | VARCHAR(16) | The parent account identifier |
ECSInteractionChannelDimension | ||
| Column Name | Snowflake Type | Description |
| icd_id | NUMBER(15,0) | Primary key |
| icd_interactionChannelName | VARCHAR(100) | Interaction channel name |
| icd_contactCenterName | VARCHAR(100) | Contact center name |
| icd_accountId | VARCHAR(16) | The account identifier |
| icd_parentEipId | VARCHAR(16) | The parent account identifier |
ECSInteractionStateDimension | ||
| Column Name | Snowflake Type | Description |
| isd_id | NUMBER(15,0) | Primary key |
| isd_interactionStateName | VARCHAR(100) | Interaction state name |
| isd_outboundStatusName | VARCHAR(100) | Outbound status name |
| isd_statusName | VARCHAR(100) | Status name |
| isd_accountId | VARCHAR(16) | The account identifier |
| isd_parentEipId | VARCHAR(16) | The parent account identifier |
ECSInteractionTypeDimension | ||
| Column Name | Snowflake Type | Description |
| itd_id | NUMBER(15,0) | Primary key |
| itd_interactionTypeName | VARCHAR(100) | Interaction type name |
| itd_directionName | VARCHAR(100) | Direction name |
| itd_mediaName | VARCHAR(100) | Media name |
| itd_purpose | VARCHAR(100) | Purpose name |
| itd_accountId | VARCHAR(16) | The account identifier |
| itd_parentEipId | VARCHAR(16) | The parent account identifier |
ECSUserDimension | ||
| Column Name | Snowflake Type | Description |
| eud_id | NUMBER(15,0) | Primary key |
| eud_ecsUserDisplayName | VARCHAR(100) | User display name |
| eud_accountId | VARCHAR(16) | The account identifier |
| eud_broadsoftUserId | VARCHAR(161) | Broadsoft user identifier |
| eud_parentEipId | VARCHAR(16) | The parent account identifier |
| eud_ecsUserGUID | VARCHAR(36) | GUID identifier |
| eud_isSupervisor | BOOLEAN | Is supervisor |
| eud_disabled | BOOLEAN | User disabled or not |
ECSOrganizationMapping | ||
| Column Name | Snowflake Type | Description |
| eom_id | NUMBER(38,0) | Primary key |
| eom_organizationName | VARCHAR(150) | Organization name |
| eom_organizationDWDBName | VARCHAR(150) | Organization data warehouse database name |
| eom_organizationId | VARCHAR(36) | Organization GUID identifier |
| eom_accountId | VARCHAR(16) | The account identifier |
| eom_isActive | BOOLEAN | Organization is active or not |
TimeZoneDimension | ||
| Column Name | Snowflake Type | Description |
| tzd_timeZoneId | NUMBER(38,0) | Primary key |
| tzd_offset | NUMBER(38,0) | Time zone offset |
| tzd_timeZoneName | VARCHAR(150) | Time zone name |
| tzd_displayName | VARCHAR(150) | Time zone display name |
AreaCodeDimension | ||
| Column Name | Snowflake Type | Description |
| acd_areaCodeId | NUMBER(38,0) | Area code |
| acd_state | VARCHAR(40) | State |
ECS Fact Tables | ||||
ECSAlertFact | ||||
| Column Name | Snowflake Type | Description | References | Comments |
|---|---|---|---|---|
| alrf_id | NUMBER(38,0) | Primary key | ||
| alrf_alertId | NUMBER(38,0) | Identifier of the alert | ||
| alrf_agentId | NUMBER(15,0) | Foreign key to the agent | ECSUserDimension | |
| alrf_alertTypeId | NUMBER(38,0) | Deprecated | Deprecated field. Replaced by alrf_alertTypeName | |
| alrf_businessProcessId | NUMBER(15,0) | Foreign key to the business process | ECSBusinessProcessDimension | |
| alrf_counter | NUMBER(38,0) | Deprecated | Deprecated field. Replaced by alrf_counterTypeName | |
| alrf_counterTypeId | NUMBER(15,0) | Deprecated | Deprecated field. Replaced by alrf_counterTypeName | |
| alrf_endDateSliceId | NUMBER(38,0) | Foreign key to the alert end date in UTC | DateDimension | |
| alrf_endTime | TIMESTAMP_NTZ(9) | Alert end time in UTC | ||
| alrf_endTimeSliceId | NUMBER(38,0) | Foreign key to the alert end time of day in UTC | TimeOfDayDimension | |
| alrf_eomId | NUMBER(38,0) | Foreign key to the ECS organization | ECSOrganizationMapping | |
| alrf_startDateSliceId | NUMBER(38,0) | Foreign key to the alert start date in UTC | DateDimension | |
| alrf_startTime | TIMESTAMP_NTZ(9) | Alert start time | ||
| alrf_startTimeSliceId | NUMBER(38,0) | Foreign key to the alert start time of day in UTC | TimeOfDayDimension | |
| alrf_updateDateTime | TIMESTAMP_NTZ(9) | Alert last update datetime | ||
| alrf_value | NUMBER(38,0) | Alert value | ||
| alrf_eipId | VARCHAR(16) | The account identifier | ||
| alrf_alertTypeName | VARCHAR(100) | Alert type name | ||
| alrf_counterTypeName | VARCHAR(100) | Counter type name | ||
| alrf_parentEipId | VARCHAR(16) | The account identifier | ||
| alrf_startTimestampLocal | TIMESTAMP_NTZ(9) | Alert start time in local time | ||
| alrf_endTimestampLocal | TIMESTAMP_NTZ(9) | Alert end time in local time | ||
| alrf_startDateLocal | NUMBER(38,0) | Foreign key to the alert start date in local time | DateDimension | |
| alrf_startTimeLocal | NUMBER(38,0) | Foreign key to the alert start time of day in local time | TimeOfDayDimension | |
| alrf_endDateLocal | NUMBER(38,0) | Foreign key to the alert end date in local time | DateDimension | |
| alrf_endTimeLocal | NUMBER(38,0) | Foreign key to the alert end time of day in local time | TimeOfDayDimension | |
| alrf_lastUpdatedTimestamp | TIMESTAMP_NTZ(9) | The record updated timestamp | ||
| alrf_updated | BOOLEAN | Indicates whether the record was updated | ||
ECSAgentLifeFact | ||||
| Column Name | Snowflake Type | Description | References | Comments |
| alif_id | NUMBER(38,0) | Primary key | ||
| alif_agentLifeId | NUMBER(38,0) | Identifier of agent life | ||
| alif_agentId | NUMBER(15,0) | Foreign key to the agent | ECSUserDimension | |
| alif_agentLifeTypeId | NUMBER(38,0) | Deprecated | Deprecated field. Replaced by alif_agentLifeTypeName | |
| alif_agentStatusId | NUMBER(15,0) | Deprecated | Deprecated field. Replaced by alif_agentStatusName | |
| alif_bpAssigned | BOOLEAN | Flag for a status: was assigned to BP (Business Process) | ||
| alif_breakTypeId | NUMBER(15,0) | Deprecated | ECSBreakTypeDimension | Deprecated field. Replaced by alif_breakTypeName |
| alif_businessProcessId | NUMBER(15,0) | Foreign key to the interaction business process | ECSBusinessProcessDimension | |
| alif_categoryId | NUMBER(15,0) | Foreign key to the break category | ECSBreakCategoryTypeDimension | |
| alif_decidedToApprove | BOOLEAN | Decision solution | ||
| alif_efficiency | FLOAT | Efficiency | ||
| alif_endDateSliceId | NUMBER(38,0) | Foreign key to the status end date in UTC | DateDimension | |
| alif_endTime | TIMESTAMP_NTZ(9) | Status end time in UTC | ||
| alif_endTimeSliceId | NUMBER(38,0) | Foreign key to the status end time of day in UTC | TimeOfDayDimension | |
| alif_eomId | NUMBER(38,0) | Foreign key to the ECS organization | ECSOrganizationMapping | |
| alif_exceededSeconds | NUMBER(38,0) | Count of exceeded seconds | ||
| alif_interactionEndTime | TIMESTAMP_NTZ(9) | Interaction end time in UTC | ||
| alif_interactionId | NUMBER(38,0) | Identifier of the Interaction | ||
| alif_interactionStartTime | TIMESTAMP_NTZ(9) | Interaction start time in UTC | ||
| alif_interactionStateId | NUMBER(15,0) | Foreign key to the interaction state | ECSInteractionStateDimension | |
| alif_interactionTypeId | NUMBER(15,0) | Foreign key to the interaction type | ECSInteractionTypeDimension | |
| alif_loginDateSliceId | NUMBER(38,0) | Foreign key to the status login date in UTC | DateDimension | |
| alif_loginTime | TIMESTAMP_NTZ(9) | Agent login time in UTC | ||
| alif_loginTimeSliceId | NUMBER(38,0) | Foreign key to the status login time of day in UTC | TimeOfDayDimension | |
| alif_logoffDateSliceId | NUMBER(38,0) | Foreign key to of the status logoff date in UTC | DateDimension | |
| alif_logoffTime | TIMESTAMP_NTZ(9) | Agent logoff time in UTC | ||
| alif_logoffTimeSliceId | NUMBER(38,0) | Foreign key to the status logoff time of day in UTC | TimeOfDayDimension | |
| alif_paid | BOOLEAN | Flag for a status: was paid | ||
| alif_requestTime | TIMESTAMP_NTZ(9) | Request time for a status | ||
| alif_shiftId | NUMBER(38,0) | Shift number | ||
| alif_sourceKey | VARCHAR(50) | Source Key | ||
| alif_startDateSliceId | NUMBER(38,0) | Foreign key to the status start date in UTC | DateDimension | |
| alif_startTime | TIMESTAMP_NTZ(9) | Status start time in UTC | ||
| alif_startTimeSliceId | NUMBER(38,0) | Foreign key to the status start time of day in UTC | TimeOfDayDimension | |
| alif_supervisorDecisionTime | TIMESTAMP_NTZ(9) | Supervisor decision time for a status | ||
| alif_supervisorId | NUMBER(15,0) | Foreign key to the supervisor | ECSUserDimension | |
| alif_updateDateTime | TIMESTAMP_NTZ(9) | Agent life last status update datetime | ||
| alif_eipId | VARCHAR(16) | The account identifier | ||
| alif_agentLifeTypeName | VARCHAR(50) | Agent life type name | ||
| alif_agentStatusName | VARCHAR(50) | Agent status name | ||
| alif_breakTypeName | VARCHAR(100) | Break type name | ||
| alif_parentEipId | VARCHAR(16) | Parent account identifier | ||
| alif_loginTimestampLocal | TIMESTAMP_NTZ(9) | Agent login time in local time | ||
| alif_logoffTimestampLocal | TIMESTAMP_NTZ(9) | Agent logoff time in local time | ||
| alif_startTimestampLocal | TIMESTAMP_NTZ(9) | Status start time in local time | ||
| alif_endTimestampLocal | TIMESTAMP_NTZ(9) | Status end time in local time | ||
| alif_interactionStartTimestampLocal | TIMESTAMP_NTZ(9) | Interaction start time in local time | ||
| alif_interactionEndTimestampLocal | TIMESTAMP_NTZ(9) | Interaction end time in local time | ||
| alif_loginDateLocal | NUMBER(38,0) | Foreign key to the status login date in local time | DateDimension | |
| alif_loginTimeLocal | NUMBER(38,0) | Foreign key to the status login time of day in local time | TimeOfDayDimension | |
| alif_logoffDateLocal | NUMBER(38,0) | Foreign key to the status logoff date in local time | DateDimension | |
| alif_logoffTimeLocal | NUMBER(38,0) | Foreign key to the status logoff time of day in local time | TimeOfDayDimension | |
| alif_startDateLocal | NUMBER(38,0) | Foreign key to the status start date in local time | DateDimension | |
| alif_startTimeLocal | NUMBER(38,0) | Foreign key to the status start time of day in local time | TimeOfDayDimension | |
| alif_endDateLocal | NUMBER(38,0) | Foreign key to the status end date in local time | DateDimension | |
| alif_endTimeLocalI | NUMBER(38,0) | Foreign key to the status end time of day in local time | TimeOfDayDimension | |
| alif_lastUpdatedTimestamp | TIMESTAMP_NTZ(9) | The record updated timestamp | ||
| alif_updated | BOOLEAN | Indicates whether the record was updated | ||
| alif_changeTrigger | VARCHAR(200) | |||
ECSAttemptFact | ||||
| Column Name | Snowflake Type | Description | References | Comments |
| atmp_id | NUMBER(38,0) | Primary key | ||
| atmp_attemptId | NUMBER(38,0) | Identifier of the attempt | ||
| atmp_agentId | NUMBER(15,0) | Foreign key to the agent | ECSUserDimension | |
| atmp_answerDateSliceId | NUMBER(38,0) | Foreign key to the answer date in UTC | DateDimension | |
| atmp_answerTime | TIMESTAMP_NTZ(9) | Answer datetime in UTC | ||
| atmp_answerTimeSliceId | NUMBER(38,0) | Foreign key to the answer time of day in UTC | TimeOfDayDimension | |
| atmp_attemptDateSliceId | NUMBER(38,0) | Foreign key to the attempt date in UTC | DateDimension | |
| atmp_attemptNo | NUMBER(38,0) | Attempt number | ||
| atmp_attemptTime | TIMESTAMP_NTZ(9) | Attempt datetime in UTC | ||
| atmp_attemptTimeSliceId | NUMBER(38,0) | Foreign key to the attempt time of day in UTC | TimeOfDayDimension | |
| atmp_businessProcessId | NUMBER(15,0) | Foreign key to the business process of current attempt. | ECSBusinessProcessDimension | |
| atmp_campaignEnterDateSliceId | NUMBER(38,0) | Foreign key to the campaign enter date in UTC | DateDimension | |
| atmp_campaignEnterTime | TIMESTAMP_NTZ(9) | When the interaction was added to campaign (loaded) | ||
| atmp_campaignEnterTimeSliceId | NUMBER(38,0) | Foreign key to the campaign enter time of day of day in UTC | TimeOfDayDimension | |
| atmp_campaignId | NUMBER(15,0) | Foreign key to the campaign | ECSCampaignDimension | |
| atmp_campaignInteractionId | NUMBER(38,0) | Campaign Interaction Id - system Id | ||
| atmp_campaignLastAttemptDateSliceId | NUMBER(38,0) | Foreign key to the campaign last attempt date in UTC | DateDimension | Deprecated field |
| atmp_campaignLastAttemptTime | TIMESTAMP_NTZ(9) | Last attempt datetime | ||
| atmp_campaignLastAttemptTimeSliceId | NUMBER(38,0) | Foreign key to the campaign last attempt time of day in UTC | TimeOfDayDimension | Deprecated field |
| atmp_destination | VARCHAR(16777216) | Destination | ||
| atmp_endDateSliceId | NUMBER(38,0) | Foreign key to the end date in UTC | DateDimension | |
| atmp_endTime | TIMESTAMP_NTZ(9) | Attempt end time | ||
| atmp_endTimeSliceId | NUMBER(38,0) | Foreign key to the end time of day in UTC | TimeOfDayDimension | |
| atmp_eomId | NUMBER(38,0) | Foreign key to the ECS organization | ECSOrganizationMapping | |
| atmp_interactionStateId | NUMBER(15,0) | Foreign key to the interaction state of current attempt | ECSInteractionStateDimension | |
| atmp_lastAttemptInteractionStateId | NUMBER(15,0) | Foreign key to the interaction state of last attempt | ECSInteractionStateDimension | |
| atmp_numberOfAttempts | NUMBER(38,0) | Number of attempts | ||
| atmp_remarks | VARCHAR(16777216) | Remarks | ||
| atmp_updateDateTime | TIMESTAMP_NTZ(9) | Attempt last update datetime | ||
| atmp_eipId | VARCHAR(16) | The account identifier | ||
| atmp_parentEipId | VARCHAR(16) | Parent account identifier | ||
| atmp_lastUpdatedTimestamp | TIMESTAMP_NTZ(9) | The record updated timestamp | ||
| atmp_updated | BOOLEAN | Indicates whether the record was updated | ||
| atmp_interactionId | NUMBER(38,0) | |||
| atmp_handlerName | VARCHAR(256) | |||
ECSInteractionFact | ||||
| Column Name | Snowflake Type | Description | References | Comments |
| intr_id | NUMBER(38,0) | Primary key | ||
| intr_interactionId | NUMBER(38,0) | Identifier of interaction | ||
| intr_interactionGUIDID | VARCHAR(36) | GUID identifier | ||
| intr_interactionLeg | NUMBER(38,0) | Interaction leg | ||
| intr_agentHandlingTime | NUMBER(38,0) | Agent handling time | ||
| intr_agentID | NUMBER(15,0) | Foreign key to the ECS agent | ECSUserDimension | |
| intr_answeredWithinGoalTime | BOOLEAN | Flag: was interaction answered within a goal time? | ||
| intr_areaCodeId | NUMBER(38,0) | Foreign key ot the area code | AreaCodeDimension | |
| intr_CRMContactId | VARCHAR(36) | Identifier to CRM contact | ||
| intr_campaignId | NUMBER(15,0) | Foreign key to the campaign | ECSCampaignDimension | |
| intr_closedBySystem | BOOLEAN | Flag: was interaction closed by system? | ||
| intr_consultTime | NUMBER(38,0) | Consult time | ||
| intr_currentSLThreshold | NUMBER(38,0) | Current Service Level Threshold | ||
| intr_customerBillingCode | VARCHAR(128) | Customer billing code | ||
| intr_customerCalls | NUMBER(38,0) | Customer Calls | ||
| intr_destination | VARCHAR(16777216) | Destination | ||
| intr_directionId | NUMBER(38,0) | Deprecated | Deprecated field. Replaced by: intr_directionName. | |
| intr_dispositionCode | VARCHAR(200) | Disposition code | ||
| intr_dispositionCodeCategory | VARCHAR(128) | Disposition Code Category | ||
| intr_dispositionCodeSubCategory | VARCHAR(128) | Disposition Code Sub Category | ||
| intr_duration | NUMBER(38,0) | Last attempt duration | ||
| intr_emailBacklog | BOOLEAN | Flag: was email interaction kept in a backlog? | ||
| intr_endDateSliceId | NUMBER(38,0) | Foreign key to the interaction end date in UTC | DateDimension | |
| intr_endTime | TIMESTAMP_NTZ(9) | Interaction end time in UTC | ||
| intr_endTimeSliceId | NUMBER(38,0) | Foreign key to the interaction end time of day in UTC | TimeOfDayDimension | |
| intr_endedInRequestDNC | BOOLEAN | Ended in request "Do not call" | ||
| intr_endedInTransfer | BOOLEAN | Flag: was interaction ended in transfer? | ||
| intr_endingStatus | VARCHAR(50) | Ending status - is not actual | ||
| intr_enterDateSliceId | NUMBER(38,0) | Foreign key to the interaction enter date in UTC | DateDimension | |
| intr_enterTime | TIMESTAMP_NTZ(9) | When the interaction was added to campaign (loaded) in UTC | ||
| intr_enterTimeSliceId | NUMBER(38,0) | Foreign key to the interaction enter time of day in UTC | TimeOfDayDimension | |
| intr_eomId | NUMBER(38,0) | Foreign key to the ECS organization | ECSOrganizationMapping | |
| intr_externalTransferDID | VARCHAR(128) | External transfer DID | ||
| intr_hasAnotherAttempt | BOOLEAN | Flag: is there another attempt? | ||
| intr_holdTime | NUMBER(38,0) | Hold time in seconds | ||
| intr_IVRTime | NUMBER(38,0) | IVR time | ||
| intr_interactionCreationTypeId | NUMBER(38,0) | Deprecated | Deprecated field. Replaced by: intr_interactionCreationTypeName | |
| intr_interactionMediaId | NUMBER(38,0) | Deprecated | Deprecated field. Replaced by: intr_interactionMediaName | |
| intr_interactionResultId | NUMBER(15,0) | Deprecated | Deprecated field. Replaced by: intr_interactionResultName | |
| intr_interactionTypeId | NUMBER(15,0) | Foreign key to the interaction type | ECSInteractionTypeDimension | |
| intr_isDeferrable | BOOLEAN | Flag: was the interaction deferrable? | ||
| intr_lasHandlerHandlingTime | NUMBER(38,0) | Last handler handling time | ||
| intr_lastAttemptAgentId | NUMBER(15,0) | Foreign key of the last attempt agent | ECSUserDimension | |
| intr_lastAttemptAnswerDateSliceId | NUMBER(38,0) | Deprecated | Deprecated field | |
| intr_lastAttemptAnswerTime | TIMESTAMP_NTZ(9) | Last attempt answer time in UTC | ||
| intr_lastAttemptAnswerTimeSliceId | NUMBER(38,0) | Deprecated | Deprecated field | |
| intr_lastAttemptDateSliceId | NUMBER(38,0) | Deprecated | Deprecated field | |
| intr_lastAttemptDestination | VARCHAR(128) | Last attempt destination | ||
| intr_lastAttemptEndDateSliceId | NUMBER(38,0) | Deprecated | Deprecated field | |
| intr_lastAttemptEndTime | TIMESTAMP_NTZ(9) | Last attempt end time in UTC | ||
| intr_lastAttemptEndTimeSliceId | NUMBER(38,0) | Deprecated | Deprecated field | |
| intr_lastAttemptInteractionStateId | NUMBER(15,0) | Foreign key to the interaction state of last attempt | ECSInteractionStateDimension | |
| intr_lastAttemptRemarks | VARCHAR(16777216) | Remarks of last attempt | ||
| intr_lastAttemptTime | TIMESTAMP_NTZ(9) | Last Attempt time in UTC | ||
| intr_lastAttemptTimeSliceId | NUMBER(38,0) | Identifier of the last attempt time of day in UTC | Deprecated field | |
| intr_lastInteractionStateId | NUMBER(15,0) | Foreign key to the latest interaction state | ECSInteractionStateDimension | |
| intr_lastTreatingAgentId | NUMBER(15,0) | Foreign key to the agent last treated the interaction | ECSUserDimension | |
| intr_lastTreatingBusinessProcessId | NUMBER(15,0) | Foreign key to the business process last treated the interaction | ECSBusinessProcessDimension | |
| intr_lastTreatingInteractionChannelId | NUMBER(15,0) | Foreign key to the channel last treated the interaction | ECSInteractionChannelDimension | |
| intr_mistreatedCode | NUMBER(38,0) | DNC number | ||
| intr_mistreatedDateSliceId | NUMBER(38,0) | Foreign key to the mistreated date in UTC | Deprecated field | |
| intr_mistreatedTime | TIMESTAMP_NTZ(9) | When DNC number was called in UTC | ||
| intr_mistreatedTimeSliceId | NUMBER(38,0) | Foreign key to the mistreated time of day in UTC | Deprecated field | |
| intr_numberOfAttempts | NUMBER(38,0) | Number of attempts | ||
| intr_origin | VARCHAR(128) | Origin | ||
| intr_overflow | BOOLEAN | Flag: was interaction overflow? | ||
| intr_previousAgentId | NUMBER(15,0) | Foreign key to the agent if the previous handler was an agent | ECSUserDimension | |
| intr_previousBusinessProcessId | NUMBER(15,0) | Foreign key to the business process if the previous handler was a business process | ECSBusinessProcessDimension | |
| intr_previousHandlerHandlingTime | NUMBER(38,0) | Handling time of the handler before the last handler of the interaction | ||
| intr_previousInteractionChannelId | NUMBER(15,0) | Foreign key to the interaction channel if the previous handler was a channel | ECSInteractionChannelDimension | |
| intr_queueTime | NUMBER(38,0) | Queue time | ||
| intr_queued | BOOLEAN | Flag: was interaction queued? | ||
| intr_remarks | VARCHAR(16777216) | Remarks | ||
| intr_responseCount | NUMBER(38,0) | Count of responses within a conversation | ||
| intr_responseTimeSum | NUMBER(38,0) | Summarized count of seconds in responses within a conversation | ||
| intr_routingClientName | VARCHAR(50) | Routing Client Name | ||
| intr_routingInboundCampaignName | VARCHAR(50) | Routing Inbound Campaign Name | ||
| intr_routingProductName | VARCHAR(50) | Routing Product Name | ||
| intr_routingProductType | VARCHAR(50) | Routing Product Type | ||
| intr_sLExcluded | BOOLEAN | Flag: was interaction excluded from Service Level calculations? | ||
| intr_startDateSliceId | NUMBER(38,0) | Foreign key to the interaction start date in UTC | DateDimension | |
| intr_startTime | TIMESTAMP_NTZ(9) | Interaction start time in UTC | ||
| intr_startTimeSliceId | NUMBER(38,0) | Foreign key to the interaction start time of day in UTC | TimeOfDayDimension | |
| intr_telephonyTimeExternalAgent | NUMBER(38,0) | External agent telephony time | ||
| intr_telephonyTimeExternalConsult | NUMBER(38,0) | External consulting telephony time | ||
| intr_telephonyTimeIncoming | NUMBER(38,0) | Incoming telephony time | ||
| intr_telephonyTimeOutgoing | NUMBER(38,0) | Outgoing telephony time | ||
| intr_timeZoneId | NUMBER(38,0) | Foreign key to the time zone | TimeZoneDimension | |
| intr_updateDateTime | TIMESTAMP_NTZ(9) | Interaction last update datetime in UTC | ||
| intr_voiceMailAssignedAgentId | NUMBER(15,0) | Foreign key to the to assigned agent for a voicemail | ECSUserDimension | |
| intr_voiceMailLeft | BOOLEAN | Flag: was left a voicemail | ||
| intr_wasAbandoned | BOOLEAN | Flag: was interaction abandoned? | ||
| intr_wrapUpTime | NUMBER(38,0) | Wrap-up time in seconds | ||
| intr_eipId | VARCHAR(16) | The account identifier | ||
| intr_inbound | BOOLEAN | Indicates if the interaction creation type is inbound | ||
| intr_outbound | BOOLEAN | Indicates if the interaction creation type is outbound | ||
| intr_outgoingInternal | BOOLEAN | Indicates if the interaction creation type is outgoing internal | ||
| intr_callback | BOOLEAN | Indicates if the interaction creation type is callback | ||
| intr_campaign | BOOLEAN | Indicates if the interaction creation type is campaign | ||
| intr_telephony | BOOLEAN | Indicates if the interaction is a telephony interaction | ||
| intr_chat | BOOLEAN | Indicates if the interaction is a chat interaction | ||
| intr_email | BOOLEAN | Indicates if the interaction is an email interaction | ||
| intr_callbackRequests | BOOLEAN | Indicates the callback was requested | ||
| intr_callbackCompleted | BOOLEAN | Indicates the callback has been completed | ||
| intr_transferredIn | BOOLEAN | Indicates if the interaction is transferred in | ||
| intr_transferredOut | BOOLEAN | Indicates if the interaction is an external transfer | ||
| intr_abandoned | BOOLEAN | Indicates if the interaction was abandoned | ||
| intr_disconnected | BOOLEAN | Indicates if handled interaction was closed by the system | ||
| intr_answered | BOOLEAN | Indicates if the incoming interaction has been answered | ||
| intr_isTalked | BOOLEAN | Indicates if the interaction talk time > 0 | ||
| intr_rescheduled | BOOLEAN | Indicates emails that were manually scheduled by an agent to be answered at a later time | ||
| intr_handled | BOOLEAN | Indicates if an incoming email interaction was handled by an agent | ||
| intr_simplyAbandoned | BOOLEAN | Indicates if an interaction was abandoned includes interactions that were excluded from Service Level calculations | ||
| intr_hold | BOOLEAN | Indicates if the interaction was on hold | ||
| intr_purged | BOOLEAN | Indicates if the interaction has been purged | ||
| intr_consulted | BOOLEAN | Indicates if the interaction state is consulted | ||
| intr_missed | BOOLEAN | Indicates if the interaction has been missed | ||
| intr_rejected | BOOLEAN | Indicates if the interaction was rejected | ||
| intr_handledInBP | BOOLEAN | Indicates if the interaction was first handled by a business process | ||
| intr_handledByAgent | BOOLEAN | Indicates if the interaction was first handled by an agent | ||
| intr_abandonedTime | NUMBER(38,0) | Time until interaction was abandoned | ||
| intr_CRMFirstName | VARCHAR(50) | First name of the CRM contact | ||
| intr_CRMLastName | VARCHAR(50) | Last name of the CRM contact | ||
| intr_interactionCreationTypeName | VARCHAR(100) | Interaction creation type name | ||
| intr_interactionMediaName | VARCHAR(100) | Interaction media name | ||
| intr_interactionResultName | VARCHAR(100) | Interaction result name | ||
| intr_directionName | VARCHAR(100) | Direction name | ||
| intr_businessProcessName | VARCHAR(100) | Business process name | ||
| intr_oldCallbackExisted | VARCHAR(36) | Was interaction handled after a callback requested? if yes, then GUID identifier will be defined here | ||
| intr_telephonyTimeExternalTransfer | NUMBER(38,0) | External Transfer telephony time | ||
| intr_businessProcessId | NUMBER(15,0) | Foreign key to the business process | ECSBusinessProcessDimension | |
| intr_talkTime | NUMBER(38,0) | Talk time in seconds | ||
| intr_parentEipId | VARCHAR(16) | Parent account identifier | ||
| intr_startTimestampLocal | TIMESTAMP_NTZ(9) | Interaction start time in local time | ||
| intr_enterTimestampLocal | TIMESTAMP_NTZ(9) | When the interaction was added to campaign (loaded) in local time | ||
| intr_endTimestampLocal | TIMESTAMP_NTZ(9) | Interaction end time in local time | ||
| intr_startDateLocal | NUMBER(38,0) | Foreign key to the interaction start date in local time | DateDimension | |
| intr_startTimeLocal | NUMBER(38,0) | Foreign key to the interaction start time of day in local time | TimeOfDayDimension | |
| intr_enterDateLocal | NUMBER(38,0) | Foreign key to the interaction enter date in local time | DateDimension | |
| intr_enterTimeLocal | NUMBER(38,0) | Foreign key to the interaction enter time of day in local time | TimeOfDayDimension | |
| intr_endDateLocal | NUMBER(38,0) | Foreign key to the interaction end date in local time | DateDimension | |
| intr_endTimeLocal | NUMBER(38,0) | Foreign key to the interaction end time of day in local time | TimeOfDayDimension | |
| intr_lastUpdatedTimestamp | TIMESTAMP_NTZ(9) | The record updated timestamp | ||
| intr_updated | BOOLEAN | Indicates whether the record was updated | ||
| intr_remoteParty | VARCHAR(16777216) | |||
| intr_customerOptIn | BOOLEAN | |||
| intr_survey | BOOLEAN | Post call survey data | ||
| intr_postAgentTimeSec | NUMBER(38,0) | |||
| intr_campaignInteractionLastStateId | NUMBER(15,0) | |||
| intr_previewTime | BOOLEAN | |||
| intr_recordingPath | VARCHAR(256) | |||
| intr_recordingTranscription | VARCHAR(16777216) | |||
| intr_interactionVariables | VARCHAR(16777216) | |||
| intr_HPBXCallInfo | VARCHAR(16777216) | HPBX call info in JSON format | ||
| intr_disconnectingParty | NUMBER(38,0) | |||
| intr_dynamicRoutingData | VARCHAR(16777216) | |||
ECSInteractionSegmentFact | ||||
| Column Name | Snowflake Type | Description | References | Comments |
| iseg_id | NUMBER(38,0) | Primary key | ||
| iseg_interactionSegmentId | NUMBER(38,0) | Interaction segment identifier | ||
| iseg_interactionLeg | NUMBER(38,0) | Interaction leg | ||
| iseg_agentHandlingTime | NUMBER(38,0) | Agent handling time | ||
| iseg_agentId | NUMBER(15,0) | Foreign key to the agent | ECSUserDimension | |
| iseg_answeredWithinGoalTime | BOOLEAN | Flag: was interaction answered within a goal time? | ||
| iseg_areaCodeId | NUMBER(38,0) | Foreign key to the area code | AreaCodeDimension | |
| iseg_businessProcessId | NUMBER(15,0) | Foreign key to the business process | ECSBusinessProcessDimension | |
| iseg_CRMContactId | VARCHAR(36) | Identifier to CRM contact | ||
| iseg_campaignId | NUMBER(15,0) | Foreign key to the campaign | ECSCampaignDimension | |
| iseg_closedBySystem | BOOLEAN | Flag: was interaction closed by system? | ||
| iseg_consultTime | NUMBER(38,0) | Consult time | ||
| iseg_currentSLThreshold | NUMBER(38,0) | Current Service Level Threshold | ||
| iseg_customerBillingCode | VARCHAR(128) | Customer billing code | ||
| iseg_customerCalls | NUMBER(38,0) | Customer calls | ||
| iseg_destination | VARCHAR(16777216) | Destination | ||
| iseg_directionId | NUMBER(38,0) | Deprecated | Deprecated field. Replaced by: iseg_directionName. | |
| iseg_dispositionCode | VARCHAR(256) | Disposition Code | ||
| iseg_dispositionCodeCategory | VARCHAR(128) | Disposition Code Category | ||
| iseg_dispositionCodeSubCategory | VARCHAR(128) | Disposition Code Sub Category | ||
| iseg_duration | NUMBER(38,0) | Last attempt duration | ||
| iseg_emailBacklog | BOOLEAN | Flag: was email interaction kept in a backlog? | ||
| iseg_endDateSliceId | NUMBER(38,0) | Foreign key to the interaction segment end date in UTC | DateDimension | |
| iseg_endTime | TIMESTAMP_NTZ(9) | Segment end time in UTC | ||
| iseg_endTimeSliceId | NUMBER(38,0) | Foreign key to the interaction segment end time of day in UTC | TimeOfDayDimension | |
| iseg_endedInRequestDNC | BOOLEAN | Ended in request "Do not call" | ||
| iseg_endedInTransfer | BOOLEAN | Flag: was interaction ended in transfer? | ||
| iseg_endingStatus | VARCHAR(50) | Ending status - currently not in use | ||
| iseg_enterDateSliceId | NUMBER(38,0) | Foreign key to the interaction Interaction enter date in UTC | DateDimension | |
| iseg_enterTime | TIMESTAMP_NTZ(9) | When the interaction was added to campaign (loaded) | ||
| iseg_enterTimeSliceId | NUMBER(38,0) | Foreign key to the interaction enter time of day in UTC | TimeOfDayDimension | |
| iseg_eomId | NUMBER(38,0) | Foreign key to the ECS organization | ECSOrganizationMapping | |
| iseg_externalTransferDID | VARCHAR(128) | External transfer DID | ||
| iseg_handler | NUMBER(38,0) | Identifier to handler (source key from D_Agent, D_BusinessProcess or D_InteractionChannel) | ||
| iseg_hasAnotherAttempt | BOOLEAN | Flag: is there another attempt? | ||
| iseg_holdTime | NUMBER(38,0) | Hold time in seconds | ||
| iseg_IVRTime | NUMBER(38,0) | IVR time | ||
| iseg_interactionChannelId | NUMBER(15,0) | Foreign key of the interaction channel | ECSInteractionChannelDimension | |
| iseg_interactionCreationTypeId | NUMBER(38,0) | Deprecated | Deprecated field. Replaced by iseg_creationTypeName | |
| iseg_interactionEndDateSliceId | NUMBER(38,0) | Foreign key to the Interaction end date in UTC | DateDimension | |
| iseg_interactionEndTime | TIMESTAMP_NTZ(9) | Interaction end time in UTC | ||
| iseg_interactionEndTimeSliceId | NUMBER(38,0) | Foreign key to the Interaction end time of day in UTC | TimeOfDayDimension | |
| iseg_interactionGUIDID | VARCHAR(36) | GUID identifier to interaction | ||
| iseg_interactionId | NUMBER(38,0) | Identifier of the interaction | ||
| iseg_interactionMediaId | NUMBER(38,0) | Deprecated | Deprecated field. Replaced by: iseg_interactionMediaName | |
| iseg_interactionResultId | NUMBER(15,0) | Deprecated | Deprecated field. Replaced by: iseg_interactionResultName | |
| iseg_interactionStartDateSliceId | NUMBER(38,0) | Foreign key to the Interaction start date in UTC | DateDimension | |
| iseg_interactionStartTime | TIMESTAMP_NTZ(9) | Interaction start time in UTC | ||
| iseg_interactionStartTimeSliceId | NUMBER(38,0) | Foreign key to the Interaction start time of day in UTC | TimeOfDayDimension | |
| iseg_interactionStateId | NUMBER(15,0) | Foreign key of the interaction state | ECSInteractionStateDimension | |
| iseg_interactionTypeId | NUMBER(15,0) | Foreign key of the interaction type | ECSInteractionTypeDimension | |
| iseg_isDeferrable | BOOLEAN | Flag: was the interaction deferrable? | ||
| iseg_lasHandlerHandlingTime | NUMBER(38,0) | Last handler handling time | ||
| iseg_lastAttemptAgentId | NUMBER(15,0) | Foreign key to the last attempt agent | ECSUserDimension | |
| iseg_lastAttemptAnswerDateSliceId | Deprecated | Deprecated field | ||
| iseg_lastAttemptAnswerTime | TIMESTAMP_NTZ(9) | Last attempt answer time in UTC | ||
| iseg_lastAttemptAnswerTimeSliceId | NUMBER(38,0) | Deprecated | Deprecated field | |
| iseg_lastAttemptDateSliceId | NUMBER(38,0) | Deprecated | Deprecated field | |
| iseg_lastAttemptDestination | VARCHAR(128) | Last attempt destination | ||
| iseg_lastAttemptEndDateSliceId | NUMBER(38,0) | Deprecated | Deprecated field | |
| iseg_lastAttemptEndTime | TIMESTAMP_NTZ(9) | Last attempt end time in UTC | ||
| iseg_lastAttemptEndTimeSliceId | NUMBER(38,0) | Deprecated | Deprecated field | |
| iseg_lastAttemptInteractionStateId | NUMBER(15,0) | Foreign key to the last attempt interaction state | ECSInteractionStateDimension | |
| iseg_lastAttemptRemarks | VARCHAR(16777216) | Remarks of last attempt | ||
| iseg_lastAttemptTime | TIMESTAMP_NTZ(9) | Last Attempt time in UTC | ||
| iseg_lastAttemptTimeSliceId | NUMBER(38,0) | Deprecated | Deprecated field | |
| iseg_lastInteractionStateId | NUMBER(15,0) | Foreign key of the last interaction state | ECSInteractionStateDimension | |
| iseg_lastTreatingAgentId | NUMBER(15,0) | Foreign key of the agent last treated the interaction | ECSUserDimension | |
| iseg_lastTreatingBusinessProcessId | NUMBER(15,0) | Foreign key of the business process last treated the interaction | ECSBusinessProcessDimension | |
| iseg_lastTreatingInteractionChannelId | NUMBER(15,0) | Foreign key of the channel last treated the interaction | ECSInteractionChannelDimension | |
| iseg_mistreatedCode | NUMBER(38,0) | DNC number | ||
| iseg_mistreatedDateSliceId | NUMBER(38,0) | Deprecated | Deprecated field | |
| iseg_mistreatedTime | TIMESTAMP_NTZ(9) | When DNC number was called in UTC | ||
| iseg_mistreatedTimeSliceId | NUMBER(38,0) | Deprecated | Deprecated field | |
| iseg_nextInteractionStateId | NUMBER(15,0) | Foreign key to the next interaction state | ECSInteractionStateDimension | |
| iseg_numberOfAttempts | NUMBER(38,0) | Number of attempts | ||
| iseg_origin | VARCHAR(128) | Origin | ||
| iseg_originatedFromId | NUMBER(38,0) | Deprecated | Deprecated field. Replaced by iseg_originatedFromName | |
| iseg_overflow | BOOLEAN | Flag: was interaction overflow? | ||
| iseg_previousAgentId | NUMBER(15,0) | is not actual | ||
| iseg_previousBusinessProcessId | NUMBER(15,0) | is not actual | ||
| iseg_previousHandlerHandlingTime | NUMBER(38,0) | is not actual | ||
| iseg_previousInteractionChannelId | NUMBER(15,0) | Foreign key to the previous interaction channel | ||
| iseg_queueTime | NUMBER(38,0) | Queue time | ||
| iseg_queued | BOOLEAN | Flag: was interaction queued? | ||
| iseg_remarks | VARCHAR(16777216) | Remarks | ||
| iseg_responseCount | NUMBER(38,0) | Count of responses within a conversation | ||
| iseg_responseTimeSum | NUMBER(38,0) | Summarized count of seconds in responses within a conversation | ||
| iseg_SLExcluded | BOOLEAN | Flag: was interaction excluded from Service Level calculations? | ||
| iseg_sequenceId | NUMBER(38,0) | Sequence number within a specific interaction | ||
| iseg_startDateSliceId | NUMBER(38,0) | Foreign key to the interaction segment start date in UTC | DateDimension | |
| iseg_startTime | TIMESTAMP_NTZ(9) | Segment start time in UTC | ||
| iseg_startTimeSliceId | NUMBER(38,0) | Foreign key to the interaction segment start time of day in UTC | TimeOfDayDimension | |
| iseg_talkTime | NUMBER(38,0) | Talk time in seconds | ||
| iseg_telephonyTimeExternalAgent | NUMBER(38,0) | External agent telephony time | ||
| iseg_telephonyTimeExternalConsult | NUMBER(38,0) | External consulting telephony time | ||
| iseg_telephonyTimeIncoming | NUMBER(38,0) | Incoming telephony time | ||
| iseg_telephonyTimeOutgoing | NUMBER(38,0) | Outgoing telephony time | ||
| iseg_timeZoneId | NUMBER(38,0) | Foreign key to time zone | TimeZoneDimension | |
| iseg_updateDateTime | TIMESTAMP_NTZ(9) | Segment last update date time | ||
| iseg_voiceMailAssignedAgentId | NUMBER(15,0) | Foreign key to the assigned agent for a voicemail | ECSUserDimension | |
| iseg_voiceMailLeft | BOOLEAN | Flag: was left a voicemail | ||
| iseg_wasAbandoned | BOOLEAN | Flag: was interaction abandoned? | ||
| iseg_wrapUpTime | NUMBER(38,0) | Wrap Up time in seconds | ||
| iseg_eipId | VARCHAR(16) | The account identifier | ||
| iseg_oldCallbackExisted | VARCHAR(36) | Was interaction handled after a callback requested? if yes, then GUID identifier will be defined here | ||
| iseg_telephonyTimeExternalTransfer | NUMBER(38,0) | External Transfer telephony time | ||
| iseg_handlerTypeName | VARCHAR(128) | Handler type name | ||
| iseg_directionName | VARCHAR(128) | Direction name | ||
| iseg_interactionResultName | VARCHAR(128) | Interaction result name | ||
| iseg_interactionMediaName | VARCHAR(128) | Interaction media name | ||
| iseg_originatedFromName | VARCHAR(128) | Originated source name of the interaction | ||
| iseg_businessProcessName | VARCHAR(128) | Business process name | ||
| iseg_interactionCreationTypeName | VARCHAR(128) | Interaction creation type name | ||
| iseg_interactionStateName | VARCHAR(128) | Interaction state name | ||
| iseg_routingClientName | VARCHAR(64) | Routing client name | ||
| iseg_routingInboundCampaignName | VARCHAR(64) | Routing Inbound campaign name | ||
| iseg_routingProductName | VARCHAR(64) | Routing product name | ||
| iseg_routingProductType | VARCHAR(64) | Routing product type | ||
| iseg_CRMFirstName | VARCHAR(64) | First name of the CRM contact | ||
| iseg_CRMLastName | VARCHAR(64) | Last name of the CRM contact | ||
| iseg_segmentDuration | NUMBER(38,0) | Segment duration | ||
| iseg_agentAnswerTime | NUMBER(38,0) | This is the sum of time spent in the queue (excluding ring time / offer time) | ||
| iseg_agentDelayTime | NUMBER(38,0) | The sum of time spent in the queue (excluding ring time / offer time ) | ||
| iseg_selectTime | TIMESTAMP_NTZ(9) | |||
| iseg_inbound | BOOLEAN | Indicates if the interaction creation type is inbound | ||
| iseg_outBound | BOOLEAN | Indicates if the interaction creation type is outbound | ||
| iseg_callback | BOOLEAN | Indicates if the interaction creation type is callback | ||
| iseg_telephony | BOOLEAN | Indicates if the interaction is a telephony interaction | ||
| iseg_chat | BOOLEAN | Indicates if the interaction is a chat interaction | ||
| iseg_email | BOOLEAN | Indicates if the interaction is an email interaction | ||
| iseg_callbackRequests | BOOLEAN | Indicates that a callback was requested | ||
| iseg_callbackCompleted | BOOLEAN | Indicates the callback has been completed | ||
| iseg_transferredIn | BOOLEAN | Indicates if the interaction is transferred in | ||
| iseg_transferredOut | BOOLEAN | Indicates if the interaction is an external transfer | ||
| iseg_disconnected | BOOLEAN | Indicates if handled interaction was closed by the system | ||
| iseg_answered | BOOLEAN | Indicates if the incoming interaction has been answered | ||
| iseg_consulted | BOOLEAN | Indicates if the interaction state is consulted | ||
| iseg_talked | BOOLEAN | Indicates if the interaction talk time > 0 | ||
| iseg_rescheduled | BOOLEAN | Indicates emails that were manually scheduled by an agent to be answered at a later time | ||
| iseg_handled | BOOLEAN | Indicates if an incoming email interaction was handled by an agent | ||
| iseg_missed | BOOLEAN | Indicates if the interaction has been missed | ||
| iseg_rejected | BOOLEAN | Indicates if the interaction was rejected | ||
| iseg_handledInBP | BOOLEAN | Indicates if the interaction was first handled by a business process | ||
| iseg_handledByAgent | BOOLEAN | Indicates if the interaction was handled by an agent | ||
| iseg_answeredAllTypes | BOOLEAN | Indicates if the interaction is in handling state | ||
| iseg_BPExist | BOOLEAN | Indicates if segment has a business process associated with it | ||
| iseg_parentEipId | VARCHAR(16) | The account parent identifier | ||
| iseg_interactionStartTimestampLocal | TIMESTAMP_NTZ(9) | Interaction start time in local time | ||
| iseg_interactionEndTimestampLocal | TIMESTAMP_NTZ(9) | Interaction end time in local time | ||
| iseg_startTimestampLocal | TIMESTAMP_NTZ(9) | Segment start time in local time | ||
| iseg_endTimestampLocal | TIMESTAMP_NTZ(9) | Segment end time in local time | ||
| iseg_enterTimestampLocal | TIMESTAMP_NTZ(9) | When the interaction was added to campaign (loaded) in local time | ||
| iseg_interactionStartDateLocal | NUMBER(38,0) | Foreign key to the interaction start date in local time | DateDimension | |
| iseg_interactionStartTimeLocal | NUMBER(38,0) | Foreign key to the interaction start time of day in local time | TimeOfDayDimension | |
| iseg_interactionEndDateLocal | NUMBER(38,0) | Foreign key to the interaction end date in local time | DateDimension | |
| iseg_interactionEndTimeLocal | NUMBER(38,0) | Foreign key to the interaction end time of day in local time | TimeOfDayDimension | |
| iseg_startDateLocal | NUMBER(38,0) | Foreign key to the start date in local time | DateDimension | |
| iseg_startTimeLocal | NUMBER(38,0) | Foreign key to the start time of day in local time | TimeOfDayDimension | |
| iseg_endDateLocal | NUMBER(38,0) | Foreign key to the end date in local time | DateDimension | |
| iseg_endTimeLocal | NUMBER(38,0) | Foreign key to the end time of day in local time | TimeOfDayDimension | |
| iseg_enterDateLocal | NUMBER(38,0) | Foreign key to the enter date in local time | DateDimension | |
| iseg_enterTimeLocal | NUMBER(38,0) | Foreign key to the enter time of day in local time | TimeOfDayDimension | |
| iseg_lastUpdatedTimestamp | TIMESTAMP_NTZ(9) | The record updated timestamp | ||
| iseg_updated | BOOLEAN | Indicates whether the record was updated | ||
| iseg_previewTime | NUMBER(38,0) | Preview time | ||
| iseg_additionalInfo | VARCHAR(16777216) | Additional info | ||
| iseg_HPBXCallInfo | VARCHAR(16777216) | HPBX call info in JSON format | ||
| iseg_SIPCallId | VARCHAR(16777216) | The SIP call ID | ||
ECSInteractionSkillFact | ||||
| Column Name | Snowflake Type | Description | References | Comments |
| iskl_id | NUMBER(38,0) | Primary key | ||
| iskl_active | BOOLEAN | Flag: is active or not | ||
| iskl_date | NUMBER(38,0) | Foreign key to the skill date | DateDimension | |
| iskl_entityId | NUMBER(38,0) | Identifier of entity | ||
| iskl_entityTypeId | NUMBER(38,0) | Deprecated | Deprecated field. Replaced by iskl_entityTypeName | |
| iskl_eomId | NUMBER(38,0) | Foreign key to ECS organization | ECSOrganizationMapping | |
| iskl_interactionId | VARCHAR(36) | Identifier to interaction | ||
| iskl_interactionSkillId | NUMBER(38,0) | Identifier of the interaction skill | ||
| iskl_levelId | NUMBER(38,0) | Deprecated | Deprecated field. Replaced by iskl_levelName | |
| iskl_skillId | NUMBER(15,0) | Deprecated | Deprecated field. Replaced by iskl_skillName | |
| iskl_time | NUMBER(38,0) | Foreign key to the skill time | TimeOfDayDimension | |
| iskl_timestamp | TIMESTAMP_NTZ(9) | false | ||
| iskl_eipId | VARCHAR(16) | The account identifier | ||
| iskl_entityTypeName | VARCHAR(50) | Entity type name | ||
| iskl_levelName | VARCHAR(50) | Level name | ||
| iskl_skillName | VARCHAR(128) | Skill name | ||
| iskl_parentEipId | VARCHAR(16) | The parent account identifier | ||
| iskl_lastUpdatedTimestamp | TIMESTAMP_NTZ(9) | false | ||
| iskl_updated | BOOLEAN | Indicates whether the record was updated | ||
ECSInteractionConversationFact | ||||
| Column Name | Snowflake Type | Description | References | Comments |
| icnv_id | NUMBER(38,0) | Primary key | ||
| icnv_interactionConversationId | NUMBER(38,0) | The interaction conversation identifier | ||
| icnv_interactionMediaName | VARCHAR(100) | The name to media: email / chat | ||
| icnv_interactionGUIDID | VARCHAR(36) | The interaction GUID identifier | ||
| icnv_interactionId | NUMBER(38,0) | Identifier to interaction | ||
| icnv_isCustomer | BOOLEAN | Flag: was a message from customer? | ||
| icnv_messageTimestamp | TIMESTAMP_NTZ(9) | The message timestamp in UTC | ||
| icnv_messageTime | NUMBER(38,0) | Foreign key to the interaction message time in UTC | TimeOfDayDimension | |
| icnv_messageDate | NUMBER(38,0) | Foreign key to the interaction message date in UTC | DateDimension | |
| icnv_messageTimestampLocal | TIMESTAMP_NTZ(9) | The message timestamp in local time | ||
| icnv_messageTimeLocal | NUMBER(38,0) | Foreign key to the interaction message date in local time | TimeOfDayDimension | |
| icnv_messageDateLocal | NUMBER(38,0) | Foreign key to the interaction message date in local time | DateDimension | |
| icnv_messageText | VARCHAR(16777216) | The message text | ||
| icnv_subject | VARCHAR(16777216) | The email subject | ||
| icnv_from | VARCHAR(16777216) | The sender | ||
| icnv_to | VARCHAR(16777216) | The recipient | ||
| icnv_cc | VARCHAR(16777216) | Carbon copy | ||
| icnv_bcc | VARCHAR(16777216) | Blind carbon copy | ||
| icnv_sessionClosed | BOOLEAN | |||
| icnv_eomId | NUMBER(38,0) | Foreign key to ECS organization | ECSOrganizationMapping | |
| icnv_eipId | VARCHAR(16) | The account identifier | ||
| icnv_parentEipId | VARCHAR(16) | The parent account identifier | ||
| icnv_lastUpdatedTimestamp | TIMESTAMP_NTZ(9) | The record updated timestamp | ||
| icnv_updated | BOOLEAN | Indicates whether the record was updated | ||
ECSInteractionDelegatedFact | ||||
| Column Name | Snowflake Type | Description | References | Comments |
| eidf_id | NUMBER(38,0) | Primary key | ||
| eidf_interactionDelegatedId | NUMBER(38,0) | The interaction delegated identifier | ||
| eidf_interactionGUIDID | VARCHAR(36) | The interaction GUID identifier | ||
| eidf_interactionTypeId | NUMBER(15,0) | Foreign key to the interaction type | ECSInteractionTypeDimension | |
| eidf_businessProcessId | NUMBER(15,0) | Foreign key to the business process | ECSBusinessProcessDimension | |
| eidf_businessProcessName | VARCHAR(100) | The business process name | ||
| eidf_details | VARCHAR(16777216) | |||
| eidf_converser | VARCHAR(256) | |||
| eidf_initiatorAgentId | NUMBER(15,0) | Foreign key to the intiator agent | ||
| eidf_initiatorBusinessProcessId | NUMBER(15,0) | Foreign key to the initiator business process | ||
| eidf_initiatorName | VARCHAR(50) | Initiator name | ||
| eidf_entryTimestamp | TIMESTAMP_NTZ(9) | Entry timestamp in UTC | ||
| eidf_entryDate | NUMBER(38,0) | Foreign key to the entry date in UTC | DateDimension | |
| eidf_entryTime | NUMBER(38,0) | Foreign key to the entry time in UTC | TimeOfDayDimension | |
| eidf_entryTimestampLocal | TIMESTAMP_NTZ(9) | Entry timestamp in local time | ||
| eidf_entryDateLocal | NUMBER(38,0) | Foreign key to the entry date in local time | DateDimension | |
| eidf_entryTimeLocal | NUMBER(38,0) | Foreign key to the entry time in local time | TimeOfDayDimension | |
| eidf_updateTimestamp | TIMESTAMP_NTZ(9) | Update timestamp in UTC | ||
| eidf_updateDate | NUMBER(38,0) | Foreign key to the update date in UTC | DateDimension | |
| eidf_updateTime | NUMBER(38,0) | Foreign key to the update time in UTC | TimeOfDayDimension | |
| eidf_remarks | VARCHAR(16777216) | Remarks | ||
| eidf_delegatedStateName | VARCHAR(100) | The interaction delegated state name | ||
| eidf_interactionMediaName | VARCHAR(100) | The interaction media name | ||
| eidf_interactionStateId | NUMBER(15,0) | Foreign key to the interaction state | ECSInteractionStateDimension | |
| eidf_interactionStateName | VARCHAR(100) | Interaction state name | ||
| eidf_callback | BOOLEAN | |||
| eidf_campaignId | NUMBER(15,0) | Foreign key to the campaign | ECSCampaignDimension | |
| eidf_campaignName | VARCHAR(100) | The campaign name | ||
| eidf_customerId | VARCHAR(16777216) | |||
| eidf_supervisorCloseMessage | VARCHAR(16777216) | |||
| eidf_eomId | NUMBER(38,0) | Foreign key to ECS organization | ECSOrganizationMapping | |
| eidf_eipId | VARCHAR(16) | The account identifier | ||
| eidf_parentEipId | VARCHAR(16) | The parent account identifier | ||
ECSInteractionUsageFact | ||||
| Column Name | Snowflake Type | Description | References | Comments |
| iusg_id | NUMBER(38,0) | Primary key | ||
| iusg_interactionUsageId | NUMBER(38,0) | The interaction usage identifier | ||
| iusg_interactionId | NUMBER(38,0) | The interaction identifier | ||
| iusg_interactionGUIDID | VARCHAR(36) | The interaction GUID identifier | ||
| iusg_origin | VARCHAR(128) | Origin | ||
| iusg_destination | VARCHAR(128) | Destination | ||
| iusg_directionName | VARCHAR(128) | Direction name | ||
| iusg_duration | NUMBER(38,0) | Usage duration | ||
| iusg_lastHandler | VARCHAR(256) | The last handler name | ||
| iusg_startTime | NUMBER(38,0) | Foreign key to the usage start time in UTC | TimeOfDayDimension | |
| iusg_startDate | NUMBER(38,0) | Foreign key to the usage start date in UTC | DateDimension | |
| iusg_startTimeLocal | NUMBER(38,0) | Foreign key to the usage start time in local time | TimeOfDayDimension | |
| iusg_startDateLocal | NUMBER(38,0) | Foreign key to the usage start date in local time | DateDimension | |
| iusg_endTime | NUMBER(38,0) | Foreign key to the usage end time in UTC | TimeOfDayDimension | |
| iusg_endDate | NUMBER(38,0) | Foreign key to the usage end date in UTC | DateDimension | |
| iusg_endTimeLocal | NUMBER(38,0) | Foreign key to the usage end time in local time | TimeOfDayDimension | |
| iusg_endDateLocal | NUMBER(38,0) | Foreign key to the usage end date in local time | DateDimension | |
| iusg_startTimestamp | TIMESTAMP_NTZ(9) | The usage start timestamp in UTC | ||
| iusg_startTimestampLocal | TIMESTAMP_NTZ(9) | The usage start timestamp in local time | ||
| iusg_endTimestamp | TIMESTAMP_NTZ(9) | The usage end timestamp in UTC | ||
| iusg_endTimestampLocal | TIMESTAMP_NTZ(9) | The usage end timestamp in local time | ||
| iusg_interactionUsageTypeName | VARCHAR(128) | The interaction usage type name | ||
| iusg_interactionStateId | NUMBER(15,0) | Foreign key to the interaction state | ||
| iusg_interactionStateName | VARCHAR(128) | The interaction state name | ||
| iusg_dispositionCode | VARCHAR(256) | Disposition code | ||
| iusg_businessProcessId | NUMBER(15,0) | Foreign key to the business process | ECSBusinessProcessDimension | |
| iusg_businessProcessName | VARCHAR(128) | The business process name | ||
| iusg_needsUpdateAfterByeTransfer | BOOLEAN | Flag | ||
| iusg_eomId | NUMBER(38,0) | Foreign key to ECS organization | ECSOrganizationMapping | |
| iusg_eipId | VARCHAR(16) | The account identifier | ||
| iusg_parentEipId | VARCHAR(16) | The parent account identifier | ||
| iusg_lastUpdatedTimestamp | TIMESTAMP_NTZ(9) | The record updated timestamp | ||
| iusg_updated | BOOLEAN | Indicates whether the record was updated | ||
ECSAgentBpTimeFact | ||||
| Column Name | Snowflake Type | Description | References | Comments |
| abpt_id | NUMBER(38,0) | Primary key | ||
| abpt_agentBpTimeId | NUMBER(38,0) | The Agent Bp time source identifier | ||
| abpt_agentId | NUMBER(15,0) | Agent foreign key | ECSUserDimension | |
| abpt_agentName | VARCHAR(100) | Agent name | ||
| abpt_backOffice | NUMBER(38,0) | |||
| abpt_backofficeBusy | NUMBER(38,0) | |||
| abpt_backofficeIdle | NUMBER(38,0) | |||
| abpt_break | NUMBER(38,0) | |||
| abpt_businessProcessId | NUMBER(15,0) | Business process foreign key | ECSBusinessProcessDimension | |
| abpt_businessProcessName | VARCHAR(100) | Business process name | ||
| abpt_busy | NUMBER(38,0) | |||
| abpt_consulting | NUMBER(38,0) | |||
| abpt_dialing | NUMBER(38,0) | |||
| abpt_handling | NUMBER(38,0) | |||
| abpt_handlingOutgoingInt | NUMBER(38,0) | |||
| abpt_handlingOutgoingIntBusy | NUMBER(38,0) | |||
| abpt_handlingOutgoingIntIdle | NUMBER(38,0) | |||
| abpt_handlingTime | NUMBER(38,0) | |||
| abpt_inConference | NUMBER(38,0) | |||
| abpt_isAssigned | NUMBER(38,0) | |||
| abpt_isInternal | NUMBER(38,0) | |||
| abpt_outgoingBreakExists | NUMBER(38,0) | |||
| abpt_noAnswer | NUMBER(38,0) | |||
| abpt_offered | NUMBER(38,0) | |||
| abpt_loginTime | NUMBER(38,0) | |||
| abpt_ready | NUMBER(38,0) | |||
| abpt_waitingFor | NUMBER(38,0) | |||
| abpt_startDate | NUMBER(38,0) | Foreign key to the Agent BP time start date in UTC | DateDimension | |
| abpt_startTime | NUMBER(38,0) | Foreign key to the Agent BP time start time in UTC | TimeOfDayDimension | |
| abpt_startDateLocal | NUMBER(38,0) | Foreign key to the Agent BP time start date in local time | DateDimension | |
| abpt_startTimeLocal | NUMBER(38,0) | Foreign key to the Agent BP time start time in local time | TimeOfDayDimension | |
| abpt_startTimestamp | TIMESTAMP_NTZ(9) | Agent BP time start timestamp in UTC | ||
| abpt_startTimestampLocal | TIMESTAMP_NTZ(9) | Agent BP time start timestamp in local time | ||
| abpt_endDate | NUMBER(38,0) | Foreign key to the Agent BP time end date in UTC | DateDimension | |
| abpt_endTime | NUMBER(38,0) | Foreign key to the Agent BP time end time in UTC | TimeOfDayDimension | |
| abpt_endDateLocal | NUMBER(38,0) | Foreign key to the Agent BP time end date in local time | DateDimension | |
| abpt_endTimeLocal | NUMBER(38,0) | Foreign key to the Agent BP time end time in local time | TimeOfDayDimension | |
| abpt_endTimestamp | TIMESTAMP_NTZ(9) | Agent BP time end timestamp in UTC | ||
| abpt_endTimestampLocal | TIMESTAMP_NTZ(9) | Agent BP time end timestamp in local time | ||
| abpt_eomId | NUMBER(38,0) | ECS organization foreign key | ECSOrganizationMapping | |
| abpt_eipId | VARCHAR(16) | The account identifier | ||
| abpt_parentEipId | VARCHAR(16) | The parent account identifier | ||
| abpt_lastUpdatedTimestamp | TIMESTAMP_NTZ(9) | The record updated timestamp | ||
| abpt_updated | BOOLEAN | Indicates whether the record was updated | ||
ECSAgentAssignmentFact | ||||
| Column Name | Snowflake Type | Description | References | Comments |
| aaf_id | NUMBER(38,0) | Primary key | ||
| aaf_agentAssignmentsLogId | NUMBER(38,0) | The agent assignment source identifier | ||
| aaf_agentId | NUMBER(15,0) | Agent foreign key | ECSUserDimension | |
| aaf_agentName | VARCHAR(128) | Agent name | ||
| aaf_businessProcessId | NUMBER(15,0) | Business process foreign key | ECSBusinessProcessDimension | |
| aaf_businessProcessName | VARCHAR(128) | Business process name | ||
| aaf_modifiedBy | VARCHAR(100) | |||
| aaf_startTime | NUMBER(38,0) | Foreign key to the Agent assignment start time in UTC | TimeOfDayDimension | |
| aaf_startDate | NUMBER(38,0) | Foreign key to the Agent assignment start date in UTC | DateDimension | |
| aaf_startTimeLocal | NUMBER(38,0) | Foreign key to the Agent assignment start time in local time | TimeOfDayDimension | |
| aaf_startDateLocal | NUMBER(38,0) | Foreign key to the Agent assignment start date in local time | DateDimension | |
| aaf_endTime | NUMBER(38,0) | Foreign key to the Agent assignment end time in UTC | TimeOfDayDimension | |
| aaf_endDate | NUMBER(38,0) | Foreign key to the Agent assignment end date in UTC | DateDimension | |
| aaf_endTimeLocal | NUMBER(38,0) | Foreign key to the Agent assignment end time in local time | TimeOfDayDimension | |
| aaf_endDateLocal | NUMBER(38,0) | Foreign key to the Agent assignment end date in local time | DateDimension | |
| aaf_startTimestamp | TIMESTAMP_NTZ(9) | Agent assignment start timestamp in UTC | ||
| aaf_startTimestampLocal | TIMESTAMP_NTZ(9) | Agent assignment start timestamp in local time | ||
| aaf_endTimestamp | TIMESTAMP_NTZ(9) | Agent assignment end timestamp in UTC | ||
| aaf_endTimestampLocal | TIMESTAMP_NTZ(9) | Agent assignment end timestamp in local time | ||
| aaf_eomId | VARCHAR(128) | ECS organization foreign key | ECSOrganizationMapping | |
| aaf_eipId | VARCHAR(16) | The account identifier | ||
| aaf_parentEipId | VARCHAR(16) | The parent account identifier | ||
| aaf_lastUpdatedTimestamp | TIMESTAMP_NTZ(9) | The record updated timestamp | ||
| aaf_updated | BOOLEAN | Indicates whether the record was updated | ||
| aaf_status | VARCHAR(16) | |||
ECSSupervisorAssignmentFact | ||||
| Column Name | Snowflake Type | Description | References | Comments |
| saf_id | NUMBER(38,0) | Primary key | ||
| saf_supervisorAssignmentsLogId | NUMBER(38,0) | The supervisor assignment source identifier | ||
| saf_supervisorId | NUMBER(15,0) | Supervisor Foreign key | ECSUserDimension | |
| saf_supervisorName | VARCHAR(128) | Supervisor name | ||
| saf_businessProcessId | NUMBER(15,0) | Business process foreign key | ECSBusinessProcessDimension | |
| saf_businessProcessName | VARCHAR(128) | Business process name | ||
| saf_modifiedBy | VARCHAR(100) | |||
| saf_startTime | NUMBER(38,0) | Foreign key to the Supervisor assignment start time in UTC | TimeOfDayDimension | |
| saf_startDate | NUMBER(38,0) | Foreign key to the Supervisor assignment start date in UTC | DateDimension | |
| saf_startTimeLocal | NUMBER(38,0) | Foreign key to the Supervisor assignment start time in local time | TimeOfDayDimension | |
| saf_startDateLocal | NUMBER(38,0) | Foreign key to the Supervisor assignment start date in local time | DateDimension | |
| saf_endTime | NUMBER(38,0) | Foreign key to the Supervisor assignment end time in UTC | TimeOfDayDimension | |
| saf_endDate | NUMBER(38,0) | Foreign key to the Supervisor assignment date time in UTC | DateDimension | |
| saf_endTimeLocal | NUMBER(38,0) | Foreign key to the Supervisor assignment end time in local time | TimeOfDayDimension | |
| saf_endDateLocal | NUMBER(38,0) | Foreign key to the Supervisor assignment end date in local time | DateDimension | |
| saf_startTimestamp | TIMESTAMP_NTZ(9) | Supervisor assignment start timestamp in UTC | ||
| saf_startTimestampLocal | TIMESTAMP_NTZ(9) | Supervisor assignment start timestamp in local time | ||
| saf_endTimestamp | TIMESTAMP_NTZ(9) | Supervisor assignment end timestamp in UTC | ||
| saf_endTimestampLocal | TIMESTAMP_NTZ(9) | Supervisor assignment end timestamp in local time | ||
| saf_eomId | NUMBER(38,0) | ECS organization foreign key | ECSOrganizationMapping | |
| saf_eipId | VARCHAR(16) | The account identifier | ||
| saf_parentEipId | VARCHAR(16) | The parent account identifier | ||
| saf_lastUpdatedTimestamp | TIMESTAMP_NTZ(9) | The record updated timestamp | ||
| saf_updated | BOOLEAN | Indicates whether the record was updated | ||
| saf_status | VARCHAR(16) | |||
ECSCallbackFact | ||||
| Column Name | Snowflake Type | Description | References | Comments |
| ecbf_id | NUMBER(38,0) | Primary key | ||
| ecbf_callbackId | NUMBER(38,0) | The callback source identifier | ||
| ecbf_interactionGUIDID | VARCHAR(36) | Interaction GUID identifier | ||
| ecbf_destination | VARCHAR(16777216) | Destination | ||
| ecbf_campaignId | NUMBER(15,0) | Campaign foreign key | ||
| ecbf_campaignName | VARCHAR(100 | Campaign name | ||
| ecbf_completedInteractionId | NUMBER(38,0) | The completed interaction identifier | ||
| ecbf_completedInteractionStartTimestamp | TIMESTAMP_NTZ(9) | The completed interaction start time in UTC | ||
| ecbf_completedBusinessProcessId | NUMBER(15,0) | Foreign key to the completed Business Process | ECSBusinessProcessDimension | |
| ecbf_completedBusinessProcessName | VARCHAR(100) | Complete Business Process name | ||
| ecbf_requestedBusinessProcessId | NUMBER(15,0) | Foreign key to the requested business process | ECSBusinessProcessDimension | |
| ecbf_requestedBusinessProcessName | VARCHAR(100) | Requested business process name | ||
| ecbf_requestedCallbackCount | NUMBER(38,0) | Requested callback count | ||
| ecbf_customerCalls | NUMBER(38,0) | Customer calls | ||
| ecbf_customerData | VARCHAR(16777216) | Customer data | ||
| ecbf_webCallback | BOOLEAN | |||
| ecbf_dispositionCode | VARCHAR(200) | Disposition code | ||
| ecbf_dispositionCodeCategory | VARCHAR(128) | Disposition code category | ||
| ecbf_dispositionCodeSubCategory | VARCHAR(128) | Disposition code sub category | ||
| ecbf_firstRequestedInteractionId | NUMBER(38,0) | First requests interaction identifier | ||
| ecbf_interactionCreationTypeName | VARCHAR(128) | Interaction creation type name | ||
| ecbf_interactionResultName | VARCHAR(128) | Interaction result name | ||
| ecbf_startTime | NUMBER(38,0) | Foreign key to the Callback start time in UTC | TimeOfDayDimension | |
| ecbf_startDate | NUMBER(38,0) | Foreign key to the Callback start date in UTC | DateDimension | |
| ecbf_startTimeLocal | NUMBER(38,0) | Foreign key to the Callback start time in local Time | TimeOfDayDimension | |
| ecbf_startDateLocal | NUMBER(38,0) | Foreign key to the Callback start date in local Time | DateDimension | |
| ecbf_endTime | NUMBER(38,0) | Foreign key to the Callback end time in UTC | TimeOfDayDimension | |
| ecbf_endDate | NUMBER(38,0) | Foreign key to the Callback end date in UTC | DateDimension | |
| ecbf_endTimeLocal | NUMBER(38,0) | Foreign key to the Callback end time in local time | TimeOfDayDimension | |
| ecbf_endDateLocal | NUMBER(38,0) | Foreign key to the Callback end date in local time | DateDimension | |
| ecbf_startTimestamp | TIMESTAMP_NTZ(9) | Callback start time in UTC | ||
| ecbf_startTimestampLocal | TIMESTAMP_NTZ(9) | Callback start time in local time | ||
| ecbf_endTimestamp | TIMESTAMP_NTZ(9) | Callback end time in UTC | ||
| ecbf_endTimestampLocal | TIMESTAMP_NTZ(9) | Callback end time in local time | ||
| ecbf_enterTimestamp | TIMESTAMP_NTZ(9) | Callback enter time in UTC | ||
| ecbf_talkTime | NUMBER(38,0) | Talk time in seconds | ||
| ecbf_numberOfAttempts | NUMBER(38,0) | Number of Attempts | ||
| ecbf_lastAttemptAgentId | NUMBER(15,0) | Foreign key to the last attempt's agent | ECSUserDimension | |
| ecbf_lastAttemptDestination | VARCHAR(16777216) | Last attempt's destination | ||
| ecbf_lastAttemptInteractionStateId | NUMBER(15,0) | Foreign key to the last attempt's interaction state | ECSInteractionStateDimension | |
| ecbf_lastAttemptInteractionStateName | VARCHAR(128) | Last attempt's interaction state name | ||
| ecbf_lastAttemptRemarks | VARCHAR(16777216) | Last attempt's remarks | ||
| ecbf_lastAttemptEndTimestamp | TIMESTAMP_NTZ(9) | Last attempt end time in UTC | ||
| ecbf_lastAttemptAnswerTimestamp | TIMESTAMP_NTZ(9) | Last attempt answer time in UTC | ||
| ecbf_lastAttemptTimestamp | TIMESTAMP_NTZ(9) | Last attempt time in UTC | ||
| ecbf_lastAttemptTimestampLocal | TIMESTAMP_NTZ(9) | Last attempt time in local time | ||
| ecbf_lastInteractionStateId | NUMBER(15,0) | Foreign key to the last interaction state | ECSInteractionStateDimension | |
| ecbf_lastInteractionStateName | VARCHAR(128) | Last interaction state name | ||
| ecbf_routingClientName | VARCHAR(50) | Routing client name | ||
| ecbf_routingInboundCampaignName | VARCHAR(50) | Routing inbound campaign name | ||
| ecbf_routingProductName | VARCHAR(50) | Routing product name | ||
| ecbf_routingProductType | VARCHAR(50) | Routing product type | ||
| ecbf_remarks | VARCHAR(16777216) | Callback remarks | ||
| ecbf_timeZone | VARCHAR(128) | Foreign key to the time zone | TimeZoneDimension | |
| ecbf_overflowed | BOOLEAN | |||
| ecbf_queued | BOOLEAN | |||
| ecbf_oldCallbackExisted | VARCHAR(36) | Was interaction handled after a callback requested? if yes, then GUID identifier will be defined here | ||
| ecbf_eomId | NUMBER(38,0) | Foreign key to ECS organization | ECSOrganizationMapping | |
| ecbf_eipId | VARCHAR(16) | The account identifier | ||
| ecbf_parentEipId | VARCHAR(16) | The parent account identifier | ||
| ecbf_status | VARCHAR(16) | Callback status | ||
| ecbf_lastUpdatedTimestamp | TIMESTAMP_NTZ(9) | The record's last update timestamp | ||
| ecbf_updated | BOOLEAN | Indicates whether the record was updated | ||
ECSCampaignFact | ||||
| Column Name | Snowflake Type | Description | References | Comments |
| ecf_id | NUMBER(38,0) | Primary key | ||
| ecf_campaignInteractionId | NUMBER(38,0) | Campaign interaction identifier | ||
| ecf_interactionGuidId | VARCHAR(64) | The interaction GUID | ||
| ecf_destination | VARCHAR(16777216) | Destination | ||
| ecf_businessProcessId | NUMBER(15,0) | Foreign key to the business process | ||
| ecf_businessProcessName | VARCHAR(100) | The business process name | ||
| ecf_campaignId | NUMBER(15,0) | The campaign unique identifier from source | ||
| ecf_campaignName | VARCHAR(200) | The campaign name | ||
| ecf_customerCalls | NUMBER(38,0) | Customer calls | ||
| ecf_customerData | VARCHAR(16777216) | Customer data | ||
| ecf_talkTime | NUMBER(38,0) | Talk time in seconds | ||
| ecf_wrapupTime | NUMBER(38,0) | Wrap-up time in seconds | ||
| ecf_dispositionCode | VARCHAR(200) | Disposition code | ||
| ecf_dispositionCodeCategory | VARCHAR(128) | Disposition code category | ||
| ecf_dispositionCodeSubCategory | VARCHAR(128) | Disposition code sub category | ||
| ecf_interactionCreationTypeName | VARCHAR(100) | Interaction creation type name | ||
| ecf_interactionId | NUMBER(38,0) | The interaction identifier | ||
| ecf_interactionResultName | VARCHAR(100) | Interaction result name | ||
| ecf_lastAttemptAgentId | NUMBER(15,0) | Foreign key to the last attempt's agent | ECSUserDimension | |
| ecf_lastAttemptAnswerTimestamp | TIMESTAMP_NTZ(9) | Last Attempt answer time in UTC | ||
| ecf_lastAttemptDestination | VARCHAR(16777216) | Last attempt destination | ||
| ecf_lastAttemptEndTimestamp | TIMESTAMP_NTZ(9) | Last attempt end time in UTC | ||
| ecf_lastAttemptInteractionStateId | NUMBER(15,0) | Foreign key to the last attempt's interaction state | ECSInteractionStateDimension | |
| ecf_lastAttemptInteractionStateName | VARCHAR(100) | Last attempt's interaction state name | ||
| ecf_lastAttemptRemarks | VARCHAR(16777216) | Last attempt's remarks | ||
| ecf_lastAttemptTimestamp | TIMESTAMP_NTZ(9) | Last attempt time in UTC | ||
| ecf_lastAttemptTimestampLocal | TIMESTAMP_NTZ(9) | Last attempt time in local time | ||
| ecf_lastInteractionStateId | NUMBER(15,0) | Foreign key to the last interaction state | ECSInteractionStateDimension | |
| ecf_lastInteractionStateName | VARCHAR(100) | Last interaction state name | ||
| ecf_numberOfAttempts | NUMBER(38,0) | Number of attempts | ||
| ecf_remarks | VARCHAR(16777216) | Remarks | ||
| ecf_routingClientName | VARCHAR(50) | Routing client name | ||
| ecf_routingInboundCampaignName | VARCHAR(50) | Routing inbound campaign name | ||
| ecf_routingProductName | VARCHAR(50) | Routing product name | ||
| ecf_routingProductType | VARCHAR(50) | Routing product type | ||
| ecf_startTime | NUMBER(38,0) | Foreign key to the Campaign start time in UTC | TimeOfDayDimension | |
| ecf_startDate | NUMBER(38,0) | Foreign key to the Campaign start date in UTC | DateDimension | |
| ecf_startTimeLocal | NUMBER(38,0) | Foreign key to the Campaign start time in local time | TimeOfDayDimension | |
| ecf_startDateLocal | NUMBER(38,0) | Foreign key to the Campaign start date in local time | DateDimension | |
| ecf_startTimestamp | TIMESTAMP_NTZ(9) | Campaign start time in UTC | ||
| ecf_startTimestampLocal | TIMESTAMP_NTZ(9) | Campaign start time in local time | ||
| ecf_endtime | NUMBER(38,0) | Foreign key to the Campaign end time in UTC | TimeOfDayDimension | |
| ecf_enddate | NUMBER(38,0) | Foreign key to the Campaign end date in UTC | DateDimension | |
| ecf_endTimeLocal | NUMBER(38,0) | Foreign key to the Campaign end time in local time | TimeOfDayDimension | |
| ecf_endDateLocal | NUMBER(38,0) | Foreign key to the Campaign end date in local time | DateDimension | |
| ecf_endTimestamp | TIMESTAMP_NTZ(9) | Campaign end time in UTC | ||
| ecf_endTimestampLocal | TIMESTAMP_NTZ(9) | Campaign end time in local time | ||
| ecf_enterTimestamp | TIMESTAMP_NTZ(9) | Campaign enter time in UTC | ||
| ecf_enterTimestampLocal | TIMESTAMP_NTZ(9) | Campaign enter time in local time | ||
| ecf_eipId | VARCHAR(16) | The account identifier | ||
| ecf_parentEipId | VARCHAR(16) | The parent account identifier | ||
| ecf_eomId | NUMBER(38,0) | Foreign key to the ECS organization | ECSOrganizationMapping | |
| ecf_status | VARCHAR(16) | Campaign status | ||
| ecf_timezone | VARCHAR(128) | Foreign key to the time zone | TimeZoneDimension | |
| ecf_overflowed | BOOLEAN | |||
| ecf_queued | BOOLEAN | |||
| ecf_lastUpdatedTimestamp | TIMESTAMP_NTZ(9) | The record's last update timestamp | ||
| ecf_updated | BOOLEAN | Indicates whether the record was updated | ||