Table of Contents

SMART Data Protection

Path: Data Protection List

The system allows you to delete and anonymize personal data if necessary, for example, to ensure compliance with the GDPR principles. Upon expiration of the data retention period, such data may be deleted if it is necessary to store other data that is not personal data for a certain period of time, which can be configured. For statistical purposes, for example, anonymization of personal data can be applied.

  1. On the Data Protection page, you need to create settings in accordance with which information will be administered. You must fill in the appropriate fields on the General and Tables tabs.

On the General tab, the following fields can be filled in:

Field Description
Code Setting code
Description Setting description
Active Setting activity. If Active = TRUE, the selected setting will be performed by running the job queue operation automatically, if such running is additionally configured.
Main Table ID The main table ID for selecting the date field ID. Tables can be selected from the list of tables selected in the Tables tab in rows.
Main Table Name The name of the main table. It is filled in automatically depending on the selected Main Table ID.
Date field ID ID of the date field in the Date or DateTime format from the main table, by the value of which the data will be selected. Records where this field is blank are never processed.
Date Field Name The name of the date field is filled in automatically depending on the selected date field code.
Processing Date Formula Data processing formula. You must specify the period after which the data will be processed in accordance with the settings. Valid formula format is, for example, 1M (1 month), 1Y (1 year). Periods can be combined, for example 1Y+6M. A record is processed when the date in the date field plus this period is on or before the processing date.
No. of Tables Number of tables. The field is filled in automatically depending on the number of tables created in the lines of the Tables tab.

In the lines of the Tables tab, the system allows you to:

• create lines,

• delete lines,

• administer information by making changes to fields – the Data Protection Fields page,

• filter information available for administration – Data Protection Table Filters page.

To create a line for a table, in the lines of the Tables tab, fill in the following fields:

Field Description
Table ID Table ID.
Table Name The table name is filled in automatically depending on the specific code.
Delete Records Setting the value determines whether all records of the selected table will be deleted after the selected time period. Please note that after deletion, data recovery is not possible. If field settings already exist for the table, you are asked to confirm that they are removed.
Page ID Page ID. Is filled in automatically with the ID of the page displaying the selected table.
Parent Table ID Parent table ID. If a parent table ID is set, the system will first select the data according to the configured parameters of the parent table and administer in the same way as it is configured in the dependent table.
Processing Order Number in the processing order.
No. of Fields Number of fields. The field is filled in automatically with the number of fields that are set up on the Data Protection Fields page. Choose the value to open the Data Protection Fields page.
Comments Comments.

Having chosen the tables in which information will be administered, you can select specific fields in which such administration will take place. To do this, in the line of the corresponding table, go to the Data Protection Fields page through the Fields action.

On the Data Protection Fields page, you need to fill in the following fields:

Field Description
Field ID ID of the field to be administered. Primary key fields and fields of unsupported types (for example, Duration or DateFormula) cannot be selected.
Field Caption Field name, is filled in automatically depending on the selected field ID.
Field Type Field type. Is filled in automatically.
Anonymize Check the box if the value = TRUE and the field value needs to be anonymized. If the checkbox is checked, the value of the Anonymize Value field will automatically be filled with “anonymized”, which can be edited to another value.
Anonymize Value The value that will be set in the selected field instead of the initial one after starting administration of information by selected settings. Enter dates as 1800-01-01, numbers as 0 or 0.5, Boolean values as false, and option fields as the option name. BLOB and Media fields cannot be anonymized, only cleared.
Clear Check the checkbox if the value = TRUE and the field value must be cleared.

It is possible to select (create) several fields in the table that need to be administered, edit and delete them.

On the Data Protection Table Filters page, you need to fill in the following fields:

Field Description
Field ID Field ID. The Field ID and the Linked Field ID must have the same value for each of the tables.
Field Caption Name of the field.
Type Type.
Filter Value Value of the filter.
Linked Field ID ID of the linked field.
Linked Field Name Name of the linked field.
  1. Once you have done the necessary settings for data administration, you can preview the result using Actions – Overview. In the Options group, select the date in the View on date field. The result is displayed by the system in lines with the following fields:
Field Description
Record Caption Name of the record to be processed.
Processing Date The date in the date field of the main record + the period from the Processing Date Formula. The preview shows the records whose processing date is on or before the selected date; related records are shown under their main record.
Anonymized Fields Number of records for which fields are anonymized.
Cleared Fields Number of records for which fields are cleared.
Deleted Records Number of deleted records.

Before you activate or start a setting, you can check it through Actions – Check Rule. The system lists errors and warnings, for example a dependent table that is not linked to its parent table by a filter line of type Field (without such a link, all records of the dependent table would be processed for every parent record), a table that is not linked to the main table, an anonymize value that does not match the field type, or a table that seems to contain posted documents or ledger entries. A setting with errors cannot be activated or started. While a setting is active, its tables, fields, filters, main table, date field and processing formula cannot be changed, and the setting cannot be deleted; clear Active first, make the changes, and then activate the setting again. When the job queue runs, settings with errors are skipped and all other active settings are processed; the job queue entry then stops with an error that lists the skipped settings, so fix them and restart the job queue entry. The warning about posted documents and ledger entries is based on the table name and can be shown for other tables as well.

  1. To administer information, this process must be started through Actions – Run.
  • The information administration process can be started manually through Actions – Run on the Data Protection page of each setting.
  • The information administration process can be started automatically by creating Codeunit 70860390 SMA Data Protection Management Job Queue Activity. On the Data Protection List page, choose Set Up Job Queue Entry: if the entry does not exist yet, it is created to run every day at 02:00 with the status On Hold. Review it, and then set its status to Ready. All active settings are processed in each run; each setting is processed as a whole, so if an error occurs, no changes of that setting are saved.

To process the personal data of a specific person right away, regardless of the retention period (for example, when the person asks for their data to be erased), use Actions – Process on Request on the Data Protection page. Set a filter that selects the person in the main table, for example the employee number. The Process on Request page shows how many records match the filter, how many of them are excluded by the filters of the setting, how many have already been processed, and a preview of the changes. Choose Process Records to process them. A filter is required and must not select all records of the table. The retention period and the date field are ignored, so records with a blank date can be processed too. Records that are already in the log are not processed again.

  1. The results of the information administration carried out are logged on the Data Protection Log page (path: Related – Log) in the following form:
Field Description
Entry No. Is filled in automatically by the system.
Data Protection Code The setting code under which the information was administered.
Anonymized Fields Number of records for which fields are anonymized.
Clear Fields Number of records for which fields are cleared.
Deleted Records Number of deleted records.
Record Caption The processed record of the main table. Choose the value to open the record, if it still exists.
Process Trigger Why the record was processed: Retention Period or Request.
Processed At When the record was processed.
Processed By The user who processed the record or who created the job queue entry.

Deleting log records does not cancel anonymization or information deletion.