Trying to understand SQL Server Table Information for Ratings

Venky Immadisetty
Venky Immadisetty
Second Anniversary Kudos 1 Name Dropper Facilitator 1
in Blackbaud Raiser's Edge NXT®: General Discussions

Hi All,
Good Morning ?
I am working on the nightly backup in SQL SERVER for collecting ratings of all the constituents. Here is example of one record in the RE NXT database view.

559ca147cedb3cbb304f84819d5e53d3-huge-im

These are the different categories that we use in our system. I am trying to gather this ratings information from the back up file that we restored in SQL SERVER. After doing some searching I was able to find the category information in the TABLEENTRIES and here is how it looks like

f2fae8136e03b45b31311e24800047f3-huge-im

Unfortunately I was not able to locate the table that contains the values for these categories. Does anyone have any suggestions?

thanks!


Comments

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Venky Immadisetty
    the database tables you want to look into are:

    • PROSPECT
      • id links to RATINGS.prospect_id - this is a ONE-to-MANY relationship
      • constit_id links to RECORDS.id - this is a ONE-to-ONE relationship
    • RATINGS
      • category_code (integer, links to TABLEENTRIES.tableentriesid to see the longdeescription of what the rating category is)
      • category_id (integer, links to PR_CATEGORIES.id for Blackbaud pre-defined category)
      • check the text, source, or tableentry for values that is the value (if checking source or tableentry, you need to link to TABLEENTRIES.tableentriesid to see the longdescription
  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Venky Immadisetty

    As a suggestion, if you are going to do work with the backup using direct SQL, you will benefits from reading the RE Database Schema help file.

  • Venky Immadisetty
    Venky Immadisetty
    Second Anniversary Kudos 1 Name Dropper Facilitator 1

    @Alex Wong
    Thanks Alex. This is helpful. I was looking at the RE Database Schema after you mentioned in the below post.

    For some reason, while I was working on these ratings, I was confused.
    thanks again for your help

Categories