POSC Specifications: Epicentre Version 3.0 Logical Data Model

Change Abstracts

C001 ERP_miscellaneous_fixes

These changes represent mechanical fixes which implement the intent of the model.

C002 ERP_fix_well_test_recovery

In Version 2.2, two new attributes were added to Well_test_recovery with a mandatory select rule on these two attributes plus attribute reservoir_fluid_system. The new attributes were not included in the SI rule for its subtypes.

C003 ERP_pty_dip_angle

Pty_dip_angle has a non-abstract supertye with an SI. The SI rule in Pty_dip_angle conflicts with this inherited rule because it is attempting to broaden the uniqueness. Move the fracture relationship to its supertype so that it can be included in the SI.

C004 ERP_topological_object

Make Topological Object a subtype of Business Object. Move some spatial related behavior up to Spatial Object.

C005 ERP_graphical_element

Eliminate the subtypes of Grahical Element as subtypes of Spatial Object. Replace spatial attributes with 2D geometrical characteristics.

C006 ERP_remove_spatial_many_to_many_

Eliminate the many-to-many relationships between spatial subtypes.

C007 ERP_geometrical_relationship

Add the capability to assert geometrical relationships independent of topological assertions. For example, objects AA and BB might have a topological assertion that AA is "disjoint" from BB and might also have multiple geometrical assertions such as AA is "above" BB and AA has a 20ft "separation" from BB.

C008 ERP_earth_model_object

Delete Earth Model Object and all of its subtypes. Move any required locate/represent behavior to Spatial Objects.

C009 ERP_other_spatial_object

Eliminate Other_spatial_object and its subtypes since they are now redundant.

C010 ERP_other_spatial_object_drop_from_si

Drop other spatial object from the uniqueness rule of all subtypes of property.

C011 ERP_earth_feature

Add Earth_feature as the supertype of the Earth related objects.

C012 ERP_earth_feature_continued

More changes related to Earth_feature.

C013 ERP_facility

Some changes related to Facility. Move common behavior up to Facility.

C014 ERP_material_hierarchy

Alter the Material hierarchy to include Document and to drop Rock_material_part.

C015 ERP_bulk_material

Insert entity Bulk_material between Material and its current subtypes. Move all somewhat specialized behavior from Material to Bulk_material so that Document and Equipment_item will not inherit them.

C016 ERP_material_sample

Eliminate Material_sample.

C017 ERP_inventory_object

Eliminate Inventory_object.

C018 ERP_equipment

Make equipment a subtype of material. Resolve the variations of composition. The change to allow a facility to be classified as to its material nature allows many of the associations to "typical" to be eliminated.

C019 ERP_catalog_equipment_subtypes

Since Catalog_equipment is non-abstract (and has an SI rule), we need to either eliminate its subtypes or we need to eliminate the SI rule from the subtypes. This change deletes them.

C020 ERP_data_collection_many_to_many

Add an association entity to the many-to-many relationship between Data_collection and E_and_p_data.

C021 ERP_ref_data

Make Ref_data a subtype of E_and_p_data. Create Ref_aliasable_data as the supertype of all ref entities which are aliasable. Move Ref_code to be a subtype of Ref_aliasable_data. Move all non-code entities from Ref_code to Ref_aliasable_data.

C022 ERP_ref_code

Add attribute identifier to Ref_code. Eliminate description and name/kind/identifier from all subtypes. Change the SI rules accordingly.

C023 ERP_ref_code_new_subtypes

Move some entities which have the behavior of "codes" to be subtypes of Ref_code. Do not eliminate the inverse relationships under the assumption that all inverse relationships will be explicitly modeled.

C024 ERP_typical_facility_sybtype

The subtypes of Typical_facility have a uniqueness clause even though Typical_facility also has a uniqueness clause. Delete the redundant SI from the subtypes.

C025 ERP_technical_reference

Create a new supertype of all subtypes of Technical_object which are also subtypes of Reference_behavior. Move common behavior to the supertype (i.e., identifier, description).

