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_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.
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.
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.