1. Go to the RE HELP subfolder after the install of RE 7.94 (ex: C:\Program Files (x86)\Blackbaud\The Raisers Edge 7\Help)
  2. Open the Windows help file RE7Schema_WhatsNew794.chm
The major change in the RE 7.94 database schema is that Phones are no longer linked to a donor record via an address. As an example, below is a SQL query which illustrates this change. The dbo.PHONES table now links directly to the dbo.RECORDS and\or the dbo.CONSTIT_RELATIONSHIPS tables.

OLD 7.93 QUERY
-- [Start Code Snippet] --
select R.CONSTITUENT_ID, isnull(R.LAST_NAME, R.ORG_NAME) as 'KEY_NAME', PH.NUM

from dbo.RECORDS R
left outer join dbo.CONSTIT_ADDRESS CA on R.ID = CA.CONSTIT_ID and CA.PREFERRED = -1
left outer join dbo.CONSTIT_ADDRESS_PHONES CAPH on CA.ID = CAPH.CONSTITADDRESSID
left outer join dbo.PHONES PH on CAPH.PHONESID = PH.PHONESID

where R.CONSTITUENT_ID = '97'
-- [End Code Snippet] --

NEW 7.94 QUERY
-- [Start Code Snippet] --
select R.CONSTITUENT_ID, isnull(R.LAST_NAME, R.ORG_NAME) as 'KEY_NAME', PH.NUM

from dbo.RECORDS R
left outer join dbo.PHONES PH on R.ID = PH.CONSTIT_ID

where R.CONSTITUENT_ID = '97'
-- [End Code Snippet] --
Disclaimer: Blackbaud provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes you are familiar with Structured Query Language and the tools used to create and modify SQL statements and Crystal Reports. Blackbaud Customer Support may help explain the functionality of a particular procedure, but we will not modify, or assist you with modifying, these examples to provide additional functionality.