When you add a new field to a table, you must set the DataClassification field property in the code. When you add a new field to a table and do not specify the property, the field is assigned an initial value of ToBeClassified.
Data Classification requires access to the database tables and access to the development environment.
There are 6 classification options:
- CustomerContent
- EndUserIdentifiableInformation
- AccountData
- EndUsePseudonymousIdentifiers
- OrganizationIdentifiableInformation
- SystemMetadata.
It is possible to view the Data Classification for all fields and apply filters to view selected records. In the Dynamics Business Central Development Environment, open the Data Classification Worksheet page.
Bulk-classifying data
Records in the Field Data Classification page can be sent to Excel by using the built-in Print & Send/Microsoft Excel. With that column format you can bulk-classify all fields and then import to the database using the PowerShell script by Microsoft.
Script Path Example: NAV.11.0.20783.W1.DVD\WindowsPowerShellScripts\DataClassification
Commands needed
Import-Module DataClassification.psm1
Set-FieldDataClassificationFromExcelFile -ExcelFilePath "C:\TEMP\Classification.xlsx" -SheetName 'Field Data Classification' -RTCFolder "C:\Program Files (x86)\Microsoft Dynamics NAV\110\RoleTailored Client" -DBName NAVDBNAME -OutputFolder C:\TEMP
Result
The script replaces the property value in the database with the value from the Excel sheet. You must re-compile modified tables.
The script creates a backup of the modified tables in the Output Folder in case you want to roll back the changes.
See also
Data Classification in LS Central