NHP Data Exchange Export Template Version 0.1Export template that B4 NHP/CDC will use to export NHP data files to NatureServe at the start of the data exchange. Limits the EST & EO export so that only records for the source subnation will be sent. User must change the SUBNATION_NAME to match their own subnation in the EST & EO export SQL.NHP_B4_synch_export_01.xpttyler_christensenWed Jul 10 13:05:52 EDT 2002cscottTue Oct 13 12:58:53 EDT 20092005-12-12tyler_christensenWed Jul 10 16:09:16 EDT 2002cscottTue Oct 13 12:44:39 EDT 2009exists ( select 1 from element_subnational est, subnation s where eo.element_subnational_id = est.element_subnational_id and est.subnation_id = s.subnation_id and s.nation_id in (225, 38) and s.subnation_code = 'NV' )exists ( select 1 from element_subnational est, element_national ent, element_global egt, scientific_name sn, d_name_category d where eo.element_subnational_id = est.element_subnational_id and ent.element_national_id = est.element_national_id and egt.element_global_id = ent.element_global_id and est.sname_id = sn.scientific_name_id and sn.d_name_category_id = d.d_name_category_id and (egt.inactive_ind = 'Y' or d.name_type_cd not in ( 'A','P') -- or est.element_subnational_id in (/*EST_ID list*/) ) )cscottTue May 09 17:23:04 EDT 2006cscottTue Oct 13 12:48:39 EDT 2009exists (select 'x' from eo_source_feature esf where source_feature.shape_id = esf.source_feature_shape_id) and exists ( select 1 from element_subnational est, subnation s where source_feature.element_subnational_id = est.element_subnational_id and est.subnation_id = s.subnation_id and s.nation_id in (225, 38) and s.subnation_code = 'NV' )exists ( select 1 from element_subnational est, element_national ent, element_global egt, scientific_name sn, d_name_category d where source_feature.element_subnational_id = est.element_subnational_id and ent.element_national_id = est.element_national_id and egt.element_global_id = ent.element_global_id and est.sname_id = sn.scientific_name_id and sn.d_name_category_id = d.d_name_category_id and (egt.inactive_ind = 'Y' or d.name_type_cd not in ( 'A','P') -- or est.element_subnational_id in (/*EST_ID list*/) ) )