The source of this issue can be found in the tran_type field of the RcptCd model in the raw database. There, a "transcation type" is recorded that can be one of three values (that we know of).
They are:
T for third party (Whatever that means)
F for a forgiven loan that is being taken off the books
R for a returned contribution
While we do not typically roll up line-item contributions to calculate overall totals, there are many cases where we extract the line-item data for graphics, searches and other apps. In those cases, the forgiven and returned contributions need to be properly distinguished so that they are treated as negative values.
The first step in accomplishing that is properly coding then in our "clean" Contribution model in this application, followed by a cascading series of changes on all of our underlying views and templates where line-item contributions are display or exported.
The source of this issue can be found in the
tran_typefield of theRcptCdmodel in the raw database. There, a "transcation type" is recorded that can be one of three values (that we know of).They are:
Tfor third party (Whatever that means)Ffor a forgiven loan that is being taken off the booksRfor a returned contributionWhile we do not typically roll up line-item contributions to calculate overall totals, there are many cases where we extract the line-item data for graphics, searches and other apps. In those cases, the forgiven and returned contributions need to be properly distinguished so that they are treated as negative values.
The first step in accomplishing that is properly coding then in our "clean" Contribution model in this application, followed by a cascading series of changes on all of our underlying views and templates where line-item contributions are display or exported.