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.

Environment

 Blackbaud CRM
 4.0
 4.0.180.1605

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.