Finding proposal (opportunities) data in RE SQL server database

Xin Li
Xin Li
Facilitator 1 First Anniversary
in Raiser's Edge NXT Discussions

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.

Best Answer

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Facilitator 5 Kudos 5 bbcon 2025 Attendee Badge
    Answer ✓

    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

Answers

Categories