Key to XML File Tags

The following tables provide an explanation of the tags used in the required XML file structure.

Table B-1 XML Section Tags

Tag	Description
<TMSDSI>	File data to be processed by DSI.
<META_DATA>	Metadata information that applies to all data in the XML file.
<SOURCE_DATA>	Source data to be processed.
<SOURCE_DATA_ROW>	Individual source data rows.
<SOURCE_DATA_DEL>	Source data deletes to be processed.
<SOURCE_DATA_DEL_ROW>	Individual source data rows to be deleted.
<VTA>	Verbatim Term Assignments.
<VTA_ROW>	Verbatim Term Assignments Rows.
<VTA_NOTE>	Workflow Informative Notes for VTA.
<VTA_NOTE_ROW>	Workflow Informative Note row for VTA.
<VTA_DEL>	Declassified Verbatim Term Assignments.
<VTA_DEL_ROW>	Declassified Verbatim Term Assignments rows.
<VTI>	Verbatim Term Individuals
<VTI_ROW>	Verbatim Term Individual Rows.
<VTI_DEL>	Deleted Verbatim Term Individuals.
<VTI_DEL_ROW>	Deleted Verbatim Term Individual Rows.

Table B-2 XML Data and Metadata Tags

Tag	Description	Data Type (length)	Mand-atory?	Default Value
<INTEGRATION_KEY>	Source Data System Name	Varchar2(15)	Y	N/A
<INSTANCE_NAME>	Source Database Name	Varchar2(93)	Y	N/A
<X_AREA>	Batch Processing Unit	Number(10)	Y	0
<X_AREA_NAME>	Name; e.g. Study123	Varchar2(65)	Y	N/A
<GMT_DIFF>	DB's GMT Time Difference	Varchar2(6)	N	N/A
<DICTIONARY_SHORT_NAME>	Dictionary Short Name	Varchar2(10)	Y	N/A
<DOMAIN_NAME>	Domain Name	Varchar2(65)	Y	N/A
<VERBATIM_TERM>	Collected Verbatim Term	Varchar2(300)	Y	N/A
<VTA_GLOBAL_FLAG>	Is the VTA Global or not?	Varchar2(1)	N	N/A
<VTA_CREATED_BY>	The VTA Creator	Varchar2(30)	N	N/A
<VT_SUBTYPE>	MS (Misspelled) or AC (Accepted)	Varchar2(15)	N	N/A
VTI_CREATED_BY	The VTI Creator	Varchar2(30)	N	N/A
VT_TYPE	VTA or VTI	Varchar2(15)	N	N/A
DICT_CONTENT_CODE	DICT_CONTENT_CODE of the Dictionary term	Varchar2(30)	N	N/A
<DICTIONARY_TERM>	Dictionary Term	Varchar2(300)	N	N/A
<LABEL_TEXT_UPPER>	Informative Note Label	Varchar2(30)	N	N/A
<ALL_VERSION_FLAG>	Does the Informative Note apply to all versions?	Varchar2(1)	N	N/A
<CREATED_BY>	Informative Note Creator	Varchar2(30)	N	N/A
<DEF_DETAIL_VALUE>	Informative Note Text	CLOB	N	N/A
<STATUS>	Informative Note Status	Varchar2(15)	N	N/A
<SOURCE_TERM_ID>	Source Data ID (PK)	Number(15)	Y	N/A
<OCCURRENCE_ID>	Source Data ID (PK)	Number(10)	Y	0
<SOURCE_TERM_ALT_KEY>	Alternative Source Data Key	Varchar2(60)	N	N/A
<EXT_VALUE_1>	User Defined Data Value	Varchar2(30)	N	N/A
<EXT_VALUE_2>	User Defined Data Value	Varchar2(30)	N	N/A
<EXT_VALUE_3>	User Defined Data Value	Varchar2(30)	N	N/A
<EXT_VALUE_4>	User Defined Data Value	Varchar2(30)	N	N/A
<EXT_VALUE_5>	User Defined Data Value	Varchar2(30)	N	N/A
<EXT_VALUE_6>	User Defined Data Value	Varchar2(30)	N	N/A
<EXT_VALUE_7>	User Defined Data Value	Varchar2(30)	N	N/A
<EXT_VALUE_8>	User Defined Data Value	Varchar2(30)	N	N/A
<OMISSION_STATUS>	Omission Status (TMS_IN_PROGRESS, TMS_EVALUATION are reserved)	Varchar2(15)	N	N/A
<ACTION_OWNER>	Person to whom the Action is assigned	Varchar2(30)	N	N/A
<ACTION_TEXT>	Action Text	Varchar2 (2000)	N	N/A
<APPROVED_FLAG>	VTA Approved Flag	Varchar2(1)	Y	N