create rule check_entity_type_nm0 as @column in ('PATTERNED_AREA'
      ,'RASTER_IMAGE')
go
sp_bindrule check_entity_type_nm0, "area_element.entity_type_nm"
go
create rule check_entity_type_nm1 as @column in ('BOREHOLE'
      ,'BOREHOLE_TRAJECTORY_SECTION','ENLARGED_DIAMETER_BOREHOLE_SEGMENT',
      'OPEN_BOREHOLE_SEGMENT','PERFORATION_SET','SINGLE_DIAMETER_BOREHOLE_SEGMENT',
      'TEMPORARY_COMPLETION','WELL_COMPLETION_SEGMENT')
go
sp_bindrule check_entity_type_nm1, "borehole_cmpn.entity_type_nm"
go
create rule check_entity_type_nm2 as @column in ('CATALOG_ANCHOR'
      ,'CATALOG_COMPRESSOR','CATALOG_CONTROL_DEVICE',
      'CATALOG_CORE_BIT','CATALOG_DIRECTIONAL_SURVEY_TOOL','CATALOG_DRILL_BIT',
      'CATALOG_DRILL_COLLAR','CATALOG_DRILL_PIPE','CATALOG_ELECTRIC_GENERATOR',
      'CATALOG_EQUIPMENT','CATALOG_FLUID_VISCOMETER','CATALOG_MOTOR',
      'CATALOG_NOZZLE','CATALOG_POSITION_SENSOR','CATALOG_PRESSURE_VESSEL',
      'CATALOG_PUMP','CATALOG_PUMP_LINER','CATALOG_ROTARY_SHOULDERED_CONNECTION',
      'CATALOG_SEPARATOR','CATALOG_SOLIDS_CONTROL_EQUIPMENT','CATALOG_STABILIZER',
      'CATALOG_TANK','CATALOG_TRANSFORMER','CATALOG_TUBING',
      'CATALOG_TUBULAR_COUPLING','CATALOG_UNDERREAMER','CATALOG_WELLHEAD')
go
sp_bindrule check_entity_type_nm2, "catalog_eqp.entity_type_nm"
go
create rule check_entity_type_nm3 as @column in ('CONTRACT_AMENDMENT_CLAUSE'
      ,'CONTRACT_CLAUSE')
go
sp_bindrule check_entity_type_nm3, "contract_clause.entity_type_nm"
go
create rule check_entity_type_nm4 as @column in ('CONTRACT_DESIGNATION'
      ,'DEPOSITORY_DESIGNATION','INTEREST_DESIGNATION',
      'OWNERSHIP_DESIGNATION')
go
sp_bindrule check_entity_type_nm4, "contract_dsgn.entity_type_nm"
go
create rule check_entity_type_nm5 as @column in ('GEOCENTRIC_COORDINATE_SYSTEM'
      ,'GEOGRAPHIC_COORDINATE_SYSTEM','LOCAL_SPATIAL_COORDINATE_SYSTEM',
      'NONSPATIAL_COORDINATE_SYSTEM','PROJECTED_COORDINATE_SYSTEM')
go
sp_bindrule check_entity_type_nm5, "coordinate_sys.entity_type_nm"
go
create rule check_entity_type_nm6 as @column in ('GENERAL_COORDINATE_SYSTEM_AXIS'
      ,'MEASURED_DEPTH_SYSTEM_AXIS','VERTICAL_DEPTH_SYSTEM_AXIS',
      'VERTICAL_TIME_SYSTEM_AXIS')
go
sp_bindrule check_entity_type_nm6, "cord_sys_axis.entity_type_nm"
go
create rule check_entity_type_nm7 as @column in ('DAE_ARRAY_TYPE'
      ,'DAE_BAG_TYPE','DAE_LIST_TYPE',
      'DAE_SET_TYPE')
go
sp_bindrule check_entity_type_nm7, "dae_aggr_ty.entity_type_nm"
go
create rule check_entity_type_nm8 as @column in ('DAE_DEFAULT_UNIT'
      )
