To support our reporting and documentation requirements for go-lives in the Hypercare period, we need access to additional data that is currently unavailable in the Data Warehouse (DWH).

Several required columns and tables are missing from the DWH, which is preventing us from extracting complete and accurate reporting data. As a result, we are unable to generate the necessary reports and maintain the required documentation for Hypercare activities.

Request: Please load the missing columns and tables listed below into the Data Warehouse to enable data extraction and reporting.

TableName Missing Columns

tblTicketAttributes ShowOnContactsPage

tblTicketCategoryAttributes OutboundEmailFrom

tblTicketCategoryAttributes BccEmailAddress

tblTicketCategoryAttributes OptionalBCCEmailAddress

tblTicketCategoryAttributes Retired

tblDueDateAttributes DueDateCalculationMethod

tblDueDateAttributes DynamicDurationOperator

tblDueDateAttributes DynamicDuration_DataDictionaryGUID

tblDueDateAttributes UseEndOfDayForCalculation

tblEmailTemplates Table is missing

tblTicketAttributeVersions DefaultAdhoc_EmailTemplateGUID (Table is missing)

tblTicketAttributeVersions TicketLogged_EmailTemplateGUID (Table is missing)

tblTicketAttributeVersions TicketRejected_EmailTemplateGUID (Table is missing)

tblTicketAttributeVersions TicketSplit_EmailTemplateGUID (Table is missing)

tblTicketAttributeVersions TicketLaunchedCase_EmailTemplateGUID (Table is missing)

tblTicketAttributeVersions TicketNoResponse_EmailTemplateGUID (Table is missing)

tblTicketAttributeVersions FeedbackFooter_EmailTemplateGUID (Table is missing)

Tblemailroutes Table is missing

Business Impact:

Incomplete Hypercare reporting.

Delays in documentation and operational tracking.