Problem

The Total Funding Field on the candidate page is calculated without accounting for transaction types. For example, it counts refunds and individual contributions. From what I can tell, this is not the behavior we want.

Solution

Identify which transaction types need to be included in the sum calculation.

From the DB I see there are 12 transaction types:

+--------------------+
|transaction_type    |
+--------------------+
|Interest            |
|Contrib to Reimburse|
|Nonprofit           |
|Non-Party Comm      |
|Refund              |
|Outside Source      |
|Loan                |
|Individual          |
|General             |
|Party Comm          |
|Forgiven Loan       |
|Outstanding Loan    |
+--------------------+

Do all of these need to be included?

Todo:

• Change refund values to negative in ETL script OR subtract refund values from total
• Exclude Interest transaction type