Network Source Forecast

a network source forecast describes time based inflow from a third party source into a network for network optimization and forecasting this could be a well, satellite, pipe, etc it will deliver a constant rate into the network based on the data provided in this table this table is used when there are wells or satellites flowing into a network but those wells or satellites are not being actively modeled by the xecta system the unique constraint on the network screw compressor table rows is sourcenetworkid + sourcenetworksourceid + forecastvaliddate + date variable data type unit of measure is nullable? default value description sourcenetworkid string no source id of docid\ irxj rg5leh701vw2okjl sourcenetworksourceid string no source id of docid\ aqlrn950hbs9fpxt5pahx forecastvaliddate datetimeoffset no date of forecast generation for the source datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37+0000 date datetimeoffset no date of the forecasted rates datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37+0000 oilrate double stb/d yes forecasted oil rate gasrate double mscf/d yes forecasted gas rate waterrate double stb/d yes forecasted water rate forecastvaliddate notes since forward looking forecasts are generated at multiple points in time, the forecast valid date allows the system to select the appropriate forecast for a network source for a given xecta model run date as third party network source forecasts are generated, they will be inserted into the data platform by row of the record "date", but a reference to the forecast itself ("forecastvaliddate") is required to discern multiple forecasts over time for a given source