POSC Specifications: Epicentre Version 3.0 | Logical Data Model |
Add attribute identifier to Ref_code. Eliminate description and name/kind/identifier from all subtypes. Change the SI rules accordingly.
CHANGE ERP_ref_code ALTER ENTITY ref_code; ADD identifier : ndt_identifier (*<DESC>The name or identifier of the code.*); END_ENTITY; ALTER ENTITY ref_abundance_unit; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_activity_termination_reason; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_address_qualifier; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_age_classification_type; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_allowable; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_application_status; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_axis_orientation; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_axis_type; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_binset_geometry_class; DROP kind (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_biozone; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_business_associate_land_feature_role; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_business_association_structure; DROP identifier (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); END_ENTITY; ALTER ENTITY ref_business_association_structure_type; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_business_associate; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_business_associate_activity_role; (*<DESC>(LAST)Examples include interpreter, operator, contractor, recorder, etc.*) DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_business_associate_facility_role; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_business_associate_injury; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_business_associate_job_title; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_business_associate_privilege; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_business_associate_security_class; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_business_associate_service; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_business_association_role; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_business_contact_purpose; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_business_contact_result; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_capillary_pressure; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_capillary_pressure_usage; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_case_element_orientation; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_classification_system; DROP name (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_clause_amendment_reason; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_color; (*<DESC>(LAST)For example, blue, red or gold.*) DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_compaction_factor; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_compass_point; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_completion_status; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_conodont_color_index; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_contract_clause; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_contract_clause_item; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_contract_designation; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_contract_obligation; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_contract_processing_fee; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_contract_reference_use; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_contract_status; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_coordinate_system_constraint; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_coordinate_transform_constraint; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_coordinate_transformation; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_coordinate_transformation_parameter; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_core; DROP kind (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_data_collection_type; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_diameter; (*<DESC>A reference list of short lengths expressed in a fractional inch format (e.g. '9 5/8in', '12 1/4in' etc.). It allows diameters to be expressed in numerical or textural format.*) DROP name (*<CHANGE>Redundant to Ref_code.identifier*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_digital_file_format; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_discovery_area; DROP kind (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_display_orientation; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_downtime_reason; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_drive_mechanism; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_east_or_west; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_evaluated_flow_stream; (*<DESC>(LAST) For example, budget, estimate, quota, etc.*) DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_existence_kind; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_facility_reference_point; DROP name (XXX*<CHANGE>Redundant to Ref_code.name*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_fault_displacement_path; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_fault_horizontal_movement; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_fault_side; DROP name (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_fault_vertical_movement; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_field; DROP kind (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_flow_orientation; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_fluid_contact; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_fluid_saturation; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_gain_mode; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_generic_fluid_component; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_generic_fluid_phase; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_geographic_feature; (XXX*<DESC> For example, river, structure, etc.*XXX) DROP kind (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_geologic_fault; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_geologic_object_association; (*<REMARK> RENAMED to ref_geometrical_relationship*) DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_geopolitical_area; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_gravel_pack_screen; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_grid_variant; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_guideline; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_guideline_compliance_status; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_hardcopy_document; DROP name (*<CHANGE>Redundant to Ref_code.name*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_hold_or_pay; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_hydrocarbon_fluorescence_color; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_injection_or_production; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_interest_designation; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_justification_horizontal; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_justification_vertical; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_kind_descriptor; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_land_right_retention_class; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_limitation; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_lithologic_color; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_logging_direction; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_map_projection; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ref_material_type *) ALTER ENTITY ref_mineral_agreement_acquisition; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_mineral_right; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_north_axis_direction; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_north_or_south; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_object_intersection; DROP kind (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_obligation_frequency; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_offset_line_orientation; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_organic_matter_color; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_other_earth_point; DROP kind (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_ownership; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_parameter_attribute; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_perforation; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_pfnu_operational_object; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_pfnu_port_direction; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_phone_number; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_pool; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_position_system_identifier; DROP name (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_processing_indicator; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_product_flow_network_group; DROP kind (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_property_damage; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_property_qualifier; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_property_set; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_property_set_type; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_property_type; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_quantity_type; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_recovery_process; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_regulation; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_regulation_clause; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_regulation_purpose; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_regulation_reference_use; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_regulation_status; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_relative_permeability_model; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_relative_permeability_orientation; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_relative_permeability_usage; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_reserves_change_reason; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_reservoir_zone; DROP kind (*<CHANGE>Redundant to Ref_code.name*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_sale; DROP kind (*<CHANGE>Redundant to Ref_code.name*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_schedule_constraint; DROP name (*<CHANGE>Redundant to Ref_code.name*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_seismic_acquisition_vertex; DROP name (XXX*<CHANGE>Redundant to Ref_code.name*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; *) (*<REMARK>DROPPED ALTER ENTITY ref_seismic_facility_role; DROP kind (XXX*<CHANGE>Redundant to Ref_code.name*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP kind ADD name FIRST; END_ENTITY; *) ALTER ENTITY ref_seismic_display_mode; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_seismic_geometry; DROP kind (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_seismic_polarity; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_seismic_velocity; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_seismic_vibrator_sweep; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_shell_region_binding; DROP name (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_space_time_operation; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_spore_color_index; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_spread; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_surface_right; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_survey_environment; DROP kind (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; *) (*<REMARK>DROPPED ALTER ENTITY ref_taxonomic_class; (XXX*<DESC>The rank in the taxonomic classification hierarchy of plant and animal life, such as phylum, order, genus, and species.*XXX) DROP kind (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_template_constraint_kind; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_text_font; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_text_slant; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_text_weight; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_three_phase_rel_perm; (*<DESC> For example, wetting imbibition or intermediate drainage.*) DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_transient_period; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_tubular_classification; DROP name (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_two_phase_rel_perm; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_vertical_axis_orientation; (*<DESC>The reference entity that describes the orientation of a vertical coordinate axis with respect to a coordinate system. "Upwards" is defined as away from the center of the Earth. "Downwards" is defined as towards the center of the Earth.*) DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_wave_polarization; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_wavelet_or_filter; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_wavelet_or_filter_algorithm; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_well_log_process_state; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_well_participation_geometry; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_well_participation_role; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_well_status; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_well_structure_rule; DROP name (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_well_surface_feature_role; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_wellbore; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_wellbore_component_facility_con; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; (*<REMARK>DROPPED ALTER ENTITY ref_wellbore_point; (XXX*<DESC>(LAST) Examples include sidetrack point, core point, kickoff point, casing shoe point.*XXX) DROP name (XXX*<CHANGE>Redundant to Ref_code.identifier*XXX); DROP description (XXX*<CHANGE>Moved up to Ref_data.*XXX); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; *) ALTER ENTITY ref_wellbore_purpose; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_wellbore_status; DROP kind (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP kind ADD identifier FIRST; END_ENTITY; ALTER ENTITY ref_wellbore_trajectory_shape; DROP name (*<CHANGE>Redundant to Ref_code.identifier*); DROP description (*<CHANGE>Moved up to Ref_data.*); UNIQUE ALTER si DROP name ADD identifier FIRST; END_ENTITY; END_CHANGE;