Data Schema
...
Well
Wellbore

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