User Deletion Report
The User Deletion Report provides a list of all the user IDs that have been hard deleted from the GCP system between a specified date range that the Admin user selects. The User IDs mentioned in this report will have no related transaction records in the GCP system.
Definition
Soft Deleted accounts: are those that are deleted by either the Wallet user or the Back Office user (GCP or LS). When an account is soft deleted, a timestamp is recorded in the "deleted_at" column of the users table, indicating when the deletion occurred. Soft-deleted users cannot access the wallet application. The user's email address and mobile number can be re-used.
Hard Deleted Accounts: refers to accounts that have been completely removed from the database, leaving no trace of the wallet user. The deletion of user records occurs after 5 years (for PH users) or 10 years (for TH users) after the user was soft deleted.
For further reference on this topic, check the below document about the User Deletion Report Implementation:
The User deletion report lists all deleted users from the system. This menu will enable the admin to view and download the report. This page further describes the various information contained in the report and the process of downloading the report.
The report can be drawn for a specified period. This option can be accessed from the GCP Settings on the Toyota Wallet back office page.
The list of reports displayed on the page has been generated in the period specified in the date filter found on the top right side of the page.
On clicking the "From date" box, a calendar is displayed where the report month can be selected:
Similarly, the "To date" can be specified by selecting a month displayed on the calendar:
The list displayed will contain all the reports generated from May 2024 until July 2024.
Select one of the reports to download and click on the "Download" link provided under the "Action" field.
The report file will be downloaded to your system in the CSV(Comma Separated Values) format and can be opened using any application that supports .csv files. Some of the applications are Microsoft Excel, Google Sheets, etc.
Contents of the CSV file
The downloaded CSV files will have information such as:
SEQ - Sequence Number of the record.
DELETION UID - The unique ID generated for the report.
USER UID - The ID of the user being deleted.
COUNTRY CODE - The country code.
REQUEST DELETED AT - The timestamp of the soft-deleted time (the same as
deleted_atin theuserstable)GCP DELETED AT - The timestamp of the current date and time of hard deleting the user.
Last updated