2021.1 Data Warehouse Changes
The following gives an initial list of details of changes to the Data Warehouse as of v2021.1. The full list will be released in the coming days.

Action Attributes (tblActionAttributes)

_ProcessGUID Column
With the removal of Processes from Enate 2021.1 this column is unnecessary. To assist with upgrades to 2021.1 this column will return the same value as the _GUID column and can continue to be joined to tblProcesses.

Case Attributes (tblCaseAttributes)

_ProcessGUID Column
With the removal of Processes from Enate 2021.1 this column is unnecessary. To assist with upgrades to 2021.1 this column will return the same value as the _GUID column and can continue to be joined to tblProcesses.
_RecordCount Column
To match product capabilities this column can now return NULL values.

Cases (tblCases)

_CaseFlowStepGUID Column
With the complete embedding of “CaseFlow” into Enate this column has been renamed to _CaseStepGUID. To assist with upgrades to 2021.1 a computed column has been provided that will return the same value.

Defect Categories (tblDefectCategories)

_ServiceTemplateGUID Column
In Enate 2021.1 Service Templates have been renamed Service Lines to match the UI. To assist with upgrades to 2021.1 this column will return the same value as the _ServiceLineGUID column and can continue to be joined to tblServiceTemplates.
Queries should be migrated to use _ServiceLineGUID (and tblServiceLines).

Follow Up Attributes (tblFollowUpAttributes)

This table has been removed from Enate 2021.1. The data previously stored in tblFollowUpAttributes is available directly in the _FeedbackWindowDays column of tblTicketAttributes.

Global Checklists (tblGlobalChecklists)

_ProcessTemplateGUID Column
With the removal of Processes from Enate 2021.1 this column has been replaced with _ActionTypeGUID. To assist with upgrades to 2021.1 this column will return the same value as the _ActionTypeGUID column and can continue to be joined to tblProcessTemplates.
Queries should be migrated to use _ActionTypeGUID (and tblActionTypes).

Packet Activities (tblPacketActivities)

_PacketTaskGUID Column
With the removal of Processes and Tasks from Enate 2021.1 this column is unnecessary. To assist with upgrades to 2021.1 this column will return NULL.

Packet Allocation Histories (tblPacketAllocationHistories)

_PacketTaskGUID Column
With the removal of Processes and Tasks from Enate 2021.1 this column is unnecessary. To assist with upgrades to 2021.1 this column will return NULL.

Packet Communications (tblPacketCommunications)

_PacketTaskGUID Column
With the removal of Processes and Tasks from Enate 2021.1 this column is unnecessary. To assist with upgrades to 2021.1 this column will return NULL.

Packets (tblPackets)

_ProcessVersion Column
With the removal of Processes from Enate 2021.1 this column is unnecessary. To assist with upgrades to 2021.1 this column will return “1.0”.
_ServiceVersion Column
With the removal of versioning logic from Services in Enate 2021.1 this column is unnecessary. To assist with upgrades to 2021.1 this column will return “1.0”.
_ContractVersion Column
With the planned removal of versioning logic from Contracts in Enate 2021.1 this column is unnecessary. To assist with upgrades to 2021.1 this column will return “1.0”.
_ProcessTemplateVersion Column
With the removal of Processes from Enate 2021.1 this column is unnecessary. To assist with upgrades to 2021.1 this column will return “1.0”.
_ServiceTemplateVersion Column
With the removal of versioning logic from Services in Enate 2021.1 this column is unnecessary. To assist with upgrades to 2021.1 this column will return “1.0”.
_Current_PacketTaskGUID Column
With the removal of Processes and Tasks from Enate 2021.1 this column is unnecessary. To assist with upgrades to 2021.1 this column will return NULL.

Packet Tasks (tblPacketTasks)

With the removal of Processes and Tasks from Enate 2021.1 this table is unnecessary as no Task data exists.

Services (tblServices)

_ServiceTemplateGUID Column
In Enate 2021.1 Service Templates have been renamed Service Lines to match the UI. To assist with upgrades to 2021.1 this column will return the same value as the _ServiceLineGUID column and can continue to be joined to tblServiceTemplates.
Queries should be migrated to use _ServiceLineGUID (and tblServiceLines).

Ticket Attributes (tblTicketAttributes)

This table has been renamed to tblTicketCategoryAttributes and a new tblTicketAttributes table created in its place. This significant breaking change is necessary to accurately model the relationships configured within Enate. The below column changes are between the tblTicketAttributes table in 2020.1 and below vs tblTicketCategoryAttributes in 2021.1.
_ProcessGUID Column
With the removal of Processes from Enate 2021.1 this column is unnecessary. To assist with upgrades to 2021.1 this column will return the same value as the _TicketAttributeGUID column and can continue to be joined to tblProcesses.
_FollowUpAttributeGUID Column
This column has been removed from Enate 2021.1. The data previously stored in tblFollowUpAttributes is available directly in the _FeedbackWindowDays column.

Ticket Categories (tblTicketCategories)

_ServiceTemplateGUID Column
In Enate 2021.1 Service Templates have been renamed Service Lines to match the UI. To assist with upgrades to 2021.1 this column will return the same value as the _ServiceLineGUID column and can continue to be joined to tblServiceTemplates. Queries should be migrated to use _ServiceLineGUID (and tblServiceLines).
Last modified 4mo ago