Specification tables

Specification table defines scope (schema and table) and masking strategy in the masking process.

Specification tables overview list

All created Specification Tables can be viewed on this Specification Tables Overview List screen.

Only basic information is shown so you can identify Specification Tables at a glance. It contains a table detailing every created Specification Table, showing: Scope, Filtering, Masking strategy, Note, Records, Columns and Review.

Overview will be by default ordered by Scope. There is a possibility to change the order of all columns descending or ascending. When list of created Specification Tables is displayed user can select one Specification table row to do next actions:

• View specification columns
• Edit specification table
• Delete specification table

If there are no specification tables, the specification table overview list is empty.

Figure 1: List of the specification tables

Main parameters for each of the table:

• Scope - Scope is defined by: Schema_name – Table_name
• Filtering - automatically filled with part of data from the table where joined Masking strategy applies.
• Masking strategy - automatically filled with one masking strategy for the table
• Note - Note related to entered specification table
• Records - automatically filled when creating or editing specification table with number of records in the table
• Columns - automatically filled when creating or editing specification table with number of columns in the table
• Review - automatically filled 'Yes' or 'No' for marking the table for the later discussion

Create specification table

To create a specification table, click on the Create specification table button in the top right corner.

Create specification table screen will be open and the following information can be entered:

General

• Masking strategy - Drop-down list with options which define part of data from the table where joined Masking strategy applies.

  • Mask (mask data in the table),
  • Truncate (truncate data from the table),
  • Intact (leave data intact).

  It will be used when some data from the table should be masked and some should be truncated or left intact. If multiple strategies have to be applied to a single table, that table must be created here so many times.

• Records count - number of records in the table (optional)

• Columns count - number of columns in the table (optional)

• Note - Note related to entered specification table (optional)

Specification table scope

• Schema name - Schema name
• Table name - Table name
• Data filtering - define part of data from the table where joined Masking strategy applies.
• Needs review - allows marking the table for the later discussion (optional)

Figure 2: Create specification table

Edit specification table

The edit specification table page allows the user to change specification properties. All fields are amendable.

Figure 3: Edit specification table

Delete specification table

If specification table is no needed user can select on specification table overview list one or more specification table rows, by using checkboxes, to Delete specification tables.

A confirmation message appears before deleting. After confirmation, specification table folder will be deleted and it will no longer show on specification tables overview list.

Figure 4: Delete specification table

If Specification table gets deleted, it also deletes linked Specification Columns.