The Status field in the DIM_FUNDRAISERSECONDARY table does not update correctly when a fundraiser's end date has passed

When an entry is added to the BBDW DIM_FUNDRAISERSECONDARY for an active fundraiser with an end date in the future, the fundraiser's status remains current even after the end date has passed. In the CRM SECONDARYFUNDRAISER table, the status field is calculated and the status correctly updates, but the end date passing does not actually change the record in question so the ETL refresh does not trigger a change to the record in the BBDW.
We are currently evaluating this issue for a fix in a future service pack.

Note: Resetting then refreshing the ETL correctly updates the fundraiser's status in the table.

Steps to Duplicate

1) Add a secondary prospect plan manager with an end date in the future.
2) Refresh the ETL to add an entry to the DIM_FUNDRAISERSECONDARY when the fundraiser has a current status.
3) After the end date has passed and the fundraiser now has a status of prior, refresh the ETL.
4) Check the entry in the DIM_FUNDRAISERSECONDARY table and notice the status remains Current.


 Blackbaud CRM

Was this article helpful?