Data Schema
Well

Well Test

Valid well tests can be imported to overlay on production charts and compare with allocated volumes. The uwi field should link to a uwi in the Well table.

The unique constraint on well test entries is uwi + date.

Variable

Data Type

Unit of Measure

Is Nullable?

Default Value

Description

uwi

String

-

No

-

Unique Well Identifier

date

Datetime Offset

-

No

-

Datetime offset (with timezone) in ISO 8601 format. Example: 2022-09-27T16:28:37+0000

oilRate

Double

bbl/d

No

0.0

Oil Flow Rate

gasRate

Double

Mscf/d

No

0.0

Gas Flow Rate

waterRate

Double

bbl/d

No

0.0

Water Flow Rate

tubingPressure

Double

psig

Yes

-

Tubing / wellhead pressure

tubingTemperature

Double

degF

Yes

-

Tubing / wellhead temperature

casingPressure

Double

psig

Yes

-

Casing pressure

casingTemperature

Double

degF

Yes

-

Casing temperature

gaugePressure

Double

psig

Yes

-

Downhole gauge pressure (downhole gauge must be available in downhole equipment table)

gaugeTemperature

Double

degF

Yes

-

Downhole gauge temperature (downhole gauge must be available in downhole equipment table)

choke

Double

%

Yes

-

Choke opening %

upstreamChokePressure

Double

psig

Yes

-

Upstream choke pressure

downstreamChokePressure

Double

psig

Yes

-

Downstream choke pressure

basicSedimentAndWater

Double

%

Yes

-

Percentage basic sediment and water

duration

Double

hrs

Yes

-

Well test duration

separatorPressure

Double

psig

Yes

-

Test separator pressure

separatorTemperature

Double

degF

Yes

-

Test separator temperature



Updated 24 Jun 2024
Doc contributor
Did this page help you?