Forecast
The Well Forecast table allows you to load internal/customer forecasts, which can be compared to the ProdX PI-Based forecasts in various variance reports in the application.
Customer forecasts are not versioned in ProdX; therefore at any given point in time, there can only be one customer forecast per well. It is important to clear any old versions of forecasts before inserting new ones if there is any chance the date might differ, as different dates than the original forecast will insert. If subsequent versions of forecasts maintain the same date, they can be pushed without deletion since the unique constraint of uwi + date will allow an update of the existing records.
The forecast table has a unique constraint of uwi + date.
Variable | Data Type | Unit of Measure | Is Nullable? | Default Value | Description |
|---|---|---|---|---|---|
uwi | String | - | No | - | Unique Well Identifier |
date | Datetime Offset | - | No | - | Datetime offset (with timezone) in ISO 8601 format. Example: 2022-09-27T16:28:37+0000 |
oilRate | Double | bbl/d | No | 0.0 | Oil Flow Rate |
gasRate | Double | Mscf/d | No | 0.0 | Gas Flow Rate |
waterRate | Double | bbl/d | No | 0.0 | Water Flow Rate |
