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