Constituent Search: Exclude inactive Code Tables
Values that have been marked inactive still show up in places like the Search Screen. We would like inactive values to not show.
Jun 29 2015
Organization Name (Please enter full organization name)
Enter a subject
March 06, 2017 22:44
This is frustrating for a number of reasons:
New employees who never worked with those older values get confused when pulling queries, running reports, using datalists
For code tables with vast numbers of inactive fields, such as an annual revenue attribute (for example, we have one for every year’s Gala since 1988 for both accepts, regrets, and raffle gifts. I make them inactive, but that means there are ninety attributes) it means any report built off them would be very messy looking and not appealing to my senior leadership.
For situations like the interaction categories, where I realized we made a mistake in conversion, it feels like we cannot make a change to our coding without doing massive amounts of data clean-up to old records going back 30 years
And interactions couldn’t just be adjusted to the new values with a script – these are free-text narratives that would need to be reviewed manually to be reassigned
AND the categories are different types of categorization – the old coding was inbound vs. outbound, and the new coding is quality of contact, so they would definitely need to be manually reviewed
Open full size
Log in / Sign up
Identify yourself with your email address
You won't be notified about changes to this idea.
Allow search function in Administration\Code Tables
Administration - Code Table Filters - Add Search Option
Allow an option for Search for constituents by site to be an include or exclude filter
Indicate clearly in the constituent search screen whether a constituent record is inactive eg red text or 'inactive' next to the name
Constituent Status in Batch
Solicit Code add/change history to be available per constituent, not just in audit table
Search by Constituent Relationship Manager
allow users the choice to remove inactive code table values as report drop-down values
Add keyword search to Solicit codes, Educational Involvement and Constituent Attribute drop-downs.