An identified flow stream from or to a well. This is an isolated conduit to/from the surface from/to one or more sets of perforations or open hole intervals. Each completion represents a distinct physical arrangement within a well which provides for the production or injection of fluids from a geologic object, such as a reservoir.

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

Surrogate key of the table.


well_completion_id (M: CHAR VARYING(40))

well_completion.identifier
An identifier for a completion within a well, often a sequential number.


r_existence_kd_nm (FNK, M: CHAR VARYING(40))

facility.ref_existence_kind
The existence kind for the facility e.g. actual, planned, required or predicted.
Defines a foreign key to table r_existence_kd.


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

well_completion.well
Specifies the well in which this completion is installed.
Defines a foreign key to table well.


well_id (O: CHAR VARYING(40))

well.identifier
A unique identifying name for the well.
This column has been duplicated through attribute well_completion.well, which establishes the relationship between the original and duplicated column(s).
This column is a duplicate of column well.well_id.


abandonment_date (O: TIMESTAMP)

well_completion.abandonment_date
This is the date and time of day that this well completion was permanently removed from service.


completion_date (O: TIMESTAMP)

well_completion.completion_date
This is the date that the activities that created this well completion were completed and the well completion was available for service.


description (O: CHAR VARYING(2000))

facility.description
A description of the facility.


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

well_completion.completion_string
Specifies the completion string utilized by this well completion.
Defines a foreign key to table wellbore_tubular.


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

well_completion.mineral_zone
Specifies the mineral zone to which a well completion is assigned.
Defines a foreign key to table mineral_zone.


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

facility.typical_facility
Gives the typical facility whose specification was used as the generic basis for this facility.
Defines a foreign key to table typical_fcl.