Modeling student sponsorship

Options
Benjamin Lindahl
Benjamin Lindahl ✭
Eighth Anniversary
in Blackbaud eTapestry® General Discussion
I'm trying to figure out how to model student sponsorship.  Here are our requirements:
  • Each donor can sponsor one or more student girls ($375/year), and/or more student women ($175/year).
  • We need to be able to run reports:
    • Students and their sponsors (including names of the students and the sponsors)
    • Unsponsored students (including who the sponsors were last year)
    • Under-sponsored students where the payment was for less than the annual sponsorship amount
I was thinking about modeling it with:
  • Students as Constituent objects, with an ID field
  • Adding a sponsorship ID field to the Gift objects, and using this ID to join in the name in reports.
However, I'm not sure if this model would work with reports.


Can anyone help?


Thanks,

Ben
Tagged:

Comments

  • Mary McMurray
    Mary McMurray ✭
    Tenth Anniversary Facilitator 1 Photogenic

    Could you use the Tribute role? I think you could create a Tribute role for each student that is receiving support and mark that on transaction that is supporting.


    I'm not sure if this would work but it might be an easy work around.


    Benjamin Lindahl    :

    I'm trying to figure out how to model student sponsorship.  Here are our requirements:

    • Each donor can sponsor one or more student girls ($375/year), and/or more student women ($175/year).
    • We need to be able to run reports:
      • Students and their sponsors (including names of the students and the sponsors)
      • Unsponsored students (including who the sponsors were last year)
      • Under-sponsored students where the payment was for less than the annual sponsorship amount
    I was thinking about modeling it with:
    • Students as Constituent objects, with an ID field
    • Adding a sponsorship ID field to the Gift objects, and using this ID to join in the name in reports.
    However, I'm not sure if this model would work with reports.


    Can anyone help?


    Thanks,

    Ben

     

     

Categories