Data Schema
...
Well
Wellbore

Wellbore

A wellbore is a borehole drilled from the surface into the subsurface reservoir formation. Each well will have a at least one wellbore. In some cases, a well may have more than one wellbore. In such cases the additional wellbores will be children "sidetracked" from the main bore at a certain depth. The depth is known as the Junction Depth. For main wellbores the Junction Depth will be 0. For child wellbores the Junction Depth (ft) must be a positive number (e.g. 2000 ft)

Variable

Data Type

Unit of Measure

Is Nullable?

Default Value

Description

sourceId

String

-

No

-

From Wellview Table: wvwellbore - use idrec column From OpenWells Table: cd_wellbore - use wellbore_id column

sourceWellId

String

-

No

-

From Wellview Table: wvwellbore - use idwell column From OpenWells Table: cd_wellbore - use well_id column

name

String

-

Yes

-

Name of Wellbore

junctionMd

Double

ft

Yes

-

Measured depth at which a child wellbore joins the parent wellbore.

Wellbore Notes

You must have a Well record with a corresponding UWI in the system before adding a Wellbore

Junction Measured Depth Notes

If this is the parent wellbore, junctionMd should be NULL

Data Integrity Checks

Condition

Response

sourceId OR sourceWellId is NULL or Empty

Record Rejected

sourceId OR sourceWellId does not exist

Record Rejected