Trying to understand SQL Server Table Information for Ratings

Venky Immadisetty

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.

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

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

thanks!

Alex Wong

@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

@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

@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