Monetary transactions for a given system can be found in a table named <platform>_<bot_id>_transaction.

The transaction table holds one record per transaction in the source system. Data is mapped into a common schema, with the remote_transaction_id as the primary key. Typically we'll also index the remote_person_id (the ID of the matching donor record in the same source system), and ts (timestamp, the gift date).

The standard fields collected for monetary transactions are:

Transactions Sample

• Systems have different ways of representing source code information, and occasionally this is spread across multiple fields.