POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
A collection of land parcels and other assets which are offered for sale to prospective purchasers. These may include onshore leases, offshore blocks or concessions, or the equipment associated with drilling rigs, platforms, or pipelines, for example.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- identifier (M: CHAR VARYING(80))
- divestment_package.identifier
The uniquely identifying name assigned to a given divestment package.
- instance_create_date (O: TIMESTAMP)
- e_and_p_data.instance_create_date
This is the date that this instance was created. This date is defined by the source if imported, or is the date the instance is created if a new instance.
- last_updated (O: TIMESTAMP)
- e_and_p_data.last_updated
This is the date that this instance was last updated. This value should be updated when any part of this instance is altered (except for inverse relationships).
- closing_date (O: DATE)
- divestment_package.closing_date
The date at which a sale is executed.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- instance_creator (O: CHAR VARYING(80))
- e_and_p_data.instance_creator
This is the person, company or application that created this instance. This identifies the party responsible for loading this instance.
- last_updated_by (O: CHAR VARYING(80))
- e_and_p_data.last_updated_by
This records the person or application making the update to this instance.
- response_due_date (O: DATE)
- divestment_package.response_due_date
The date that a response to an offer is due.
- sale_date (O: DATE)
- divestment_package.sale_date
The date that a sale is scheduled for completion.
- sale_effective_date (O: DATE)
- divestment_package.sale_effective_date
The date that a sale is declared to be effective, which may be other than the sale date or the closing date.
- sale_offer_date (O: DATE)
- divestment_package.sale_offer_date
The date at which the offer of sale is made.
- source (O: CHAR VARYING(80))
- e_and_p_data.source
The provider of this instance, which is usually a data provider for imported/purchased data. If this instance is provided by POSC, then this attribute must be "POSC".
- part_of_s (FSK, O: CHAR VARYING(19))
- divestment_package.part_of
This designates the (larger) divestment package that the current divestment package is a part of.
Defines a foreign key to table divestment_package.
- r_sale (FNK, O: CHAR VARYING(80))
- divestment_package.ref_sale
The classification of a particular sale by sale type.
Defines a foreign key to table r_sale.
Table is related to: contract_object_designation, contract_oblig_object_fulfil, data_collection_content, derived_interest_makeup, divestment_equipment_inclusion, divestment_package, divestment_right_inclusion, document_specification_part, @graphical_element, guideline_compliance, object_activity_involvement, object_remark, object_subject_to_guideline, subject_of_contract
Primary Key Constraint on: INSTANCE_S
Fully implemented Unique Constraint on: IDENTIFIER
Generated on Tue Jul 10 16:15:23 2001
© Copyright 2001 POSC. All rights reserved.