When a payment record isn’t paid (i.e., it doesn’t appear on an invoice) and will never be payable, for instance when it’s for a week that falls after an entered end date the system deletes it.
If a payment has been made (i.e., it appears on an invoice) and then becomes unpayable, like in the scenario above the system creates a new reversal payment in the table and populates the REVERSED_PAYMENT_ID with the reversal.
The system doesn’t log these deletions to audit tables. This is because they only occur for payment records that aren’t payable and, therefore, no longer necessary.
When a commitment is cancelled, the system deletes any associated payments that aren’t included on an invoice. However, if the payments are included on an invoice, the system reverses all of them. This is another instance where payment deletion takes place.