go
sp_bindrule check_entity_type_nm8, "dae_app_prefer.entity_type_nm"
go
create rule check_entity_type_nm9 as @column in ('DAE_EXPLICIT_ATTRIBUTE'
      ,'DAE_INVERSE_ATTRIBUTE','DAE_METHOD_DEFINITION')
go
sp_bindrule check_entity_type_nm9, "dae_atr_def.entity_type_nm"
go
create rule check_entity_type_nm10 as @column in ('DAE_ANGLE_TYPE'
      ,'DAE_ANYQUANTITY_TYPE','DAE_COMPLEX_TYPE',
      'DAE_DATE_TYPE','DAE_DAYTIMEINTERVAL_TYPE','DAE_ELEMENT_TYPE',
      'DAE_LINE_TYPE','DAE_LOCATION_TYPE','DAE_MONEY_TYPE',
      'DAE_POINT_TYPE','DAE_QUANTITY_TYPE','DAE_RATIONAL_TYPE',
      'DAE_RATIO_TYPE','DAE_SAMPLE_TYPE','DAE_SURFACE_TYPE',
      'DAE_TIMESTAMP_TYPE','DAE_TIME_TYPE','DAE_UNSTRUCTURED_3D_TOPOLOGY',
      'DAE_VOLUME_TYPE','DAE_YEARMONTHINTERVAL_TYPE')
go
sp_bindrule check_entity_type_nm10, "dae_epcnt_dtype.entity_type_nm"
go
create rule check_entity_type_nm11 as @column in ('DAE_FRAME'
      ,'DAE_SPARSE')
go
sp_bindrule check_entity_type_nm11, "dae_frame.entity_type_nm"
go
create rule check_entity_type_nm12 as @column in ('DAE_BINARY_TYPE'
      ,'DAE_BOOLEAN_TYPE','DAE_INTEGER_TYPE',
      'DAE_LOGICAL_TYPE','DAE_REAL_TYPE','DAE_STRING_TYPE')
go
sp_bindrule check_entity_type_nm12, "dae_simple_type.entity_type_nm"
go
create rule check_entity_type_nm13 as @column in ('DAE_GLOBAL_RULE'
      ,'DAE_TYPE_WHERE_RULE','DAE_UNIQUENESS_RULE',
      'DAE_WHERE_RULE')
go
sp_bindrule check_entity_type_nm13, "dae_swtch_rule.entity_type_nm"
go
create rule check_entity_type_nm14 as @column in ('ELECTRONIC_DOCUMENT'
      ,'HARDCOPY_DOCUMENT')
go
sp_bindrule check_entity_type_nm14, "document.entity_type_nm"
go
create rule check_entity_type_nm15 as @column in ('FACILITY_ASSEMBLY'
      ,'FACILITY_COLLECTION')
go
sp_bindrule check_entity_type_nm15, "facility_cmps.entity_type_nm"
go
create rule check_entity_type_nm16 as @column in ('PROSPECTIVE_FIELD'
      ,'REGULATORY_FIELD','UNITIZED_FIELD')
go
sp_bindrule check_entity_type_nm16, "field.entity_type_nm"
go
create rule check_entity_type_nm17 as @column in ('FLUID_PHASE_AQUEOUS'
      ,'FLUID_PHASE_LIQUID','FLUID_PHASE_OLEIC')
go
sp_bindrule check_entity_type_nm17, "fluid_phase_lq.entity_type_nm"
go
create rule check_entity_type_nm18 as @column in ('FLUID_FILTRATE'
      ,'FLUID_SAMPLE','PRESSURIZED_FLUID_SAMPLE')
go
sp_bindrule check_entity_type_nm18, "fluid_sample.entity_type_nm"
go
create rule check_entity_type_nm19 as @column in ('GRID_1D_EQUAL'
      ,'GRID_1D_PARAMETRIC','GRID_1D_UNEQUAL')
go
sp_bindrule check_entity_type_nm19, "grid_1d.entity_type_nm"
go
create rule check_entity_type_nm20 as @column in ('CURVED_TEXT_ELEMENT'
      ,'LINE_ELEMENT')
