Change Details

Currently, we are using the "status" field of the `spenden` table to coalesce payment status, moderation status and soft-deletion status into one. Our database queries in the Fundraising Operation Center should use the proper data source to determine status. **Acceptance Criteria** - No code uses the "spenden.status" field to select donations **Implementation Details** Queries/scripts to look out for in the Fundraising Operation Center: - Export query - Analysis (`DatabaseDonationReader` class) - Purging of exported data - Payment Monitor (see also {https://phabricator.wikimedia.org/T270069}) - tools `campaignExport` and `raw_data_export` -> Check with Product manager if these scripts are still in use. If not, delete them To determine the actual status, join the payment tables to see if the payment is booked, check the `donations_moderation_reasons` to see if a donation is moderated and the soft-delete column to see if a donation is soft-deleted ({T359955} is a prerequisite for this ticket)

Currently, we are using the "status" field of the `spenden` table to coalesce payment status, moderation status and soft-deletion status into one. Our database queries in the Fundraising Operation Center should use the proper data source to determine status. **Acceptance Criteria** - No code uses the "spenden.status" field to select donations **Implementation Details** Queries/scripts to look out for in the Fundraising Operation Center: - Export query (see {T401229}) - Analysis (`DatabaseDonationReader` class) - Purging of exported data - Payment Monitor (see also {https://phabricator.wikimedia.org/T270069}) - tools `campaignExport` and `raw_data_export` -> Check with Product manager if these scripts are still in use. If not, delete them To determine the actual status, join the payment tables to see if the payment is booked, check the `donations_moderation_reasons` to see if a donation is moderated and the soft-delete column to see if a donation is soft-deleted ({T359955} is a prerequisite for this ticket)

Currently, we are using the "status" field of the `spenden` table to coalesce payment status, moderation status and soft-deletion status into one. Our database queries in the Fundraising Operation Center should use the proper data source to determine status. **Acceptance Criteria** - No code uses the "spenden.status" field to select donations **Implementation Details** Queries/scripts to look out for in the Fundraising Operation Center: - Export query (see {T401229}) - Analysis (`DatabaseDonationReader` class) - Purging of exported data - Payment Monitor (see also {https://phabricator.wikimedia.org/T270069}) - tools `campaignExport` and `raw_data_export` -> Check with Product manager if these scripts are still in use. If not, delete them To determine the actual status, join the payment tables to see if the payment is booked, check the `donations_moderation_reasons` to see if a donation is moderated and the soft-delete column to see if a donation is soft-deleted ({T359955} is a prerequisite for this ticket)