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	Property / Storage Unit	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 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 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
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]

Drilling_Operation_Data

Copyright © 2018 Schlumberger. All rights reserved.