 	   
 MERGE INTO SBREXT.TOOL_OPTIONS_VIEW_EXT S
 USING (		   
-SELECT 'CURATION' AS TOOL_NAME, 'EVS.VOCAB.6.EVSNAME' AS PROPERTY, 'Medical Dictionary for Regulatory Activities Terminology (MedDRA)' AS VALUE, 'Store vocab name for the MedDRA vocabulary'AS DESCRIPTION FROM DUAL
+SELECT 'CURATION' AS TOOL_NAME, 'EVS.VOCAB.6.EVSNAME' AS PROPERTY, 'MedDRA (Medical Dictionary for Regulatory Activities Terminology)' AS VALUE, 'Store vocab name for the MedDRA vocabulary'AS DESCRIPTION FROM DUAL
 UNION SELECT 'CURATION' AS TOOL_NAME, 'EVS.VOCAB.6.ACCESSREQUIRED' AS PROPERTY, '10382' AS VALUE, 'Store vocab access code for the MedDRA vocabulary' AS DESCRIPTION FROM DUAL
 UNION SELECT 'CURATION' AS TOOL_NAME, 'EVS.VOCAB.6.DISPLAY' AS PROPERTY, 'MedDRA' AS VALUE,'Store vocab display name for the MedDRA vocabulary'AS DESCRIPTION FROM DUAL
 UNION SELECT 'CURATION' AS TOOL_NAME, 'EVS.VOCAB.6.VOCABCODETYPE' AS PROPERTY, 'MEDDRA_CODE' AS VALUE,'Store vocab code type (alt type) for the MedDRA vocabulary'AS DESCRIPTION FROM DUAL

      
MERGE INTO SBREXT.TOOL_OPTIONS_VIEW_EXT S
USING (	   
SELECT 'CURATION' AS TOOL_NAME, 'EVS.VOCAB.7.EVSNAME' AS PROPERTY, 'SNOMED Clinical Terms' AS VALUE, 'Store vocab name for the SNOMED vocabulary'AS DESCRIPTION FROM DUAL
UNION SELECT 'CURATION' AS TOOL_NAME, 'EVS.VOCAB.7.DISPLAY' AS PROPERTY, 'SNOMED' AS VALUE, 'Store vocab display name for the SNOMED vocabulary'AS DESCRIPTION FROM DUAL
UNION SELECT 'CURATION' AS TOOL_NAME, 'EVS.VOCAB.7.VOCABCODETYPE' AS PROPERTY, 'SNOMED_CODE' AS VALUE, 'Store vocab code type (alt type) for the SNOMED vocabulary'AS DESCRIPTION FROM DUAL
UNION SELECT 'CURATION'AS TOOL_NAME, 'EVS.VOCAB.7.METASOURCE' AS PROPERTY, '@EVS.VOCAB.7.METASOURCE@' AS VALUE, 'Store vocab meta source for the SNOMED vocabulary'AS DESCRIPTION FROM DUAL

UNION SELECT 'ALL' AS TIER, 'CURATION' AS TOOL_NAME, 'VERSION' AS PROPERTY, '@appl.version@' AS VALUE, 'Store curation tool version' AS DESCRIPTION FROM DUAL
UNION SELECT 'ALL' AS TIER, 'CURATION' AS TOOL_NAME, 'NAME' AS PROPERTY, 'CDE Curation Tool' AS VALUE, 'Store curation tool name' AS DESCRIPTION FROM DUAL
UNION SELECT 'ALL' AS TIER, 'CURATION' AS TOOL_NAME, 'HELP.HOME' AS PROPERTY, 'https://cdecurate@TIER@.nci.nih.gov/help' AS VALUE, 'Store curation tool help url' AS DESCRIPTION FROM DUAL
UNION SELECT 'DEV' AS TIER, 'CURATION' AS TOOL_NAME, 'EVS.URL' AS PROPERTY,'http://lexevsapi51.nci.nih.gov/lexevsapi51' AS VALUE,'Store evs alternate url specific to curation tool if needed' AS DESCRIPTION FROM DUAL 
UNION SELECT 'ALL' AS TIER, 'CURATION' AS TOOL_NAME, 'CSI.PACKAGE.ALIAS' AS PROPERTY,'UML_PACKAGE_ALIAS' AS VALUE,'The special CSI type for the UML Package Alias' AS DESCRIPTION FROM DUAL
UNION SELECT 'ALL' AS TIER, 'CURATION' AS TOOL_NAME, 'CSI.PACKAGE.NAME' AS PROPERTY,'UML_PACKAGE_NAME' AS VALUE,'The special CSI type for the UML Package Name' AS DESCRIPTION FROM DUAL  
) hits WHERE hits.tier IN ('ALL', '@TIER.UPPER@')
