Constituent Codes for Schools Records in RE

Tiffany Thomas

Hello - We are in the process of doing some database cleanup and I'm wondering what everyone uses for a constituent code on school records? Ours are not very consistent. Our current constituent code hierarchy is like this:

1. 
   
   Individual Donor/Prospect
   
   
2. 
   
   Business
   
   
3. 
   
   Estate
   
   
4. 
   
   Trust
   
   
5. 
   
   Foundation
   
   
6. 
   
   Donor Advised Fund
   
   
7. 
   
   Matching Gift Company
   
   
8. 
   
   Non-Profit (Club/Association/Service Org)
   
   
9. 
   
   Third Party Event
   
   
10. 
    
    Town/County/State Government
    
    

Does anyone use anything similar to one of our current codes? Or do you use something else entirely? Also, do you code colleges, universities, public schools, nursery schools, etc. all the same?

 Thanks for your thoughts!

Rob Kudyba

Tiffany Thomas:

Hello - We are in the process of doing some database cleanup and I'm wondering what everyone uses for a constituent code on school records? Ours are not very consistent. Our current constituent code hierarchy is like this:

1. 
   
   Individual Donor/Prospect
   
   
2. 
   
   Business
   
   
3. 
   
   Estate
   
   
4. 
   
   Trust
   
   
5. 
   
   Foundation
   
   
6. 
   
   Donor Advised Fund
   
   
7. 
   
   Matching Gift Company
   
   
8. 
   
   Non-Profit (Club/Association/Service Org)
   
   
9. 
   
   Third Party Event
   
   
10. 
    
    Town/County/State Government
    
    

Does anyone use anything similar to one of our current codes? Or do you use something else entirely? Also, do you code colleges, universities, public schools, nursery schools, etc. all the same?

 Thanks for your thoughts!

 Just create a new one called School.

Christine Cooke 2

Tiffany Thomas:

Hello - We are in the process of doing some database cleanup and I'm wondering what everyone uses for a constituent code on school records? Ours are not very consistent. Our current constituent code hierarchy is like this:

1. 
   
   Individual Donor/Prospect
   
   
2. 
   
   Business
   
   
3. 
   
   Estate
   
   
4. 
   
   Trust
   
   
5. 
   
   Foundation
   
   
6. 
   
   Donor Advised Fund
   
   
7. 
   
   Matching Gift Company
   
   
8. 
   
   Non-Profit (Club/Association/Service Org)
   
   
9. 
   
   Third Party Event
   
   
10. 
    
    Town/County/State Government
    
    

Does anyone use anything similar to one of our current codes? Or do you use something else entirely? Also, do you code colleges, universities, public schools, nursery schools, etc. all the same?

 Thanks for your thoughts!

 We are a school and so we need to dial down more specific than just "school" as a constituent code. 

We break them into:

School-College/University

School-Private

School-Public