Where is NetCommunity Info Stored in RE?

Options
Douglas Pruiett 2
Douglas Pruiett 2 ✭
Ninth Anniversary First Reply
in Blackbaud Raiser's Edge NXT®: General Discussion
When someone makes a donation via the portal in Netcommunity/Spark, where does the information end up in the donors RE record?  In particular, if they add a comment or make a donation in memory of or in honor of, in what fields do these pieces of information end up?  What tables and fields?
Tagged:

Comments

  • Jennifer Ring
    Jennifer Ring ✭
    Tenth Anniversary Facilitator 1 Name Dropper Photogenic
    Most of the donation information will be stored on the Raiser's Edge Gift Record.  Comments from a NetCommunity Donation Form will appear as a Gift Attribute, and can be found on the Attributes tab of the Gift Record.  All Tribute information will appear on the Gift Record as well under the Tribute tab.



    I am including a link to our Integration Guide, which I think may be helpful in determining where certain pieces of NetCommunity information end up in the Raiser's Edge.  You can skip to page 107, and the guide will list each NetCommunity field and the corresponding Raiser's Edge field.
  • Douglas Pruiett 2
    Douglas Pruiett 2 ✭
    Ninth Anniversary First Reply
    Thanks Jennifer.  That is what I was after.  God bless.
  • Douglas Pruiett 2
    Douglas Pruiett 2 ✭
    Ninth Anniversary First Reply
    Jennifer.  Can you point me to a document that shows the relationships between tables in RE?  In particular, I have a PHONETYPEID=17859 and want to know where (in what table) the phone type is described.  But a nice document showing relationships would help, as we are building queries outside RE.
  • Joshua Bekerman bCLO bCRE
    Joshua Bekerman bCLO bCRE ✭
    Tenth Anniversary Facilitator 3 Name Dropper Photogenic
    It's not a "nice" document but you can find the schema infomation in knowledgebase article # 45876.



    You can go through the Help menu in RE or "    You may also access the database schema outside of Blackbaud application by going to C:\\Program Files\\Blackbaud\\[product name]\\Help and opening the file [product name]Schema.chm."







     
  • Alan French
    Alan French ✭
    Tenth Anniversary Facilitator 3 Name Dropper Photogenic

    Douglas Pruiett:

    Jennifer.  Can you point me to a document that shows the relationships between tables in RE?  In particular, I have a PHONETYPEID=17859 and want to know where (in what table) the phone type is described.  But a nice document showing relationships would help, as we are building queries outside RE.

    Can't help with the document in general, but PHONES.PHONETYPEID needs to be joined to TABLEENTRIES.TABLEENTRIESID and then you want the field LONGDESCRIPTION. If you need the name of the code table itself (i.e. Phone Types) this is in the NAME field in the CODETABLES table, which joins to TABLEENTRIES using the CODETABLESID field in each table.

Categories