Skip to main content

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:

FieldDescription
CodeSetting code
DescriptionSetting description
ActiveSetting 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 IDThe 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 NameThe name of the main table. It is filled in automatically depending on the selected Main Table ID.
Date field IDID 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 NameThe name of the date field is filled in automatically depending on the selected date field code.
Processing Date FormulaData 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 TablesNumber 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:

FieldDescription
Table IDTable ID.
Table NameThe table name is filled in automatically depending on the specific code.
Delete RecordsSetting 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 IDPage ID. Is filled in automatically with the ID of the page displaying the selected table.
Parent Table IDParent 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 OrderNumber in the processing order.
No. of FieldsNumber 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.
CommentsComments.

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:

FieldDescription
Field IDID of the field to be administered. Primary key fields and fields of unsupported types (for example, Duration or DateFormula) cannot be selected.
Field CaptionField name, is filled in automatically depending on the selected field ID.
Field TypeField type. Is filled in automatically.
AnonymizeCheck 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 ValueThe 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.
ClearCheck 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:

FieldDescription
Field IDField ID. The Field ID and the Linked Field ID must have the same value for each of the tables.
Field CaptionName of the field.
TypeType.
Filter ValueValue of the filter.
Linked Field IDID of the linked field.
Linked Field NameName 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:
FieldDescription
Record CaptionName of the record to be processed.
Processing DateThe 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 FieldsNumber of records for which fields are anonymized.
Cleared FieldsNumber of records for which fields are cleared.
Deleted RecordsNumber 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:
FieldDescription
Entry No.Is filled in automatically by the system.
Data Protection CodeThe setting code under which the information was administered.
Anonymized FieldsNumber of records for which fields are anonymized.
Clear FieldsNumber of records for which fields are cleared.
Deleted RecordsNumber of deleted records.
Record CaptionThe processed record of the main table. Choose the value to open the record, if it still exists.
Process TriggerWhy the record was processed: Retention Period or Request.
Processed AtWhen the record was processed.
Processed ByThe user who processed the record or who created the job queue entry.

Deleting log records does not cancel anonymization or information deletion.

© 2008 - 2026 SMART business