The ratio of flow rate to pressure drop. Used for oil wells, PI is the barrels of oil produced per day per psi decline in bottomhole flowing pressure.

p_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_productivity_index.data_value
The value of the 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.


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

pty_productivity_index.pfnu_grid_cell_connection

Defines a foreign key to table pfnu_grid_con.


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.


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

pty_productivity_index.temporary_completion

Defines a foreign key to table borehole_cmpn.


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

pty_productivity_index.well

Defines a foreign key to table well.


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

pty_productivity_index.wellbore_measurement_point

Defines a foreign key to table wellbore_meas_pt.


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

pty_productivity_index.well_completion

Defines a foreign key to table well_completion.


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

pty_productivity_index.well_completion_segment

Defines a foreign key to table borehole_cmpn.