POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
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.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- identifier (M: CHAR VARYING(80))
- facility.identifier
The name of the facility.
- 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).
- r_existence_kind (FNK, M: CHAR VARYING(80))
- 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_kind.
- 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.
- abandonment_date (O: TIMESTAMP)
abandonment_date_cd (O: CHAR(1))
abandonment_date_yr (O: FLOAT)
abandonment_date_yp (O: INTEGER)
abandonment_date_dy (O: INTEGER)
abandonment_date_hr (O: INTEGER)
abandonment_date_mt (O: INTEGER)
abandonment_date_st (O: FLOAT)
abandonment_date_of (O: FLOAT)
- 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)
completion_date_cd (O: CHAR(1))
completion_date_yr (O: FLOAT)
completion_date_yp (O: INTEGER)
completion_date_dy (O: INTEGER)
completion_date_hr (O: INTEGER)
completion_date_mt (O: INTEGER)
completion_date_st (O: FLOAT)
completion_date_of (O: FLOAT)
- 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))
- e_and_p_data.description
A remark or comment about the instance.
- 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".
- completion_string_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.
- kind_s (FSK, O: CHAR VARYING(19))
- facility.kind
The class which asserts the fundamental nature of the facility.
Defines a foreign key to table facility_class.
- 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.
- naming_system (FNK, O: CHAR VARYING(80))
- facility.naming_system
The naming system in which the identifier is specified and determined to be unique.
Defines a foreign key to table naming_system.