4.2.3 Manual truncation of data from backend

This topic provides information on Manual truncation of data from backend. In scenarios where OBDX 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.

Note:

The fields which are marked as Required are mandatory.

For more information on fields, refer to the field description table.

Table 4-2 PII Data

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 fromDIGX_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 fromDIGX_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 fromDIGX_OR_APPLICANT_CONTACT where APPLICANT_ID = '<APPLICANT IDENTIFIER>';

delete fromDIGX_OR_EMAIL_VERIFICATION where SUBMISSION_ID = '<SUBMISSION IDENTIFIER>';

delete fromDIGX_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