Network Joint Constraint
The network joint constraint table describes time-based constraints to apply to joint 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 Joint Constraint table rows is sourceId + name + date
Variable | Data Type | Unit of Measure | Is Nullable? | Default Value | Description |
sourceId | String | - | No | - | Source ID for the joint/date constraint. This sourceID enables upsert functionality from client source systems of record |
name | String | - | No | - | Joint name. This must match the joint name in the network definition |
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 |
maxMolarFractionCO2 | Double | molar fraction | Yes | - | Maximum molar fraction CO2 constraint |
maxMolarFractionN2 | Double | molar fraction | Yes | - | Minimum molar fraction N2 constraint |
maxMolarFractionH2S | Double | molar fraction | Yes | - | Maximum molar fraction H2S 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 |

