Correspondence Code not updated in DIM_MAILPREFERENCE table when Data Warehouse is refreshed

When the Data Warehouse is refreshed, the BBDW.DIM_MAILPREFERENCE table is not reflecting correspondence code updates when an ETL Refresh takes place.
We are currently evaluating this issue for a fix in a future service pack.
 

Steps to Duplicate

1. Marketing and Communications functional area > Manage correspondence > Correspondence Codes tab > Add a new correspondence code.
2. Open up any constituent > Communications tab > Preferences tab > Add a new Mail preference using the code created in step 1.
3. Run the ETL Refresh.
4. Marketing and Communications functional area > Manage correspondence > Correspondence Codes tab > Edit the code created in step 1 and update its name to something else.
5. Run the ETL Refresh again. DIM_MAILPREFERENCE table still has the old name value created in step 1 instead of the updated value in step 4.

Environment

 Blackbaud CRM
 4.0.180.1605

Was this article helpful?