POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
This describes the calculated, anticipated or scheduled flow streams and performance projections from reservoir simulation, decline curve analysis, or other predictive techniques. This also defines quotas, budgets and other non-allowable estimates for which histories and projections need to be kept.
- 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).
- 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.
- identifier (O: CHAR VARYING(80))
- evaluated_flow_stream.identifier
An identifier for the target performance profile.
- 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".
- fluid_component_s (FSK, O: CHAR VARYING(19))
fluid_component_t (O: CHAR VARYING(30))
- evaluated_flow_stream.fluid_component
This is the fluid component for which this fluid flow stream may be defined. If a fluid phase is also defined, the fluid flow stream is this fluid component within the fluid phase.
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).
- fluid_phase_s (FSK, O: CHAR VARYING(19))
fluid_phase_t (O: CHAR VARYING(30))
- evaluated_flow_stream.fluid_phase
This is the fluid phase defined for this evaluated flow stream. If a fuid component is also defined, then the flow stream describes that component in this fluid phase.
fluid_phase_s: Implements a foreign key to a row in one of the tables projected from entity fluid_phase depending on the value of the next column (See below).
fluid_phase_t: Defines the name of the referenced table. Possible values are defined in @fluid_phase.
- kind (FNK, O: CHAR VARYING(80))
- evaluated_flow_stream.kind
The kind of evaluated fluid flow stream, such as budget, estimate, reservoir simulation prediction, reservoir simulation history match, etc.
Defines a foreign key to table r_evaluated_flow_stream.
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_curve_fit_result, p_decline_curve, p_economic_limit, p_fluid_component_ratio, p_fluid_phase_ratio, p_inflow_performance_ratio, p_standard_volume_gas, p_standard_volume_gas_rate, p_standard_volume_liquid, p_standard_vol_liquid_rate, p_transient_energy, subject_of_contract
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 16:21:05 2001
© Copyright 2001 POSC. All rights reserved.