4.4 Converting a Table to a Form

Elements that can have more than one value are displayed by XML Authority as a table:

In the Country-by-Country schema, the Receiving Country element is unbounded which means that the XML instance can have more than 1 value for this element.  For this reason, it is displayed as a table that can have any number of rows.

In the source data, there will be a separate Receiving Country table and its primary key will be inserted into the CBC OECD table as a foreign key to maintain the relationship.

If only one receiving country is required by the reporting entity, the schema presentation and source data requirements can be simplified using the masking functionality - the table can be converted into a form, and the Receiving Country value can be provided on the CBC OECD form directly. This will also eliminate the need for a separate table in the source data and the primary, foreign key relationship.

NB! Because this will have an impact on the fields and tables of your data sources, it is recommended that you complete your schema masking before you begin integrating it with your data sources.

Converting a Table to a Form

To convert a table to a form, enter Schema Masking mode by clicking the Mask Schema Elements button on the Home ribbon:

The individual element masking toggle button will appear in the same row (or column) as the "Go to the table" button:

The table will remain until the Mask Schema Elements toggle button on the Home ribbon is deactivated.  Once deactivated, the table will be converted to a form and integrated into the CBC OECD form:

CRS Example

In the CRS Schema, the Crs Body element is unbounded as the CRS schema is designed to collate the submissions of many reporting entities into the same XML instance.  For this reason, the Crs Body element is has a "Go to the table" button on the CRS OECD form:

The Crs Body table has the following elements as table columns:

Since a single reporting entity will only ever have a single Crs Body element, this table can be converted to a form as described above.  The presentation of the schema will be simplified as the columns on the Crs Body table will now appear as rows in the CRS OECD form:

In the source data, the columns in the Crs Body table will now be in the CRS OECD table eliminating the need for a separate table with primary and foreign keys to maintain the relationships.