Data Schema
...
Network
Constraints

Network Well Constraint

The network well constraint table describes time-based constraints to apply to well elements in a network for network optimization and forecasting defaults.

Constraints will apply from the last date they were set. For example, if a record is added with date 2023-01-01T00:00:00+0000 with the "maxPressure" variable set to 2100 psi, that constraint will continue to apply until a future record is added with a different value for "maxPressure".

A NULL value for a particular constraint effectively makes that variable unconstrained. With this in mind, it is important to take care to manage constraints appropriately if various constraint variables are changing on different time horizons, as it could be easy to reset constraints unexpectedly with NULL values.

The unique constraint on the Network Well Constraint table rows is sourceNetworkId + sourceId + date

Variable

Data Type

Unit of Measure

Is Nullable?

Default Value

Description

sourceNetworkId

String

-

No

-

Source ID of Network Header

sourceWellId

String

-

No

-

Source ID of Network Well Definition

sourceId

String

-

No

-

Source ID for the well/date constraint. This sourceID enables upsert functionality from client source systems of record

date

DateTimeOffset

-

No

-

Date at which the constraint becomes applicable. Datetime offset (with timezone) in ISO 8601 format. Example: 2022-09-27T16:28:37+0000

maxPressure

Double

psig

Yes

-

Maximum pressure constraint

minPressure

Double

psig

Yes

-

Minimum pressure constraint

maxOilRate

Double

STB/d

Yes

-

Maximum oil rate constraint

maxGasRate

Double

Mscf/d

Yes

-

Maximum gas rate constraint

maxWaterRate

Double

STB/d

Yes

-

Maximum water rate constraint

maxLiquidRate

Double

STB/d

Yes

-

Maximum liquid rate constraint

maxDrawdown

Double

psi

Yes

-

Maximum drawdown constraint (Reservoir pressure - bottomhole pressure)

plannedDowntime

Double

%

Yes

-

Planned downtime in percent (100% == 24 hours)

maxGasLiftInjectionRate

Double

Mscf/d

Yes

-

Maximum gas lift injection rate

minGasLiftInjectionRate

Double

Mscf/d

Yes

-

Minimum gas lift injection rate

maxGasLiftInjectionPressure

Double

psig

Yes

-

Maximum gas lift injection pressure

minGasLiftInjectionPressure

Double

psig

Yes

-

Minimum gas lift injection pressure