go
sp_bindrule check_entity_type_nm20, "line_element.entity_type_nm"
go
create rule check_entity_type_nm21 as @column in ('COMPONENT_MATERIAL'
      ,'COMPONENT_MATERIAL_TYPE')
go
sp_bindrule check_entity_type_nm21, "material_cmps.entity_type_nm"
go
create rule check_entity_type_nm22 as @column in ('PRODUCT_FLOW_NETWORK_GROUP'
      ,'WELL_PATTERN')
go
sp_bindrule check_entity_type_nm22, "pfng.entity_type_nm"
go
create rule check_entity_type_nm23 as @column in ('PRODUCT_FLOW_NETWORK_GROUP_ALLOCATION'
      ,'WELL_PATTERN_PARTICIPATION')
go
sp_bindrule check_entity_type_nm23, "pfng_allocation.entity_type_nm"
go
create rule check_entity_type_nm24 as @column in ('NONCURVED_TEXT_ELEMENT'
      ,'SYMBOL')
go
sp_bindrule check_entity_type_nm24, "point_element.entity_type_nm"
go
create rule check_entity_type_nm25 as @column in ('PTY_AZIMUTH'
      ,'PTY_DIP_AZIMUTH','PTY_STRIKE')
go
sp_bindrule check_entity_type_nm25, "p_azimuth.entity_type_nm"
go
create rule check_entity_type_nm26 as @column in ('PTY_LINE'
      ,'PTY_POINT','PTY_QUANTITY',
      'PTY_STRING')
go
sp_bindrule check_entity_type_nm26, "p_equipment_fcl.entity_type_nm"
go
create rule check_entity_type_nm27 as @column in ('PTY_GEOMETRY_COMPLEX_1D_EDGE'
      ,'PTY_GEOMETRY_SIMPLE_1D_EDGE')
go
sp_bindrule check_entity_type_nm27, "p_geom_1d_edg.entity_type_nm"
go
create rule check_entity_type_nm28 as @column in ('PTY_DIP_ANGLE'
      ,'PTY_INCLINATION_FROM_VERTICAL')
go
sp_bindrule check_entity_type_nm28, "p_inc_from_vert.entity_type_nm"
go
create rule check_entity_type_nm29 as @column in ('REGULATION_CLAUSE'
      ,'REGULATION_CLAUSE_AMENDMENT')
go
sp_bindrule check_entity_type_nm29, "regulation_clse.entity_type_nm"
go
create rule check_entity_type_nm30 as @column in ('RESERVOIR_DRAINAGE_FEATURE'
      ,'RESERVOIR_PATTERN_FEATURE','RESERVOIR_ZONE')
go
sp_bindrule check_entity_type_nm30, "reservoir_part.entity_type_nm"
go
create rule check_entity_type_nm31 as @column in ('REF_BASE_SI_UNIT'
      ,'REF_CUSTOMARY_UNIT_OF_MEASURE','REF_DERIVED_SI_UNIT')
go
sp_bindrule check_entity_type_nm31, "r_uom.entity_type_nm"
go
create rule check_entity_type_nm32 as @column in ('REF_UNIT_OF_MEASURE_CUSTOM_CONVERSION'
      ,'REF_UNIT_OF_MEASURE_SI_CONVERSION')
go
sp_bindrule check_entity_type_nm32, "r_uom_conv.entity_type_nm"
go
create rule check_entity_type_nm33 as @column in ('BIOSTRATIGRAPHIC_MARKER'
      ,'CHRONOSTRATIGRAPHIC_BOUNDARY','LITHOSTRATIGRAPHIC_MARKER',
      'STRATIGRAPHIC_MARKER')
go
sp_bindrule check_entity_type_nm33, "strat_mrk.entity_type_nm"
go
create rule check_entity_type_nm34 as @column in ('SURFACE_GEOCHEMICAL_SURVEY'
      ,'SURFACE_GEOLOGIC_SURVEY')
