POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
These are the PVT properties of an oleic fluid defined at given pressures, temperatures and bubble point pressures. The pressure, temperature and bubble point values are optional but should always be recorded, if available. When the bubble point is not defined, it is assumed that the fluid is saturated (that is, the bubble point pressure is the fluid pressure). When the bubble point is less than the fluid pressure, the fluid is undersaturated.
- 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_phase_oleic_s (FSK, M: CHAR VARYING(19))
- fluid_phase_oleic_pvt.fluid_phase_oleic
This is the oleic fluid phase for which these PVT properties are defined.
Defines a foreign key to table fluid_phase_oleic.
- bubble_point (O: FLOAT)
bubble_point_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.bubble_point
The saturation pressure of the fluid. The pressure of a liquid phase fluid system when it is in equilibrium with an infinitesimal amount of vapor phase.
bubble_point_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- compressibility (O: FLOAT)
compressibility_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.compressibility
The measure of the change in volume of a fluid with respect to a unit change in pressure; expressed as a positive value for fluids that shrink as pressure is increased.
compressibility_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- density (O: FLOAT)
density_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.density
Mass per unit volume of a fluid.
density_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- formation_volume_factor (O: FLOAT)
formation_volume_factor_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.formation_volume_factor
The ratio of the volume occupied by a quantity of oleic phase at reservoir conditions to that occupied by the same quantity at stock tank or standard conditions. This is the inverse of the shrinkage factor.
formation_volume_factor_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- gas_oil_pseudo_pressure (O: FLOAT)
gas_oil_pseudo_pressure_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.gas_oil_pseudo_pressure
The real gas potential of a fluid that accounts for the presence of both oil and gas.
gas_oil_pseudo_pressure_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- 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.
- molar_density (O: FLOAT)
molar_density_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.molar_density
The ratio of the number of moles to the molar volume for a fluid.
molar_density_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- pressure (O: FLOAT)
pressure_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.pressure
This is the pressure at which these PVT properties are defined.
pressure_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- shrinkage_factor (O: FLOAT)
shrinkage_factor_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.shrinkage_factor
The ratio of the volume occupied by a quantity of oil at standard conditions to that occupied by the same quantity at reservoir conditions. This is the inverse of the formation volume factor.
shrinkage_factor_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- solution_gas_oil_ratio (O: FLOAT)
solution_gas_oil_ratio_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.solution_gas_oil_ratio
The amount of natural gas contained in crude oil expressed as a ratio of volumes at standard temperature and pressure.
solution_gas_oil_ratio_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- 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".
- specific_molar_volume (O: FLOAT)
specific_molar_volume_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.specific_molar_volume
A specific volume of a fluid given as a mole basis.
specific_molar_volume_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- specific_volume (O: FLOAT)
specific_volume_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.specific_volume
A specific volume of a liquid given as a mass basis.
specific_volume_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- temperature (O: FLOAT)
temperature_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.temperature
This is the temperature at which these PVT properties are defined.
temperature_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- total_formation_volume_fact (O: FLOAT)
total_formation_volume_fact_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.total_formation_volume_factor
The ratio of the volume occupied by a quantity of oleic phase at reservoir conditions to that occupied by the same fluid at stock tank or standard conditions, including the volume of the evolved gas.
total_formation_volume_fact_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- viscosity (O: FLOAT)
viscosity_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.viscosity
This describes the (dynamic) viscosity of a fluid.
viscosity_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- viscosity_kinematic (O: FLOAT)
viscosity_kinematic_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.viscosity_kinematic
The dynamic viscosity of a fluid divided by the density of the fluid.
viscosity_kinematic_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- viscous_compressibility (O: FLOAT)
viscous_compressibility_u (FNK, O: CHAR VARYING(15))
- fluid_phase_oleic_pvt.viscous_compressibility
The change in viscosity of a fluid with pressure divided by the original viscosity.
viscous_compressibility_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- y_factor (O: FLOAT(6))
- fluid_phase_oleic_pvt.y_factor
A dimensionless compressibility factor used to correlate and smooth laboratory measurements.
- activity_s (FSK, O: CHAR VARYING(19))
- process_data.activity
Defines the activity which created this instance.
Defines a foreign key to table activity.
- fluid_property_set_s (FSK, O: CHAR VARYING(19))
- fluid_phase_oleic_pvt.fluid_property_set
This is the fluid property set within which these fluid property values are a part.
Defines a foreign key to table fluid_property_set.
Table is related to: data_collection_content, document_specification_part, @graphical_element, process_data_item
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 16:26:24 2001
© Copyright 2001 POSC. All rights reserved.