POSC Specifications: Epicentre Version 3.0 | Logical Data Model |
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.
CHANGE ERP3_drop_redundant_status (*<REMARK> CHANGE ERP3_drop_redundant_status *) (*<CHANGE> 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. *) DROP ENTITY ref_completion_status; DROP ENTITY well_completion_status; ALTER ENTITY well_completion; INVERSE DROP well_completion_status; END_ENTITY; DROP ENTITY ref_application_status; DROP ENTITY application_status; ALTER ENTITY application_for_permit; INVERSE DROP application_status; END_ENTITY; DROP ENTITY ref_contract_status; DROP ENTITY contract_status; ALTER ENTITY contract; INVERSE DROP contract_status; END_ENTITY; END_CHANGE;