C026 ERP_subject_of_guideline_or_privilege

Eliminate Technical_object as a supertype of the subtypes of Subject_of_guideline_or_privilege and then drop it.

C027 ERP_association_reference

Create a new supertype of all subtypes of Association which are also currently subtypes of Reference_behavior. Note that a few subtypes of Technical_object have been included when they have two relationships (and no identifier) as part of their SI rule.

C028 ERP_naming_system

Eliminate the distinction between classification system and naming system. Add a parent/child relationship to the naming system in order to support the semantics of ref_classification_system. Add a many-to-one relationship to a new entity REF_ENTITY to allow an assertion that the identifiers in a naming system should be constrained to use with one entity. Add naming system to most aliasable entities (including ref_code). Adding naming system to reference entities will allow standard instance identifiers to be substituted by an alias identifier. The standard meaning is still provided by the standard instance but the 'name' can be interchanged.

C029 ERP_alias

Relate all aliasable entities to Object_alias. The semantics that something is a 'well alias' is provided by the fact that an instance of Well is being aliased.

C030 ERP_process_data

Move Process_data underneath E_and_data and make it the supertype of most things which are "created by" an activity.

C031 ERP_rock_feature_material_properties

Replicate the Material properties into Rock_feature.

C032 ERP_rock_feature_rock_properties

Because Rock_feature is no longer a subtype of Rock_material, replicate the Rock_material properties into Rock_feature.

C033 ERP_hole

Hole does not refer to the "usage" of the void. Move it to Rock_material.

C034 ERP_earth_feature_classification

Consolidate the classification of all of the subtypes of Earth_feature.

C035 ERP_object_association_class

Add new subtype of aliasable_technical_reference for those "classes" which qualify an association as opposed to an object. Note that this adds naming_system to object_abundance_class.

C036 ERP_object_ranking

Delete Object_ranking, Ranking_system and Relative_rank as being far too general to be semantically useful. If something is needed then it needs to be more narrowly defined at a lower level.

C037 ERP_identifier_only

Change attribute "name" to "identifier" in order to be consistent with other non-ref entities. At the same time, change the type to ndt_identifier.

C038 ERP_description_only

Most entities in Epicentre have a description attribute. About half of the subtypes of Technical_object and Association do not have this attribute. Note however that Transient_association does have it. Only a few subtypes of Property have the attribute. This change insures that ALL non-abstract entities will have the attribute. Instead of adding this attribute to E_and_p_data, it is being "replicated" at a lower level.

C039 ERP_facility_classification

This change creates a supertype of material and facility classes. Since a Facility is the "use" of a material in some role, a facility must be able to be classified based on the material nature of the usage.

C040 ERP_class_specialization

Add the capability for a class to be a specialization of one other class. Note that this is a specific variation of the existing class classification. The difference is that specialization asserts a "narrowing" of definition while class classification can now be constrained to assert a "conformance" to a definition.

C041 ERP_typical_material_subtypes

The changes to the material model have greatly reduced the significance of "typical" materials. The primary semantics that they might now provide will be any required "point" behavior as opposed to the "range" behavior available to classes. Delete all subtypes of typical material and move the semantics to material class. The new "specialization" capability in class classification will allow, for example, the class "isotype" to be the generalization of the class "C12". That is, classes will need to be created to represent the existing subtypes of typical.

C042 ERP_reference_behavior

: Replicate the Reference_behavior attributes instead of inheriting them. Drop most former subtypes of Reference_behavior and add the new the new entities which consolodate the former subtypes.

C043 ERP_eliminate_void_inverse

Add missing inverse attributes in order to make them visible and queryable. For REF entities, use the verb phrase to generate a generic description (i.e., similar to inverse relationships to properties).

C044 ERP_partially_deleted_relationships

Delete the forward side of attributes which were incompletely deleted by change #1051 in Epicentre V2.2.

C045 ERP_local_spatial_coordinate_system

Allow a Local_spatial_coordinate_system to be identified within a context. This is needed for parameterized coordinate systems such as measured depth systems within a wellbore and binset coordinate systems.

