Release 82

by

Release Notes – Week Ending 10 November

1. Feedback Meta Views

Files:

  • feedback_meta_codes_customervoice
  • feedback_meta_codes_legacyexternal
  • feedback_meta_codes_customerthermometer
  • feedback_meta_codes_legacyinternal
  • feedback_meta_codes_satisfaction
  • feedback_meta_satisfaction

Summary:
The former feedback_meta_codes_satisfaction view (over 800 lines) has been decomposed into its logical components to improve maintainability and clarity. These sub-views—covering Customer Voice, Customer Thermometer, Legacy External, and Legacy Internal—are now individually managed and combined through the new feedback_meta_satisfaction UNION view.

This marks the introduction of a composite Datamart view pattern, where the catalogue and get.myView functions will handle the UNION logic dynamically. This modular approach simplifies ongoing maintenance and supports more flexible expansion of the Feedback domain.

2. Person Item Absence Views

Files:

  • person_item_codes_absence
  • person_item_dates_absence
  • person_item_values_absence

Summary:
Adjustments were made to address an incomplete data transfer from the Employee domain, mitigating a potential risk of data exposure. The OBJECT_SEQ field now correctly uses PERSON_ID in place of EMP_NO, ensuring appropriate linkage and data segregation.

3. Customer Thermometer Views

Files:

  • customer_thermometer_202404
  • customer_thermometer_202409
  • customer_thermometer

Summary:
Revisions were made to support the get.myView wrapper by explicitly defining field names rather than using wildcards (*). This change resolves a naming conflict where pipelinelog_date appeared twice in the view outputs.

4. Business Opportunity (APC)

File:

  • busopp_details_APC

Summary:
Following changes to Dataflows—where all fields are now delivered as text—numeric calculations within the CTE have been updated to include explicit CAST operations to integer. This ensures reliable data typing and consistent downstream processing.

Leave a Comment