Drilling_Operation_Data


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

General Information

[Next]
Name Drilling_Operation_Data
Entity Type Table
Description Entity describing the data captured by the driller during drilling.
Submodel WS_Activity
Entity Scope Project
Primary Key Id
Natural Key
Generalizations Borehole_Activity , Wellsite_Activity , Activity , Entity , IT_Object , Tracked_Object
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
Activity_Program_Id Activity_Program
Reference to the program during which the activity was performed. No
NUMBER(38)
Activity_State STRING64 NA
The current state, or status, of the activity. Activity state is a refinement of the lifecycle indicator Existence_Kind. For example, a drilling job whose Existence_Kind is "Actual" could have an activity state of "turning to the right", "suspended due to weather", or "tool makeup or breakdown". An activity whose Existence_Kind is "Required" could have State values like "under investigation", "proposed" and "AFE approved". Note: The valid list of activity states will vary from one kind of activity to another, so the values entered into this column are not validated via a lookup table. No
VARCHAR2(64)
Activity_Template_Id Activity_Template
The identifier of the activity template which activates or characterizes the Activity. No
NUMBER(38)
Actual_Build_Rate double Well_Curvature
deg/30m
The actual build rate achieved during the reporting period No
NUMBER
Actual_Static_Hook_Load double High_Force
1000 kgf
The hook load measured while not rotating. No
NUMBER
Actual_Turn_Rate double Well_Curvature
deg/30m
The actual turn rate achieved during the reporting period No
NUMBER
Adjustable_Stabilizer_OD double Cylinder_Diameter
mm
Outer Diameter of the Adjustable Stabilizer, can be changed from surface No
NUMBER
Allowable_Hook_Load double High_Force
1000 kgf
The maximum allowable hook load (overpull) before yield. No
NUMBER
Average_Rate_Of_Penetration double Drillbit_Penetration_Rate
m/h
The average rate of penetration observed during the reporting period No
NUMBER
Average_Rotary_Speed double Rotary_Speed
c/min
The average rotary speed during the reporting period No
NUMBER
Average_Weight_On_Bit double High_Force
1000 kgf
The average weight on the bit during the reporting period No
NUMBER
BHA_Drag double High_Torque
kN.m
BHA drag No
NUMBER
BH_Annular_Pressure double Pressure
kPa
Annular pressure at the bottom of the hole No
NUMBER
Bent_Sub_Bend_Angle double Plane_Angle
deg
Offset angle to the axis of the body of the sub (high-side). This angle is usually from 1 to 3 degrees in increments of half a degree. No
NUMBER
Bias_Force double Force
N
Force exerted by a Rotary Steerable System when biasing No
NUMBER
Bit_Operating_Time double Time
s
The operating time of the bit measured at the end of each drilled interval No
NUMBER
Bit_Pressure_Drop double Pressure
kPa
Bit pressure drop is that part of the total system pressure loss which is attributed to forcing the fluid to flow across the bit face No
NUMBER
Bit_Rotary_Speed double Rotary_Speed
c/min
This is the speed of rotation of the drill bit. This is the sum of the Surface_Rotary_Speed and the Motor_Speed No
NUMBER
Bit_Rotation_Count int No_Unit
The number of revolutions performed by the bit during the bit run No
NUMBER(10)
Bit_Run_Number CODE NA
A code to indicate the Bit Run Number No
VARCHAR2(64)
Boost_Line_Flowrate double Flowrate
m3/h
The flow rate through the boost line. No
NUMBER
Borehole_Id Borehole
The identifier of the borehole in which the activity occurred. Yes
NUMBER(38)
Bottom_Hole_Temperature double Temperature
degC
Bottom hole temperature No
NUMBER
Circulation_Pressure double Pressure
kPa
The circulation pressure utilized during this reporting period No
NUMBER
Circulation_Time double Time
s
Circulating time in this time interval No
NUMBER
Collar_Rotary_Speed double Rotary_Speed
c/min
Speed at which the drill collar is rotated as measured by a sensor. This could be different to the Surface_Rotary_Speed at an instant in time in the situation of Stick_N_Slip drilling. On average the Collar_Rotary_Speed and the Surface_Rotary_Speed should be the same. No
NUMBER
Connection_Time double Time
s
The amount of time taken to complete a connection. No
NUMBER
Description DESCRIPTION_STR NA
A general description of or remark on the information stored in the database record No
VARCHAR2(999)
Desired_Dogleg_Severity double Well_Curvature
deg/30m
Desired Dogleg Severity Setting for Rotary Steerable System, down linkable from surface No
NUMBER
Desired_Toolface_Angle double Plane_Angle
deg
Desired Toolface angle setting for Rotary Steerable System, requires desired tool face mode to be a complete measurement No
NUMBER
Desired_Toolface_Mode STRING8 NA
Desired mode of measurement for the desired toolface angle, currently Magnetic or Gravity. No
VARCHAR2(8)
Downhole_Torque double High_Torque
kN.m
Downhole Torque on Bit measured by MWD tool sensor and transmitted to surface No
NUMBER
Downhole_Weight_On_Bit double High_Force
1000 kgf
Downhole Weight on bit measured by MWD tool sensor and transmitted to surface No
NUMBER
Drive_Current_On_Bottom double Electric_Current
mA
Rotary table or top drive motor current, measured while on bottom, drilling No
NUMBER
Drive_Type STRING64 NA
The drive method used for drilling. No
VARCHAR2(64)
Duration double Time
s
The duration of the activity. For planned activities, this would be expected duration. No
NUMBER
End_Date DATE NA
The date and time at which the activity will end or did end. For planned activities, this would be expected end date. No
DATE
End_MD double Depth
m
Measured depth at the end of the activity or proposed depth end of the activity. No
NUMBER
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)
External_Reference STRING64 NA
A value that is used by an external organization to reference this activity. For example, if an external organization is hired to perform this activity, this column could be used to store the work order or purchase order number that organization uses to reference this activity. No
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)
Gas_Injection_Rate double Gas_Flowrate
m3/h
Rate of gas injection No
NUMBER
HSI double Power_Per_Area
W/m2
Calculated hydraulic horsepower generated by the flow of fluid through the bit nozzles No
NUMBER
Hole_Measured_Bottom_Depth double Depth
m
The bottom measured depth of interval to drill No
NUMBER
Hole_Measured_Top_Depth double Depth
m
The top measured depth of interval to drill No
NUMBER
Id ID No_Unit
Unique identifier for this entity. Yes
NUMBER(38)
Injection_Temperature double Temperature
degC
Temperature of the flowing fluid No
NUMBER
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)
Internal_Reference STRING64 NA
A value that is used internally within the organization to reference this activity. No
VARCHAR2(64)
Jet_Impact_Force double Force
N
Force exerted on the bottom of the hole by the flow of fluid through the bit No
NUMBER
Lateral_Position_Desc double NA
Lateral Position of string in wellbore e.g. left, right, center - lateral position No
NUMBER
Liquid_Return_Rate double Flowrate
m3/h
Total liquid rate return at the surface No
NUMBER
Lithology_Description STRING128 NA
Brief textual description of Lithology being drilled, usually the predominant lithology being drilled No
VARCHAR2(128)
Max_Over_Pull double High_Torque
kN.m
Maximum over pull. The value domain(Mesaurement) of this attribute is High_Torque No
NUMBER
Max_Rate_Of_Penetration double Drillbit_Penetration_Rate
m/h
The maximum rate of penetration observed during the reporting period No
NUMBER
Max_Rotary_Speed double Rotary_Speed
c/min
Maximum Rotary Speed applied to drill string over the reporting period. No
NUMBER
Max_Surface_WOB double High_Force
1000 kgf
Maximum Weight on Bit measured on the rig floor over the reporting period No
NUMBER
Min_Rate_Of_Penetration double Drillbit_Penetration_Rate
m/h
The minimum rate of penetration observed during the reporting period No
NUMBER
Min_Rotary_Speed double Rotary_Speed
c/min
Minimum Rotary Speed applied to drill string over the reporting period. No
NUMBER
Min_Surface_WOB double High_Force
1000 kgf
Minimum Weight on Bit measured on the rig floor over the reporting period No
NUMBER
Motor_Speed double Rotary_Speed
c/min
Speed at which the downhole motor is rotated. No
NUMBER
Mud_Flowrate_In double Flowrate
m3/h
Drilling fluid flow rate No
NUMBER
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)
Nozzle_Velocity double Velocity
m/s
The calculated velocity of the fluid passing through the nozzle. The nozzle velocity is calculated according to the following equation-- Vn = (volume/area*time)/30.48 where Vn is nozzle velocity in ft/s; volume is the sample volume in mL; area is the area of the nozzle in sq cm; and time is the sampling time in seconds No
NUMBER
Orienting_Mode STRING32 NA
Driving mode for the directional tool, can be rotating/sliding for a mud motor, in/out for adjustable stabilizer or steering/straight for a rotary steerable system No
VARCHAR2(32)
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)
Pick_Up_Hook_Load double High_Force
1000 kgf
Hook load corresponding to sliding friction when pulling out string from wellbore No
NUMBER
Power_Setting double Percent
%
Percent Power Setting for Rotary Steerable System, down linkable from surface No
NUMBER
Predicted_Build_Rate double Well_Curvature
deg/30m
The predicted build rate expected during the reporting period No
NUMBER
Predicted_Turn_Rate double Well_Curvature
deg/30m
The predicted turn rate expected during the reporting period No
NUMBER
Processing_Option STRING128 NA
Used to identify the computation / display mode of the slide sheet to accommodate either mud motor, adjustable stabilizer or rotary steerable orienting tools No
VARCHAR2(128)
Produced_By STRING64 NA
The name of application role that created the entity, for data created programmatically. No
VARCHAR2(64)
Purpose STRING255 NA
A description of purpose of the activity or its stage No
VARCHAR2(255)
RSS_Drop double Well_Curvature
deg/30m
Rotary Steerable System build/drop response from the predicted response over the depth interval No
NUMBER
RSS_Gain double Well_Curvature
deg/30m
Rotary Steerable System steering response gain from the predicted steering response over the depth interval No
NUMBER
RSS_Offset double Plane_Angle
deg
Rotary Steerable System steering response offset from the predicted steering response over the depth interval No
NUMBER
RSS_Walk double Well_Curvature
deg/30m
Rotary Steerable System walk response from the predicted walk response over the depth interval No
NUMBER
Rate_Of_Penetration_Input double Drillbit_Penetration_Rate
m/h
Rate of Penetration manually input by operator, necessary for areas where the computation is erratic No
NUMBER
Reaming_Drill_Time double Time
s
Amount of time when penetration is accomplished by reaming. No
NUMBER
Remarks STRING2000 NA
Any type of remarks added to an entity instance. No
VARCHAR2(2000)
Rotating_Drill_Time double Time
s
Amount of time when penetration is accomplished by rotating the drill string. No
NUMBER
Rotating_Hook_Load double High_Force
1000 kgf
The hook load measured while on Bottom with prescribed Weight on Bit, Surface RPM and Flow Rate No
NUMBER
Run_Number_Id Borehole_Activity_Detail
The run numbers associated with a Drilling Operation record No
NUMBER(38)
SDAT_Label int No_Unit
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. No
NUMBER(10)
Slack_Off_Hook_Load double High_Force
1000 kgf
Hook load corresponding to sliding friction when lowering string into wellbore No
NUMBER
Sliding_Drill_Time double Time
s
Amount of time when penetration is accomplished by sliding the drill string. No
NUMBER
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)
Standpipe_Differential_Pres double Pressure
kPa
Standpipe Differential pressure, STANDPIPE_PRESSURE_ON_BOTTOM-STANDPIPE_PRESSURE_ON_BOTTOM No
NUMBER
Standpipe_Pres_Off_Bottom double Pressure
kPa
Standpipe Pressure measured while off bottom, measures the pressure losses in the circulating system while off bottom No
NUMBER
Standpipe_Pres_On_Bottom double Pressure
kPa
Standpipe Pressure measured while on bottom, measures the pressure losses in the circulating system while drilling No
NUMBER
Start_Date DATE NA
The date and time at which the activity will start or did start. For planned activities, this would be expected start date. No
DATE
Start_MD double Depth
m
Measured depth at the start of the activity or proposed start depth of the activity. No
NUMBER
Steering_Direction double Plane_Angle
deg
Direction setting for Rotary Steerable System, down linkable from surface No
NUMBER
Successful_Flag boolean NA
A flag to indicate whether or not the activity was successful (Yes/No) No
NUMBER(1)
Surface_Annular_Pressure double Pressure
kPa
Surface annular pressure No
NUMBER
Surface_Annular_Temperature double Temperature
degC
Surface annular temperature No
NUMBER
Surface_Gas_Return_Rate double Gas_Flowrate
m3/h
Flow rate of gas at the surface No
NUMBER
Surface_Rotary_Speed double Rotary_Speed
c/min
Speed at which the drill string is rotated on the rig floor, usually by a rotary table or top drive motor No
NUMBER
Surface_Torque_Off_Bottom double High_Torque
kN.m
Torque when string is off bottom as measured on the rig floor No
NUMBER
Surface_Torque_On_Bottom double High_Torque
kN.m
Torque on Bottom measured on the rig floor No
NUMBER
Surface_Weight_On_Bit double High_Force
1000 kgf
Weight on Bit measured on the rig floor No
NUMBER
Time_Offset double Time
s
The time offset from the start of the program that this activity is scheduled to start at. This is normally used while planning a job. No
NUMBER
Toolface_Angle double Plane_Angle
deg
Actual Tool face angle of downhole orienting equipment. No
NUMBER
Toolface_Mode STRING8 NA
Mode of measurement for the toolface angle, currently Magnetic or Gravity No
VARCHAR2(8)
Total_Cost double No_Unit
The total cost of the activity expressed in the local currency. No
NUMBER
Total_Drill_Time double Time
s
Total time spent drilling during this reporting period No
NUMBER
Transient_Period R_Transient_Period
A code or name that indicates whether the activity is executed daily, monthly, on demand, etc. No
VARCHAR2(64)
Triggering_Event_Id 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. No
NUMBER(38)
Tripping_Speed double Velocity
m/s
The speed at which the drill string is either run into the hole or pulled from it. No
NUMBER
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)
Weight_Above_Jar double High_Force
1000 kgf
Weight of the string above the jar. The Neutral Point is the location where the drill string has no stress. All drill string above the Neutral Point is in tension while all string below is in compression, so the weight above the jar is the string weight between the jar and the Neutral Point. Based on this, assuming the jar is running in compression, the weight above the jar must not exceed the jar's down lock load. This could cause firing down while drilling. Weight below the drilling jar. The weight below must be below the jar's Up Lock Load. This could cause firing when tripping or making up connections. No
NUMBER
Weight_Below_Jar double High_Force
1000 kgf
Weight of the string below the jar. The drill string weight is different in fluid than in air; therefore, the difference in weight must be taken into account. No
NUMBER
Work_String_Id Work_String
The work string used during a borehole activity. No
NUMBER(38)


Referenced By

[Previous] [Next] [Top]
From EntityLinkDescriptionImplementation TechniqueRequired
Wellsite_Periodic_Rpt Drilling_Operation_Data Reference to Drilling Operation Data Assoc to Many No


Refers To

[Previous] [Next] [Top]
LinkTo EntityDescriptionImplementation TechniqueRequired
Run_Number Borehole_Activity_Detail The run numbers associated with a Drilling Operation record Nullify No
Activity_Template Activity_Template _ Restrict No
Fulfilled_Activity Activity _ Assoc to Many No
Triggering_Event Event _ Nullify No
Transient_Period R_Transient_Period _ Restrict No
Activity_Program Activity_Program _ Restrict No
Work_String Work_String _ Restrict No
Borehole_Zone Borehole_Zone _ Assoc to Many No
Borehole Borehole _ Cascade Yes
Borehole_Section Borehole_Section _ Assoc to Many No
Super_Activity Activity _ Assoc to One No


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

Copyright © 2018 Schlumberger. All rights reserved.