C046 ERP_gis_geometry

Add a GIS oriented geometry property which simply uses a list of real. Unless we are going to add a suite of manipulation functions to the DAE then this is just about as useful as adding specialized data type.

C047 ERP_object_kind

Allow most classifiable objects to have the fundamental nature of one class. Each leaf subtype (where the subtypes are considered to be incomplete) may specify that the "kind" is identifying on the instance. This replaces existing one to many relationships to typical_activity and to some REFs.

C048 ERP_wellbore_reference

Eliminate the concept of a Wellbore_reference. Instead, retain Wellbore_point and Wellbore_interval as subtypes of Wellbore_component_facility to represent interesting "named" point/interval facilities in the wellbore. Since the functionality has changed radically, this is logically equivalent to a delete/add.

C049 ERP_consistent_identifier_length

Make all identifier attributes the same length (80) and use the same NDT for all identifiers. Change the type of any remaining identifiers to ndt_identifier. Any renamed attributes were changed at the time that they were renamed. Any added attributes were properly defined when added. Do not alter non-identifying string attributes.

C050 ERP_change_rules

Fix parsing problems in where rules.

C051 ERP_fix_rules

Fix rules which are badly formed.

C052 ERP_interpreted_feature

Create interpreted_feature as the supertype of all interpreted objects.

C053 ERP_remove_many_to_many

Convert all remaining many-to-many relationships to an association entity. This will more easily allow local extensions to qualify the relationship. Where appropriate, the new entity will have a name derived from the relational projection intersection table.

C054 ERP_use_class_instead_of_typical

Utilize class instead of typical for object semantics. Utilize typical as an archetype for class.

C055 ERP_EPSG_coordinate_system

This change implements the recommendations of the EPSG.

C056 ERP_activity_drop_subtypes

Eliminate all subtypes of Activity and move any required behavior up to Activity. In order to capture most of the existing behavior, create Object_activity_involvement as a transient association between Activity and Object_of_interest.

C057 ERP_temporal_object

Eliminate all subtypes of Temporal_period and Temporal_event in order to bring this area in line with the geologic changes made in V2.2. Move Temporal_object from Topological_object to Aliasable_technical_object. This is because there does not appear to be any topological behavior which benefits the time concepts.

C058 ERP_rename_typical_geologic_process

Rename "typical" geologic to "class" in order to be more consistent with Activity terminology.

C059 ERP_add_common_composition

Add "common" composition.

C060 ERP_rename_pty_equipment_facility

Rename Pty_equipment_facility to describe its function rather than who it is "a property of". Moved the uniqueness to the supertype so that the identity of the property is independent of the representation.

C061 ERP_remove_void_many_to_many

Remove many-to-many which contained void. This change represents an adjustment to change ERP_eliminate_void_inverse.

C062 ERP_add_missing_ndt_descriptions

Add missing descriptions in ndt where rules.

C063 ERP_add_material_type_composition

Add subtypes of material composition to allow for composition of types. This change represents and adjustment to change ERP_equipment.

C064 ERP_classification_adjustments

DROP facility_material_class and replace it with explicit relationships with MSE rules. Allow an earth_feature to also be classified based on its material nature. This change represents adjustments to changes: ERP_typical_material_subtypes ERP_facility_classification ERP_adjustments

C065 ERP_pick_adjustments

Add rock_material to Interpreted_feature as an alternative to geologic_feature. Allow a wellbore_pick to be alternatively located by wellbore_point or wellbore_interval. Change Seismic_feature_classification to Seismic_pick_classification (i.e., seismic_pick replaced part of its semantics). These changes represent an adjustment to change ERP_interpreted_feature.

C066 ERP_data_collection

Make the data collection identifier and type attributes mandatory.

C067 ESM_field

This modification eliminates the subtypes of field to allow the lifecycle description of a field from prospect to abandonment. This is accomplished by eliminating the subtypes of field and making field non-abstract.

C068 ESM_ndt_cleanup

