Database - Deletion Audit Table (deletion_audit)

Description

For some tables, the database marks records as deleted in the 'deleted' field. For others, records are completely removed. This table keeps a record of what was completely removed from the database.

Common Uses

To audit what was deleted from the database.

Table Fields

Column

Data Type

Column Info

Value Notes

Other

table_name

varchar(50)

The name of the table the record was deleted from.

deleted_id

int(11)

The ID of the record that was deleted.

deletedAt

timestamp

The date and time when the item was deleted.

A record of deletions from the following tables is shown in the deletion_audit table:

  • Loan-Related:
    • loan_tx
    • loan__customer
    • loan__recurrent_charge
    • loan__rule_applied_settings
    • loan_active_time_tx
  • Tenant-Related:
    • custom_field__entity

Not all tables that use a hard delete are included in the deletion_audit table. This is either because the history for those tables is already tracked in the loan_status_archive table, or because the deletion of records is so inconsequential that tracking it doesn't make sense. This is the list of tables that use a hard delete:

  • Loan-Related:
    • billing_tool__loan
    • collector_queue__loan
    • custom_form_tool__loan
    • email_tool__loan
    • linked_loan__entity
    • loan__customer
    • loan__recurrent_charge
    • loan__rule_applied_apd_reset
    • loan__rule_applied_charge_off
    • loan__rule_applied_settings
    • loan__rule_applied_stop_interest
    • loan__sub_portfolio
    • loan_active_time_tx
    • loan_chargeoff__transactions
    • loan_reverse_status_archive -> when a modification is canceled
    • loan_tx
    • mail_house_loan
    • loan__rule_applied_account_tools
    • loan__rule_applied_autopay
    • loan__rule_applied_checklist
    • loan__rule_applied_customer_tools
    • loan__rule_applied_duedate
    • loan__rule_applied_loan_setup
    • loan_late_fee__buckets
  • Tenant-Related:
    • admin_tool__loan
    • advance_category_entity
    • cash_drawer__payment_method
    • checklist_item__entity
    • custom_boarding_process_step_entity
    • custom_field__entity
    • customer_social_profile_entity
    • customer_status_entity
    • defaults_late_fee__buckets
    • doc_section_entity
    • email_queue
    • escrow__transactions
    • holding_account__investor
    • investment__portfolio
    • investment__sub_portfolio
    • investor_status_entity
    • note_category_entity
    • notification_category__delivery
    • payment__portfolio
    • report_cache
    • restriction_group__user
    • restriction_group__user
    • rule__category
    • rule_applied_settings__portfolio
    • rule_applied_settings__portfolio_to_delete
    • rule_applied_settings__sub_portfolio
    • rule_applied_settings__sub_portfolio_to_delete
    • view_template__view_module
    • work_item__questions
    • actions__notes
    • action__result
    • payment__sub_portfolio
    • preconfigured_loan__portfolio
    • preconfigured_loan__sub_portfolio
    • result__notes
    • support_transaction__topic
    • wizard_group_wizard


How did we do?


Powered by HelpDocs (opens in a new tab)