POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
A distinct volume of the wellbore that has been isolated from other wellbore volumes by tubulars, plugs, packers, etc. or occupied by specific material, such as cement or fill.
- 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.
- wellbore_s (FSK, M: CHAR VARYING(19))
- wellbore_component_facility.wellbore
Specifies the wellbore in which this facility is installed.
Defines a foreign key to table wellbore.
- entity_type_nm (M: CHAR VARYING(30))
- Column that contains the name of the entity that this row is an instance of in case a table represents multiple entities. Possible values are: wellbore_annular_volume, wellbore_cement_sheath, wellbore_fill, wellbore_tubular_volume.
- annulus_volume (O: FLOAT)
annulus_volume_u (FNK, O: CHAR VARYING(15))
- wellbore_annular_volume.annulus_volume
This is the total volume of the annulus.
annulus_volume_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- capacity (O: FLOAT)
capacity_u (FNK, O: CHAR VARYING(15))
- wellbore_annular_volume.capacity
This is the capacity (volume per unit length) of the annulus.
capacity_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- component_order (O: INTEGER)
- wellbore_component_facility.component_order
This is the relative order of the component within the assembly. A component with an order of one is "next to" a component with an order of two. An order of one is first in the hole , i.e. is nearest the bottom of the well.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- effective_volume (O: FLOAT)
effective_volume_u (FNK, O: CHAR VARYING(15))
- wellbore_volume.effective_volume
The volume of this wellbore volume.
effective_volume_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- end_date (O: TIMESTAMP)
end_date_cd (O: CHAR(1))
end_date_yr (O: FLOAT)
end_date_yp (O: INTEGER)
end_date_dy (O: INTEGER)
end_date_hr (O: INTEGER)
end_date_mt (O: INTEGER)
end_date_st (O: FLOAT)
end_date_of (O: FLOAT)
- wellbore_component_facility.end_date
This is the date and time of day when this wellbore component facility was permanently removed from service.
- flow_area (O: FLOAT)
flow_area_u (FNK, O: CHAR VARYING(15))
- wellbore_annular_volume.flow_area
This is the effective cross-sectional flow area of this annulus.
flow_area_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.
- 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".
- start_date (O: TIMESTAMP)
start_date_cd (O: CHAR(1))
start_date_yr (O: FLOAT)
start_date_yp (O: INTEGER)
start_date_dy (O: INTEGER)
start_date_hr (O: INTEGER)
start_date_mt (O: INTEGER)
start_date_st (O: FLOAT)
start_date_of (O: FLOAT)
- wellbore_component_facility.start_date
This is the date and time when this wellbore component facility was placed in service within the wellbore.
- wellbore_volume_length (O: FLOAT)
wellbore_volume_length_u (FNK, O: CHAR VARYING(15))
- wellbore_volume.wellbore_volume_length
The length of this wellbore volume.
wellbore_volume_length_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- belongs_to_assembly_s (FSK, O: CHAR VARYING(19))
belongs_to_assembly_t (O: CHAR VARYING(30))
- wellbore_component_facility.belongs_to_assembly
This points to the wellbore_component_facility assembly that this is a part of.
belongs_to_assembly_s: Implements a foreign key to a row in one of the tables projected from entity wellbore_component_facility depending on the value of the next column (See below).
belongs_to_assembly_t: Defines the name of the referenced table. Possible values are defined in @wellbore_component_facility.
- 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.
- 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.
Table is related to: activity, address, business_assoc_facility_involv, contract_object_designation, contract_oblig_object_fulfil, data_collection_content, derived_interest_makeup, document_specification_part, facility_alias, facility_classification, facility_fulfillment, facility_composition, coordinate_system, general_facility, @graphical_element, guideline_compliance, material_installation, object_activity_involvement, object_remark, object_subject_to_guideline, property_damage, p_generic_property, space_time_operation, spatial_object, subject_of_contract, topological_relationship, @wellbore_component_facility, wellbore_component_fcl_conn
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 17:13:48 2001
© Copyright 2001 POSC. All rights reserved.