go
sp_bindrule check_entity_type_nm34, "surf_geol_srvy.entity_type_nm"
go
create rule check_entity_type_nm35 as @column in ('BIOZONE'
      ,'BIOZONE_MARKER','CHRONOZONE',
      'GEOCHRONOLOGIC_AGE','GEOCHRONOLOGIC_EON','GEOCHRONOLOGIC_EPOCH',
      'GEOCHRONOLOGIC_ERA','GEOCHRONOLOGIC_EVENT','GEOCHRONOLOGIC_PERIOD',
      'GEOCHRONOLOGIC_SUBEPOCH','SEA_LEVEL_CYCLE','SEA_LEVEL_CYCLE_EVENT',
      'SEA_LEVEL_SUPERCYCLE','TEMPORAL_EVENT','TEMPORAL_PERIOD',
      'THIRD_ORDER_SEA_LEVEL_CYCLE')
go
sp_bindrule check_entity_type_nm35, "temporal_object.entity_type_nm"
go
create rule check_entity_type_nm36 as @column in ('TYPICAL_FACILITY'
      ,'TYPICAL_RECEIVER_ELEMENT','TYPICAL_REFERENCE_POINT',
      'TYPICAL_SEISMIC_RECEIVER','TYPICAL_SEISMIC_SOURCE','TYPICAL_SOURCE_ELEMENT')
go
sp_bindrule check_entity_type_nm36, "typical_fcl.entity_type_nm"
go
create rule check_entity_type_nm37 as @column in ('BOTTOMHOLE_ASSEMBLY'
      ,'BRIDGE_PLUG','CASING_CENTRALIZER',
      'CASING_SHOE','COLLAR','CORE_BIT',
      'DOWNHOLE_CHOKE','DOWNHOLE_MOTOR','DOWNHOLE_PRESSURE_SENSOR',
      'DOWNHOLE_PUMP','DOWNHOLE_RATE_SENSOR','DOWNHOLE_SENSOR',
      'DOWNHOLE_TEMPERATURE_SENSOR','DRILLING_JAR','DRILLSTRING_STABILIZER',
      'DRILL_BIT','DRILL_COLLAR','DRILL_MEASUREMENT_TOOL',
      'DRILL_PIPE_JOINT','FISH','FLOAT_COLLAR',
      'GAS_LIFT_MANDREL','GAS_LIFT_VALVE','GAUGE_ADAPTER',
      'GRAVEL_PACK','HOLE_OPENER','PACKER',
      'PERFORATING_GUN','PLUNGER','SEALING_BORE',
      'SLIDING_SLEEVE','STANDING_VALVE','SUCKER_ROD_SEGMENT',
      'SUCKER_ROD_STRING','TRAVELING_VALVE','TUBING_ANCHOR',
      'UNDERREAMER','WELLBORE_PLUG')
go
sp_bindrule check_entity_type_nm37, "wellbore_device.entity_type_nm"
go
create rule check_entity_type_nm38 as @column in ('BOTTOMHOLE'
      ,'DERRICK_FLOOR_REFERENCE','GROUND_LEVEL',
      'KELLY_BUSHING_REFERENCE','KICK_OFF_POINT')
go
sp_bindrule check_entity_type_nm38, "wellbore_ref.entity_type_nm"
go
create rule check_entity_type_nm39 as @column in ('BLAST_JOINT'
      ,'CASING_SEGMENT','CASING_STRING',
      'CROSSOVER_NIPPLE','DRILLSTRING','DRILLSTRING_SEGMENT',
      'EXPANSION_JOINT','HOLD_DOWN_NIPPLE','LANDING_NIPPLE',
      'LINER','MULESHOE','NIPPLE',
      'PERFORATED_JOINT','SAFETY_JOINT','SCREEN_LINER',
      'SHOCK_SUB','TIE_BACK_STRING','TUBING_SEGMENT',
      'TUBING_STRING')
go
sp_bindrule check_entity_type_nm39, "wellbore_tubular.entity_type_nm"
go
create rule check_entity_type_nm40 as @column in ('WELLBORE_ANNULAR_VOLUME'
      ,'WELLBORE_CEMENT_SHEATH','WELLBORE_FILL',
      'WELLBORE_TUBULAR_VOLUME')
go
sp_bindrule check_entity_type_nm40, "wellbore_volume.entity_type_nm"
go