In this article we will learn about the columns in the projects section of the data garden.

Definitions are the headers of the columns that are added for every project in the data garden. They form the structure of your database. The definitions tab within the projects section of the data garden, greatly resembles that of the imports section, which we described in another article.

Once you've selected a project and navigated to the definitions tab within that project, you'll land on a screen that is similar to the one that is shown above. The left hand side, showing the column definitions is already filled with the definitions that currently match the answer options within your questionnaire. By adding extra columns to these current variables you'll create new columns, new area's for your imported data to be mapped under.

If you want to add new columns to the import then you must click on the plus icon and the information below pops up on the page.

To add a column you will need to fill out the following fields:

  • Header name       -    The title of the header by which the definition is recognised in the database.
  • Main type            -    Does this column contain general Data, Labeled Data or Questionnaire Data
  • Sub type              -    Does the data within this column concern textual data, numeric data or date formatted data

Once you've saved this information, a new definition will be added to the list on your left. Again, you can move about or rename these definitons.

Please note: the main type and sub type cannot be changed if records are already present in the system.

Next, the data that gets gathered under the project definitions can be ranked based on the risk level it contains, such as High risk/ Medium risk/ Low risk. Assigning a risk level is mandatory, which is to be selected based on the data gravity it contains. Any personal data has its own risk level. So, it can be classified accordingly.

Under the definitions tab you can also flag the data that is gathered under a certain column as a unique identifier (so you can easily search/filter your records) or as a multi project variable. Using this option, you can link projects by stating that the information in this column is also used in the same way in other projects. 

In order for the multi project variable to work, the definition headers need to be exactly the same, as that is used as the reference to connect them.