I am trying to query constituent id information based on constituent first name and last name.  I am just going to pull the data into an Excel spreadsheet that I can then use as an import file.  I connected to the RE database with Excel and I found the ID and First_Name fields in the CONSTITUENT table.  Where is Last_Name?

Is there an RE data dictionary available anywhere?

David-

Use the RECORDS table. There is a schema help file which I believe is available if you pay for RODBA support.

Mitch

Mitch,

Thanks for your reply.  Is your suggestion to use the RECORDS table exclusively, or do join the RECORDS table to CONSTITUENTS?  If so, what key field relationship should I use.

Is RODBA support something above and beyond normal technical support?

Okay, I'm actually going to reverse myself. While I find the RECORDS table more useful in 99% of situations, the CONSTITUENT table would probably actually be better for your needs since, I believe, it is used only for Searches.

While a constituent would only have a single record in the RECORDS table, I think a constituent could actually have multiple entries in the CONSTITUENT table based on things like aliases, spouses, etc.

Regarding your first question regarding the missing Last Name field, it is stored in KEY_NAME which contains either the Last Name for an Individual or Organization name for organizations.

You'll probably still need to link to the RECORDS table to get at information like the Constituent ID or Import ID.

I hope that helps,

 Mitch

For a RE data dictionary I also reference the RE7Schema (on my system it is located at C:\Program Files\Blackbaud\The Raisers Edge 7\Help\RE7Schema.chm).

For the query I would suggest using the RECORDS table (I have not, that I recall, ever used the CONSTITUENT table).