This combines several miscellaneous changes to the ndt specifications.

C069 ESM_business_object_remark

This change proposes a general remark entity for business objects. Each remark is dated as an optional part, which is included in the uniqueness clause (therefore, only 1 undated remark allowed). No capability is defined to order these remarks except for the date information. Proposed instances for ref_remark_type include: 'source' = 'A comment describing the source of the remark.' 'quality' = 'A remark that relates to the quality of the business object being described.' 'history' = 'Unstructured information concerning the history of the object.'

C070 ESM_contract_amendment

This change allows the instantiation of a contract amendment. Without this extension, the amendment has to be instantiated as a distinct kind of contract.

C071 ESM_derived_interest_object

This extension increases the scope of objects for which ownership interest may be described with derived interest makeup. Now technical objects may be owned.

C072 ESM_document_date

This change adds a date for each document_specification, giving the creation date of the document_specification (not the date loaded into the data store).

C073 ESM_document_spec_business_associate

This change provides the capability to define roles for business associates with respect to document specifications. This replaces the capability to define a business associate in a recorded document with a more general structure. The roles are provided in a new reference entity, in which instances like author, publisher, officer-in-charge, etc. should be defined. This should be an _open_ reference entity. This proposal specifically solves a problem for regulatory agencies who need to know which regulatory officer is assigned which license.

C074 ESM_library_facility

This change creates a subtype of GENERAL FACILITY for the storage of hardcopy documents.

C075 ESM_location_quality

This change adds an attribute to PTY_LOCATION_ACCURACY that provides a qualitative indication of location accuracy. The population of this indicator will have to be further refined.

C076 ESM_location_status

This change adds an attribute to PTY_LOCATION that provides a status of the location property.

C077 ESM_pipeline_diameters

This change adds explicit diameters to pipeline.

C078 ESM_probability_behavior

This change provides additional attributes to selected property entities for recording probability distribution curves.

C079 ESM_production_facilities

This change introduces several facilities that are useful in describing production facilities (compressor, lact_unit ,stock_tank, tank_battery, vapor_recovery_unit).

C080 ESM_recombined_fluid_sample

These modifications describe the changes proposed to improve the description of fluid samples (deleting pressurized sample and adding ability to describe new sample created from existing samples).

C081 ESM_ref_generic_fluid_type

This change allows each instance of ref_generic_fluid_component to be described as normally existing in a gaseous, liquid or solid state.

C082 ESM_ref_postal_code

This modification replaces the text form of postal codes with a validated set of postal codes.

C083 ESM_ref_water_depth_datum

This change provides the measurement datum for the water depth information.

C084 ESM_seismic_source_facility_width

This change adds additional descriptive attributes for a seismic source.

C085 ESM_subsurface_rock_segment

This change describes the missing intervals for a subsurface rock segment. It also provides indicator of ordering for repeating intervals.

C086 ESM_surface_cable

This change adds surface_cable as a new subtype to general_facility.

C087 ESM_preferred_spatial_representation

This change defines a flag that indicates that one instance of a spatial object is the preferred spatial representation of a locatable object.

C088 ESM_well_status

This modification removes the redundant entities that duplicate the behavior of facility classification. These entities were not removed when facility classification was introduced.

C089 ESM_well_pattern_participation_si

This removes a redundant uniqueness rule given for well pattern participation.

C090 ESM_wellbore_curvature

This change adds the ability to describe the curvature of a wellbore at a point or over an interval, such as the description of dogleg severity. To describe a wellbore as a whole, an interval over the entire wellbore is created.

C091 ESM_www_address

This extension provides an address subtype for the world wide web. The length of the URL is limited to 255 characters.

C092 ESM_effective_tubing_volume

This change adds the concept of effective tubing volume. This characteristic is used in transient pressure test analysis to estimate and correct for the effects of after-flow during shut-in tests and unloading during flow tests.

C093 ESM_fluid_flow_stream_contaminant

This change adds a new characteristic to fluid flow streams that describes the presence of contaminant in a fluid flow stream. The amount of contaminant is described as a property of association.

