POSC Specifications: Epicentre Version 3.0 | Logical Data Model |
This change overides the "default" projection names. Attribute names longer than 28 characters that are relationships will have a shorter projected name (to allow for a "_s" suffix). Duplicate attribute names with different data types that are consolidated up to a table will have a different projected name. Attribute names of type quantity that are longer than 28 characters will have a shorter projected name (to allow for "_u" on the units column).
CHANGE _ERP4_Long_to_Short_Names_for_Projection ------- Consolidated attribute names that are the same but point to entities in different parts of the hierarchy. -- Change the names so that "_s" and "_t" columns will not be generated instead of using the natural key. ALTER ENTITY interest_designation; ALTER kind (*<projname>interest_kind*); END_ENTITY; ALTER ENTITY ownership_designation; ALTER kind (*<projname>ownership_kind*); END_ENTITY; -- Change the names so that a "_t" column will not be generated that is not properly documented. ALTER ENTITY facility_specific_composition; ALTER part (*<projname>specific_part*); END_ENTITY; ALTER ENTITY facility_type_composition; ALTER part (*<projname>type_part*); END_ENTITY; ALTER ENTITY material_specific_composition; ALTER part (*<projname>specific_part*); END_ENTITY; ALTER ENTITY material_type_composition; ALTER part (*<projname>type_part*); END_ENTITY; ------- Consolidated attribute names that are the same but have different data types. ALTER ENTITY pty_initial_final_rate_ratio; ALTER data_value (*<projname>rate_ratio*); END_ENTITY; ALTER ENTITY pty_loss_ratio_decline_rate; ALTER data_value (*<projname>ratio_decline_rate*); END_ENTITY; alter entity ownership_designation; alter kind (*<projname>ownership_kind *); end_entity; alter entity interest_designation; alter kind (*<projname>interest_kind*); end_entity; alter entity PTY_GENERIC_TIME; alter data_value (*<projname>time_value*); end_entity; alter entity PTY_GENERIC_DATE; alter data_value (*<projname>date_value*); end_entity; alter entity PTY_GENERIC_REAL; alter data_value (*<projname>real_value*); end_entity; alter entity PTY_GENERIC_LOGICAL; alter data_value (*<projname>logical_value*); end_entity; alter entity PTY_GENERIC_SURFACE; alter data_value (*<projname>surface_value*); end_entity; alter entity PTY_GENERIC_ELEMENT; alter data_value (*<projname>element_value*); end_entity; alter entity PTY_GENERIC_RATIO; alter data_value (*<projname>ratio_value*); end_entity; alter entity PTY_GENERIC_RATIONAL; alter data_value (*<projname>rational_value*); end_entity; alter entity PTY_GENERIC_ANGLE; alter data_value (*<projname>angle_value*); end_entity; alter entity PTY_GENERIC_QUANTITY; alter data_value (*<projname>quantity_value*); end_entity; alter entity PTY_GENERIC_DAYTIMEINTERVAL; alter data_value (*<projname>daytimeinterval_value*); end_entity; alter entity PTY_GENERIC_VOLUME; alter data_value (*<projname>volume_value*); end_entity; alter entity PTY_GENERIC_BINARY; alter data_value (*<projname>binary_value*); end_entity; alter entity PTY_GENERIC_LOCATION; alter data_value (*<projname>location_value*); end_entity; alter entity PTY_GENERIC_INTEGER; alter data_value (*<projname>integer_value*); end_entity; alter entity PTY_GENERIC_LINE; alter data_value (*<projname>line_value*); end_entity; alter entity PTY_GENERIC_MONEY; alter data_value (*<projname>money_value*); end_entity; alter entity PTY_GENERIC_POINT; alter data_value (*<projname>point_value*); end_entity; alter entity PTY_GENERIC_BOOLEAN; alter data_value (*<projname>boolean_value*); end_entity; alter entity PTY_GENERIC_STRING; alter data_value (*<projname>string_value*); end_entity; alter entity PTY_GENERIC_ENUMERATION; alter data_value (*<projname>enumeration_value*); end_entity; ------- Long attribute names alter entity pty_logical_array; ALTER inflection_station_definition (*<projname>inflection_station_defn*); ALTER potential_field_stn_inflection (*<projname>potential_field_stn_infl*); end_entity; ALTER ENTITY downhole_motor; ALTER maximum_differential_pressure (*<projname>max_differential_pressure*); END_ENTITY; ALTER ENTITY pty_seismic_geometry_summary; ALTER receiver_line_nominal_spacing (*<projname>receiver_line_nom_spacing*); END_ENTITY; ALTER ENTITY pty_seismic_geometry_summary; ALTER receiver_point_nominal_spacing (*<projname>receiver_point_nom_spacing*); END_ENTITY; ALTER ENTITY text_style; ALTER character_orientation_absolute (*<projname>character_orient_absolute*); END_ENTITY; ALTER ENTITY text_style; ALTER character_orientation_relative (*<projname>character_orient_relative*); END_ENTITY; ALTER ENTITY fluid_phase_oleic_pvt; ALTER total_formation_volume_factor (*<projname>total_formation_volume_fact*); END_ENTITY; ALTER ENTITY seismic_source_facility; ALTER vibrator_sweep_start_frequency (*<projname>vibrator_sweep_start_freq*); END_ENTITY; ALTER ENTITY seismograph_platform; ALTER time_offset_wrt_master_vehicle (*<projname>time_offset_wrt_master*); END_ENTITY; ALTER ENTITY seismograph_platform; ALTER time_offset_wrt_standard_time (*<projname>time_offset_wrt_standard*); END_ENTITY; ALTER ENTITY pty_location_array; ALTER potential_field_stn_definition (*<projname>potential_field_stn_defn*); END_ENTITY; ALTER ENTITY pty_vertical_location_array; ALTER potential_field_stn_definition (*<projname>potential_field_stn_defn*); END_ENTITY; ALTER ENTITY pty_grid_convergence; ALTER projected_2d_coordinate_system (*<projname>projected_2d_coordinate_sys*); END_ENTITY; ALTER ENTITY pty_diameter; ALTER pfnu_external_span_connection (*<projname>PFNU_EXTERNAL_SPAN_CONN*); END_ENTITY; ALTER ENTITY pty_elevation_difference; ALTER pfnu_external_span_connection (*<projname>PFNU_EXTERNAL_SPAN_CONN*); END_ENTITY; ALTER ENTITY pty_flow_equivalent_length; ALTER pfnu_external_span_connection (*<projname>PFNU_EXTERNAL_SPAN_CONN*); END_ENTITY; ALTER ENTITY pty_length; ALTER pfnu_external_span_connection (*<projname>PFNU_EXTERNAL_SPAN_CONN*); END_ENTITY; ALTER ENTITY pty_pressure_change; ALTER pfnu_external_span_connection (*<projname>PFNU_EXTERNAL_SPAN_CONN*); END_ENTITY; ALTER ENTITY pty_pressure_drop_gradient; ALTER pfnu_external_span_connection (*<projname>PFNU_EXTERNAL_SPAN_CONN*); END_ENTITY; ALTER ENTITY pty_standard_pressure; ALTER surface_fluid_phase_condition (*<projname>SURFACE_FL_PHASE_CONDITION*); END_ENTITY; ALTER ENTITY pty_standard_temperature; ALTER surface_fluid_phase_condition (*<projname>SURFACE_FL_PHASE_CONDITION*); END_ENTITY; ALTER ENTITY pty_transient_pressure; ALTER surface_fluid_phase_condition (*<projname>SURFACE_FL_PHASE_CONDITION*); END_ENTITY; ALTER ENTITY pty_transient_temperature; ALTER surface_fluid_phase_condition (*<projname>SURFACE_FL_PHASE_CONDITION*); END_ENTITY; ALTER ENTITY pty_absolute_abundance; ALTER fluid_flow_stream_contaminant (*<projname>FL_FLOW_STREAM_CONTAMINANT*); END_ENTITY; ALTER ENTITY pty_conc_mass_per_mass; ALTER fluid_flow_stream_contaminant (*<projname>FL_FLOW_STREAM_CONTAMINANT*); END_ENTITY; ALTER ENTITY pty_conc_mass_per_volume; ALTER fluid_flow_stream_contaminant (*<projname>FL_FLOW_STREAM_CONTAMINANT*); END_ENTITY; ALTER ENTITY pty_conc_mole_per_volume; ALTER fluid_flow_stream_contaminant (*<projname>FL_FLOW_STREAM_CONTAMINANT*); END_ENTITY; ALTER ENTITY pty_conc_volume_per_mole; ALTER fluid_flow_stream_contaminant (*<projname>FL_FLOW_STREAM_CONTAMINANT*); END_ENTITY; ALTER ENTITY pty_conc_volume_per_volume; ALTER fluid_flow_stream_contaminant (*<projname>FL_FLOW_STREAM_CONTAMINANT*); END_ENTITY; ALTER ENTITY pty_mass_fraction; ALTER fluid_flow_stream_contaminant (*<projname>FL_FLOW_STREAM_CONTAMINANT*); END_ENTITY; ALTER ENTITY pty_mole_fraction; ALTER fluid_flow_stream_contaminant (*<projname>FL_FLOW_STREAM_CONTAMINANT*); END_ENTITY; ALTER ENTITY pty_volume_fraction; ALTER fluid_flow_stream_contaminant (*<projname>FL_FLOW_STREAM_CONTAMINANT*); END_ENTITY; END_CHANGE;