...
ECS Fact Tables | |||||
ECSAlertFact | |||||
Column Name | Type | Description | References | Comments | Indexed |
---|---|---|---|---|---|
alrf_id | bigint | Primary Key | |||
alrf_alertId | int | Identifier of the alert | |||
alrf_agentId | numeric(15, 0) | Foreign key to the agent | ECSUserDimension | ||
alrf_alertTypeId | smallint | Foreign key to the alert type | ECSAlertTypeDimension | Deprecated field. Replaced by alrf_alertTypeName | |
alrf_businessProcessId | numeric(15, 0) | Foreign key to the business process | ECSBusinessProcessDimension | ||
alrf_counter | smallint | Old field, not in use | Deprecated field. Replaced by alrf_counterTypeName | ||
alrf_counterTypeId | numeric(15, 0) | Identifier of the counter type | ECSCounterTypeDimension | Deprecated field. Replaced by alrf_counterTypeName | |
alrf_endDateSliceId | int | Foreign key to the alert end date in UTC | DateDimension | ||
alrf_endTime | datetime | Alert end time in UTC | |||
alrf_endTimeSliceId | int | Foreign key to the alert end time of day in UTC | TimeOfDayDimension | ||
alrf_eomId | int | Foreign key to the ECS organization | ECSOrganizationMapping | ||
alrf_startDateSliceId | int | Foreign key to the alert start date in UTC | DateDimension | ||
alrf_startTime | datetime | Alert start time | |||
alrf_startTimeSliceId | int | Foreign key to the alert start time of day in UTC | TimeOfDayDimension | ||
alrf_updateDateTime | datetime | Alert last update datetime | Yes | ||
alrf_value | int | Alert value | |||
alrf_eipId | varchar(16) | The account identifier | |||
alrf_alertTypeName | nvarchar(100) | Alert type name | |||
alrf_counterTypeName | nvarchar(100) | Counter type name | |||
alrf_parentEipId | varchar(16) | The account identifier | |||
alrf_startTimestampLocal | datetime | Alert start time in local time | |||
alrf_endTimestampLocal | datetime | Alert end time in local time | |||
alrf_startDateLocal | int | Foreign key to the alert start date in local time | DateDimension | ||
alrf_startTimeLocal | int | Foreign key to the alert start time of day in local time | TimeOfDayDimension | ||
alrf_endDateLocal | int | Foreign key to the alert end date in local time | DateDimension | ||
alrf_endTimeLocal | int | Foreign key to the alert end time of day in local time | TimeOfDayDimension | ||
alrf_lastUpdatedTimestamp | datetime | The record updated timestamp | |||
alrf_updated | bit | Indicates whether the record was updated | |||
ECSAgentLifeFact | |||||
Column Name | Type | Description | References | Comments | Indexed |
alif_id | bigint | Primary key | |||
alif_agentLifeId | int | Identifier of agent life | |||
alif_agentId | numeric(15, 0) | Foreign key to the agent | ECSUserDimension | ||
alif_agentLifeTypeId | smallint | Identifier of the agent life type | ECSAgentLifeTypeDimension | Deprecated field. Replaced by alif_agentLifeTypeName | |
alif_agentStatusId | numeric(15, 0) | Identifier of the agent status | ECSAgentStatusDimension | Deprecated field. Replaced by alif_agentStatusName | |
alif_bpAssigned | bit (1=true/0=false) | Flag for a status: was assigned to BP (Business Process) | |||
alif_breakTypeId | numeric(15, 0) | Identifier of the break type | ECSBreakTypeDimension | Deprecated field. Replaced by alif_breakTypeName | |
alif_businessProcessId | numeric(15, 0) | Foreign key to the interaction business process | ECSBusinessProcessDimension | ||
alif_categoryId | numeric(15, 0) | Foreign key to the break category | ECSBreakCategoryTypeDimension | ||
alif_decidedToApprove | bit | Decision solution | |||
alif_efficiency | float | Efficiency | |||
alif_endDateSliceId | int | Foreign key to the status end date in UTC | DateDimension | ||
alif_endTime | datetime | Status end time in UTC | |||
alif_endTimeSliceId | int | Foreign key to the status end time of day in UTC | TimeOfDayDimension | ||
alif_eomId | int | Foreign key to the ECS organization | ECSOrganizationMapping | ||
alif_exceededSeconds | int | Count of exceeded seconds | |||
alif_interactionEndTime | datetime | Interaction end time in UTC | |||
alif_interactionId | bigint | Identifier of the Interaction | |||
alif_interactionStartTime | datetime | Interaction start time in UTC | |||
alif_interactionStateId | numeric(15, 0) | Foreign key to the interaction state | ECSInteractionStateDimension | ||
alif_interactionTypeId | numeric(15, 0) | Foreign key to the interaction type | ECSInteractionTypeDimension | ||
alif_loginDateSliceId | int | Foreign key to the status login date in UTC | DateDimension | ||
alif_loginTime | datetime | Agent login time in UTC | |||
alif_loginTimeSliceId | int | Foreign key to the status login time of day in UTC | TimeOfDayDimension | ||
alif_logoffDateSliceId | int | Foreign key to of the status logoff date in UTC | DateDimension | ||
alif_logoffTime | datetime | Agent logoff time in UTC | |||
alif_logoffTimeSliceId | int | Foreign key to the status logoff time of day in UTC | TimeOfDayDimension | ||
alif_paid | bit | Flag for a status: was paid | |||
alif_requestTime | datetime2(7) | Request time for a status | |||
alif_shiftId | int | Shift number | |||
alif_sourceKey | nvarchar(50) | Source Key | |||
alif_startDateSliceId | int | Foreign key to the status start date in UTC | DateDimension | ||
alif_startTime | datetime | Status start time in UTC | |||
alif_startTimeSliceId | int | Foreign key to the status start time of day in UTC | TimeOfDayDimension | ||
alif_supervisorDecisionTime | datetime2(7) | Supervisor decision time for a status | |||
alif_supervisorId | numeric(15, 0) | Foreign key to the supervisor | ECSUserDimension | ||
alif_updateDateTime | datetime | Agent life last status update datetime | Yes | ||
alif_eipId | varchar(16) | The account identifier | |||
alif_agentLifeTypeName | nvarchar(50) | Agent life type name | |||
alif_agentStatusName | nvarchar(50) | Agent status name | |||
alif_breakTypeName | nvarchar(100) | Break type name | |||
alif_parentEipId | varchar(16) | Parent account identifier | |||
alif_loginTimestampLocal | datetime | Agent login time in local time | |||
alif_logoffTimestampLocal | datetime | Agent logoff time in local time | |||
alif_startTimestampLocal | datetime | Status start time in local time | |||
alif_endTimestampLocal | datetime | Status end time in local time | |||
alif_interactionStartTimestampLocal | datetime | Interaction start time in local time | |||
alif_interactionEndTimestampLocal | datetime | Interaction end time in local time | |||
alif_loginDateLocal | int | Foreign key to the status login date in local time | DateDimension | ||
alif_loginTimeLocal | int | Foreign key to the status login time of day in local time | TimeOfDayDimension | ||
alif_logoffDateLocal | int | Foreign key to the status logoff date in local time | DateDimension | ||
alif_logoffTimeLocal | int | Foreign key to the status logoff time of day in local time | TimeOfDayDimension | ||
alif_startDateLocal | int | Foreign key to the status start date in local time | DateDimension | ||
alif_startTimeLocal | int | Foreign key to the status start time of day in local time | TimeOfDayDimension | ||
alif_endDateLocal | int | Foreign key to the status end date in local time | DateDimension | ||
alif_endTimeLocalI | int | Foreign key to the status end time of day in local time | TimeOfDayDimension | ||
alif_lastUpdatedTimestamp | datetime | The record updated timestamp | |||
alif_updated | bit | Indicates whether the record was updated | |||
ECSAttemptFact | |||||
Column Name | Type | Description | References | Comments | Indexed |
atmp_id | bigint | Primary key | |||
atmp_attemptId | int | Identifier of the attempt | |||
atmp_agentId | numeric(15, 0) | Foreign key to the agent | ECSUserDimension | ||
atmp_answerDateSliceId | int | Foreign key to the answer date in UTC | DateDimension | ||
atmp_answerTime | datetime | Answer datetime in UTC | |||
atmp_answerTimeSliceId | int | Foreign key to the answer time of day in UTC | TimeOfDayDimension | ||
atmp_attemptDateSliceId | int | Foreign key to the attempt date in UTC | DateDimension | ||
atmp_attemptNo | int | Attempt number | |||
atmp_attemptTime | datetime | Attempt datetime in UTC | |||
atmp_attemptTimeSliceId | int | Foreign key to the attempt time of day in UTC | TimeOfDayDimension | ||
atmp_businessProcessId | numeric(15, 0) | Foreign key to the business process of current attempt. | ECSBusinessProcessDimension | ||
atmp_campaignEnterDateSliceId | int | Foreign key to the campaign enter date in UTC | DateDimension | ||
atmp_campaignEnterTime | datetime | When the interaction was added to campaign (loaded) | |||
atmp_campaignEnterTimeSliceId | int | Foreign key to the campaign enter time of day of day in UTC | TimeOfDayDimension | ||
atmp_campaignId | numeric(15, 0) | Foreign key to the campaign | ECSCampaignDimension | ||
atmp_campaignInteractionId | int | Campaign Interaction Id - system Id | |||
atmp_campaignLastAttemptDateSliceId | int | Foreign key to the campaign last attempt date in UTC | DateDimension | Deprecated field | |
atmp_campaignLastAttemptTime | datetime | Last attempt datetime | |||
atmp_campaignLastAttemptTimeSliceId | int | Foreign key to the campaign last attempt time of day in UTC | TimeOfDayDimension | Deprecated field | |
atmp_destination | nvarchar(MAX) | Destination | |||
atmp_endDateSliceId | int | Foreign key to the end date in UTC | DateDimension | ||
atmp_endTime | datetime | Attempt end time | |||
atmp_endTimeSliceId | int | Foreign key to the end time of day in UTC | TimeOfDayDimension | ||
atmp_eomId | int | Foreign key to the ECS organization | ECSOrganizationMapping | ||
atmp_interactionStateId | numeric(15, 0) | Foreign key to the interaction state of current attempt | ECSInteractionStateDimension | ||
atmp_lastAttemptInteractionStateId | numeric(15, 0) | Foreign key to the interaction state of last attempt | ECSInteractionStateDimension | ||
atmp_numberOfAttempts | int | Number of attempts | |||
atmp_remarks | nvarchar(MAX) | Remarks | Deprecated field | ||
atmp_updateDateTime | datetime | Attempt last update datetime | Yes | ||
atmp_eipId | varchar(16) | The account identifier | |||
atmp_parentEipId | varchar(16) | Parent account identifier | |||
atmp_lastUpdatedTimestamp | datetime | The record updated timestamp | |||
atmp_updated | bit | Indicates whether the record was updated | |||
ECSInteractionFact | |||||
Column Name | Type | Description | References | Comments | Indexed |
intr_id | bigint | Primary key | |||
intr_interactionId | int | Identifier of interaction | |||
intr_interactionGUIDID | uniqueidentifier | GUID identifier | |||
intr_interactionLeg | int | Interaction leg | |||
intr_agentHandlingTime | int | Agent handling time | |||
intr_agentID | numeric(15, 0) | Foreign key to the ECS agent | ECSUserDimension | ||
intr_answeredWithinGoalTime | bit (1=true/0=false) | Flag: was interaction answered within a goal time? | |||
intr_areaCodeId | int | Foreign key ot the area code | AreaCodeDimension | ||
intr_CRMContactId | uniqueidentifier | Identifier to CRM contact | |||
intr_campaignId | numeric(15, 0) | Foreign key to the campaign | ECSCampaignDimension | ||
intr_closedBySystem | bit (1=true/0=false) | Flag: was interaction closed by system? | |||
intr_consultTime | int | Consult time | |||
intr_currentSLThreshold | int | Current Service Level Threshold | |||
intr_customerBillingCode | nvarchar(128) | Customer billing code | |||
intr_customerCalls | int | Customer Calls | |||
intr_destination | nvarchar(MAX) | Destination | |||
intr_directionId | smallint | Identifier for the direction | ECSDirectionDimension | Deprecated field. Replaced by: intr_directionName. | |
intr_dispositionCode | nvarchar(200) | Disposition code | |||
intr_dispositionCodeCategory | nvarchar(128) | Disposition Code Category | |||
intr_dispositionCodeSubCategory | nvarchar(128) | Disposition Code Sub Category | |||
intr_duration | int | Last attempt duration | |||
intr_emailBacklog | bit (1=true/0=false) | Flag: was email interaction kept in a backlog? | |||
intr_endDateSliceId | int | Foreign key to the interaction end date in UTC | DateDimension | ||
intr_endTime | datetime | Interaction end time in UTC | Yes | ||
intr_endTimeSliceId | int | Foreign key to the interaction end time of day in UTC | TimeOfDayDimension | ||
intr_endedInRequestDNC | bit (1=true/0=false) | Ended in request "Do not call" | |||
intr_endedInTransfer | bit (1=true/0=false) | Flag: was interaction ended in transfer? | |||
intr_endingStatus | nvarchar(50) | Ending status - is not actual | |||
intr_enterDateSliceId | int | Foreign key to the interaction enter date in UTC | DateDimension | ||
intr_enterTime | datetime | When the interaction was added to campaign (loaded) in UTC | |||
intr_enterTimeSliceId | int | Foreign key to the interaction enter time of day in UTC | TimeOfDayDimension | ||
intr_eomId | int | Foreign key to the ECS organization | ECSOrganizationMapping | ||
intr_externalTransferDID | nvarchar(128) | External transfer DID | |||
intr_hasAnotherAttempt | bit (1=true/0=false) | Flag: is there another attempt? | |||
intr_holdTime | int | Hold time in seconds | |||
intr_IVRTime | int | IVR time | |||
intr_interactionCreationTypeId | smallint | Identifier of the interaction creation type | Deprecated field. Replaced by: intr_interactionCreationTypeName | ||
intr_interactionMediaId | smallint | Identifier of the interaction media | Deprecated field. Replaced by: intr_interactionMediaName | ||
intr_interactionResultId | numeric(15, 0) | Identifier of the interaction result | Deprecated field. Replaced by: intr_interactionResultName | ||
intr_interactionTypeId | numeric(15, 0) | Foreign key to the interaction type | ECSInteractionTypeDimension | ||
intr_isDeferrable | bit (1=true/0=false) | Flag: was the interaction deferrable? | |||
intr_lasHandlerHandlingTime | int | Last handler handling time | |||
intr_lastAttemptAgentId | numeric(15, 0) | Foreign key of the last attempt agent | ECSUserDimension | ||
intr_lastAttemptAnswerDateSliceId | int | Identifier of the answer date in UTC | DateDimension | Deprecated field | |
intr_lastAttemptAnswerTime | datetime | Last attempt answer time in UTC | |||
intr_lastAttemptAnswerTimeSliceId | int | Foreign key to the attempt answer time of day in UTC | TimeOfDayDimension | Deprecated field | |
intr_lastAttemptDateSliceId | int | Foreign key to the last attempt date in UTC | DateDimension | Deprecated field | |
intr_lastAttemptDestination | nvarchar(128) | Last attempt destination | |||
intr_lastAttemptEndDateSliceId | int | Identifier of the last attempt end date in UTC | DateDimension | Deprecated field | |
intr_lastAttemptEndTime | datetime | Last attempt end time in UTC | |||
intr_lastAttemptEndTimeSliceId | int | Foreign key to the attempt end time of day in UTC | TimeOfDayDimension | Deprecated field | |
intr_lastAttemptInteractionStateId | numeric(15, 0) | Foreign key to the interaction state of last attempt | ECSInteractionStateDimension | ||
intr_lastAttemptRemarks | nvarchar(MAX) | Remarks of last attempt | Deprecated field | ||
intr_lastAttemptTime | datetime | Last Attempt time in UTC | |||
intr_lastAttemptTimeSliceId | int | Identifier of the last attempt time of day in UTC | TimeOfDayDimension | Deprecated field | |
intr_lastInteractionStateId | numeric(15, 0) | Foreign key to the latest interaction state | ECSInteractionStateDimension | ||
intr_lastTreatingAgentId | numeric(15, 0) | Foreign key to the agent last treated the interaction | ECSUserDimension | ||
intr_lastTreatingBusinessProcessId | numeric(15, 0) | Foreign key to the business process last treated the interaction | ECSBusinessProcessDimension | ||
intr_lastTreatingInteractionChannelId | numeric(15, 0) | Foreign key to the channel last treated the interaction | ECSInteractionChannelDimension | ||
intr_mistreatedCode | int | DNC number | |||
intr_mistreatedDateSliceId | int | Foreign key to the mistreated date in UTC | DateDimension | Deprecated field | |
intr_mistreatedTime | datetime | When DNC number was called in UTC | |||
intr_mistreatedTimeSliceId | int | Foreign key to the mistreated time of day in UTC | TimeOfDayDimension | Deprecated field | |
intr_numberOfAttempts | int | Number of attempts | |||
intr_origin | nvarchar(128) | Origin | |||
intr_overflow | bit | Flag: was interaction overflow? | |||
intr_previousAgentId | numeric(15, 0) | Foreign key to the agent if the previous handler was an agent | ECSUserDimension | ||
intr_previousBusinessProcessId | numeric(15, 0) | Foreign key to the business process if the previous handler was a business process | ECSBusinessProcessDimension | ||
intr_previousHandlerHandlingTime | int | Handling time of the handler before the last handler of the interaction | |||
intr_previousInteractionChannelId | numeric(15, 0) | Foreign key to the interaction channel if the previous handler was a channel | ECSInteractionChannelDimension | ||
intr_queueTime | int | Queue time | |||
intr_queued | bit (1=true/0=false) | Flag: was interaction queued? | |||
intr_remarks | nvarchar(MAX) | Remarks | Deprecated field | ||
intr_responseCount | int | Count of responses within a conversation | |||
intr_responseTimeSum | int | Summarized count of seconds in responses within a conversation | |||
intr_routingClientName | nvarchar(50) | Routing Client Name | |||
intr_routingInboundCampaignName | nvarchar(50) | Routing Inbound Campaign Name | |||
intr_routingProductName | nvarchar(50) | Routing Product Name | |||
intr_routingProductType | nvarchar(50) | Routing Product Type | |||
intr_sLExcluded | bit (1=true/0=false) | Flag: was interaction excluded from Service Level calculations? | |||
intr_startDateSliceId | int | Foreign key to the interaction start date in UTC | DateDimension | ||
intr_startTime | datetime | Interaction start time in UTC | Yes | ||
intr_startTimeSliceId | int | Foreign key to the interaction start time of day in UTC | TimeOfDayDimension | ||
intr_telephonyTimeExternalAgent | int | External agent telephony time | |||
intr_telephonyTimeExternalConsult | int | External consulting telephony time | |||
intr_telephonyTimeIncoming | int | Incoming telephony time | |||
intr_telephonyTimeOutgoing | int | Outgoing telephony time | |||
intr_timeZoneId | smallint | Foreign key to the time zone | TimeZoneDimension | ||
intr_updateDateTime | datetime | Interaction last update datetime in UTC | Yes | ||
intr_voiceMailAssignedAgentId | numeric(15, 0) | Foreign key to the to assigned agent for a voicemail | ECSUserDimension | ||
intr_voiceMailLeft | bit (1=true/0=false) | Flag: was left a voicemail | |||
intr_wasAbandoned | bit (1=true/0=false) | Flag: was interaction abandoned? | |||
intr_wrapUpTime | int | Wrap-up time in seconds | |||
intr_eipId | varchar(16) | The account identifier | |||
intr_inbound | bit (1=true/0=false) | Indicates if the interaction creation type is inbound | |||
intr_outbound | bit (1=true/0=false) | Indicates if the interaction creation type is outbound | |||
intr_outgoingInternal | bit (1=true/0=false) | Indicates if the interaction creation type is outgoing internal | |||
intr_callback | bit (1=true/0=false) | Indicates if the interaction creation type is callback | |||
intr_campaign | bit (1=true/0=false) | Indicates if the interaction creation type is campaign | |||
intr_telephony | bit (1=true/0=false) | Indicates if the interaction is a telephony interaction | |||
intr_chat | bit (1=true/0=false) | Indicates if the interaction is a chat interaction | |||
intr_email | bit (1=true/0=false) | Indicates if the interaction is an email interaction | |||
intr_callbackRequests | bit (1=true/0=false) | Indicates the callback was requested | |||
intr_callbackCompleted | bit (1=true/0=false) | Indicates the callback has been completed | |||
intr_transferredIn | bit (1=true/0=false) | Indicates if the interaction is transferred in | |||
intr_transferredOut | bit (1=true/0=false) | Indicates if the interaction is an external transfer | |||
intr_abandoned | bit (1=true/0=false) | Indicates if the interaction was abandoned | |||
intr_disconnected | bit (1=true/0=false) | Indicates if handled interaction was closed by the system | |||
intr_answered | bit (1=true/0=false) | Indicates if the incoming interaction has been answered | |||
intr_isTalked | bit (1=true/0=false) | Indicates if the interaction talk time > 0 | |||
intr_rescheduled | bit (1=true/0=false) | Indicates emails that were manually scheduled by an agent to be answered at a later time | |||
intr_handled | bit (1=true/0=false) | Indicates if an incoming email interaction was handled by an agent | |||
intr_simplyAbandoned | bit (1=true/0=false) | Indicates if an interaction was abandoned includes interactions that were excluded from Service Level calculations | |||
intr_hold | bit (1=true/0=false) | Indicates if the interaction was on hold | |||
intr_purged | bit (1=true/0=false) | Indicates if the interaction has been purged | |||
intr_consulted | bit (1=true/0=false) | Indicates if the interaction state is consulted | |||
intr_missed | bit (1=true/0=false) | Indicates if the interaction has been missed | |||
intr_rejected | bit (1=true/0=false) | Indicates if the interaction was rejected | |||
intr_handledInBP | bit (1=true/0=false) | Indicates if the interaction was first handled by a business process | |||
intr_handledByAgent | bit (1=true/0=false) | Indicates if the interaction was first handled by an agent | |||
intr_abandonedTime | int | Time until interaction was abandoned | |||
intr_CRMFirstName | nvarchar(50) | First name of the CRM contact | |||
intr_CRMLastName | nvarchar(50) | Last name of the CRM contact | |||
intr_interactionCreationTypeName | nvarchar(100) | Interaction creation type name | |||
intr_interactionMediaName | nvarchar(100) | Interaction media name | |||
intr_interactionResultName | nvarchar(100) | Interaction result name | |||
intr_directionName | nvarchar(100) | Direction name | |||
intr_businessProcessName | nvarchar(100) | Business process name | |||
intr_oldCallbackExisted | uniqueidentifier | Was interaction handled after a callback requested? if yes, then GUID identifier will be defined here | |||
intr_telephonyTimeExternalTransfer | int | External Transfer telephony time | |||
intr_businessProcessId | numeric(15, 0) | Foreign key to the business process | ECSBusinessProcessDimension | ||
intr_talkTime | int | Talk time in seconds | |||
intr_parentEipId | varchar(16) | Parent account identifier | |||
intr_startTimestampLocal | datetime | Interaction start time in local time | |||
intr_enterTimestampLocal | datetime | When the interaction was added to campaign (loaded) in local time | |||
intr_endTimestampLocal | datetime | Interaction end time in local time | |||
intr_startDateLocal | int | Foreign key to the interaction start date in local time | DateDimension | ||
intr_startTimeLocal | int | Foreign key to the interaction start time of day in local time | TimeOfDayDimension | ||
intr_enterDateLocal | int | Foreign key to the interaction enter date in local time | DateDimension | ||
intr_enterTimeLocal | int | Foreign key to the interaction enter time of day in local time | TimeOfDayDimension | ||
intr_endDateLocal | int | Foreign key to the interaction end date in local time | DateDimension | ||
intr_endTimeLocal | int | Foreign key to the interaction end time of day in local time | TimeOfDayDimension | ||
intr_lastUpdatedTimestamp | datetime | The record updated timestamp | |||
intr_updated | bit | Indicates whether the record was updated | |||
intr_remoteParty | nvarchar(max) | ||||
intr_customerOptIn | bit | ||||
intr_survey | bit | Post call survey data | |||
intr_postAgentTimeSec | int | ||||
intr_campaignInteractionLastStateId | numeric(15, 0) | ||||
intr_previewTime | int | ||||
intr_recordingPath | varchar(256) | ||||
intr_recordingTranscription | varchar(max) | ||||
intr_interactionVariables | varchar(max) | ||||
intr_HPBXCallInfo | varchar(max) | HPBX call info in JSON format | |||
ECSInteractionSegmentFact | |||||
Column Name | Type | Description | References | Comments | Indexed |
iseg_id | bigint | Primary key | |||
iseg_interactionSegmentId | int | Interaction segment identifier | |||
iseg_interactionLeg | int | Interaction leg | |||
iseg_agentHandlingTime | int | Agent handling time | |||
iseg_agentId | numeric(15, 0) | Foreign key to the agent | ECSUserDimension | ||
iseg_answeredWithinGoalTime | bit (1=true/0=false) | Flag: was interaction answered within a goal time? | |||
iseg_areaCodeId | int | Foreign key to the area code | AreaCodeDimension | ||
iseg_businessProcessId | numeric(15, 0) | Foreign key to the business process | ECSBusinessProcessDimension | ||
iseg_CRMContactId | uniqueidentifier | Identifier to CRM contact | |||
iseg_campaignId | numeric(15, 0) | Foreign key to the campaign | ECSCampaignDimension | ||
iseg_closedBySystem | bit (1=true/0=false) | Flag: was interaction closed by system? | |||
iseg_consultTime | int | Consult time | |||
iseg_currentSLThreshold | int | Current Service Level Threshold | |||
iseg_customerBillingCode | nvarchar(128) | Customer billing code | |||
iseg_customerCalls | int | Customer calls | |||
iseg_destination | nvarchar(MAX) | Destination | |||
iseg_directionId | smallint | Identifier of the direction | ECSDirectionDimension | Deprecated field. Replaced by: iseg_directionName. | |
iseg_dispositionCode | nvarchar(256) | Disposition Code | |||
iseg_dispositionCodeCategory | nvarchar(128) | Disposition Code Category | |||
iseg_dispositionCodeSubCategory | nvarchar(128) | Disposition Code Sub Category | |||
iseg_duration | int | Last attempt duration | |||
iseg_emailBacklog | bit (1=true/0=false) | Flag: was email interaction kept in a backlog? | |||
iseg_endDateSliceId | int | Foreign key to the interaction segment end date in UTC | DateDimension | ||
iseg_endTime | datetime | Segment end time in UTC | Yes | ||
iseg_endTimeSliceId | int | Foreign key to the interaction segment end time of day in UTC | TimeOfDayDimension | ||
iseg_endedInRequestDNC | bit (1=true/0=false) | Ended in request "Do not call" | |||
iseg_endedInTransfer | bit (1=true/0=false) | Flag: was interaction ended in transfer? | |||
iseg_endingStatus | nvarchar(50) | Ending status - currently not in use | |||
iseg_enterDateSliceId | int | Foreign key to the interaction Interaction enter date in UTC | DateDimension | ||
iseg_enterTime | datetime | When the interaction was added to campaign (loaded) | |||
iseg_enterTimeSliceId | int | Foreign key to the interaction enter time of day in UTC | TimeOfDayDimension | ||
iseg_eomId | int | Foreign key to the ECS organization | ECSOrganizationMapping | ||
iseg_externalTransferDID | nvarchar(128) | External transfer DID | |||
iseg_handler | int | Identifier to handler (source key from D_Agent, D_BusinessProcess or D_InteractionChannel) | |||
iseg_hasAnotherAttempt | bit (1=true/0=false) | Flag: is there another attempt? | |||
iseg_holdTime | int | Hold time in seconds | |||
iseg_IVRTime | int | IVR time | |||
iseg_interactionChannelId | numeric(15, 0) | Foreign key of the interaction channel | ECSInteractionChannelDimension | ||
iseg_interactionCreationTypeId | smallint | Identifier of the interaction creation type | ECSInteractionCreationTypeDimesion | Deprecated field. Replaced by iseg_creationTypeName | |
iseg_interactionEndDateSliceId | int | Foreign key to the Interaction end date in UTC | DateDimension | ||
iseg_interactionEndTime | datetime | Interaction end time in UTC | |||
iseg_interactionEndTimeSliceId | int | Foreign key to the Interaction end time of day in UTC | TimeOfDayDimension | ||
iseg_interactionGUIDID | uniqueidentifier | GUID identifier to interaction | |||
iseg_interactionId | bigint | Identifier of the interaction | |||
iseg_interactionMediaId | smallint | Foreign key to the interaction media | ECSInteractionMediaDimension | Deprecated field. Replaced by: iseg_interactionMediaName | |
iseg_interactionResultId | numeric(15, 0) | Foreign key to the interaction result | ECSInteractionResultDimension | Deprecated field. Replaced by: iseg_interactionResultName | |
iseg_interactionStartDateSliceId | int | Foreign key to the Interaction start date in UTC | DateDimension | ||
iseg_interactionStartTime | datetime | Interaction start time in UTC | |||
iseg_interactionStartTimeSliceId | int | Foreign key to the Interaction start time of day in UTC | TimeOfDayDimension | ||
iseg_interactionStateId | numeric(15, 0) | Foreign key of the interaction state | ECSInteractionStateDimension | ||
iseg_interactionTypeId | numeric(15, 0) | Foreign key of the interaction type | ECSInteractionTypeDimension | ||
iseg_isDeferrable | bit (1=true/0=false) | Flag: was the interaction deferrable? | |||
iseg_lasHandlerHandlingTime | int | Last handler handling time | |||
iseg_lastAttemptAgentId | numeric(15, 0) | Foreign key to the last attempt agent | ECSUserDimension | ||
iseg_lastAttemptAnswerDateSliceId | int | Foreign key to the last attempt answer date in UTC | DateDimension | Deprecated field | |
iseg_lastAttemptAnswerTime | datetime | Last attempt answer time in UTC | |||
iseg_lastAttemptAnswerTimeSliceId | int | Foreign key to the last attempt answer time of day in UTC | TimeOfDayDimension | Deprecated field | |
iseg_lastAttemptDateSliceId | int | Foreign key to the last attempt date in UTC | DateDimension | Deprecated field | |
iseg_lastAttemptDestination | nvarchar(128) | Last attempt destination | |||
iseg_lastAttemptEndDateSliceId | int | Foreign key to the last attempt end date in UTC | DateDimension | Deprecated field | |
iseg_lastAttemptEndTime | datetime | Last attempt end time in UTC | |||
iseg_lastAttemptEndTimeSliceId | int | Foreign key to the last attempt end time of day in UTC | TimeOfDayDimension | Deprecated field | |
iseg_lastAttemptInteractionStateId | numeric(15, 0) | Foreign key to the last attempt interaction state | ECSInteractionStateDimension | ||
iseg_lastAttemptRemarks | nvarchar(MAX) | Remarks of last attempt | Deprecated field | ||
iseg_lastAttemptTime | datetime | Last Attempt time in UTC | |||
iseg_lastAttemptTimeSliceId | int | Foreign key to the last attempt time of day in UTC | TimeOfDayDimension | Deprecated field | |
iseg_lastInteractionStateId | numeric(15, 0) | Foreign key of the last interaction state | ECSInteractionStateDimension | ||
iseg_lastTreatingAgentId | numeric(15, 0) | Foreign key of the agent last treated the interaction | ECSUserDimension | ||
iseg_lastTreatingBusinessProcessId | numeric(15, 0) | Foreign key of the business process last treated the interaction | ECSBusinessProcessDimension | ||
iseg_lastTreatingInteractionChannelId | numeric(15, 0) | Foreign key of the channel last treated the interaction | ECSInteractionChannelDimension | ||
iseg_mistreatedCode | int | DNC number | |||
iseg_mistreatedDateSliceId | int | Foreign key to the mistreated date in UTC | DateDimension | Deprecated field | |
iseg_mistreatedTime | datetime | When DNC number was called in UTC | |||
iseg_mistreatedTimeSliceId | int | Foreign key to the mistreated time of day in UTC | TimeOfDayDimension | Deprecated field | |
iseg_nextInteractionStateId | numeric(15, 0) | Foreign key to the next interaction state | ECSInteractionStateDimension | ||
iseg_numberOfAttempts | int | Number of attempts | |||
iseg_origin | nvarchar(128) | Origin | |||
iseg_originatedFromId | smallint | Identifier to originated source of the interaction | ECSOriginatedFromDimension | Deprecated field. Replaced by iseg_originatedFromName | |
iseg_overflow | bit (1=true/0=false) | Flag: was interaction overflow? | |||
iseg_previousAgentId | numeric(15, 0) | is not actual | |||
iseg_previousBusinessProcessId | numeric(15, 0) | is not actual | |||
iseg_previousHandlerHandlingTime | int | is not actual | |||
iseg_previousInteractionChannelId | numeric(15, 0) | Foreign key to the previous interaction channel | |||
iseg_queueTime | int | Queue time | |||
iseg_queued | bit (1=true/0=false) | Flag: was interaction queued? | |||
iseg_remarks | nvarchar(MAX) | Remarks | Deprecated field | ||
iseg_responseCount | int | Count of responses within a conversation | |||
iseg_responseTimeSum | int | Summarized count of seconds in responses within a conversation | |||
iseg_SLExcluded | bit (1=true/0=false) | Flag: was interaction excluded from Service Level calculations? | |||
iseg_sequenceId | bigint | Sequence number within a specific interaction | |||
iseg_startDateSliceId | int | Foreign key to the interaction segment start date in UTC | DateDimension | ||
iseg_startTime | datetime | Segment start time in UTC | Yes | ||
iseg_startTimeSliceId | int | Foreign key to the interaction segment start time of day in UTC | TimeOfDayDimension | ||
iseg_talkTime | int | Talk time in seconds | |||
iseg_telephonyTimeExternalAgent | int | External agent telephony time | |||
iseg_telephonyTimeExternalConsult | int | External consulting telephony time | |||
iseg_telephonyTimeIncoming | int | Incoming telephony time | |||
iseg_telephonyTimeOutgoing | int | Outgoing telephony time | |||
iseg_timeZoneId | smallint | Foreign key to time zone | TimeZoneDimension | ||
iseg_updateDateTime | datetime | Segment last update date time | Yes | ||
iseg_voiceMailAssignedAgentId | numeric(15, 0) | Foreign key to the assigned agent for a voicemail | ECSUserDimension | ||
iseg_voiceMailLeft | bit (1=true/0=false) | Flag: was left a voicemail | |||
iseg_wasAbandoned | bit (1=true/0=false) | Flag: was interaction abandoned? | |||
iseg_wrapUpTime | int | Wrap Up time in seconds | |||
iseg_eipId | varchar(16) | The account identifier | |||
iseg_oldCallbackExisted | uniqueidentifier | Was interaction handled after a callback requested? if yes, then GUID identifier will be defined here | |||
iseg_telephonyTimeExternalTransfer | int | External Transfer telephony time | |||
iseg_handlerTypeName | nvarchar(128) | Handler type name | |||
iseg_directionName | nvarchar(128) | Direction name | |||
iseg_interactionResultName | nvarchar(128) | Interaction result name | |||
iseg_interactionMediaName | nvarchar(128) | Interaction media name | |||
iseg_originatedFromName | nvarchar(128) | Originated source name of the interaction | |||
iseg_businessProcessName | nvarchar(128) | Business process name | |||
iseg_interactionCreationTypeName | nvarchar(128) | Interaction creation type name | |||
iseg_interactionStateName | nvarchar(128) | Interaction state name | |||
iseg_routingClientName | nvarchar(64) | Routing client name | |||
iseg_routingInboundCampaignName | nvarchar(64) | Routing Inbound campaign name | |||
iseg_routingProductName | nvarchar(64) | Routing product name | |||
iseg_routingProductType | nvarchar(64) | Routing product type | |||
iseg_CRMFirstName | nvarchar(64) | First name of the CRM contact | |||
iseg_CRMLastName | nvarchar(64) | Last name of the CRM contact | |||
iseg_segmentDuration | int | Segment duration | |||
iseg_agentAnswerTime | int | This is the sum of time spent in the queue (excluding ring time / offer time) | |||
iseg_agentDelayTime | int | The sum of time spent in the queue (excluding ring time / offer time ) | |||
iseg_selectTime | datetime | ||||
iseg_inbound | bit (1=true/0=false) | Indicates if the interaction creation type is inbound | |||
iseg_outBound | bit (1=true/0=false) | Indicates if the interaction creation type is outbound | |||
iseg_callback | bit (1=true/0=false) | Indicates if the interaction creation type is callback | |||
iseg_telephony | bit (1=true/0=false) | Indicates if the interaction is a telephony interaction | |||
iseg_chat | bit (1=true/0=false) | Indicates if the interaction is a chat interaction | |||
iseg_email | bit (1=true/0=false) | Indicates if the interaction is an email interaction | |||
iseg_callbackRequests | bit (1=true/0=false) | Indicates that a callback was requested | |||
iseg_callbackCompleted | bit (1=true/0=false) | Indicates the callback has been completed | |||
iseg_transferredIn | bit (1=true/0=false) | Indicates if the interaction is transferred in | |||
iseg_transferredOut | bit (1=true/0=false) | Indicates if the interaction is an external transfer | |||
iseg_disconnected | bit (1=true/0=false) | Indicates if handled interaction was closed by the system | |||
iseg_answered | bit (1=true/0=false) | Indicates if the incoming interaction has been answered | |||
iseg_consulted | bit (1=true/0=false) | Indicates if the interaction state is consulted | |||
iseg_talked | bit (1=true/0=false) | Indicates if the interaction talk time > 0 | |||
iseg_rescheduled | bit (1=true/0=false) | Indicates emails that were manually scheduled by an agent to be answered at a later time | |||
iseg_handled | bit (1=true/0=false) | Indicates if an incoming email interaction was handled by an agent | |||
iseg_missed | bit (1=true/0=false) | Indicates if the interaction has been missed | |||
iseg_rejected | bit (1=true/0=false) | Indicates if the interaction was rejected | |||
iseg_handledInBP | bit (1=true/0=false) | Indicates if the interaction was first handled by a business process | |||
iseg_handledByAgent | bit (1=true/0=false) | Indicates if the interaction was handled by an agent | |||
iseg_answeredAllTypes | bit (1=true/0=false) | Indicates if the interaction is in handling state | |||
iseg_BPExist | bit (1=true/0=false) | Indicates if segment has a business process associated with it | |||
iseg_parentEipId | varchar(16) | The account parent identifier | |||
iseg_interactionStartTimestampLocal | datetime | Interaction start time in local time | |||
iseg_interactionEndTimestampLocal | datetime | Interaction end time in local time | |||
iseg_startTimestampLocal | datetime | Segment start time in local time | |||
iseg_endTimestampLocal | datetime | Segment end time in local time | |||
iseg_enterTimestampLocal | datetime | When the interaction was added to campaign (loaded) in local time | |||
iseg_interactionStartDateLocal | int | Foreign key to the interaction start date in local time | DateDimension | ||
iseg_interactionStartTimeLocal | int | Foreign key to the interaction start time of day in local time | TimeOfDayDimension | ||
iseg_interactionEndDateLocal | int | Foreign key to the interaction end date in local time | DateDimension | ||
iseg_interactionEndTimeLocal | int | Foreign key to the interaction end time of day in local time | TimeOfDayDimension | ||
iseg_startDateLocal | int | Foreign key to the start date in local time | DateDimension | ||
iseg_startTimeLocal | int | Foreign key to the start time of day in local time | TimeOfDayDimension | ||
iseg_endDateLocal | int | Foreign key to the end date in local time | DateDimension | ||
iseg_endTimeLocal | int | Foreign key to the end time of day in local time | TimeOfDayDimension | ||
iseg_enterDateLocal | int | Foreign key to the enter date in local time | DateDimension | ||
iseg_enterTimeLocal | int | Foreign key to the enter time of day in local time | TimeOfDayDimension | ||
iseg_lastUpdatedTimestamp | datetime | The record updated timestamp | |||
iseg_updated | bit | Indicates whether the record was updated | |||
iseg_previewTime | int | ||||
ECSInteractionSkillFact | |||||
Column Name | Type | Description | References | Comments | Indexed |
iskl_id | bigint | Primary key | |||
iskl_active | bit (1=true/0=false) | Flag: is active or not | |||
iskl_date | int | Foreign key to the skill date | DateDimension | ||
iskl_entityId | int | Identifier of entity | |||
iskl_entityTypeId | smallint | Identifier of entity type | Deprecated field. Replaced by iskl_entityTypeName | ||
iskl_eomId | int | Foreign key to ECS organization | ECSOrganizationMapping | ||
iskl_interactionId | uniqueidentifier | Identifier to interaction | |||
iskl_interactionSkillId | int | Identifier of the interaction skill | |||
iskl_levelId | smallint | Identifier to level | Deprecated field. Replaced by iskl_levelName | ||
iskl_skillId | numeric(15, 0) | Identifier to skill | Deprecated field. Replaced by iskl_skillName | ||
iskl_time | int | Foreign key to the skill time | TimeOfDayDimension | ||
iskl_timestamp | datetime2(7) | Timestamp when a skill was assigned | Yes | ||
iskl_eipId | varchar(16) | The account identifier | |||
iskl_entityTypeName | nvarchar(50) | Entity type name | |||
iskl_levelName | nvarchar(50) | Level name | |||
iskl_skillName | nvarchar(128) | Skill name | |||
iskl_parentEipId | varchar(16) | The parent account identifier | |||
iskl_lastUpdatedTimestamp | datetime | The record updated timestamp | |||
iskl_updated | bit | Indicates whether the record was updated | |||
ECSInteractionConversationFact | |||||
Column Name | Type | Description | References | Comments | Indexed |
icnv_id | bigint | Primary key | |||
icnv_interactionConversationId | bigint | The interaction conversation identifier | |||
icnv_interactionMediaName | nvarchar(100) | The name to media: email / chat | |||
icnv_interactionGUIDID | uniqueidentifier | The interaction GUID identifier | |||
icnv_interactionId | bigint | Identifier to interaction | |||
icnv_isCustomer | bit | Flag: was a message from customer? | |||
icnv_messageTimestamp | datetime2(7) | The message timestamp in UTC | |||
icnv_messageTime | int | Foreign key to the interaction message time in UTC | TimeOfDayDimension | ||
icnv_messageDate | int | Foreign key to the interaction message date in UTC | DateDimension | ||
icnv_messageTimestampLocal | datetime2(7) | The message timestamp in local time | |||
icnv_messageTimeLocal | int | Foreign key to the interaction message date in local time | TimeOfDayDimension | ||
icnv_messageDateLocal | int | Foreign key to the interaction message date in local time | DateDimension | ||
icnv_messageText | nvarchar(MAX) | The message text | |||
icnv_subject | nvarchar(MAX) | The email subject | |||
icnv_from | nvarchar(MAX) | The sender | |||
icnv_to | nvarchar(MAX) | The recepient | |||
icnv_cc | nvarchar(MAX) | Carbon copy | |||
icnv_bcc | nvarchar(MAX) | Blind carbon copy | |||
icnv_sessionClosed | bit | ||||
icnv_eomId | int | Foreign key to ECS organization | ECSOrganizationMapping | ||
icnv_eipId | varchar(16) | The account identifier | |||
icnv_parentEipId | varchar(16) | The parent account identifier | |||
icnv_lastUpdatedTimestamp | datetime2(7) | The record updated timestamp | |||
icnv_updated | bit | Indicates whether the record was updated | |||
ECSInteractionDelegatedFact | |||||
Column Name | Type | Description | References | Comments | Indexed |
eidf_id | bigint | Primary key | |||
eidf_interactionDelegatedId | int | The interaction delegated identifier | |||
eidf_interactionGUIDID | uniqueidentifier | The interaction GUID identifier | |||
eidf_interactionTypeId | numeric(15, 0) | Foreign key to the interaction type | ECSInteractionTypeDimension | ||
eidf_businessProcessId | numeric(15, 0) | Foreign key to the business process | ECSBusinessProcessDimension | ||
eidf_businessProcessName | nvarchar(100) | The business process name | |||
eidf_details | nvarchar(MAX) | ||||
eidf_converser | nvarchar(256) | ||||
eidf_initiatorAgentId | numeric(15, 0) | Foreign key to the intiator agent | |||
eidf_initiatorBusinessProcessId | numeric(15, 0) | Foreign key to the intiator business process | |||
eidf_initiatorName | nvarchar(50) | Intiator name | |||
eidf_entryTimestamp | datetime2(7) | Entry timestamp in UTC | |||
eidf_entryDate | int | Foreign key to the entry date in UTC | DateDimension | ||
eidf_entryTime | int | Foreign key to the entry time in UTC | TimeOfDayDimension | ||
eidf_entryTimestampLocal | datetime2(7) | Entry timestamp in local time | |||
eidf_entryDateLocal | int | Foreign key to the entry date in local time | DateDimension | ||
eidf_entryTimeLocal | int | Foreign key to the entry time in local time | TimeOfDayDimension | ||
eidf_updateTimestamp | datetime2(7) | Update timestamp in UTC | |||
eidf_updateDate | int | Foreign key to the update date in UTC | DateDimension | ||
eidf_updateTime | int | Foreign key to the update time in UTC | TimeOfDayDimension | ||
eidf_remarks | nvarchar(MAX) | Remarks | |||
eidf_delegatedStateName | nvarchar(100) | The interaction delegated state name | |||
eidf_interactionMediaName | nvarchar(100) | The interaction media name | |||
eidf_interactionStateId | numeric(15, 0) | Foreign key to the interaction state | ECSInteractionStateDimension | ||
eidf_interactionStateName | nvarchar(100) | Interaction state name | |||
eidf_callback | bit | ||||
eidf_campaignId | numeric(15, 0) | Foreign key to the campaign | ECSCampaignDimension | ||
eidf_campaignName | nvarchar(100) | The campaign name | |||
eidf_customerId | nvarchar(MAX) | ||||
eidf_supervisorCloseMessage | nvarchar(MAX) | ||||
eidf_eomId | int | Foreign key to ECS organization | ECSOrganizationMapping | ||
eidf_eipId | varchar(16) | The account identifier | |||
eidf_parentEipId | varchar(16) | The parent account identifier | |||
ECSInteractionUsageFact | |||||
Column Name | Type | Description | References | Comments | Indexed |
iusg_id | bigint | Primary key | |||
iusg_interactionUsageId | bigint | The interaction usage identifier | |||
iusg_interactionId | bigint | The interaction identifier | |||
iusg_interactionGUIDID | uniqueidentifier | The interaction GUID identifier | |||
iusg_origin | nvarchar(128) | Origin | |||
iusg_destination | nvarchar(128) | Destination | |||
iusg_directionName | nvarchar(128) | Direction name | |||
iusg_duration | int | Usage duration | |||
iusg_lastHandler | nvarchar(256) | The last handler name | |||
iusg_startTime | int | Foreign key to the usage start time in UTC | TimeOfDayDimension | ||
iusg_startDate | int | Foreign key to the usage start date in UTC | DateDimension | ||
iusg_startTimeLocal | int | Foreign key to the usage start time in local time | TimeOfDayDimension | ||
iusg_startDateLocal | int | Foreign key to the usage start date in local time | DateDimension | ||
iusg_endTime | int | Foreign key to the usage end time in UTC | TimeOfDayDimension | ||
iusg_endDate | int | Foreign key to the usage end date in UTC | DateDimension | ||
iusg_endTimeLocal | int | Foreign key to the usage end time in local time | TimeOfDayDimension | ||
iusg_endDateLocal | int | Foreign key to the usage end date in local time | DateDimension | ||
iusg_startTimestamp | datetime2(7) | The usage start timestamp in UTC | |||
iusg_startTimestampLocal | datetime2(7) | The usage start timestamp in local time | |||
iusg_endTimestamp | datetime2(7) | The usage end timestamp in UTC | |||
iusg_endTimestampLocal | datetime2(7) | The usage end timestamp in local time | |||
iusg_interactionUsageTypeName | nvarchar(128) | The interaction usage type name | |||
iusg_interactionStateId | numeric(15, 0) | Foreign key to the interaction state | |||
iusg_interactionStateName | nvarchar(128) | The interaction state name | ECSInteractionStateDimension | ||
iusg_dispositionCode | nvarchar(256) | Disposition code | |||
iusg_businessProcessId | numeric(15, 0) | Foreign key to the business process | ECSBusinessProcessDimension | ||
iusg_businessProcessName | nvarchar(128) | The business process name | |||
iusg_needsUpdateAfterByeTransfer | bit | Flag | |||
iusg_eomId | int | Foreign key to ECS organization | ECSOrganizationMapping | ||
iusg_eipId | varchar(16) | The account identifier | |||
iusg_parentEipId | varchar(16) | The parent account identifier | |||
iusg_lastUpdatedTimestamp | datetime2(7) | The record updated timestamp | |||
iusg_updated | bit | Indicates whether the record was updated | |||
...