C094 ESM_geopolitical_boundary_and_border

This change adds specific entities to describe the borders and boundaries for geopolitical features.

C095 ESM_electronic_document_content

This extension adds an attribute to store the binary contents of an electronic document (i.e., the file itself).

C096 ESM_pty_isotope_ratio

This change defines a new characteristic for a component material type. This property a specific isotope ratio for a type of material within a sample.

C097 ESM_rock_fluid_feature_material

This change improves the description of the rock material in a rock fluid feature. The extension moves the relationship from rock fluid feature and rock feature to the supertype of rock feature (rock material). The definition of this relationship is also improved to indicate a parts and assembly relationship. The relationship from rock fluid feature to reservoir fluid system is improved to explicitly describe the concept of the fluid filling the rock material.

C098 ESM_text_location_reference

This extension defines the orientation point for a noncurved text element. When annotating a graphical representation, this defines the point in the text string at which the location is specified.

C099 ESM_well_log_trace_mnemonic

This change allows the capture of the trace mnemonic for a well log trace. These are currently loaded into Epicentre as well_log_trace_aliases after a change proposed by POSC for v222. This proposal refines that change.

C100 ESM_wellbore_point_and_interval_

These are several changes to simplify and improve the description of points and intervals within a wellbore.

C101 ESM_earth_model_kind

This extension provides a strong typing for an earth model. This attribute is intended to describe the primary purpose for which the earth model was created or is to be used.

C102 ESM_forchheimer_coefficient

This change adds the forchheimer coefficient to the other forms describing non-Darcy flow.

C103 ESM_geochemical_properties

These are a series of new properties that are needed for geochemical analysis.

C104 ESM_geologic_age_uncertainty

This change defines an optional uncertainty value for geologic age in pty_geologic_age.

C105 ESM_geologic_feature_class

This change allows any geologic feature to be the archetype for a material_class.

C106 ESM_geologic_feature_exist_probability

This change adds a general description of existence probability for geologic features.

C107 ESM_wellbore_location_confidence

This change adds an attribute to PTY_LOCATION_ACCURACY that describes the confidence level used to evaluate the confidence level of the accuracy description. Also, a default confidence level is added to PTY_EDGE_GEOMETRY_UNCERTAINTY to suggest how uncertainty realizations should be generated.

C108 ERP2_fix_typos

Fix typos found using a spell checker.

C109 ERP2_EPSG_coordinate_system

Apply additional EPSG recomendations.

C110 ERP2_add_potential_field

Add the Field Bank Potential Field model.

C111 ERP2_drop_parent_class

Drop attribute parent_class from the uniqueness of classes.

C112 ERP2_shorten_names

Shorten entity and attribute names from a maximum of 40 characters to a maximum of 30 characters. This will bring the logical model more in line with available physical engines.

C113 ERP2_add_objective

Add Objective as a subtype of Guideline_or_privilege and Objective_set as a subtype of Document_specification. Create Ref_guideline_or_priviledge as the supertype of all "types" of guidelines and privilege and move the "subject of" relationship from Guideline_or_privilege to Ref_guideline_or_priviledge. That is, classes may be related to types rather than specifics. Rename Ref_guideline_compliance_stat to Ref_guideline_compliance so that compliance characterizations other than status may be defined.

C114 ERP2_material_installation

Remove references to activity from the relationship between material_installation and material.

C115 ERP2_data_trace

Move seismic_data_set to be a subtype of data_trace. Rename well_log_trace_class, well_log_trace_classification, well_log_trace_class_clsn and well_log_trace_alias to refer to data trace instead of well log trace. Add kind to data_trace and add it to the uniqueness of the subtypes. Add entity Common_data_trace_property in order to capture the ELEMENT properties which are associated with each class. Drop Synthetic_log_trace and move the optional "feature" relationship to Well_log_trace.

C116 ERP2_fix_ndt_documentation

Add NDT documentation which was inadverdently eliminated by the parser in the alpha version.

