Data Schema

Wellbore Tubing

Tubing is the pipe or conduit to transport fluids from the reservoir to the surface. The tubing sits inside the casing and is constructed in sections. Both casing and tubing are manufactured to certain diameters and wall thicknesses.
Variable
Data Type
Unit of Measure
Is Nullable?
Default Value
Description
sourceId
String
-
No
-
From Wellview Table:
wvtub - use idrec column

From OpenWells Table:
cd_assembly - use assembly_id column
sourceWellId
String
-
No
-
From Wellview Table:
wvtub - use idwell column

From OpenWells Table:
cd_assembly - use well_id column
sourceWellboreId
String
-
No
-
From Wellview Table:
wvtub - use idrecwellbore column

From OpenWells Table:
cd_assembly - use wellbore_id column
topMd
Double
ft
No
0.0
Top Depth
bottomMd
Double
ft
No
-
Bottom Depth
id
Double
in
No
-
Inner Diameter
From Wellview Table:
wvtub - use SZIDNOMMINCALC column
od
Double
in
No
-
Outer Diameter
From Wellview Table:
wvtub - use SZODNOMMINCALC column
roughness
Double
in
Yes
0.0003
Roughness of Tubing
runDate
Datetime Offset
-
Yes
-
Datetime offset (with timezone) in ISO 8601 format. Example: 2022-09-27T16:28:37+0000
pullDate
Datetime Offset
-
Yes
-
Datetime offset (with timezone) in ISO 8601 format. Example: 2022-09-27T16:28:37+0000
Wellbore Tubing Notes
Tubing data is optional.

For wells with no tubing data and tubing pressures missing or atmospheric, the well model will interpret casing flow.

For wells with no tubing data and tubing pressures greater than atmospheric tubing pressures, the well model will interpret tubing flow (tubing properties and dimensions will be copied from the temporally adjacent tubing string).
Top Measured Depth Notes
If the topMd is NULL, the system will assume 0.0 ft as the default topMd value.
Roughness Notes
If the roughness is NULL, the system will assume 0.0003 as the default roughness value.
Data Integrity Checks
Condition
Response
sourceId, sourceWellId, OR sourceWellboreId is NULL or Empty
Record Rejected
sourceId, sourceWellId, OR sourceWellboreId does not exist
Record Rejected
﻿

Updated 21 Jul 2023

Did this page help you?

Wellbore Casing

Wellbore Downhole Equipment

Docs powered by Archbee

TABLE OF CONTENTS

Wellbore Tubing Notes

Top Measured Depth Notes

Roughness Notes

Data Integrity Checks

Variable	Data Type	Unit of Measure	Is Nullable?	Default Value	Description
sourceId	String	-	No	-	From Wellview Table: wvtub - use idrec column From OpenWells Table: cd_assembly - use assembly_id column
sourceWellId	String	-	No	-	From Wellview Table: wvtub - use idwell column From OpenWells Table: cd_assembly - use well_id column
sourceWellboreId	String	-	No	-	From Wellview Table: wvtub - use idrecwellbore column From OpenWells Table: cd_assembly - use wellbore_id column
topMd	Double	ft	No	0.0	Top Depth
bottomMd	Double	ft	No	-	Bottom Depth
id	Double	in	No	-	Inner Diameter From Wellview Table: wvtub - use SZIDNOMMINCALC column
od	Double	in	No	-	Outer Diameter From Wellview Table: wvtub - use SZODNOMMINCALC column
roughness	Double	in	Yes	0.0003	Roughness of Tubing
runDate	Datetime Offset	-	Yes	-	Datetime offset (with timezone) in ISO 8601 format. Example: 2022-09-27T16:28:37+0000
pullDate	Datetime Offset	-	Yes	-	Datetime offset (with timezone) in ISO 8601 format. Example: 2022-09-27T16:28:37+0000

Condition	Response
sourceId, sourceWellId, OR sourceWellboreId is NULL or Empty	Record Rejected
sourceId, sourceWellId, OR sourceWellboreId does not exist	Record Rejected