Data Schema
...
Network
Specifications

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 Network Header

sourceNetworkSourceId

String

-

No

-

Source Id of Network Source Definition

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.