C117 ERP2_description

Move attribute description up to E_and_p_data.

C118 ERP2_ref_wellbore

This deletes ref_wellbore as this duplicates wellbore.kind.

C119 ERP2_wellbore_trajectory_shape

This removes an attribute that is redundant to facility classification.

C120 ERP2_fluid_saturation

This generalizes the description of fluid saturations in rock materials and reservoirs.

C121 ERP2_drop_pfnu_period_performance_report

This removes the alternative production report.

C122 ERP2_cleanup

Add missing inverse relationships. Eliminate SELF redeclarations which were obviated by conversion from m-m relationships. Add missing verb phrases. Change the "be a property of" relationship from properties to rock_feature to be optional instead of mandatory.

C123 ERP2_composition

Make the material, facility and activity composition behavior consistent. Add more composition behavior.

C124 ERP2_property_type

This change reworks the ref property type/kind part of the model as shown on diagram 'MTP: Reference Properties'. The purpose is to simplify the type/kind specification and to add the capability of capturing the information which is contained in the NDT specifications. The kind of property will be independent of any possible representations. Replace many-to-many relationships with intersection entity. Add an optional mechanism to specialize/classify kinds.

C125 ERP2_generic_property

Add new subtypes of pty_generic_property. Add a reciprocal relationship on Property which asserts that one property is an equivalent representation of another property. Move the existing relationships up to material and facility.

C126 ESM2_data_information

These changes provide additional 'meta' information on the instantiation state of the data store. This includes indicators for the current valid instance for transient associations, creation and last update information, the content provider for data, and the geographic distribution of naming systems.

C127 ESM2_location_source

This extension adds an attribute to PTY_LOCATION that provides the content source of the location information.

C128 ESM2_fluid_phase_properties

This change alters the current PVT model for fluid phase properties. The existing model is very difficult for both reading and writing due to: * separation of point and curve data into separate instances * disconnected instances for properties that are measured together * excessive coordinate system requirements (e.g., must have temperatures) This proposal uses the concepts developed within the SAVE project to combine multiple, concurrently defined properties in the same property instance. A similar concept was also proposed during the PPDM-POSC data model merger investigation (i.e., aggregate properties). The resulting PVT model is much easier to implement, populate and query. Also, this satisfies POSC change requests 1086 and 1224.

C129 ESM2_grid_convergence

This extension defines grid convergence at a point on the Earth. This is the angular deviation between the local grid north and true north at a point.

C130 ESM2_sample_fluid_system

This allows the description of the fluid samples that are extracted from each fluid system. This may be used to describe the samples that are extracted from other fluid samples, as well.

C131 ESM2_seismic_facility_desc

This extension adds the recording time delay for a seismograph.

C132 ESM2_fluid_cargo

The concept of a cargo describes a discrete amount of material which is stored and/or transported, probably being the subject of a contract.

C133 ESM2_earth_feature

This modification reorganizes the subtypes of earth_feature. The goals of this change is to eliminate the multiple inheritance created as part of the license_and_lease change proposal. This also adds an exploration area. It also insures that all subtypes of earth_feature have another feature as part of its identity.

C134 ESM2_license_and_lease

This modification merges the surface and mineral (subsurface) concepts for agreements and rights. This is done to accomodate business practices in which subsurface parts of the earth are referenced as if they were surface parts. Extensions included in this change include classification of license rights and license right payments.

C135 ESM2_offshore_block

This change clarifies the representation of offshore blocks, and adds offshore areas and quadrants.

C136 ESM2_structured_documents

This proposal adds the capability to describe the content and structure of document specifications. This provides a description of the structure of a document based upon a subset of features in XML Schema.

C137 ERP3_cleanup

This applies miscellaneous cleanup changes to the beta version. Move relationship from the subtypes of pty_azimuth up to pty_azimuth so that the relationship can participate in the uniqueness. Make data_value mandatory in properties when that is the only attibute. Add the description back to ndt_acceleration_linear. Drop ref_element_kind since it is redundant to the new ndt_element_type. Add missing rule types. Drop unused NDTs.

