Column 7: XML schema

 

The XML schemas for all fields of the OECD Harmonised Templates have already been published on the OECD website. In the updated OECD templates, the XML schema is included in the data element description replacing the previous parameter "Field name (for IT use)", which specified only part of the XML schema. For example, the field "Reference type" was identified by the field name "REFERENCE_TYPE", but is now identified by the following XML schema:

<i5:EndpointStudyRecord><i5:OECDTemplate><i5:EC_FISHTOX><i5:REFERENCE><i5:set>

<i5:PHRASEOTHER_REFERENCE_TYPE><i5:REFERENCE_TYPE>

Each XML schema consists of the following seven identifiers, or tags, which normally appear in one row without line breaks:

  • <Record type>: For all OECD templates, this tag is always denoted as <i5:EndpointStudyRecord>.
  • <Template type>: For all OECD templates, this is tag always specified as <i5:OECDTemplate>.
  • <Section>: This tag denotes the name of the endpoint template in terms of the internal section name used in IUCLID 5, e.g. <i5:EC_FISHTOX>
  • <Block name>: This tag specifies the block name. This identifier corresponds to the field name used in the first version of OECD Harmonised Templates as follows:

- For single fields (i.e. not grouped to blocks of fields), the <Block name> is identical with the field name used in the first version of the OECD templates. For example, the field name for field "Cross-reference to same study" was indicated as "CROSSREF_SAMESTUDY". The XML schema for this field is:

 

<i5:EndpointStudyRecord><i5:OECDTemplate><i5:EC_FISHTOX><i5:CROSSREF_SAMESTUDY><i5:set>

<i5:TEXT_BELOW><i5:TEXT_BELOW>.

- For subfields grouped to blocks of fields, the <Block name> is identical with the first part of the name given to subfields in the first version of the OECD templates. For example, the field "Reference type" was identified by the field name "REFERENCE_TYPE". This name is now identical with the <Field name>, i.e. the very last identifier of the XML schema, whereas "REFERENCE" is the <Block name>, as shown in the following XML schema:

 

<i5:EndpointStudyRecord><i5:OECDTemplate><i5:EC_FISHTOX><i5:REFERENCE><i5:set>

<i5:PHRASEOTHER_REFERENCE_TYPE><i5:REFERENCE_TYPE>.

  • <set>: This tag has been used to group (repeatable) blocks.
  • <Property>: This tag specifies the field type. For example, <i5:PHRASEOTHER_REFERENCE_TYPE> means that the field is a field of type LIST-OPEN, whereas <i5:TEXT_BELOW> denotes a text field that is located below the preceding field.
  • <Field name>: This tag specifies the name of any subfields of blocks of fields (see tag <Block name>). In the case of single (ungrouped) fields, this tag is redundant with the Property tag.