POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
Estimated volumes of crude oil, condensate, natural gas, natural gas liquids, and associated substances anticipated to be commercially recoverable from known accumulations from a given date forward, under existing economic conditions, by established operating practices, and under current government regulations. Reserves estimates are based on interpretations of geologic and/or engineering data available at the time of the estimate. Reserves do not include volumes of crude oil, condensate, natural gas, or natural gas liquids being held in inventory. If required for financial reporting or other special purposes, reserves may be reduced for on-site usage and/or processing losses.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- 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).
- fluid_component_s (FSK, M: CHAR VARYING(19))
fluid_component_t (M: CHAR VARYING(30))
- reserves.fluid_component
This specifies the fluid component being quantified by this description of reserves. This is where the crude oil or natural gas is identified as the material being described.
fluid_component_s: Implements a foreign key to a row in one of the tables projected from entity fluid_component depending on the value of the next column (See below).
fluid_component_t: Defines the name of the referenced table. Possible values are: bulk_material, r_generic_fluid_component (@fluid_component).
- pfnu_s (FSK, M: CHAR VARYING(19))
pfnu_t (M: CHAR VARYING(30))
- reserves.pfnu
Indicates the facility for which reserves are estimated.
pfnu_s: Implements a foreign key to a row in one of the tables projected from entity pfnu depending on the value of the next column (See below).
pfnu_t: Defines the name of the referenced table. Possible values are defined in @pfnu.
- reserves_category_s (FSK, M: CHAR VARYING(19))
- reserves.reserves_category
This is the definitive classification of reserves that defines its fundamental meaning. This always points to a reserves_class defined within a formal hierarchy, usually be a governmental agency or standards organization. Additional reserves_classifications are intended to provide additional characterizations without changing this fundamental meaning.
Defines a foreign key to table reserves_class.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- effective_date (O: DATE)
- reserves.effective_date
The date at which the reserves definition becomes effective.
- expiry_date (O: DATE)
- reserves.expiry_date
The date at which the reserves definition expires.
- 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.
- 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".
- approved_by_s (FSK, O: CHAR VARYING(19))
- reserves.approved_by
The business associate charged with approving the classification of reserves and the validation of reserves estimate values.
Defines a foreign key to table business_associate.
- r_recovery_process (FNK, O: CHAR VARYING(80))
- reserves.ref_recovery_process
The classification of the recovery process that was assumed for the estimation of the reserves, such as: natural reservoir energy, pressure maintenance, cycling, water flooding, thermal methods, chemical flooding, and miscible or immiscible displacement.
Defines a foreign key to table r_recovery_process.
Table is related to: contract_object_designation, contract_oblig_object_fulfil, data_collection_content, derived_interest_makeup, document_specification_part, @graphical_element, guideline_compliance, object_activity_involvement, object_remark, object_subject_to_guideline, p_standard_volume_gas, p_standard_volume_liquid, reserves_category_change, reserves_classification, reserves_sale_commitment, subject_of_contract
Primary Key Constraint on: INSTANCE_S
Fully implemented Unique Constraint on: PFNU_S, PFNU_T, FLUID_COMPONENT_S, FLUID_COMPONENT_T, RESERVES_CATEGORY_S
Generated on Tue Jul 10 16:56:40 2001
© Copyright 2001 POSC. All rights reserved.