 	select id || ' :: ' || frm from temp_doc_id_raw order by id;
 
 		select id || ' :: ' || frm from temp_doc_id_raw where id not in (select cf_variable from ssrch_field_doc@db_production) order by id;
+
+		create table temp_doc_merge (
+			cfvar varchar2(4000),
+			in_code  varchar2(4000),
+			in_docs  varchar2(4000),
+			CATEGORY varchar2(4000),
+			CONTROLLED_VOCABULARY varchar2(4000),
+			DATA_TYPE varchar2(4000),
+			DEFINITION varchar2(4000),
+			DISPLAY_TEXT varchar2(4000),
+			DOCUMENTATION_LINK varchar2(4000),
+			PLACEHOLDER_TEXT varchar2(4000),
+			SEARCH_HINT varchar2(4000),
+			SQL_ELEMENT varchar2(4000),
+			SPECIMEN_RESULTS_COL varchar2(4000),
+			DISP_ORDER varchar2(4000),
+			SPECIMEN_QUERY_TERM varchar2(4000),
+			used_in_frm varchar2(4000),
+			rawtags varchar2(4000)
+		);
 
 ---->
 <cfinclude template="/includes/_header.cfm">

	<cfquery name="p_raw" datasource="prod">
		select * from ssrch_field_doc
	</cfquery>

	<cfquery name="allterms" dbtype="query">
		select id cfvar from d_raw
		union
		select cf_variable cfvar from p_raw
	</cfquery>

	<cfdump var=#allterms#>


			<cfdump var=#p#>
		</cfif>
	</cfloop>
	---->
</cfoutput>
</cfif>

