Data Structure

Data Origin

• The data originates from the Xlsx file.
• The build pipeline runs the converter.js script to convert the Xlsx to a json file that is optimized for the app to consume.
• The data is static in the app. There are no external APIs or data sources connected to this app.

Data Structure

This section describes the schema of the Xlsx file.

Sheets

The sheets are in a specific order in the Xlsx.

• ChangeLog, must come first.
• ISO, must come second.
• Individual Regulations, can be in any order

Individual regulation sheet names control the name displayed in the app.

The ISO standard and individual regulation sheets have 2 tables in them.

1. The first table is the ISO regulation mapping. It has a row for every individual regulation, its text, links, and mappings to the ISO standard. Fields:

   • id - Encodes the section id of the regulation section, ex: 6.5.4.3.a. This field will be normalized, ex: (6)5-4.3(a) will produce the same result.
   • section - Short title of the regulation section.
   • body - Main body of the regulation. This field supports HTML so it can have hyperlinks and markup.
   • hyperlink - Converts the section title into a clickable link to the specified hyperlink.
   • isolinks - Mappings to the ISO standard, ex: 7.3.1;7.4.6;7.4.7;7.4.8. Semicolon delimited ISO standard ids.
   • [lang-local_section] - Optional, additional pair of columns to specify the section in alternate languages. The syntax for the column name is [lang-local]_section. Ex: "en-us_section"
   • [lang-local_body] - Optional, additional pair of columns to specify the body in alternate languages. The syntax for the column name is [lang-local]_body. Ex: "en-us_body"

2. The second table is for notes. It is preceded by a line that says "Notes". It has a row for each note at the level of a link between the individual regulation and ISO standard. Fields:

   • id - Section id in for the individual regulation section, ex: 6.5.4.3.a.
   • isoid - With regard to this list of ISO standard, ex: 7.3.1;7.4.6;7.4.7;7.4.8. Semicolon delimited ISO standard ids.
   • comment - Display this comment.

Copyright (c) Data Protection Mapping Project. All rights reserved. Licensed under the MIT License.