Fundraising/ContributionTracking
ContributionTracking refers to donation metadata saved to a table which currently resides not in the fundraising civicrm database, but in the drupal database for the host drupal instance. The placement of this table in the drupal database is clearly very silly, and as such it needs to be moved elsewhere.
Payments-wiki formerly used a direct DB connection to the backend to insert new rows and get the autoincrement ID to use as the contribution_tracking_id. That DB connection was managed by an extension called ContributionTracking. The ContributionTracking extension no longer exists, and ID generation has been moved to a sequence generator in Redis, to fully decouple the payments-wiki front end from the back-end database.
UPDATE: The ContributionTracking table has been moved from drupal to the civicrm database. The table's name in the civicrm database is civicrm_contribution_tracking. The ContributionTracking entity controls the DB connection from CiviCRM and is being managed by the wmf-civicrm CiviCRM extension.
Table Columns
| column name | description |
|---|---|
| id | |
| contribution_id | |
| amount | |
| currency | |
| usd_amount | |
| is_recurring | |
| referrer | |
| utm_medium | |
| utm_campaign | |
| utm_key | |
| gateway | |
| appeal | |
| payments_form_variant | |
| banner | |
| landing_page | |
| payment_method_id | |
| payment_submethod_id | |
| language | |
| country | |
| tracking_date | |
| os | |
| os_version | |
| browser_version | |
| recurring_choice_id | |
| device_type_id | |
| banner_size_id | |
| is_test_variant | |
| banner_variant | |
| is_pay_fee | |
| mailing_identifier | |
| utm_source | |
| banner_history_log_id |