XML File Structure

The XML file has two sections: the metadata definition, which is used to map the metadata of two disconnected systems (see Defining XML Tag Mappings), and the actual source data. For information about the tags, see Table B-1 and Table B-2.

The required XML file structure depends on whether the file is generated at the sponsor or the source data site. See Example B-1 and Example B-2.

Example B-1 Source Site XML Sample Structure

<?xml version="1.0" encoding="UTF-8" ?> 
<TMSDSI>
  <META_DATA>
    <INTEGRATION_KEY>OCL</INTEGRATION_KEY> 
    <INSTANCE_NAME>SUN5X13.ORACLE.COM</INSTANCE_NAME> 
    <X_AREA>1</X_AREA> 
    <X_AREA_NAME>TMSLEARN</X_AREA_NAME> 
    <GMT_DIFF>-10:00</GMT_DIFF> 
  </META_DATA>
  <VT>
   <VT_ROW>
     <DICTIONARY_SHORT_NAME>MEDDRAPP</DICTIONARY_SHORT_NAME> 
     <DOMAIN_NAME>ALLDICTIONARIES</DOMAIN_NAME> 
     <VERBATIM_TERM>SORE SORE MUSCLE PAIN</VERBATIM_TERM> 
     <VT_NOTE>
      <VT_NOTE_ROW>
        <LABEL_TEXT_UPPER>CODER COMMENT</LABEL_TEXT_UPPER> 
        <OCCURRENCE_ID>1</OCCURRENCE_ID> 
        <DEF_DETAIL_VALUE>another test of special chars %^$#@!~`&*()_-=+|\}{[];:'"<>,.?/</DEF_DETAIL_VALUE> 
        <CREATED_BY LOCAL_FLAG="Y">TMS</CREATED_BY> 
      </VT_NOTE_ROW>
     </VT_NOTE>
   </VT_ROW>
  </VT>
   <SOURCE_DATA_DEL /> 
   <SOURCE_DATA>
    <SOURCE_DATA_ROW>
      <DICTIONARY_SHORT_NAME>MEDDRAPP</DICTIONARY_SHORT_NAME> 
      <DOMAIN_NAME>ALLDICTIONARIES</DOMAIN_NAME> 
      <VERBATIM_TERM>CORN BEEF 1</VERBATIM_TERM> 
      <SOURCE_TERM_ID>300000005</SOURCE_TERM_ID> 
      <OCCURRENCE_ID>0</OCCURRENCE_ID> 
      <EXT_VALUE_1>TMSPROJ</EXT_VALUE_1> 
      <EXT_VALUE_2>TMSSTUDY2</EXT_VALUE_2> 
      <EXT_VALUE_3>M_INV1</EXT_VALUE_3> 
      <EXT_VALUE_4>VISIT2</EXT_VALUE_4> 
      <EXT_VALUE_5>101</EXT_VALUE_5> 
      <EXT_VALUE_6>KEN804</EXT_VALUE_6> 
      <EXT_VALUE_7>OPA</EXT_VALUE_7> 
      <EXT_VALUE_8>66201</EXT_VALUE_8> 
      <OMISSION_STATUS>TMS IN PROGRESS</OMISSION_STATUS> 
      <ACTION_TEXT>Can you clarify please?</ACTION_TEXT> 
      <ACTION_OWNER LOCAL_FLAG="Y">OLS$JSMITH</ACTION_OWNER> 
    </SOURCE_DATA_ROW>
   </SOURCE_DATA>
</TMSDSI>

Example B-2 Sponsor Site XML Sample Structure

