Previous Next JavaScript must be enabled to correctly display this content

## 4.2.3 Deleting or Purging PII data

In scenarios where OBAPI does not have user interface to remove customer data and scheduled purge option is not useful, then data needs to be purged using SQL scripts.

Below section provides some queries that can be used for such a purging. This option must be used with utmost care and proper impact analysis must be done before using these scripts.

PII Data | Table | Script
--- | --- | ---
For modules other than Origination: Personal information of user including Country, state, or city of residence, Date of birth, Email address, Employee ID, Full name, Gender, Personal/office telephone numbers, Login name, Work telephone, First Name, Surname | `USERS` `GROUPMEMBERS` `DIGX_UM_USERPROFILE` `DIGX_UM_USERAPPDATA` `DIGX_UM_USERPARTY_RELATION` `DIGX_UM_REGISTRATION` | delete from `digx_um_userparty_relation where user_id = ‘<USER IDENTIFIER>’;` delete from `digx_um_userappdata where id = ‘<USER IDENTIFIER>’;` delete from `DIGX_UM_USERPROFILE where U_NAME = ‘<USER IDENTIFIER>’;` delete from `GROUPMEMBERS where G_MEMBER = ‘<USER IDENTIFIER>’;` delete from `USERS where U_NAME = ‘<USER IDENTIFIER>’;`
Bank Account Information | `DIGX_AC_ACCOUNT_NICKNAME` `DIGX_AM_ACCOUNT_ACCESS` `DIGX_AM_ACCOUNT_EXCEPTION` | delete from `DIGX_AC_ACCOUNT_NICKNAME where USER_ID = <USER IDENTIFIER>;` delete from `DIGX_AM_ACCOUNT_EXCEPTION where ACCOUNT_ACCESS_ID in (select ACCOUNT_ACCESS_ID from DIGX_AM_ACCOUNT_ACCESS where ACCESS_LEVEL = ‘USER’ and USERID = <USER IDENTIFIER>);` delete from`DIGX_AM_ACCOUNT_ACCESS where ACCESS_LEVEL = ‘USER’ and USERID = <USER IDENTIFIER>;`
Beneficiaries | `DIGX_PY_PAYEEGROUP` `DIGX_PY_PAYEE` `DIGX_PY_DOMESTIC_UK_PAYEE` `DIGX_PY_INTERNAL_PAYEE` `DIGX_PY_DEMANDDRAFT_PAYEE` `DIGX_PY_INTNATNL_PAYEE_BNKDTLS` `DIGX_PY_DOMESTIC_INDIA_PAYEE` `DIGX_PY_PEERTOPEER_PAYEE` `DIGX_PY_INTERNATIONAL_PAYEE` `DIGX_PY_DOMESTIC_SEPA_PAYEE` | delete from `DIGX_PY_INTNATNL_PAYEE_BNKDTLS_V3 where PAYEE_ID in (select PAYEE_ID from DIGX_PY_PAYEE_V3 where CREATED_BY = <USER IDENTIFIER>);` delete from `DIGX_PY_INTERNATIONAL_PAYEE_V3 where PAYEE_ID in (select PAYEE_ID from DIGX_PY_PAYEE_V3 where CREATED_BY = <USER IDENTIFIER>);` delete from `DIGX_PY_DEMANDDRAFT_PAYEE_V3 where PAYEE_ID in (select PAYEE_ID from DIGX_PY_PAYEE_V3 where CREATED_BY = <USER IDENTIFIER>);` delete from `DIGX_PY_DOMESTIC_PAYEE_V3 where PAYEE_ID in (select PAYEE_ID from DIGX_PY_PAYEE_V3 where CREATED_BY = <USER IDENTIFIER>);` delete from `DIGX_PY_INTERNAL_PAYEE_V3 where PAYEE_ID in (select PAYEE_ID from DIGX_PY_PAYEE_V3 where CREATED_BY = <USER IDENTIFIER>);` delete from`DIGX_PY_PEERTOPEER_PAYEE_V3 where PAYEE_ID in (select PAYEE_ID from DIGX_PY_PAYEE_V3 where CREATED_BY = <USER IDENTIFIER>);` delete from `DIGX_PY_PAYEE_PARTY_MAP_V3 where PAYEE_ID in (select PAYEE_ID from DIGX_PY_PAYEE_V3 where CREATED_BY = <USER IDENTIFIER>);` delete from `DIGX_PY_PAYEE_V3 where CREATED_BY = <USER IDENTIFIER>;`
Party/User Information in Originations | `DIGX_OR_APPLICANT` `DIGX_OR_APPLICANT_ADDRESS` delete from `DIGX_OR_APLT_FIN_EXP where APPLICANT_ID = '<APPLICANT IDENTIFIER>';` `DIGX_OR_APLT_IDNT` `DIGX_OR_APPLICANT_CONTACT` `DIGX_OR_EMAIL_VERIFICATION` `DIGX_OR_APLT_EMPT` `DIGX_OR_APLT_FIN_INCM` `DIGX_OR_APLT_FIN_AST` `DIGX_OR_APLT_FIN_EXP` `DIGX_OR_APLT_FIN_LIB` | delete from`DIGX_OR_APLT_FIN_INCM where APPLICANT_ID = '<APPLICANT IDENTIFIER>';` delete from `DIGX_OR_APLT_FIN_AST where APPLICANT_ID = '<APPLICANT IDENTIFIER>';` delete from `DIGX_OR_APLT_FIN_LIB where APPLICANT_ID = '<APPLICANT IDENTIFIER>';` delete from `DIGX_OR_APLT_EMPT where APPLICANT_ID = '<APPLICANT IDENTIFIER>';` delete from `DIGX_OR_APLT_IDNT where APPLICANT_ID = '<APPLICANT IDENTIFIER>';` delete from`DIGX_OR_APPLICANT_CONTACT where APPLICANT_ID = '<APPLICANT IDENTIFIER>';` delete from`DIGX_OR_EMAIL_VERIFICATION where SUBMISSION_ID = '<SUBMISSION IDENTIFIER>';` delete from`DIGX_OR_APPLICANT_ADDRESS where APPLICANT_ID = '<APPLICANT IDENTIFIER>';` delete from `DIGX_OR_APPLICANT where PARTY_ID = '<PARTY IDENTIFIER>';`

Parent topic: Deleting or Purging PII data