POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
The calculated flow stream of a fluid component resulting from the production allocation process. These rates and volumes are defined in terms of standard volumes rather than phase volumes, and contain histories for cumulative production and injection, daily and monthly rates, etc.
- 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))
- allocated_flow_stream.fluid_component
This is the fluid component being described by the allocated flow stream. This is usually a chemically homogeneous material for which consistent physical properties amy be known. For example, this may be the "A7/35 oil" from a reservoir "A7" which is in turn classified as a crude oil.
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_port_s (FSK, M: CHAR VARYING(19))
- fluid_flow_stream.pfnu_port
This is the port at which this fluid flow stream is defined.
Defines a foreign key to table pfnu_port.
- 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.
- 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".
Table is related to: contract_object_designation, contract_oblig_object_fulfil, data_collection_content, derived_interest_makeup, document_specification_part, fluid_flow_stream_allocation, fluid_flow_stream_contaminant, @graphical_element, guideline_compliance, object_activity_involvement, object_remark, object_subject_to_guideline, p_basic_sediment_and_water, p_curve_fit_result, p_decline_curve, p_economic_limit, p_fluid_component_ratio, p_standard_volume_gas, p_standard_volume_gas_rate, p_standard_volume_liquid, p_standard_vol_liquid_rate, p_transient_cal_value_gas, p_transient_density_liquid, p_transient_density_vapor, p_transient_energy, p_transient_mass, subject_of_contract
Primary Key Constraint on: INSTANCE_S
Fully implemented Unique Constraint on: PFNU_PORT_S, FLUID_COMPONENT_S, FLUID_COMPONENT_T
Generated on Tue Jul 10 16:01:43 2001
© Copyright 2001 POSC. All rights reserved.