POSC Specifications: Epicentre Version 3.0 | Logical Data Model |
This change eliminates all remaining LISTs.
CHANGE ERP3_eliminate_list (*<REMARK> CHANGE ERP3_eliminate_list *) (*<DESC> This change eliminates all remaining LISTs. *) DROP ENTITY contract_remark (*<CHANGE>Redundant to Object_remark.*); ALTER ENTITY business_associate; INVERSE ALTER contract_remark AS author_of_remark ALTER TYPE AS object_remark (*<DESC>Indicates various remarks authored by this business associate.*); END_ENTITY; ALTER ENTITY contract; INVERSE DROP contract_remark; END_ENTITY; ALTER ENTITY object_remark; ADD business_associate : OPTIONAL business_associate (*<DESC>Specifies the author of this remark.*) (*<VERB>be made by*); END_ENTITY; ALTER ENTITY guideline_or_privilege; ALTER guideline_or_privilege_remedy ALTER INVERT ALTER AGGREGATE AS SET (*<DESC>These are the remedies specified in case this guideline or privilege is violated. Each remedy defines a class of activity to be completed and may have data values relating to that activity.*); END_ENTITY; ALTER ENTITY guideline_or_privilege_remedy; ADD apply_order : OPTIONAL ndt_pint4 (*<DESC>This is the relative order in which the remedy is to be applied. A remedy with an order of one should be applied before a remedy with an order of two.*); INVERSE ALTER guideline_or_privilege ALTER INVERT DROP OPTIONAL; END_ENTITY; ALTER ENTITY regulation; ALTER regulation_clause ALTER INVERT ALTER AGGREGATE AS SET DROP UNIQUE; END_ENTITY; ALTER ENTITY regulation_clause; ADD occurrence_order : OPTIONAL ndt_pint4 (*<DESC>This is the relative order of the clause within the regulation. A clause with an order of one occurs before a clause with an order of two.*); INVERSE ALTER regulation ALTER INVERT DROP OPTIONAL; END_ENTITY; ALTER ENTITY wellbore_component_facility; ALTER component_parts ALTER INVERT ALTER AGGREGATE AS SET DROP UNIQUE (*<DESC>This points to the wellbore_component_facilities that this assembly is made up from. The order in which the wellbore_component_facilities were assembled is defined by attribute component_order. Facilities which are next to each other in the list can be interpreted as being connected to each other. The order is; the first in the list was first in the hole, i.e. is nearest the bottom of the well.*); ADD component_order : OPTIONAL ndt_pint4 (*<DESC>This is the relative order of the component within the assembly. A component with an order of one is "next to" a component with an order of two. An order of one is first in the hole , i.e. is nearest the bottom of the well.*); INVERSE ALTER belongs_to_assembly ALTER INVERT DROP AGGREGATE ADD OPTIONAL; WHERE ADD val : (EXISTS(belongs_to_assembly) AND EXISTS(component_order)) OR (NOT (EXISTS(belongs_to_assembly)) AND NOT (EXISTS(component_order))) (*<DESC>For each instance, either both of belongs_to_assembly and component_order must be given or neither may be given but not one or the other.*) (*<RULETYPE>val*); END_ENTITY; END_CHANGE;