| Name | Rig_Specification |
|---|---|
| Entity Type | Table |
| Description | Entity describing the technical specification of a rig. |
| Submodel | WS_Surface_Facility |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | Rig_Id , Start_Date , Existence_Kind , Version |
| Generalizations | Entity , IT_Object , Tracked_Object |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Anchor_Count | int | No_Unit |
The number of anchors available for use on a rig | No |
NUMBER(10) |
| Automatic_Driller_Model | STRING64 | NA |
Type of Automatic driller used in the Rig Instrumentation | No |
VARCHAR2(64) |
| Auxiliary_Brake_Desc | STRING64 | NA |
Description of auxiliary brake | No |
VARCHAR2(64) |
| Block_Line_Count | int | No_Unit |
Number of block lines | No |
NUMBER(10) |
| Block_Model | STRING64 | NA |
Model of the block | No |
VARCHAR2(64) |
| Block_Weight | double | High_Force 1000 kgf |
Weight of block | No |
NUMBER |
| Chart_Recorder_Model | STRING64 | NA |
Model of chart recorder used in the Rig Instrumentation | No |
VARCHAR2(64) |
| Choke_Line_Inside_Diameter | double | Cylinder_Diameter mm |
The inside diameter of the choke line fitted to the BOP. | No |
NUMBER |
| Choke_Line_Length | double | Length m |
The Length of the choke line fitted to the BOP. | No |
NUMBER |
| Choke_Setting | double | NA |
A description of the opening of the choke (1.0 = wide open, 0.0 = fully closed). Typical settings are in eighths. Thus 1/8 closed (7/8 open) is 0.875. | No |
NUMBER |
| Clear_Height | double | Length m |
Clear height | No |
NUMBER |
| Compensator_Stroke_Length | double | Length m |
The maximum length that the motion compensator can move | No |
NUMBER |
| Connection_Time | double | Time s |
The time taken to make a connection. | No |
NUMBER |
| Crane_Count | int | No_Unit |
Number of cranes on the rig | No |
NUMBER(10) |
| Derrick_Count | int | No_Unit |
Number of derricks on the rig | No |
NUMBER(10) |
| Derrick_Height | double | Length m |
Height of derrick | No |
NUMBER |
| Derrick_Rating | double | High_Force 1000 kgf |
Rating of the derrick | No |
NUMBER |
| Derrick_Type | STRING64 | NA |
Type of derrick | No |
VARCHAR2(64) |
| Derrick_Wind_Cap | double | Velocity m/s |
Derrick wind capacity | No |
NUMBER |
| Drawwork_Model | STRING64 | NA |
Model of the drawwork | No |
VARCHAR2(64) |
| Drawwork_Motor_Desc | STRING64 | NA |
Description of the drawwork motor | No |
VARCHAR2(64) |
| Drawwork_Rated_Power | double | Power W |
The rated horse power for the drawworks | No |
NUMBER |
| Drawwork_Rated_Weight | double | High_Force 1000 kgf |
Weight Rating of the Drawworks | No |
NUMBER |
| Drawwork_Type | STRING64 | NA |
Type of the drawwork | No |
VARCHAR2(64) |
| Drift_Recorder_Type | STRING64 | NA |
Type of Drift Recorder used in the Rig Instrumentation | No |
VARCHAR2(64) |
| Driller_Control_Panel_Model | STRING64 | NA |
Model of Driller's Control Panel | No |
VARCHAR2(64) |
| Drilling_Recorder_Model | STRING64 | NA |
Model of Drilling Recorder used in the Rig Instrumentation | No |
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) |
| Floor_Height | double | Length m |
Floor height | No |
NUMBER |
| 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) |
| Hook_Model | STRING64 | NA |
Model of the hook | No |
VARCHAR2(64) |
| Hook_Type | STRING64 | NA |
Type of hook | No |
VARCHAR2(64) |
| 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) |
| Kelly_Spinner_Desc | STRING64 | NA |
Description of kelly spinner, such as Weatherford model KS 1500 AB/ powered by air | No |
VARCHAR2(64) |
| Max_Heave | double | Length m |
Maximum allowable heave | No |
NUMBER |
| Max_Hook_Load | double | Force N |
The maximum hook load that can be safely be applied | No |
NUMBER |
| Max_Pump_Flowrate | double | Flowrate m3/h |
The maximum pump rate of the mud pumps installed on the rig. This is a denormalization of derivable information from Mud_Pump and Mud_Pump_Oper_Pty_Set | No |
NUMBER |
| Max_Rotary_Speed | double | Rotary_Speed c/min |
The maximum rotary speed of the Rotary Table | No |
NUMBER |
| Max_Tong_Torque_Indicator | double | High_Force 1000 kgf |
Tong Torque Indicator used in the Rig Instrumentation | No |
NUMBER |
| Max_Var_Deck_Load | double | High_Force 1000 kgf |
Variable Deck Load Maximum (offshore rigs only) | No |
NUMBER |
| Motion_Compensator_Flag | boolean | NA |
A flag to denote whether the rig is fitted with a motion compensator | No |
NUMBER(1) |
| Mud_Flow_Volume_Console_Mdl | STRING64 | NA |
Model of mud flow volume console used in the Rig Instrumentation | No |
VARCHAR2(64) |
| Mud_Volume_Totalizer_Model | STRING64 | NA |
Model of mud volume totalizer used in the Rig Instrumentation | No |
VARCHAR2(64) |
| 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) |
| Pipe_Handling_System_Desc | STRING64 | NA |
Description of pipe handling system | No |
VARCHAR2(64) |
| Produced_By | STRING64 | NA |
The name of application role that created the entity, for data created programmatically. | No |
VARCHAR2(64) |
| Remarks | STRING2000 | NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(2000) |
| Rig_Id | Rig |
|
Reference to the rig whose specification is described. | Yes |
NUMBER(38) |
| Rotary_Capacity | double | High_Force 1000 kgf |
Rotary capacity | No |
NUMBER |
| Rotary_Table_Capacity | double | High_Force 1000 kgf |
Rotary table capacity | No |
NUMBER |
| Rotary_Table_Clearance | double | Length m |
Rotary table clearance | No |
NUMBER |
| Rotary_Table_Model | STRING64 | NA |
Model of rotary table | No |
VARCHAR2(64) |
| SCR_System_Desc | STRING64 | NA |
Description of SCR system | No |
VARCHAR2(64) |
| SDAT_Label | int | No_Unit |
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. | No |
NUMBER(10) |
| Setback_Capacity | double | High_Force 1000 kgf |
Setback capacity | 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) |
| Specification_Name | CODE | NA |
A name given to this particular specification of a rig | No |
VARCHAR2(64) |
| Stand_Length | double | Length m |
The average length of a stand of drill pipe on this rig. | No |
NUMBER |
| Start_Date | DATE | NA |
Start time of the specification | No |
DATE |
| Substructure_Manufacturer | STRING64 | NA |
Manufacture of substructure | No |
VARCHAR2(64) |
| Substructure_Type | STRING64 | NA |
Type of substructure | No |
VARCHAR2(64) |
| Swivel_Capacity | double | High_Force 1000 kgf |
Swivel capacity | No |
NUMBER |
| Swivel_Model | STRING64 | NA |
Model of swivel | No |
VARCHAR2(64) |
| Swivel_Type | STRING64 | NA |
Type of swivel | No |
VARCHAR2(64) |
| Top_Drive_Capacity | double | High_Force 1000 kgf |
Top drive capacity | No |
NUMBER |
| Top_Drive_Model | STRING64 | NA |
Model of top drive | No |
VARCHAR2(64) |
| Top_Drive_Torque | double | Torque N.m |
The torque rating of the top drive mechanism installed | 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) |
| Var_Deck_Load_Storm_Rating | double | High_Force 1000 kgf |
Variable Deck Load Storm Rating (offshore rigs only | No |
NUMBER |
| Version | STRING255 | NA |
The form or variant of the entity. | Yes 1 |
VARCHAR2(255) |
| Weight_Indicator_Model | STRING64 | NA |
Model of Weight Indicator used in the Rig Instrumentation | No |
VARCHAR2(64) |
| Weight_Indicator_Sensor_Mdl | STRING64 | NA |
Model of the sensor in the Weight Indicator used in the Rig Instrumentation | No |
VARCHAR2(64) |
| Work_String_Torque_Rating | double | Torque N.m |
Work string rotational torque rating | No |
NUMBER |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Rig | Rig | Reference to the rig whose specification is described. | Cascade | Yes |