Approve Delete(4.1)

Owned by Jenni Wallin
Last updated: May 17, 2024 by Chooi San Chong
4 min read

Data Veracity - Approve Delete view allows users with write access to Data Veracity and Data Veracity Approve Delete applications to approve or reject the deletion of Data Veracity records with the PRE_DELETE state. For more information on User Privileges Management, please refer to User Privileges Management(4.1).

Viewing PRE_DELETE Data Veracity Records

To view PRE_DELETE records, follow the steps below:

  1. You must first select a Data Veracity profile. Click the Filter button to open the Filter dialog.

  2. Click Browse to select a Data Veracity profile.

  3. The UDRs will be grouped according to their UDR types and Data Veracity Profiles while the batch files will be grouped according to the Data Veracity Profiles they are assigned to.

  4. Click on Review at the Actions column for a UDR or batch group that you wish to review.

  5. At the review page, all records marked for PRE_DELETE will be listed in the table.

    data_veracity_approve_delete3.png

Review Sort Order

Sorting is done from the Data Veracity Database via SQL query statement and so the sorting behavior will depend on the behavior of the Data Veracity Database(for example, sorting of alphabetical characters in Oracle and SAP HANA is case sensitive, whereas in PostgreSQL it is case insensitive).

 

  1. You may select display fields you would like to view in the table. Meta data fields are selected by default. The table will be updated as fields are removed or added.

  2. View UDR is only applicable and visible when record type is UDR. Click on View UDR at the Actions column to inspect a UDR and view the field and values present in the UDR.

Approving PRE_DELETE Data Veracity Records

When the Data Veracity records have been viewed, inspected and the decision is made to delete the records, you can then approve the deletion of the records. 

  1. To approve the records for deletion, you can:

    • Click on Approve at the Actions column to approve a single record for deletion.

    • Select the records you will want to approve for deletion then click on Approve button in the result table menu bar.

    • Click on Approve button in the result table menu bar, when all of the records are deselected. This is to approve all records for deletion in the result table.

  2. Click OK when prompted to confirm the approval. This will change the state on the selected records to DELETE_APPROVED.

Rejecting PRE_DELETE Data Veracity Records

You can also reject the deletion of a Data Veracity record, especially if there are still any issues with the record. Rejecting the deletion of records will cause the state of the records to be changed back to NEW, ready to be reprocessed by the Data Veracity Collection Agent once more.

  1. To reject the records for deletion, you can:

    • click on Reject at the Actions column to reject a single record for deletion.

    • select the records you will want to reject for deletion then click on Reject button in the result table menu bar.

    • click on Reject button in the result table menu bar, when all of the records are deselected. This is to reject all records for deletion in the result table.

  2. Click OK when prompted to confirm the rejection. This will change the state on the selected UDRs to NEW, ready to be reprocessed by the Data Veracity Collection agent again.

Export Data Veracity Records

Data Veracity allows you to export all Data Veracity records in the table into a zipped file.

  1. Click the Export button in the result table menu bar.

  2. In the Export search result dialog, enter the following:

    • Filename - The export filename should contains alphanumeric- or dash (-) characters. Do not add a file extension or a path.

    • Delimiter - You can enter a character or string that should represent the separator token, e.g. a comma or a semi-colon. 

  3. Select the check box Include Header to add the column names to first row in the file.
     

  4. Click the OK button.  A dialog box containing a link to download the zipped file will be displayed. All the columns of the table that is specified in Display Field will be included in the file.

Â