Best practices for coding board members in RE ?
Comments
-
Hi Rowlawn. Re is a little limited for data that changes frequently I find. For our board members we use constituent codes and when one changes we just add a "to" date to show that they are no longer a Trustee/board member. We then use a query to pull data with the constituent code, filtering by "constituent code = Trustee" and "constituent code to date = blank".12
-
At previous orgs, we've used the Volunteer Module to track board member terms (and other committees). If you have the Volunteer Module, I would recommend looking at that. Especially if you are wanting to retain historical information.
Others have posted about using Relationship Records to either your org's record or a separate Constituent Record specifically for this purpose.
Beyond those, Constituent Codes and Attributes are the most common places to store this information. Regardless of where you choose to put this data, you'll need to continue to keep it updated.3 -
We use Attributes. The "Board of Govornors" Attribute has a table of Descriptions (Governon-at-Large, Governon-in-Council, Alumni (rep), Faculty (rep), Student (rep), Honorary Governon, Life Governon, Ex Officio, Chair, Vice-Chair, Treasurer, Secretary. In the Comment field I will enter their term dates.
When their term ends I change the Attribute to "Former Bords" with the same table of Descriptions.
We did a house cleaning of Constituent Codes to reduce the number and so that each record only has one code (main relationship with organization). Some people will still have the Constituent Code: Board Member or Former Board Member.0 -
We do it the same way that Joy does it. Constitutent code with a start date and add the end date when the term is up. We have had members take a term off and join the board again. I give them a second Board Member constituent code with a new start date and no end date.1
-
This is also helpful when it comes to constituent codes: http://www.billconnors.com/media/Former%20Constituent%20Codes--post%20to%20fundsvcs.pdf
1 -
Current (current fiscal year) board members are coded in constituent codes
The history of when they served on boards is in the volunteer tab under job assignments0 -
For current members we add a Constituency Code of Trustee to make it easy to pull for reporting.
We also created a Membership for our different boards, and the positions that they hold. This has provided us with flexibility and a great way to track the data historically.
Cheers,
David1 -
Rolawn Pinkney:
Can anyone share infomation on how to code a board member in RE, these members tend to change at an ongoing basis, what have been some useful ways to code constituents whose roles change. Previously, these members were coded using attributes but, this information quickly became stale and a pain to update.We use constituency codes, but don't use the "to" date as my staff found date ranges too difficult to remember when pulling information in query. We also give them a volunteer constituency code which stays active until they die. To move active board members to inactive members we change the code to Former board. We also create a note called Committee/Boards to track the board members service and committees on which they served. We do not have the volunteer module. This may seem a bit cumbersome, but it works for us and all staff understand the process.
1 -
We have a Constituent sub-code of Current Board of Directors with the from date. When they leave the board that sub-code becomes Former Board of Directors with from and to dates. The reason for the sub-code is that we have a very small number of primary codes (in all caps) and some of our board members are ALUMNUS while some are FRIEND - basically the only 2 individual primary codes that we have - in addition to a handful of organization primary codes. That works pretty well for us.
On a related note, we have several advisory boards and those members come and go all the time it seems. To handle those (I think I saw the suggestion here in the community and "borrowed" it) I give each Advisory Board an Organizational record (with our College's mailing address) and make the members contacts on the relationships tab - makes it really easy to pull a roster.0 -
Rolawn Pinkney:
Can anyone share infomation on how to code a board member in RE, these members tend to change at an ongoing basis, what have been some useful ways to code constituents whose roles change. Previously, these members were coded using attributes but, this information quickly became stale and a pain to update.We had been using Attributes to track board and council membership for the university as a whole, but we had the same problems. We have something like 30 boards and councils, minmum, and some constituents may belong to multiple, or they may have gaps when their first term ends and they wait a few years before their second term.
This year, we have begun transitioning from Attributes to Memberships, since we already have the module for some of our auxiliary institutions and a couple boards were using it with success. This works handily because a few of the councils have dues requirements, and with Memberships we can track whether the dues were paid for the council term (using Linked Gifts). We can also use Membership Programs to group the councils by division or college and Subcategories or Membership Attributes to track specific council committees or positions. (Which one is used depends on the council's rules - which, admittedly, is a bit of a headache to keep track, but it was nearly impossible to do with Attributes.)
I have found that it is very, very helpful to create a tree/relational map of the various university colleges and divisions, their boards and councils, and any committees or other subdivisions. This is stored with our Memberships policies and procedures and will be updated prior to each academic year. The Membership Program -> Category -> Subcategory is the same breakdown, but it's nice to see them laid out in the reference file instead of having to visualize it from the Config tables and settings. It's also a good reference for our data entry staff, who of course do not have access to the Config settings.
To be honest, our solution is really only necessary if you have a huge number of board members and need to be able to see their history with the organization. It's a little complicated to set up, but once it's done, the term dates automatically remove the board members from the active roster, so I only have to worry about adding or renewing the board membership and linking their dues.
3 -
Rolawn Pinkney:
Can anyone share infomation on how to code a board member in RE, these members tend to change at an ongoing basis, what have been some useful ways to code constituents whose roles change. Previously, these members were coded using attributes but, this information quickly became stale and a pain to update.
But you could also put them in Relationships.
I would say those are the two most direct ways of tagging them. In my experience, it is always a primary group that is referred to, and so they deserve their own Constit Code. My two cents.1 -
Rolawn Pinkney:
Can anyone share infomation on how to code a board member in RE, these members tend to change at an ongoing basis, what have been some useful ways to code constituents whose roles change. Previously, these members were coded using attributes but, this information quickly became stale and a pain to update.I'm reposting a response from Aaron Rothberg in a previous thread - which is how I also handle board members (in the thread they were discussing committee members but it's the same thing ...):
I'm a huge proponent for tracking committee members and board members using Ind-> Org relationships. You've already noted some of the downsides of using Constit Codes to track this data especially when a constituent may belong to more than one Committee and those memberships can change over time. If the person joins the committee, leaves the committee, and joins the committee again you now have two Constit Codes to track that changing relationship. Constit Codes also limit you to capturing one start date and one end date and not much else about the committee relationship. It's true that should you choose to use Relationships moving forward (which I recommend) you would also have two Rels on the Relationships Tab, but relationship records allow you to track much more information such as the constituents position on the committee, if s/he is a contact for the committee, if the constituent has phone numbers or email addresses specific to the committee. Our process includes that if someone leaves the committee, we change their relationship to Former Member which allows me to filter them out of Export by Relationship Type, but we leave the dates intact so we can see when that person was active on the committee.
Once I started tracking committee relationships using Ind -> Org Rels and discovered the advantages of going that route I never looked back.
2 -
We use both Constituent Codes and Attributes.
Constituent Codes are to track the term of the current board members, then their primary Const Code become Former Board Member when they leave the board.
Attributes are for tracking our Committees. As others have mentioned, this might get cumbersome with multiple boards, lots of committes, etc., but the most number of committees we've had since I started here has been 8, so it works okay for us.0
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™
- 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
- 3 Blackbaud Staff Discussions
- 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