Forecasts
Monthly production forecasts, Arps decline segments and parameters, and county supply projections.
Views live in NOVI_DATA_ACCESS.NOVI_WELLS. Column descriptions are from the Wells data dictionary, release 26.4.3. Type is the data model’s logical type, and unit appears where the model declares one. For Snowflake column types, query NOVI_DATA_ACCESS.INFORMATION_SCHEMA.COLUMNS.
PRODUCTION_FORECAST
Section titled “PRODUCTION_FORECAST”Forecasted monthly production for a wellbore.
More about this view
One row per (wellbore_key, forecast_day, scenario). This projection currently ships monthly granularity only (period_granularity='monthly') and the P50 scenario only, the source is monthly and emits a single deterministic forecast. Stream rates (oil/gas/water) come from source; oil carries condensate combined, as the source oil does, and NGL and condensate are NULL. Cumulative columns aggregate over the forecast horizon. The year / month pair carries the PRODUCTION month each row represents, not a revenue month, and is the calendar axis for aligning rows with actual production and with production_forecast_arps_segment.segment_start_date. Do not align on forecast_day, which is a nominal period ordinal rather than elapsed time; see its description.
- Joins to
SELECT PRODUCTION_FORECAST_ID, WELLBORE_KEY, PERIOD_GRANULARITY, FORECAST_DAY, YEARFROM NOVI_DATA_ACCESS.NOVI_WELLS.PRODUCTION_FORECASTLIMIT 10- PRODUCTION_FORECAST_IDinteger
- Identifier that groups the period rows of one forecast.
More
Shared by those rows, so it is not unique per row.
- WELLBORE_KEYstring
- Foreign key to
wellbore.wellbore_key. - PERIOD_GRANULARITYstring
- Granularity of this forecast record.
More
A yearly record is a 12-month block counted from the first month of the wellbore's monthly series, not a calendar year.
- FORECAST_DAYintegerday
- Period index relative to initial production (IP), expressed in nominal day units.
More
For monthly records this is the month ordinal times 30, where the ordinal is 1-based (so month 1 encodes as 30); for weekly records, multiples of 7. The lowest value actually present in a given fact depends on which months that fact carries, a forecast-only projection whose historical months are excluded starts at whatever month the forecast begins, not at 30. NOT a count of elapsed days, dividing by 30 recovers the month index exactly, and real elapsed time drifts from it by roughly 0.44 days per month (about 264 days over a 600-month horizon). Same 1-based month ordinal as
MONTHS_ON_PRODUCTION(times 30 for monthly records). Use forecast_day to order rows within this fact. Do NOT use it as an alignment key againstproduction_forecast_arps_segment.day_start(real calendar days) or for discounting; align on year / month, or on the segment's segment_start_date / segment_end_date. - YEARinteger
- Calendar year of the production month this forecast row represents.
More
Not the revenue month, revenue conventionally lags production by 1–2 months. Together with month, this is the alignment axis against actual production and against
production_forecast_arps_segment.segment_start_date. On yearly records, the calendar year of forecast_date, the first month of the 12-month block. - MONTHinteger
- Calendar month number (1–12) of the production month this forecast row represents.
More
Not the revenue month. See year. On yearly records, the calendar month of forecast_date, the first month of the 12-month block.
- SCENARIOstring
- Forecast scenario.
More
This release publishes P50, the median forecast, only.
- OIL_PER_DAYnumberbbl/d
- Oil rate (bbl/d).
More
May carry oil and condensate as a single combined rate, in which case condensate_per_day is null; a populated oil rate beside a null condensate rate therefore does not assert that no condensate is forecast. Semi-additive; do not sum across wells without producing_days weighting. On yearly records, the 12-month block's volume divided by the calendar days of that block counted from forecast_date (365 or 366), so a final partial block is still divided by a full block.
- CUMULATIVE_OILnumberbbl
- Cumulative oil volume (bbl), combined with condensate on the same rows as oil_per_day (cumulative_condensate is then null), accumulated over the FORECAST horizon only: the running total of this fact's own per-period forecast volumes, from the first forecast period at this row's period_granularity.
More
It excludes production that occurred before the forecast starts; historical volumes live in production. Semi-additive: it may be summed across wellbores at a fixed period, but must NEVER be summed across periods; it is already a running total, so summing double-counts. To recover a single period's volume, difference consecutive rows.
- GAS_PER_DAYnumberMcf/d
- Gas rate (Mcf/d).
More
Semi-additive; do not sum across wells without producing_days weighting. On yearly records, the 12-month block's volume divided by the calendar days of that block counted from forecast_date (365 or 366), so a final partial block is still divided by a full block.
- CUMULATIVE_GASnumberMcf
- Cumulative gas volume (Mcf), accumulated over the FORECAST horizon only: the running total of this fact's own per-period forecast volumes, from the first forecast period at this row's period_granularity.
More
It excludes production that occurred before the forecast starts; historical volumes live in production. Semi-additive: it may be summed across wellbores at a fixed period, but must NEVER be summed across periods; it is already a running total, so summing double-counts. To recover a single period's volume, difference consecutive rows.
- NGL_PER_DAYnumberbbl/d
- NGL rate (bbl/d).
More
Semi-additive; do not sum across wells without producing_days weighting. On yearly records, the 12-month block's volume divided by the calendar days of that block counted from forecast_date (365 or 366), so a final partial block is still divided by a full block.
- CUMULATIVE_NGLnumberbbl
- Cumulative NGL volume (bbl), accumulated over the FORECAST horizon only: the running total of this fact's own per-period forecast volumes, from the first forecast period at this row's period_granularity.
More
It excludes production that occurred before the forecast starts; historical volumes live in production. Semi-additive: it may be summed across wellbores at a fixed period, but must NEVER be summed across periods; it is already a running total, so summing double-counts. To recover a single period's volume, difference consecutive rows.
- WATER_PER_DAYnumberbbl/d
- Water rate (bbl/d).
More
Semi-additive; do not sum across wells without producing_days weighting. On yearly records, the 12-month block's volume divided by the calendar days of that block counted from forecast_date (365 or 366), so a final partial block is still divided by a full block.
- CUMULATIVE_WATERnumberbbl
- Cumulative water volume (bbl), accumulated over the FORECAST horizon only: the running total of this fact's own per-period forecast volumes, from the first forecast period at this row's period_granularity.
More
It excludes production that occurred before the forecast starts; historical volumes live in production. Semi-additive: it may be summed across wellbores at a fixed period, but must NEVER be summed across periods; it is already a running total, so summing double-counts. To recover a single period's volume, difference consecutive rows.
- CONDENSATE_PER_DAYnumberbbl/d
- Condensate rate (bbl/d).
More
Null wherever condensate is not carried separately; the rate may then be combined into oil_per_day, so a null does not establish that none is forecast. Semi-additive; do not sum across wells without producing_days weighting. On yearly records, the 12-month block's volume divided by the calendar days of that block counted from forecast_date (365 or 366), so a final partial block is still divided by a full block.
- CUMULATIVE_CONDENSATEnumberbbl
- Cumulative condensate volume (bbl), null wherever condensate is not carried separately (it may then be combined into cumulative_oil), accumulated over the FORECAST horizon only: the running total of this fact's own per-period forecast volumes, from the first forecast period at this row's period_granularity.
More
It excludes production that occurred before the forecast starts; historical volumes live in production. Semi-additive: it may be summed across wellbores at a fixed period, but must NEVER be summed across periods; it is already a running total, so summing double-counts. To recover a single period's volume, difference consecutive rows.
- FORECAST_DATEdate
- First day of the calendar month whose production this row forecasts (e.g. 2034-03-01): the forecast production month, not the revenue month, which typically lags 1–2 months.
More
On yearly records, the first day of the first month of the 12-month block; not 1 January. On monthly records it joins to
production.production_dateby value; on yearly records it matches only the block's first month. - FORECAST_MONTHinteger
- 1-based index of the month within the wellbore's monthly series of consecutive months, 1 being the series' earliest month.
More
On monthly records, the month this row forecasts, equal to forecast_day / 30. On yearly records, the last month present in the 12-month block: the year ordinal times 12, or less for a final partial year. An ordinal index, not a calendar month: see month for the calendar month.
- BASIN
- Basin name (e.g., Permian, Eagle Ford).
- SUBBASIN
- Subbasin name (e.g., Delaware, Midland).
- SOURCE_ID
- Foreign key to
source.source_idfor data lineage. - CREATED_ATtimestamp
- Source ingestion timestamp from the production forecast feed.
No columns match. Try a shorter word.
PRODUCTION_FORECAST_ARPS_SEGMENT
Section titled “PRODUCTION_FORECAST_ARPS_SEGMENT”An ARPS forecast segment refers to a specific time range for a single production stream of a wellbore.
More about this view
Each segment consists of a continuous number of days that share the same ARPS regime (for example, buildup, transition, or terminal). Segments are numbered starting from one and are ordered sequentially; they must not overlap within a specific combination of wellbore_key and production_stream.
- Joins to
SELECT WELLBORE_KEY, PRODUCTION_FORECAST_ID, SEGMENT_UID, PRODUCTION_STREAM, SEGMENT_NUMBERFROM NOVI_DATA_ACCESS.NOVI_WELLS.PRODUCTION_FORECAST_ARPS_SEGMENTLIMIT 10- WELLBORE_KEYstring
- Foreign key to
wellbore.wellbore_key. - PRODUCTION_FORECAST_IDinteger
- Forecast run to which this segment belongs.
More
Use to group segments and parameters by a single forecast execution. May be NULL when no parent production_forecast row exists for this segment.
- SEGMENT_UIDinteger
- Stable, immutable unique identifier for this segment.
- PRODUCTION_STREAMstring
- Which stream this segment forecasts (e.g., oil, gas, ngl, water, condensate).
- SEGMENT_NUMBERinteger
- 1-based index of the segment within the stream for the wellbore_key.
- KINDstring
- ARPS regime represented by this segment: - buildup: early-time pre-decline behavior, - transition: changeover period between regimes, - terminal: late-time decline segment.
- SEGMENT_CURVE_TYPEstring
- Type of decline curve applied in this segment.
More
'exponential' assumes constant nominal decline D; 'hyperbolic' uses exponent b (0<b<1 typical; b=1 is harmonic); 'linear' is a buildup-phase ramp where rate increases linearly from segment_start_rate to segment_end_rate over (day_stop - day_start) days (no decline math applies). 'linear' is only valid when kind='buildup'.
- DAY_STARTinteger
- Inclusive day index where this segment begins, in real calendar days since first production (0 = first day of production).
More
This is the axis the segment's Arps parameters were fitted against and is the correct axis for evaluating the curve within this fact. It is NOT comparable to
production_forecast.forecast_day, which is a nominal 30-day month ordinal rather than a day count; matching the two drifts by a median of 129 days and up to 236, well-specific and uncorrectable by a constant. To align this fact with production_forecast, use segment_start_date / segment_end_date against year / month. - DAY_STOPinteger
- Inclusive day index where this segment ends, in real calendar days since first production.
More
Must be >= day_start for valid datasets (cannot be enforced portably in standard JSON Schema). Same axis and same caveats as day_start; (day_stop - day_start) is the segment duration in days, used by the 'linear' segment_curve_type ramp.
- SEGMENT_START_DATEdate
- Calendar date on which this segment begins, inclusive (YYYY-MM-DD).
More
The alignment axis between this fact and production_forecast: a monthly forecast row belongs to the segments whose [segment_start_date, segment_end_date] range overlaps its year/month. Anchors the fitted curve to real calendar time, which is what evaluating a segment against actual monthly production requires. NULL when the wellbore has no calendar anchor (no first-production date), in which case consumers must fall back to the relative day_start / day_stop offsets.
- SEGMENT_END_DATEdate
- Calendar date on which this segment ends, inclusive (YYYY-MM-DD).
More
NULL when the wellbore has no calendar anchor. See segment_start_date.
- BASIN
- Basin name (e.g., Permian, Eagle Ford).
- SUBBASIN
- Subbasin name (e.g., Delaware, Midland).
- SOURCE_ID
- Foreign key to
source.source_idfor data lineage.
No columns match. Try a shorter word.
PRODUCTION_FORECAST_ARPS_SEGMENT_PARAMETER
Section titled “PRODUCTION_FORECAST_ARPS_SEGMENT_PARAMETER”Parameter values associated with a single ARPS forecast segment.
More about this view
These parameters describe decline behavior and rates for the segment referenced by forecast_segment_id. Units for rates should match the stream's production rate (e.g., bbl/d, mcf/d). Decline rates are per-day fractions unless otherwise noted.
- Joins to
FORECAST_SEGMENT_IDForeign key to the ARPS segment this parameter set applies to.SOURCE_IDjoinsSOURCE.SOURCE_ID
SELECT FORECAST_SEGMENT_ID, SEGMENT_PARAMETER_UID, B_FACTOR, EFFECTIVE_DECLINE_RATE_TANGENT, EFFECTIVE_DECLINE_RATE_SECANTFROM NOVI_DATA_ACCESS.NOVI_WELLS.PRODUCTION_FORECAST_ARPS_SEGMENT_PARAMETERLIMIT 10- FORECAST_SEGMENT_IDinteger
- Foreign key to the ARPS segment this parameter set applies to.
More
Must reference an existing ProductionForecastArpsSegment.segment_uid.
- SEGMENT_PARAMETER_UIDinteger
- Stable unique identifier for this parameter row.
- B_FACTORnumber
- Hyperbolic decline exponent b. >0 for hyperbolic; b=1 is harmonic; values typically in (0, 2].
More
Only relevant when the segment curve type is hyperbolic/harmonic.
- EFFECTIVE_
DECLINE_ numberRATE_ TANGENT - D_eff (tangent), effective decline rate using the tangent (instantaneous) approximation over a 1-day interval (dimensionless fraction in [0,1)).
More
For exponential decline, D_eff_tangent = 1 - e^{-D_nom}. This is the point-in-time derivative of the decline curve; use effective_decline_rate_secant for the average-interval approximation.
- EFFECTIVE_
DECLINE_ numberRATE_ SECANT - D_eff (secant), effective decline rate using the secant (average-interval) approximation over a 1-day interval (dimensionless fraction in [0,1)).
More
For exponential decline, D_eff_secant = 1 - (q(t+1)/q(t)). Secant is the discrete-period average decline; needed for ARIES export and reproducibility alongside the tangent approximation.
- NOMINAL_DECLINE_RATEnumber
- D_nom, nominal decline parameter used in ARPS (1/day).
More
Constant for exponential; initial value for hyperbolic at segment start.
- SEGMENT_START_RATEnumber
- q_start, production rate at the beginning of the segment (same units as stream, e.g., bbl/d or mcf/d).
- SEGMENT_END_RATEnumber
- q_end, production rate at the end of the segment (same units as stream).
More
Should be <= q_start for decline segments (cannot be enforced portably here).
- SOURCE_ID
- Foreign key to
source.source_idfor data lineage. - CREATED_ATtimestamp
- Timestamp the record was created.
- UPDATED_ATtimestamp
- Timestamp of the most recent update.
No columns match. Try a shorter word.
SUPPLY_PROJECTION
Section titled “SUPPLY_PROJECTION”County-level type curve projections for oil and gas supply modeling.
More about this view
One row per county per production-start-month cohort per months-on-production. Provides average forecasted production rates and volumes per well for horizontal wells that started producing since 2010.
- Key columns
SUPPLY_PROJECTION_IDSurrogate key.
- Joins to
SELECT SUPPLY_PROJECTION_ID, COUNTY_CODE, MONTH_OF_PRODUCTION_START, MONTHS_ON_PRODUCTION, DATEFROM NOVI_DATA_ACCESS.NOVI_WELLS.SUPPLY_PROJECTIONLIMIT 10- SUPPLY_PROJECTION_ID
- Surrogate key.
- COUNTY_CODE
- FIPS county code.
- MONTH_
OF_ PRODUCTION_ START - First day of the month in which the cohort started producing.
- MONTHS_ON_PRODUCTION
- Month index from first production.
More
Uses the same convention as
PRODUCTION.MONTHS_ON_PRODUCTION: 1 = the first month on production, or 0 for a distinguished incomplete first month before full month 1. For supply projections the first index represents the cohort's first month on production. - DATE
- Calendar date for this data point.
- YEAR_
OF_ PRODUCTION_ START - Year the cohort started producing.
- OIL_
PER_ MONTH_ PROJECTED - Average forecasted oil production per well for this month.
More
A per-well average, so it is non-additive: summing it across cohorts or months does not give a total volume.
- OIL_PER_DAY_PROJECTED
- Average forecasted oil production rate per well per day.
More
Non-additive (rate average).
- GAS_
PER_ MONTH_ PROJECTED - Average forecasted gas production per well for this month.
More
A per-well average, so it is non-additive: summing it across cohorts or months does not give a total volume.
- GAS_PER_DAY_PROJECTED
- Average forecasted gas production rate per well per day.
More
Non-additive (rate average).
- BASIN
- Basin name (e.g., Permian, Eagle Ford).
- SUBBASIN
- Subbasin name (e.g., Delaware, Midland).
- SOURCE_ID
- Foreign key to
source.source_idfor data lineage. - UPDATED_AT
- Timestamp of the most recent update.
No columns match. Try a shorter word.