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 well test table can support a variety of well test types including: WELLTEST, TRACER, CGR, and SALINITY. The default type value is WELLTEST, which indicates a standard production volume measurement through a test separator.

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

type

String

-

Yes

WELLTEST

Describes the type of the well test

  • WELLTEST - standard measurements through test separator
  • TRACER
  • CGR
  • SALINITY

oilRate

Double

bbl/d

Yes

-

Oil Flow Rate

gasRate

Double

Mscf/d

Yes

-

Gas Flow Rate

waterRate

Double

bbl/d

Yes

-

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

gasLiftInjectionRate

Double

Mscf/d

Yes

-

Test gas lift injection rate

waterGasRatio

Double

STB/MMscf

Yes

-

Test water/gas ratio

condensateGasRatio

Double

STB/MMscf

Yes

-

Test condensate/gas ratio

salinity

Double

ppm

Yes

-

Test salinity



Updated 05 Nov 2024
Doc contributor
Did this page help you?