How To Pull Certain Constituencies through Query or Export
Hello.
Suppose I have two constituents, John Doe and Michael Fox, who are members of the Board of Directors (and BOD is their primary constituent code). They are both current parents (so their second constituent code is CPAR with a Date From of 05/01/19). Now John Doe's child just graduated, so I add a new constituent code, PPAR for Past Parent, with a Date From of 05/31/23 and a blank Date To. I kept the CPAR code but added a Date To of 05/31/23. Michael Fox remains a true current parent.
If I want to pull all Current Parents from RE, I can pull a list based on the Primary Constituency. But what if there are other current parents whose primary constituency is BOD (just like Michael Fox), how can I pull Michael Fox without pulling John Doe?
Can I pull this only if I depend on the Date From/To information? I only ask because we have not necessarily made good use of the Date From/To fields in our database (some are left blank).
Thank you.
Comments
-
@Bernard Nemis
Don't use criteria of primary constituency, just constituency code + criteria on date from/to.will give you every constituent that has the current parent code that fall in the from and to.
6 -
@Bernard Nemis
I personally won't have a constituency code of Current Parent. I would have PAR and the constituents who are current would not have a to date. The past parents would have a to date filled in. The date from/to use helps you to keep track of and properly report proper status as far as constituent codes go. If we have multiple constituent codes on a record, the primary is on the first line of the constituent codes and the rest follow according to the hierarchy in the constituent code of the record. You can set up your constituent code table using your hierarchy with the most important (for us Alumnus/ae) down to your least important. That way when constituent codes are assigned to new records or added to existing records the sort order of the table helps with the code assignment. We do a lot of campaign reporting based on constituent codes so we do constituent code cleanup regularly to ensure the accuracy of our records.1 -
@Bernard Nemis Alex's post should get you what you need.
Additional comment about end dates. You will need to figure out what works for you and your org. Do you want every record to have a valid constituent code for today's date? What Annette described regarding primary/hierarchy is correct.
If you use end dates for codes like ‘current parent’/'faculty' and that is the only code on the record they will not have a valid code when you pull some reports. For that reason, we do use codes such as ‘former faculty’ with the date from that is the date to of their ‘faculty’ code.
So a record might look like this:
Former faculty 6/ 1 / 2023 (open date to)
Faculty 8/ 1 /2018 6/ 1 /2023The primary constituency is also the default gift constituency. If there is no open constituency when gift is entered the gift constituency is blank and that also can affect your reporting.
Just some things to consider.
3 -
Thank you, everyone. So based on what I gathered from all of you is, to continue with my plan of doing a historical list of all constituencies and continue to leave the Date To field blank if that is still a valid code. If not, then I need to add a Date To value. Since those non valid codes will still get pulled by a query, I have to make good use of the Date From/Date To values. Which leaves me to the conclusion that I have to go back to my old records and make sure I globally add dates on them.
Thank you, all!
0 -
@Bernard Nemis
A lot of folks already mentioned, but when I replied, didn't exactly go through what we do as an org.For example, we currently have a National Board Member constituent code, and a Past National Board Member constituent code, and we do not use Date from/to. So as long as we properly keep these 2 code used on the right constituent, we can simply query one or both of these code to get the list of constituent we need. We also have error checking to ensure no record has both.
This is not neccessary the “better” way to go, as we lose the information on when the donor became national board member or stop being one. This current way of recording is “lazy” and efficient if you don't care for the “when”. However, if you do need to know in a query-able manner, then use 1 code, and utilize Date from/to will be better.
0 -
The whole date thing is interesting. We have many codes on records with no dates whatsoever. As long as we use the hierarchy correctly, IMO, no dates is easier to deal with than dates.
I inherited a db of alumni that does not even have the date from on their primary code of alumnus/a. Was quite surprised. A project to go back and put their graduation date is near the bottom of my list of clean up projects.
What you may want to do @Bernard Nemis is take a half dozen records (real or test) and put in codes with and with out dates. Run a couple queries/reports/exports. See what you get. It may help you decide what will work best for your org.
Best wishes on your project.
0 -
@JoAnn Strommen
Thank you. Quick question, if you are not using the date fields, I go back to my original post… how do you pull Michael Fox w/o pulling John Doe? I thought the dates will prevent you from pulling constituents with an invalid constituent code from the query, if the date to is expired. Currently we do have a hierarchy of codes, but only on paper. I am planning to implement that in how we enter them in RE. I do want to ask you how placing the codes in hierarchy in BIO2 can be useful in pulling out only “true" current parents.0 -
@Bernard Nemis If I'm thinking clearly (long week already LOL) you should be able to pull using a query criteria of constituency equals CPAR and date to is blank.
I'm trying to think of something I could test in my db. Try that, if it doesn't work. Post and we'll figure out another option.
1 -
@Alex Wong
Hello, Alex. Thank you. That is currently what we do now. I am being advised that the more traditional way is to keep history of the codes in their records.0 -
@JoAnn Strommen
You are correct! I tested it. Adding the Date To = blank in the criteria gives me a true list of CPAR! That means I will really have to rely on the Date From/To. I just want to create a plan on how to update existing data. Thank you. Hope the week gets better.1
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 1 YourCause® from Blackbaud®
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 1.1K ARCHIVED FORUMS | Inactive and/or Completed EAPs
- 3 Blackbaud Staff Discussions
- 7.7K ARCHIVED FORUM CATEGORY [ID 304]
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board