C138 ERP3_verb_phrase

Add verb phrases for relationships to REF entities. These originally did not have verb phrases because of the way they were treated in the Oracle case tool.

C139 ERP3_add_missing_inverse

Fix missing inverse relationships.

C140 ERP3_reference_data

Insure that associations between reference data is also reference data.

C141 ERP3_mandatory_set

Convert SET[1:?] to SET[0:?] and add rule which makes the attribute mandatory. This affects only inverse attributes which were formerly mandatory many-to-many.

C142 ERP3_reference_population

Properly set the population codes (i.e., local, open, fixed) for some entities. Eliminate population code for entities for which standard instances are questionable.

C143 ERP3_fix_spatial_predicate

This change adds some omitted spatial predicates to the enumeration. It also updates the documentation to refer to the new attributes.

C144 ERP3_well_log_trace_mnemonic

This change attempts to do a better job of handling well log trace mnemonics which were stored in Well_log_trace_alias in V2.2.

C145 ERP3_eliminate_list

This change eliminates all remaining LISTs.

C146 ERP3_naming_system_optional

Change the naming system from mandatory to optional in Facility. This will make it consistent with all other objects.

C147 ERP3_drop_redundant_status

Drop the well completion status entities since they are redundant to facility class and classification. Drop the application status and contract status entities since they are redundant to document specification class and classification.

C148 ERP3_EPSG_coordinate_system

This set of changes finalizes the convergence with the EPSG v5 data.

C149 ERP3_more_cleanup

Make some final cleanup as identified during loading and testing.

C150 ERP3_ndt_azimuth

Alter ndt_azimuth to use QUANTITY instead of POINT. Knowledge of the point is generally carried by the "object".

C151 ERP3_cleanup_final

This applies final cleanup changes to the beta version. Fix SI rule for a class entity. Drop or fix some rules. Fix ndt_de9im. Change BAG[0:1] to SET[0:1]. Change the population status of some reference entities.

C152 _ERP4_Default_Entity_Projection

This change sets the default entity projection types for entities. The default is for entites with an SI rule to become tables. Supertypes of those entities will be replicated and subtypes of those entites will be consolidated. Note that this change will not appear as a change to entities in the logical model documentation.

C153 _ERP4_Default_Names_for_Projection

This change sets the default projection name to match the logical name. This necessary in order to override any residual names from V2.2. Note that this change will not show up as a change to the entities or attributes in the logical model documentation.

C154 _ERP4_Long_to_Short_Names_for_Projection

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).

C155 _ERP4_Natural_Keys_for_Projection

This change defines candidate entities for using natural keys instead of surrogate keys for foreign keys to the specified tables. The setting is set to "yes" for all entities which are a subtype of ref_code (i.e., have a single component in its uniqueness rule that has a type of STRING and is a mandatory attribute). All other entities are set to "no" with the exception of entity naming_system which is set to "yes". Note that a natural key will only be used if the relationship is directly to the specified entity (i.e., not inherited) and the entity becomes a table (i.e., not consolidated or replicated). Otherwise, a surrogate key will be used. Note that this change will not be listed as a change to the entities in the documentation.

C156 _ERP4_Entity_Projection_Method

This change alters the previously defined "default" point in the hierarchy where a table is created. All of its subtypes below the new point will now consolidate to the supertype while all of the subtypes above the new point will be replicated. This change attempts to replicate the projection points which were implemented in V2.2.

C157 _ERP4_Entity_Projection_Method_cont

This defines more changes to the previously defined "default" point in the hierarchy where a table is created. All of its subtypes below the new point will now consolidate to the supertype while all of the subtypes above the new point will be replicated. This change adds points which are new for V3.0.

C158 ERP5_new_type_definitions

This change alters the model to conform to the new V2.3 methodology. These are the minimal changes required. There is no attempt to take advantage of new capatilities.


Generated on Tue Jul 10 14:09:15 2001
© Copyright 2001 POSC. All rights reserved.