Reporting

Phil Bell
Phil Bell
Sixth Anniversary Name Dropper Participant Facilitator 1
in Blackbaud Raiser's Edge NXT®: General Discussions
Hi I am trying to run a query in SQL to export data and want to interpret the Payment Type/Method how do you link the value in the the gift table to a code table?
Tagged:

Comments

  • Joshua Bekerman bCLO, bCRE
    Joshua Bekerman bCLO, bCRE
    Tenth Anniversary Kudos 5 Name Dropper Participant
    Pay Method is listed in the RE7Schema (as GIFT.PAYMENT_TYPE):


    1 - Cash, 2 - Personal Check, 3 - Business Check, 4 - Credit Card, 5 - Standing Orders, 6 - Direct Debit, 7 - Voucher, 8 - Other


     
  • Joshua Bekerman bCLO, bCRE
    Joshua Bekerman bCLO, bCRE
    Tenth Anniversary Kudos 5 Name Dropper Participant
    Gift Type is also listed in the schema (as GIFT.TYPE):

    Cash = 1, Pledge Pay Cash = 2, MG Pledge Pay Cash = 3, Covenant Payment = 4, Pledge = 8, Stock = 9, Sold Stock = 10, Pledge Pay Stock = 11, Pay Stock = 12, Pledge Pay Sold Stock = 13, MG Pledge Pay Sold Stock = 14, Gift In Kind = 15, Pledge Pay Gift In Kind = 16, MG PledgePay Gift In Kind = 17, Other = 18, Pledge Pay Other = 19, MG Pledge Pay Other = 20, WriteOff = 21, MG WriteOff = 22, Net Covenant = 24, Gross Covenant = 25, Deposited Covenant = 26, MG Pledge = 27, Adjustment = 28, Covenant WriteOff = 29, Recurring Gift = 30, Recurring Gift Pay Cash = 31, GLReversal = 32, Amendment = 33, Planned Gift = 34 
  • Phil Bell
    Phil Bell
    Sixth Anniversary Name Dropper Participant Facilitator 1
    Hi Joshua,

    Is there any link from the Gift table to retrieve these descriptions or do I simply assum these are fixed and wont change.

    Regards

    Phil
  • James Andrews
    James Andrews
    Tenth Anniversary Kudos 2 Participant Facilitator 1
    They won't change. The gift type and payment type names aren't referenced anywhere in RE, it's all done totally by the numbers. So they basically can't change them at this point without wrecking everyone's dbs.

Categories