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 docid\ irxj rg5leh701vw2okjl sourcepipeid string no source id of docid\ nm2btvsv7haiitak2o9yw 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)