<?xml version="1.0" encoding="UTF-8" ?> 
<TMSDSI>
 <META_DATA>
    <INTEGRATION_KEY>OCL</INTEGRATION_KEY> 
    <INSTANCE_NAME>EXAMPLE.ORACLE.COM</INSTANCE_NAME> 
  <X_AREA>1</X_AREA> 
    <X_AREA_NAME>LEARN</X_AREA_NAME> 
  <GMT_DIFF>-04:00</GMT_DIFF> 
 </META_DATA>
 <VTA_DEL /> 
 <VTI_DEL>
 <VTI_DEL_ROW><DICTIONARY_SHORT_NAME>WHOC2</DICTIONARY_SHORT_NAME><DOMAIN_NAME>DOM1</DOMAIN_NAME><VERBATIM_TERM>BACK HEADPAIN</VERBATIM_TERM><SOURCE_TERM_ID>36838008</SOURCE_TERM_ID></VTI_DEL_ROW>
 </VTI_DEL>
 <VTA>
 <VTA_ROW><DICTIONARY_SHORT_NAME>WHOC2</DICTIONARY_SHORT_NAME><DOMAIN_NAME>DOM1</DOMAIN_NAME><VERBATIM_TERM>TERM141</VERBATIM_TERM><VT_SUBTYPE>AC</VT_SUBTYPE><DICTIONARY_TERM>PT1</DICTIONARY_TERM><APPROVED_FLAG>Y</APPROVED_FLAG><VTA_GLOBAL_FLAG>N</VTA_GLOBAL_FLAG><VTA_CREATED_BY LOCAL_FLAG="Y">USER1</VTA_CREATED_BY></VTA_ROW>
 </VTA>
 <VTI>
<VTI_ROW><DICTIONARY_SHORT_NAME>WHOC2</DICTIONARY_SHORT_NAME><DOMAIN_NAME>DOM1</DOMAIN_NAME><VERBATIM_TERM>TERM71</VERBATIM_TERM><SOURCE_TERM_ID>36838005</SOURCE_TERM_ID><OCCURRENCE_ID>2</OCCURRENCE_ID><VT_SUBTYPE>AC</VT_SUBTYPE><DICTIONARY_TERM>PTNONUQ1</DICTIONARY_TERM><DICT_CONTENT_CODE>NONUQ3</DICT_CONTENT_CODE><VTI_CREATED_BY LOCAL_FLAG="Y">USER1</VTI_CREATED_BY></VTI_ROW>
 </VTI>
 <VT>
  <VT_ROW>
    <DICTIONARY_SHORT_NAME>MEDDRAPP</DICTIONARY_SHORT_NAME> 
    <DOMAIN_NAME>ALLDICTIONARIES</DOMAIN_NAME> 
    <VERBATIM_TERM>CORN BEEF 1</VERBATIM_TERM> 
   <VT_NOTE>
    <VT_NOTE_ROW>
        <LABEL_TEXT_UPPER>CODER COMMENT</LABEL_TEXT_UPPER> 
        <OCCURRENCE_ID>1</OCCURRENCE_ID> 
        <DEF_DETAIL_VALUE>SUN5X12 What is this "thing" with corn beef?</DEF_DETAIL_VALUE> 
      <CREATED_BY LOCAL_FLAG="Y">TMS</CREATED_BY> 
    </VT_NOTE_ROW>
   </VT_NOTE>
  </VT_ROW>
 <VT_ROW>
       <DICTIONARY_SHORT_NAME>MEDDRAPP</DICTIONARY_SHORT_NAME> 
       <DOMAIN_NAME>ALLDICTIONARIES</DOMAIN_NAME> 
       <VERBATIM_TERM>SORE SORE MUSCLE PAIN</VERBATIM_TERM> 
    <VT_NOTE>
     <VT_NOTE_ROW>
        <LABEL_TEXT_UPPER>CODER COMMENT</LABEL_TEXT_UPPER> 
        <OCCURRENCE_ID>1</OCCURRENCE_ID> 
        <DEF_DETAIL_VALUE>From SUN5X12 %^$#@!~`&*()_-=+|\}{[];:'"<>,.?/</DEF_DETAIL_VALUE> 
       <CREATED_BY LOCAL_FLAG="Y">TMS</CREATED_BY> 
     </VT_NOTE_ROW>
    </VT_NOTE>
   </VT_ROW>
  </VT>
  <SOURCE_DATA /> 
</TMSDSI>