| POSC Specifications Version 2.2 |
Epicentre 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.
- reserves_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- fluid_component_s (FSK, M: CHAR VARYING(19))
fluid_component_t (M: CHAR VARYING(16))
- 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: r_gnc_fl_cmpn, specific_fl_cmpn (@fluid_component).
- pfnu_s (FSK, M: CHAR VARYING(19))
pfnu_t (M: CHAR VARYING(16))
- reserves.product_flow_network_unit
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 product_flow_network_unit depending on the value of the next column (See below).
pfnu_t: Defines the name of the referenced table. Possible values are defined in @product_flow_network_unit.
- reserves_cat_s (FSK, M: CHAR VARYING(19))
- reserves.reserves_category
This is the definitive classsification of reserves that defines its fundamental meaning. This always points to a reserves_class defined by within a formal heirarchy, 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))
- reserves.description
A remark about the reserves estimate.
- 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.
- 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 bsasc.
- r_recovery_proc_nm (FNK, O: CHAR VARYING(40))
- 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, waterflooding, thermal methods, chemical flooding, and miscible or immiscible displacement.
Defines a foreign key to table r_recovery_proc.
Table is related to: dae_frame, derv_int_mkup, @graphical_element, gdln_priv_com, object_ranking, parameter_value, p_std_vol_gas, p_std_vol_lq, reserve_cat_chg, reserves_clsn, rsv_sale_cmmt
Intersection Tables: subj_of_ctrt_x, ctrt_obl_obj_x, ctrt_dsgn_obj_x, coll_cntn_x, business_obj_x
Primary Key Constraint on: RESERVES_S
Fully implemented Unique Constraint on: PFNU_S, PFNU_T, FLUID_COMPONENT_S, FLUID_COMPONENT_T, RESERVES_CAT_S
Generated on Mon Dec 1 10:20:04 1997
© Copyright 1997 POSC. All rights reserved.