3.3.3. Data Dictionary Editor

This is the Working Files' editor for Data Dictionaries (DDs).

Data Dictionary Editor

The DD Editor can be used for editing DDs. Different than other semantic documents that have a more rigid template to be followed, DDs can be documents in any way their authors want, we everything that is documents being contained in one sheet, or multiple sheets, and with different notes being used. From a semantic point of view, the main purpose of the DD editor is to help help the SDD editing by identifying the following:

• the sheet/column that has the list of labels of the file
• the sheet/column that has the description of the content within each label

Column Selection

On the “Data Dictionary” sheet, right click and select appropriately “Header” or “Description” based on the proper column. See the sheet name and the column name appear in the proper text boxes located at the top of the page.

SDD Populations

When the selection of header and description columns is completed, click the “Add to SDD” to arrive at the “Add File Headers into SDD” page.

Here, select the SDD file to receiving the DD information (be sure to select an empty SDD file)

After completion, click the “Back to SDD” button and arrive at the appropriate SDD editor page. Here, navigate to the “Dictionary Mapping sheet

To fill in the empty sheet, click the “Populate’ button for the column headers from the DD to automatically populate the SDD.

Finally, continue to edit the SDD by editing values and shopping for terms. More info about this can be found in Section 3.3.2.