Event

[Columns] [Composed Of] [Referenced By] [Refers To]

General Information

[Next]
Name Event
Entity Type Table
Description Table describing the event took place on a wellsite, or the potential risk while performing the job on the wellsite.
Submodel Event
Entity Scope Project
Primary Key Id
Natural Key
Generalizations Entity , IT_Object , Tracked_Object
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit		DescriptionRequired /
Default		Type
Associated_Risk_Id Event
Reference to the risks associated to the event or risk. No
 NUMBER(38)
Borehole_Id Borehole
Link to borehole defining where the event took place. No
 NUMBER(38)
Contractor_Name STRING64 NA
 Name of the contractor present at site when the event took place. No
 VARCHAR2(64)
Detected_By_Name_Id Business_Associate
The person who detected the event. No
 NUMBER(38)
Detected_Date DATE NA
 The date when the event took place. No
 DATE
Duration double Time
s		 The duration of the activity No
 NUMBER
End_Date DATE NA
 End time of event No
 DATE
Event_Classification R_Event_Classification
Reference to the event classification to define more detail on the nature of the event. No
 VARCHAR2(64)
Event_Location STRING255 NA
 A textual description of the location of the event. No
 VARCHAR2(255)
Event_Type R_Event
Reference to the type of the event such as risk, near misses Yes
 VARCHAR2(64)
Existence_Kind REF_EXISTENCE_KIND NA
 A reference value that describes the state of existence in the lifecycle of the entity, for example, Planned, Predicted, Required, Simulated, and Actual. Yes
Actual		 VARCHAR2(64)
GUID STRING128 NA
 Globally Unique IDentifier for an instance of a class. USAGE NOTES: There are two cases: 1) GUID is not populated or used; and 2) it is populated with a value that is globally unique. If the GUID is populated there are two means of doing so for a given project: 2a) Seabed automatically generates and populates the GUID when an instance is created (valid only on Oracle based systems); and 2b) the GUID is generated and populated by an application (other than Seabed) on instance creation. Whether Seabed automatically generates GUIDs for a project is determined by the Auto_GUID flag in SDS_Account. Note that techniques 2a and 2b can coexist in the same project. When GUIDs are automatically generated an application can override the automatically generated GUID with its own GUID by simply supplying the GUID value. Applications that generate their own GUIDs and populate the GUID column will function correctly on projects which have automatic GUID generation turned on. No
 VARCHAR2(128)
Id ID No_Unit
 Unique identifier for this entity. Yes
 NUMBER(38)
Insert_Date DATE NA
 Date the entity was created in the repository No
 DATE
Insert_User STRING64 NA
 The name of the user responsible for the creation of this entity in the repository. No
 VARCHAR2(64)
Lost_Time_Flag boolean NA
 A flag to denote whether this event has been classified as a lost time event. The amount of time lost can be held in the Lost_Time attribute in the Event_Consequence class No
 NUMBER(1)
Mechanism STRING128 NA
 Definition of mechanism causing the risk/event. No
 VARCHAR2(128)
Name ENTITY_NAME NA
 The name given to any object or data item, e.g. name of Well, name of Field, etc. No
 VARCHAR2(255)
Original_Source STRING64 NA
 The name of the person, Organization or project source that originally provided this entity, e.g. "IHS-EnergyData" or "FinderUpper Stratton Deeper Pool 15" No
 VARCHAR2(64)
Preventable_Flag boolean NA
 A flag to indicate whether or not the event was preventable No
 NUMBER(1)
Produced_By STRING64 NA
 The name of application role that created the entity, for data created programmatically. No
 VARCHAR2(64)
Production_Entity_Id Production_Entity
The identifier of the production entity for which a downtime reason event will be specified. No
 NUMBER(38)
Remarks STRING2000 NA
 Any type of remarks added to an entity instance. No
 VARCHAR2(2000)
SDAT_Label int No_Unit
 Label used by the security system for entitlements. SDAT is Secure Data Access Technology. No
 NUMBER(10)
Scheduled_Flag boolean NA
 A flag that designates whether or not an event was scheduled. 1(true) = the event was a scheduled event. 0 (false) = the event was not a scheduled event. A null value implies that it was not known whether the event was scheduled or not. No
 NUMBER(1)
Shareable_Flag boolean NA
 When set to 1, this indicator identifies that this event can be shared with other interested parties for informational purposes No
 NUMBER(1)
Source STRING64 NA
 Name of the person or organization responsible for this entitys E and P content and quality. Not the data technologist or IT expert creating the entity, for which see IT_Object.Insert_User and Update_User. No
 VARCHAR2(64)
Start_Date DATE NA
 Start time of event No
 DATE
Summary REMARKS_STR NA
 Textual summary of risk or event No
 VARCHAR2(999)
Update_Date DATE NA
 Date of the most-recent modification to the entity. No
 DATE
Update_User STRING64 NA
 The name of the user responsible for the last modification to this entity. No
 VARCHAR2(64)
Version STRING255 NA
 The form or variant of the entity. Yes
1		 VARCHAR2(255)


Referenced By

[Previous] [Next] [Top]
From EntityLinkDescriptionImplementation TechniqueRequired
Activity Triggering_Event The identifier of the event that triggered the start of this activity. Events can trigger activities. For example, an explosion event could trigger a firefighting activity. Note that this value should not conflict with, or be confused with, the value in Activity_Status.Triggering_Event. Nullify No
Activity_Status Triggering_Event The identifier of the event that triggered this activity status. In other words, this is the event that caused the activity to have this status. Events can cause changes in the status of an activity. Note that this value should not conflict with, or be confused with, the value in Activity.Triggering_Event, which defines the event that initially started the activity. Nullify No
Event Associated_Risk Reference to the risks associated to the event or risk. Restrict No
Event_Cause Event Reference to the event/risk for which the cause is defined. Cascade Yes
Event_Consequence Event Reference to the event/risk for which the consequences are defined. Cascade Yes
Event_Environment Event Reference to the event/risk for which the environment is defined. Cascade Yes
Event_Management Event Reference to the event subject to management Cascade Yes
Event_Management Residual_Risk Reference to the risk/event indicating the residual risk. Restrict No
Event_Reporting Event Reference to the event/risk Cascade No
Facility_Status Triggering_Event The event that triggered the change in status for the facility Nullify No
Kick Event Information for a specific event called a kick Cascade Yes
MS_Event_Stage Event Reference to the event. Cascade Yes


Refers To

[Previous] [Next] [Top]
LinkTo EntityDescriptionImplementation TechniqueRequired
Event_Classification R_Event_Classification Reference to the event classification to define more detail on the nature of the event. Restrict No
Event_Type R_Event Reference to the type of the event such as risk, near misses Restrict Yes
Facility Facility The facility that failed or caused the event Assoc to One No
Associated_Risk Event Reference to the risks associated to the event or risk. Restrict No
Detected_By_Name Business_Associate The person who detected the event. Restrict No
Borehole Borehole Link to borehole defining where the event took place. Restrict No
Activity Activity Reference to the activity during which the event took place or for which the risk has been identified. Assoc to One No
Production_Entity Production_Entity The identifier of the production entity for which a downtime reason event will be specified. Cascade No


[Seabed Objects] [Entities in Schema Seabed] [Index]

Copyright © 2018 Schlumberger. All rights reserved.