Drilling_Operation_Data

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

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]

Name	Value Domain / Measurement	Description	Required / 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 Activity is an activation of, and is characterized by the associated Activity_Template.	No	NUMBER(38)
Actual_Build_Rate	double Well_Curvature	The actual build rate achieved during the reporting period	No	NUMBER
Actual_Static_Hook_Load	double High_Force	The hook load measured while not rotating.	No	NUMBER
Actual_Turn_Rate	double Well_Curvature	The actual turn rate achieved during the reporting period	No	NUMBER
Adjustable_Stabilizer_OD	double Cylinder_Diameter	Outer Diameter of the Adjustable Stabilizer, can be changed from surface	No	NUMBER
Allowable_Hook_Load	double High_Force	The maximum allowable hook load (overpull) before yield.	No	NUMBER
Average_Rate_Of_Penetration	double Drillbit_Penetration_Rate	The average rate of penetration observed during the reporting period	No	NUMBER
Average_Rotary_Speed	double Rotary_Speed	The average rotary speed during the reporting period	No	NUMBER
Average_Weight_On_Bit	double High_Force	The average weight on the bit during the reporting period	No	NUMBER
BHA_Drag	double High_Torque	BHA drag	No	NUMBER
BH_Annular_Pressure	double Pressure	Annular pressure at the bottom of the hole	No	NUMBER
Bent_Sub_Bend_Angle	double Plane_Angle	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	Force exerted by a Rotary Steerable System when biasing	No	NUMBER
Bit_Operating_Time	double Time	The operating time of the bit measured at the end of each drilled interval	No	NUMBER
Bit_Pressure_Drop	double Pressure	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	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	The flow rate through the boost line.	No	NUMBER
Borehole_Id	Borehole	To identify the borehole	Yes	NUMBER(38)
Bottom_Hole_Temperature	double Temperature	Bottom hole temperature	No	NUMBER
Circulation_Pressure	double Pressure	The circulation pressure utilized during this reporting period	No	NUMBER
Circulation_Time	double Time	Circulating time in this time interval	No	NUMBER
Collar_Rotary_Speed	double Rotary_Speed	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	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	Desired Dogleg Severity Setting for Rotary Steerable System, down linkable from surface	No	NUMBER
Desired_Toolface_Angle	double Plane_Angle	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	Downhole Torque on Bit measured by MWD tool sensor and transmitted to surface	No	NUMBER
Downhole_Weight_On_Bit	double High_Force	Downhole Weight on bit measured by MWD tool sensor and transmitted to surface	No	NUMBER
Drive_Current_On_Bottom	double Electric_Current	Rotary table or top drive motor current, measured while on bottom, drilling	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	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. This GUID is not generated by the database, but is the GUID used by the application on first access of this object. Use of this property is optional and completely under the control of application developers.	No	VARCHAR2(128)
Gas_Injection_Rate	double Gas_Flowrate	Rate of gas injection	No	NUMBER
HSI	double Power_Per_Area	Calculated hydraulic horsepower generated by the flow of fluid through the bit nozzles	No	NUMBER
Hole_Measured_Bottom_Depth	double Depth	The bottom measured depth of interval to drill	No	NUMBER
Hole_Measured_Top_Depth	double Depth	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	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	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	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	Maximum over pull	No	NUMBER
Max_Rate_Of_Penetration	double Drillbit_Penetration_Rate	The maximum rate of penetration observed during the reporting period	No	NUMBER
Max_Rotary_Speed	double Rotary_Speed	Maximum Rotary Speed applied to drill string over the reporting period.	No	NUMBER
Max_Surface_WOB	double High_Force	Maximum Weight on Bit measured on the rig floor over the reporting period	No	NUMBER
Min_Rate_Of_Penetration	double Drillbit_Penetration_Rate	The minimum rate of penetration observed during the reporting period	No	NUMBER
Min_Rotary_Speed	double Rotary_Speed	Minimum Rotary Speed applied to drill string over the reporting period.	No	NUMBER
Min_Surface_WOB	double High_Force	Minimum Weight on Bit measured on the rig floor over the reporting period	No	NUMBER
Motor_Speed	double Rotary_Speed	Speed at which the downhole motor is rotated.	No	NUMBER
Mud_Flowrate_In	double Flowrate	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	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	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	The predicted build rate expected during the reporting period	No	NUMBER
Predicted_Turn_Rate	double Well_Curvature	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	ID of the activity that was executing when the entity was created, 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	Rotary Steerable System build/drop response from the predicted response over the depth interval	No	NUMBER
RSS_Gain	double Well_Curvature	Rotary Steerable System steering response gain from the predicted steering response over the depth interval	No	NUMBER
RSS_Offset	double Plane_Angle	Rotary Steerable System steering response offset from the predicted steering response over the depth interval	No	NUMBER
RSS_Walk	double Well_Curvature	Rotary Steerable System walk response from the predicted walk response over the depth interval	No	NUMBER
Rate_Of_Penetration_Input	double Drillbit_Penetration_Rate	Rate of Penetration manually input by operator, necessary for areas where the computation is erratic	No	NUMBER
Reaming_Drill_Time	double Time	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	Amount of time when penetration is accomplished by rotating the drill string.	No	NUMBER
Rotating_Hook_Load	double High_Force	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	Hook load corresponding to sliding friction when lowering string into wellbore	No	NUMBER
Sliding_Drill_Time	double Time	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 entity"s 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	Standpipe Differential pressure, STANDPIPE_PRESSURE_ON_BOTTOM-STANDPIPE_PRESSURE_ON_BOTTOM	No	NUMBER
Standpipe_Pres_Off_Bottom	double Pressure	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	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	Measured depth at the start of the activity or proposed start depth of the activity.	No	NUMBER
Steering_Direction	double Plane_Angle	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	Surface annular pressure	No	NUMBER
Surface_Annular_Temperature	double Temperature	Surface annular temperature	No	NUMBER
Surface_Gas_Return_Rate	double Gas_Flowrate	Flow rate of gas at the surface	No	NUMBER
Surface_Rotary_Speed	double Rotary_Speed	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	Torque when string is off bottom as measured on the rig floor	No	NUMBER
Surface_Torque_On_Bottom	double High_Torque	Torque on Bottom measured on the rig floor	No	NUMBER
Surface_Weight_On_Bit	double High_Force	Weight on Bit measured on the rig floor	No	NUMBER
Time_Offset	double Time	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	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_Drill_Time	double Time	Total time spent drilling during this reporting period	No	NUMBER
Transient_Period	R_Transient_Period	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	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	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	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 Entity	Link	Description	Implementation Technique	Required
Wellsite_Periodic_Rpt	Drilling_Operation_Data	Reference to Drilling Operation Data	Assoc to Many	No

Refers To

[Previous] [Next] [Top]

Link	To Entity	Description	Implementation Technique	Required
Run_Number	Borehole_Activity_Detail	The run numbers associated with a Drilling Operation record	Nullify	No
Work_String	Work_String	_	Restrict	No
Borehole_Section	Borehole_Section	_	Assoc to Many	No
Borehole_Zone	Borehole_Zone	_	Assoc to Many	No
Borehole	Borehole	_	Cascade	Yes
Activity_Program	Activity_Program	_	Restrict	No
Transient_Period	R_Transient_Period	_	Restrict	No
Super_Activity	Activity	_	Assoc to One	No
Fulfilled_Activity	Activity	_	Assoc to Many	No
Triggering_Event	Event	_	Nullify	No
Activity_Template	Activity_Template	_	Restrict	No

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

Drilling_Operation_Data

Copyright © 2009 Schlumberger. All rights reserved.