The volumetric rate per unit pressure change multiplied by the viscosity of the flowing fluid. This defines a fluid independent productivity index.

p_sp_prod_idx_s (PK, M: CHAR VARYING(19))

Surrogate key of the table.


data_value (M: FLOAT)
data_value_u (FNK, M: CHAR VARYING(15))

pty_specific_productivity_index.data_value
The value of the specific productivity index.
data_value_u: Defines the unit of measure. Defines a foreign key to table r_uom.


end_time (O: TIMESTAMP)

pty_transient_property.end_time
The date and time of day designated as the end of the valid or effective time interval over which the property applies.


preferred_flag (O: CHAR(1))

property.preferred_flag
The flag is set to True if this instance of property is the preferred value in this data store of this type of property for the object which this property describes.


start_time (O: TIMESTAMP)

pty_transient_property.start_time
The date and time of day that designated the start of the valid or effective time interval over which the property applies.


activity_s (FSK, O: CHAR VARYING(19))
activity_t (O: CHAR VARYING(16))

process_data.activity
Defines the activity which created this instance.
activity_s: Implements a foreign key to a row in one of the tables projected from entity activity depending on the value of the next column (See below).
activity_t: Defines the name of the referenced table. Possible values are defined in @activity.


other_sptl_obj_s (FSK, O: CHAR VARYING(19))
other_sptl_obj_t (O: CHAR VARYING(16))

property.other_spatial_object

other_sptl_obj_s: Implements a foreign key to a row in one of the tables projected from entity other_spatial_object depending on the value of the next column (See below).
other_sptl_obj_t: Defines the name of the referenced table. Possible values are defined in @other_spatial_object.


r_transient_pd_nm (FNK, O: CHAR VARYING(40))

pty_transient_property.ref_transient_period
The type of period over which the property applies, such as day, month, quarter, cumulative, etc.
Defines a foreign key to table r_transient_pd.


rock_fluid_ftr_s (FSK, O: CHAR VARYING(19))
rock_fluid_ftr_t (O: CHAR VARYING(16))

pty_specific_productivity_index.rock_fluid_feature

rock_fluid_ftr_s: Implements a foreign key to a row in one of the tables projected from entity rock_fluid_feature depending on the value of the next column (See below).
rock_fluid_ftr_t: Defines the name of the referenced table. Possible values are: aquifer, pool, reservoir, reservoir_part (@rock_fluid_feature).


well_s (FSK, O: CHAR VARYING(19))

pty_specific_productivity_index.well

Defines a foreign key to table well.


well_cmpl_s (FSK, O: CHAR VARYING(19))

pty_specific_productivity_index.well_completion

Defines a foreign key to table well_completion.


well_cmpl_seg_s (FSK, O: CHAR VARYING(19))

pty_specific_productivity_index.well_completion_segment

Defines a foreign key to table borehole_cmpn.