Code table to Constituent Mapping in Database

Bharat Bhushan
Bharat Bhushan
First Anniversary
in Blackbaud CRM™ General Discussions

Hello, We are trying to do some analysis on code table data. So for this I need Code table → Code table Entries → Constituent Associated with it.

I think every Code table will be listed in "CODETABLECATALOG" and category information can be found in the “CODETABLECATEGORY”. Every Code table Name has different table where Code table entries are stored in Database. Till this level i am able to find the logic.

But I am not sure about the next logic to find the Constituents associated with these Code tables.

I need to pull data using SSIS package from BBCRM DB to our Organization Database. Hence I need to find out the mapping from Code tables to Constituents.

Has anyone worked on this?

Categories