Network Source Forecast

a network source forecast describes time based inflow from a third party source into a network, for network optimization and forecasting the source could be a well, satellite, pipe, etc it delivers a constant rate into the network based on the data in this table this table is used when wells or satellites flow into a network but are not actively modeled by the xecta system the unique constraint on network source forecast entries is sourcenetworkid + sourcenetworksourceid + forecastvaliddate + date variable data type unit of measure is nullable? default value description sourcenetworkid string no source id of the network header docid\ irxj rg5leh701vw2okjl sourcenetworksourceid string no source id of the network source definition docid\ aqlrn950hbs9fpxt5pahx the forecast applies to 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 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 forward looking forecasts are generated at multiple points in time the forecast valid date lets the system select the appropriate forecast for a network source for a given xecta model run date as third party network source forecasts are generated, they are inserted row by row keyed on the record date , and the forecastvaliddate reference is required to discern multiple forecasts over time for a given source data integrity checks condition response any non nullable field is null or empty record rejected sourcenetworkid does not match a network header record rejected common error messages api scenario error response add / upsert forecast unknown sourcenetworkid network was not found for source id xxx