Finding proposal (opportunities) data in RE SQL server database

Xin Li

Hello, can you help me find out which table/tables, in SQL server database tables from the backup file, had the data entered in a constituent's opportunities section? For example:
Proposal Contact
Proposal name
Proposal purpose
Porposal Status
Proposal amount asked
Proposal date asked
Proposal amount funded
Proposal date funded
Thank you.

Alex Wong

If you don't have the RE Database Schema help file, you should get your hand on one. KB in Blackbaud has it I think.

• PROPOSAL table has many of the field you looking for, however, any field that is a "drop down menu", the actual values is in the TABLEENTRIES table join by using the field on the table (i.e. PROPOSAL.PURPOSE) with TABLEENTRIES.TABLEENTRIESID
• PROPOSAL_SOLICITOR table has who is the assigned fundraiser(s) (there can be more than one for a proposal) for this proposal, join PROPOSAL_SOLICITOR.PARENTID to PROPOSAL.ID

Xin Li

Thank you, Alex. This is very helpful.