ECS Dimension Tables | ||
ECSAgentLifeTypeDimension(Deprecated) | ||
| Column Name | Data Type | Description |
|---|---|---|
| alt_agentLifeTypeId | snallint | Primary key |
| alt_agentLifeTypeName | nvarchar(50) | Agent life type name |
ECSAgentStatusDimension(Deprecated) | ||
| Column Name | Data Type | Description |
| asd_id | numeric(15, 0) | Primary key |
| asd_agentStatusName | nvarchar(50) | Agent status name |
| asd_accountId | varchar(16) | Account identifier |
ECSAlertTypeDimension(Deprecated) | ||
| Column Name | Data Type | Description |
| atd_alertTypeId | smallint | Primary key |
| atd_alertTypeName | nvarchar(100) | Alert type name |
ECSBreakCategoryTypeDimension | ||
| Column Name | Data Type | Description |
| bct_id | numeric(15, 0) | Primary key |
| bct_breakCategoryTypeName | nvarchar(100) | The break category type name |
| bct_exceedSeconds | int | Allowed count of exceeded seconds |
| bct_paid | bit (1=true/0=false) | Is Paid |
| bct_accountId | varchar(16) | The account identifier |
| bct_parentEipId | varchar(16) | The parent account identifier |
ECSBreakTypeDimension(Deprecated) | ||
| Column Name | Data Type | Description |
| btd_id | numeric(15, 0) | Primary key |
| btd_breakTypeName | nvarchar(100) | Break type name |
| btd_accountId | varchar(16) | The account identifier |
ECSBusinessProcessDimension | ||
| Column Name | Data Type | Description |
| bpd_id | numeric(15, 0) | Primary key |
| bpd_businessProcessName | nvarchar(100) | Business process name |
| bpd_contactCenterName | nvarchar(100) | Contact center name |
| bpd_accountId | varchar(16) | The account identifier |
| bpd_parentEipId | varchar(16) | The parent account identifier |
ECSCampaignDimension | ||
| Column Name | Data Type | Description |
| ecd_id | numeric(15, 0) | Primary key |
| ecd_campaignName | nvarchar(100) | Campaign name |
| ecd_businessProcessId | numeric(15, 0) | Business process identifier |
| ecd_businessProcessName | nvarchar(100) | Business process name |
| ecd_dialerTypeId | numeric(15, 0) | Dialer type identifier |
| ecd_dialerTypeName | nvarchar(100) | Dialer type name |
| ecd_accountId | varchar(16) | The account identifier |
| ecd_parentEipId | varchar(16) | The parent account identifier |
ECSCounterTypeDimension(Deprecated) | ||
| Column Name | Data Type | Description |
| ctd_id | numeric(15, 0) | Primary key |
| ctd_counterTypeName | nvarchar(100) | Counter type name |
| ctd_accountId | varchar(16) | The account identifier |
ECSDialerTypeDimension(Deprecated) | ||
| Column Name | Data Type | Description |
| dtd_id | numeric(15, 0) | Primary key |
| dtd_dialerTypeName | nvarchar(100) | Dialer type name |
| dtd_accountId | varchar(16) | The account identifier |
ECSDirectionDimension(Deprecated) | ||
| Column Name | Data Type | Description |
| dtd_id | numeric(15, 0) | Primary key |
| dtd_dialerTypeName | nvarchar(100) | Dialer type name |
| dtd_accountId | varchar(16) | The account identifier |
ECSEntityTypeDimension(Deprecated) | ||
| Column Name | Data Type | Description |
| etd_entityTypeId | smallint | Primary key |
| etd_entityTypeName | nvarchar(50) | Entity type name |
ECSInteractionChannelDimension | ||
| Column Name | Data Type | Description |
| icd_id | numeric(15, 0) | Primary key |
| icd_interactionChannelName | nvarchar(100) | Interaction channel name |
| icd_contactCenterName | nvarchar(100) | Contact center name |
| icd_accountId | varchar(16) | The account identifier |
| icd_parentEipId | varchar(16) | The parent account identifier |
ECSInteractionStateDimension | ||
| Column Name | Data Type | Description |
| isd_id | numeric(15, 0) | Primary key |
| isd_interactionStateName | nvarchar(100) | Interaction state name |
| isd_outboundStatusName | nvarchar(100) | Outbound status name |
| isd_statusName | nvarchar(100) | Status name |
| isd_accountId | varchar(16) | The account identifier |
| isd_parentEipId | varchar(16) | The parent account identifier |
ECSInteractionCreationTypeDimension(Deprecated) | ||
| Column Name | Data Type | Description |
| ict_interactionCreationTypeId | smallint | Primary key |
| ict_interactionCreationTypeName | nvarchar(100) | Interaction creation type name |
ECSInteractionMediaDimension(Deprecated) | ||
| Column Name | Data Type | Description |
| imd_interactionMediaId | smallint | Primary key |
| imd_interactionMediaName | nvarchar(100) | Interaction media name |
ECSInteractionResultDimension(Deprecated) | ||
| Column Name | Data Type | Description |
| ird_id | numeric(15, 0) | Primary key |
| ird_interactionResultName | nvarchar(100) | Interaction result name |
| ird_accountId | varchar(16) | The account identifier |
ECSLevelDimension(Deprecated) | ||
| Column Name | Data Type | Description |
| eld_levelId | smallint | Primary key |
| eld_levelName | nvarchar(50) | Level name |
ECSOriginatedFromDimension(Deprecated) | ||
| Column Name | Data Type | Description |
| ofd_originatedFromId | smallint | Primary key |
| ofd_originatedFromName | nvarchar(100) | Originated from name |
ECSSkillDimension(Deprecated) | ||
| Column Name | Data Type | Description |
| esd_id | numeric(15, 0) | Primary key |
| esd_skillName | nvarchar(128) | Skill name |
| esd_accountId | varchar(16) | The account identifier |
ECSInteractionTypeDimension | ||
| Column Name | Data Type | Description |
| itd_id | numeric(15, 0) | Primary key |
| itd_interactionTypeName | nvarchar(100) | Interaction type name |
| itd_directionName | nvarchar(100) | Direction name |
| itd_mediaName | nvarchar(100) | Media name |
| itd_purpose | nvarchar(100) | Purpose name |
| itd_accountId | varchar(16) | The account identifier |
| itd_parentEipId | varchar(16) | The parent account identifier |
ECSUserDimension | ||
| Column Name | Data Type | Description |
| eud_id | numeric(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 | uniqueidentifier | GUID identifier |
ECSOrganizationMapping | ||
| Column Name | Data Type | Description |
| eom_id | int | Primary key |
| eom_organizationName | varchar(150) | Organization name |
| eom_organizationDWDBName | varchar(150) | Organization data warehouse database name |
| eom_organizationId | uniqueidentifier | Organization GUID identifier |
| eom_accountId | varchar(16) | The account identifier |
| eom_isActive | bit (1=true/0=false) | Organization is active or not |
TimeZoneDimension | ||
| Column Name | Data Type | Description |
| tzd_timeZoneId | smallint | Primary key |
| tzd_offset | smallint | Time zone offset |
| tzd_timeZoneName | nvarchar(150) | Time zone name |
| tzd_displayName | nvarchar(150) | Time zone display name |
AreaCodeDimension | ||
| Column Name | Data Type | Description |
| acd_areaCodeId | int | Area code |
| acd_state | nvarchar(40) | State |
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 | |||