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.
borehole_component.borehole_component_length
This is the length of this borehole component. borehole_component_length_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.
perforation_set.diameter_crush_zone
The assumed diameter of the crushed zone in each perforation in the interval. diameter_crush_zone_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
wellbore_component_facility.end_date
This is the date and time of day when this wellbore component facility was permanently removed from service.
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.
borehole.outer_diameter
The outer diameter of the borehole segment. borehole_trajectory_section.outer_diameter
The outer diameter of the borehole trajectory section. open_borehole_segment.outer_diameter
The outer diameter of the open borehole section. outer_diameter_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
perforation_set.shot_angle
The angular range of perforations created by a perforating gun set up for directional shooting, expressed clockwise from north. If perforations are from due north to due east, the angle is 90 degrees. shot_angle_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
shot_count (O: INTEGER)
perforation_set.shot_count
The number of perforations in the interval.
perforation_set.shot_density
The shot density of the perforated interval in number of perforations per length. shot_density_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
perforation_set.shot_diameter
The diameter of the perforation entrance holes. shot_diameter_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
perforation_set.shot_length
The average length of the perforations measured from the casing to the end of the perforation. shot_length_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
perforation_set.shot_phase
The angle between perforations with respect to the centerline of the wellbore. Examples are 120 deg. for perforations oriented at 0, 120 and 240 deg., and 180 deg. for perforations oriented at opposite sides of the wellbore. shot_phase_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
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".
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.
r_diameter (FNK, O: CHAR VARYING(80))
enlarged_diameter_borehole_seg.ref_diameter
The diameter to which the hole has been enlarged. In reality the actual diameter may vary from this nominal value due to mechanical wear or because of a chemical reaction between the drilling fluid and the exposed formations. single_diameter_borehole_seg.ref_diameter
The outer diameter of the created hole. In reality the actual diameter may vary from this nominal value due to mechanical wear or because of a chemical reaction between the drilling fluid and the exposed formations.
Defines a foreign key to table r_diameter.
r_perforation (FNK, O: CHAR VARYING(80))
perforation_set.ref_perforation
The type of perforations in the perforation interval.
Defines a foreign key to table r_perforation.
well_completion_s (FSK, O: CHAR VARYING(19))
well_completion_segment.well_completion
Specifies the well completion in which this facility is a component.
Defines a foreign key to table well_completion.