| Name | R_Casing_Cat |
|---|---|
| Entity Type | Table |
| Description | Reference class for storing nominal casing data. |
| Submodel | Tubular |
| Entity Scope | Reference |
| Primary Key | Ref_Id |
| Natural Key | Nom_Outside_Diameter , Nom_Outside_Diameter_UOM , Nom_Linear_Weight , Nom_Linear_Weight_UOM , Standardization_Name , Coupling_Type , Tubular_Grade |
| Generalizations | R_Tubular_Cat , R_Facility_Cat , Ref_Entity_Surrogate_Key , Reference_Entity_Parent |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Active_Flag | boolean | NA |
1 = use without restriction. 0 = avoid use - the value has been deprecated and may be removed in a later release. | Yes 1 |
NUMBER(1) |
| Body_Yield_Strength | double | Force N |
The yield strength of the body of the casing joint | No |
NUMBER |
| Burst_Pressure | double | Pressure kPa |
The internal pressure that will cause piece of drill pipe to fail. | No |
NUMBER |
| Cat_Inside_Diameter | double | Cylinder_Diameter mm |
The typical inside diameter of a tubular | No |
NUMBER |
| Cat_Length | double | Length m |
The catalog length of the tubular | No |
NUMBER |
| Cat_Linear_Weight | double | Mass_Per_Length kg/m |
The typical linear weight of a tubular | No |
NUMBER |
| Cat_Outside_Diameter | double | Cylinder_Diameter mm |
The typical outside diameter of a tubular | No |
NUMBER |
| Cat_Wall_Thickness | double | Cylinder_Diameter mm |
Wall thickness | No |
NUMBER |
| Catalog_Number | STRING64 | NA |
A catalog or part number for a facility. | No |
VARCHAR2(64) |
| Code | CODE | NA |
A standard abbreviation, mnemonic, or short code that represents the reference value. | No |
VARCHAR2(64) |
| Collapse_Pressure | double | Pressure kPa |
The minimum differential pressure which a tubular will withstand without permanent deformation | No |
NUMBER |
| Compression | double | Force N |
Compression | No |
NUMBER |
| Coupling_Outside_Diameter | double | Cylinder_Diameter mm |
The outside diameter of the coupling on the tubular | No |
NUMBER |
| Coupling_Type | String | NA |
The type of coupling on the tubular | No |
VARCHAR2(255) |
| Description | STRING2000 | NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| Displacement_Volume | double | Volume_Per_Length m3/m |
The cross-sectional area of steel (or other material if the tubular is not made of steel) in the tubular expressed in units of volume per unit length. | No |
NUMBER |
| Drift_Diameter | double | Cylinder_Diameter mm |
Largest diameter of a perfect cylinder that can fit into the pipe. Because a pipe is slightly oval the drift diameter is always smaller than the quoted inner diameter. The drift diameter is used to know if a given pipe will run into a pipe. | No |
NUMBER |
| Equipment_Symbol | R_Equipment_Symbol |
|
The display symbol associated with the equipment catalog entry. | No |
NUMBER(38) |
| Fatigue_Endurance_Limit | double | Stress kPa |
The maximum stress below which the tubular could presumably endure an infinite number of cycles. | No |
NUMBER |
| Hydrostatic_Test_Pressure | double | Pressure kPa |
Hydrostatic Test Pressure | 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) |
| Joint_Strength | double | Force N |
The strength of the joint | No |
NUMBER |
| Manufacturer | STRING64 | NA |
Name of the business associate who manufactured the item. | No |
VARCHAR2(64) |
| Min_Make_Up_Torque | double | High_Torque kN.m |
The minimum torque required to make up the joint to meet the leak resistance spec. | No |
NUMBER |
| Model_Name | STRING64 | NA |
Name of a model or version of some entity; for equipment, it may coincide with the trade name. | No |
VARCHAR2(64) |
| Name | STRING255 | NA |
The spelled-out name of the reference value. | No |
VARCHAR2(255) |
| Nom_Inside_Diameter | double | No_Unit |
Nominal inside diameter of the tubular body | No |
NUMBER |
| Nom_Inside_Diameter_UOM | R_Unit |
|
The unit of measure associated with the Nominal Inside Diameter | No |
VARCHAR2(64) |
| Nom_Linear_Weight | double | No_Unit |
The nominal linear weight of the tubular | Yes |
NUMBER |
| Nom_Linear_Weight_Str | STRING64 | NA |
The string representation of the Nominal Linear Weight of the tubular. For example ""11 lb/ft"" | No |
VARCHAR2(64) |
| Nom_Linear_Weight_UOM | R_Unit |
|
The unit of measure associated with the Nominal Linear Weight | Yes |
VARCHAR2(64) |
| Nom_Outside_Diameter | double | No_Unit |
Nominal Outside diameter of the tubular body | Yes |
NUMBER |
| Nom_Outside_Diameter_Str | STRING64 | NA |
The string representation of the Nominal Outside Diameter of the tubular. For example ""8 1/2 inch"" | No |
VARCHAR2(64) |
| Nom_Outside_Diameter_UOM | R_Unit |
|
The unit of measure associated with the Nominal Outside Diameter | Yes |
VARCHAR2(64) |
| Non_Magnetic_Flag | boolean | NA |
A flag indicating whether the tubular is made with non magnetic material | No |
NUMBER(1) |
| Ref_Id | ID | No_Unit |
The surrogate identifier of an instance of reference data. | Yes |
NUMBER(38) |
| Source | CODE | NA |
The person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. For example, POSC, EPSG, API, ISO, etc.. | No |
VARCHAR2(64) |
| Standardization_Name | STRING64 | NA |
Name of the body in charge of standardization of the data such as API, ISO | Yes |
VARCHAR2(64) |
| Storage_Unit_System | R_Unit_System |
|
The unit system in which the numeric values are stored. It is expected that every numeric value in this table will be of the same unit system e.g Metric, English etc | No |
VARCHAR2(64) |
| Tensile_Yield_Strength | double | Force N |
The tensile yield strength of the tubular | No |
NUMBER |
| Tension | double | Force N |
Tension | No |
NUMBER |
| Torsional_Yield_Strength | double | Force N |
The torsional yield strength of the tubular | No |
NUMBER |
| Tubular_Grade | R_Tubular_Grade |
|
The grade of the Tubular | No |
VARCHAR2(64) |
| 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) |
| Upset_Type | String | NA |
The upset type of the tubular. Examples are IU, EU and IEU | No |
VARCHAR2(255) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Casing | Casing_Spec | Reference to the casing catalog data | Restrict | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Equipment_Symbol | R_Equipment_Symbol | _ | Restrict | No |
| Nom_Outside_Diameter_UOM | R_Unit | _ | Restrict | Yes |
| Storage_Unit_System | R_Unit_System | _ | Restrict | No |
| Nom_Inside_Diameter_UOM | R_Unit | _ | Restrict | No |
| Nom_Linear_Weight_UOM | R_Unit | _ | Restrict | Yes |
| Tubular_Grade | R_Tubular_Grade | _ | Restrict | No |