Genpact Cora Knowledge Center


Manage Personal Data



You can manage the Personal Identifiable Information (PII) and the Sensitive Personal Identifiable Information (SPII) in Cora SeQuence. With this functionality, you can facilitate data privacy and security to your customers. You can also allow your customers to be selective about the information they want you to collect and save in your database.

Managing personal and sensitive data

Managing personal and sensitive data in Cora SeQuence involves the following steps:

StepsPerformed by 
  1. Manage the purge key column
Cora SeQuence implementor
  1. Mark the personal data
Cora SeQuence Administrator
  1. Collect the personal data
Cora SeQuence Administrator

Manage the purge key column

The purge key column is the column according to which the personal data is replaced. To purge data based on this purge key, the Implementors first need to add and manage this column in all personal data tablesIt is recommended that each value is managed with an active date, to enable lifecycle automatic purge. 

For example, Customer Id and Customer Email can be added as the purge key columns to the personal data tables. 

Mark the personal data 

To start managing the personal and sensitive data, you need to first identify and mark which information can be considered as personal and sensitive. This is done per customer requirement.  


You can either search for a table with the table name or choose a table from the existing workflows.

Search with the table name

  1. Go to Administration > Global Settings > Personal Data Tables Definition, and click Add New Record.
  2. In the Table field, enter at least the first three letters of the table name whose data you want to mark as personal.
    For example, tbl, roles, or UACT.
    Keying in tblatt displays tblAttachments, tblAttachmentsClosed and tblAttachmentsTemp tables in the list.

    You can search for a table with the table schema. For example, dbo or rbac.
  3. Select the table to purge.
  4. In the Purge Key Column, select the table column to be considered as the primary key for fetching purged columns.
    Only integer and string datatype columns appear for selection as Purge key column. 
  5. In the Columns to be purged, select the columns which are to be considered as personal data. The system populated the default value as a replacement for these column values. If you want, then you can also enter a replacement value of your own for each column.
  6. Click Add.

Search from the existing workflows

  1. Go to Administration > Global Settings > Personal Data Tables Definition, and click Add New Record.
  2. Click Find from workflows.
  3. In the Table Wath Wizard screen, select the folder where the table is located.
  4. Select the table from the list. The Table virtual path and Table fields get auto-populated on selection.
  5. Click OK.
  6. Follow steps 3 to 6 from the above procedure.

Collect the personal data

To collect the marked personal data from the tables, you need to add the Add Personal Data Purge Request built-in command to the workflow. 

  1. In the Administration site, open your workflow.
  2. From the Toolbox, under the Server Side category, click the Built-in Command activity.
  3. Double-click the Built-in Command activity in the workflow.
  4. In the Select Built-in Command screen, select:
    1. Category as Personal Data Operations.
    2. Commands as Add Personal Data Purge Request.
  5. Click Next.
  6. In the Input Parameter Bindings screen, click the PurgeRequest request parameter and clear the IsNull check box.
  7. Expand the PurgeRequest request parameter.
  8. Click the PurgeKeyValueCollection PurgeKeyValues parameter.
  9. In the Length field, add the number of purge key values you want to add. Based on the number added in this field an equal number of Value fields appear.
  10. Add in the Value field the purge key based on which the activity will fetch the purged columns.
  11. Click Finish.