Well (OpenSpirit v2.9.0 Build 27

Intro

Overview

Model

Table

OpenSpirit v2.9.0 Build 27 - Generic Model

SUMMARY: INHERITED | COLUMNS

DETAIL: COLUMNS

EpiWell_Well

Derived From:: EpEntity_Entity

Capabilties:: read

The Well table provides descriptive information about a well, such as names, aliases, and codes used for identifying a well, supplemented with other associated properties. A Well may be the origin of multiple Bores, each of which may have further information, such as picks, logs, and velocities.

Column Summary

Type Name and Description

Stringro

KeyString

Unique identifier for each table entry.

StringSeq
ro db

Bores

A list of data key strings representing all the bores associated with this well.

String
db

Comment

Contains any relevant user comments about the well.

String
db

Country

Name of the country in which the well was drilled.

String
db

County

Name of the county in which the well was drilled.

String
db

CurrentOperator

Name of the company operating this well.

String
db

Field

Name of the field in which the well was drilled.

Float
db

GroundElevation

Ground elevation.

String
ro db

GroundElevationUnit

Ground elevation unit.

String
ro req db key

Identifier

Primary well identifier assigned to a well by the API, ERCB, or any government agency.

String
ro db

IdentifierType

The type of identifier provided for the well.

String
db

LeaseName

Name of the lease in which the well was drilled.

String
db

LeaseNumber

Number of the lease in which the well was drilled.

Point
db

Location

The surface location of the well in the specified coordinate system.

String
db

OCSNumber

Number of the Outer Continental Shelf number of the well drilled as assigned by the MMS.

String
db

OffshoreArea

Name of the Outer Continental Shelf area of the well drilled as assigned by the MMS.

String
db

OffshoreBlock

Number of the Outer Continental Shelf block of the well drilled as assigned by the MMS.

String
db

PermitNumber

Number of the lease in which the well was drilled.

String
db

PlatformIdentifier

The platform from which the well was drilled.

String
ro req db

Project

No description provided.

String
db

Slot

The opening in the platform from which the well was drilled.

String
db

SpudDate

Date when drilling bit penetrates surface utilizing a drilling rig capable of drilling the well to the authorized depth.

String
db

StateOrProvince

Name of the state or province in which the well is located.

Float
db

WaterDepth

Depth of the water.

String
ro db

WaterDepthUnit

WaterDepth unit.

StringSeq
db

WellAliases

Collection of various identifiers by which this well is known.

StringSeq
db

WellAliasTypes

Collection of various types of identifiers by which this well is known.

String
db

WellStatus

Code representing the operational state of the well.

String
db

WellType

Type of well (eg.

Columns inherited from EpEntity_Entity

LastModifiedDate, Name, Project, ProjectName, StoreInstallationName, StoreType

Column Detail

KeyString

`Data Type:`	String
`Read only:`	true

Unique identifier for each table entry.

Comment

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Contains any relevant user comments about the well.

Slot

`Data Type:`	String
`Content Type:`	Key
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Referenced Table:`	EpiDrilling_Slot

The opening in the platform from which the well was drilled.

CurrentOperator

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Name of the company operating this well.

Project

`Data Type:`	String
`Content Type:`	Key
`Read only:`	true
`Required for Insert:`	true
`Stored in db:`	true
`Part of natural key:`	false
`Referenced Table:`	EpiProject_Project

No description provided.

WellAliasTypes

`Data Type:`	StringSeq
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Collection of various types of identifiers by which this well is known.

Country

`Data Type:`	String
`Content Type:`	RVString
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`RVS Set:`	Country

Name of the country in which the well was drilled.

Location

`Data Type:`	Point
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

The surface location of the well in the specified coordinate system.

OffshoreArea

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Name of the Outer Continental Shelf area of the well drilled as assigned by the MMS.

Identifier

`Data Type:`	String
`Read only:`	true
`Required for Insert:`	true
`Stored in db:`	true
`Part of natural key:`	true

Primary well identifier assigned to a well by the API, ERCB, or any government agency.

PermitNumber

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Number of the lease in which the well was drilled.

IdentifierType

`Data Type:`	String
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

The type of identifier provided for the well.

PlatformIdentifier

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

The platform from which the well was drilled.

SpudDate

`Data Type:`	String
`Content Type:`	Date
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Date when drilling bit penetrates surface utilizing a drilling rig capable of drilling the well to the authorized depth.

Field

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Name of the field in which the well was drilled.

GroundElevationUnit

`Data Type:`	String
`Content Type:`	UnitAcronym
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	VerticalDistance

Ground elevation unit.

GroundElevation

`Data Type:`	Float
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	VerticalDistance

Ground elevation.

Bores

`Data Type:`	StringSeq
`Content Type:`	KeySeq
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Referenced Table:`	EpiWell_WellBore

A list of data key strings representing all the bores associated with this well.

WaterDepthUnit

`Data Type:`	String
`Content Type:`	UnitAcronym
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	VerticalDistance

WaterDepth unit.

WellAliases

`Data Type:`	StringSeq
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Collection of various identifiers by which this well is known. The identifiers are represented by an array of name and value pairs where the name is well identifier type and the value is the identifier value. Examples of identifier types are API and Common Name.

OffshoreBlock

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Number of the Outer Continental Shelf block of the well drilled as assigned by the MMS.

WaterDepth

`Data Type:`	Float
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	VerticalDistance

Depth of the water.

County

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Name of the county in which the well was drilled.

OCSNumber

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Number of the Outer Continental Shelf number of the well drilled as assigned by the MMS.

WellType

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Permitted Values:`	ON_SHORE \| OFF_SHORE \| OFF_SHORE_SUBSEA \| UNKNOWN_WELL_TYPE

Type of well (eg. on shore, off shore).

LeaseName

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Name of the lease in which the well was drilled.

StateOrProvince

`Data Type:`	String
`Content Type:`	RVString
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`RVS Set:`	StateOrProvince

Name of the state or province in which the well is located.

LeaseNumber

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Number of the lease in which the well was drilled.

WellStatus

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false