Data Schema
...
Network
Constraints

Network Pipe Constraint

The network pipe constraint table describes time-based constraints to apply to pipe 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 "maxOilRate" variable set to 1200 STB/d, that constraint will continue to apply until a future record is added with a different value for "maxOilRate".

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 Pipe 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

sourcePipeId

String

-

No

-

Source ID of Network Pipe Definition

sourceId

String

-

No

-

Source ID for the pipe/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

psi

Yes

-

Maximum pressure constraint

minPressure

Double

psi

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

maxCFactor

Double

-

Yes

-

Maximum C-factor (pipe roughness coefficient)